Skip to content
View rifkiamil's full-sized avatar
5 followers · 41 following

Achievements

Achievement: QuickdrawAchievement: YOLOAchievement: Pull Shark

Achievements

Achievement: QuickdrawAchievement: YOLOAchievement: Pull Shark

Block or report rifkiamil

Block user

Prevent this user from interacting with your repositories and sending you notifications. Learn more about blocking users.

You must be logged in to block users.

Please don't include any personal information such as legal names or email addresses. Maximum 100 characters, markdown supported. This note will be visible to only you.
Report abuse

Contact GitHub support about this user’s behavior. Learn more about reporting abuse.

Report abuse
rifkiamil/README.md
  • 👋 Hi, I’m @rifkiamil
  • 👀 I’m interested in ... data, databases and Enterprise IT
  • 🐮 Build websites with 🐮 faces http://🐮🐮🐮.ws
  • 🌱 I’m currently learning ... python, node.js
  • 💪 Slowly building app to understand data from Strong App
  • 💞️ I’m teaching as a Google Developer Expert, I teach and educate minorities and marginalised groups on Data, SQL & Google BigQuery using sports and blockchain data with the support of Google.
  • 📫 How to reach me ... @rifkiamil on twitter or email rif atsymbol kiamil.com

Pinned Loading

  1. DATASET bigquery-public-data DB cryp... DATASET bigquery-public-data DB crypto_ethereum - quickdatabasediagrams
    1 
    "bigquery-public-data.crypto_ethereum.balances" as Bal
    2 
    -
    3 
    address STRING
    4 
    eth_balance NUMERIC
    5 
    
              
    
          
    
    
    
  
    

    2. 

      

  2. 
  
    
    
    
      
    
        
        Satoshi Nakamoto sent 50 BTC to Hal ...  Satoshi Nakamoto sent 50 BTC to Hal Finney in block 170      
    

          
    
              
    
                1
                
    # Find Bitcoin transaction 
    
              
    
              
    
                2
                
    SELECT
    
              
    
              
    
                3
                
      bt.hash,
    
              
    
              
    
                4
                
      bt.block_timestamp,
    
              
    
              
    
                5
                
      CAST(bi.value AS NUMERIC)/100000000 as InputValueBTC,
    
              
    
          
    
    
    
  
    

    3. 

      

  3. 
  
    
    
    
      
    
        
        SQL Bitcoin Part 2 - Find transactio...  SQL Bitcoin Part 2 - Find transactions with block_timestamp, block_timestamp_month, output_value WHERE block_timestamp_month      
    

          
    
              
    
                1
                
    SELECT block_timestamp, block_timestamp_month, output_value
    
              
    
              
    
                2
                
    FROM `bigquery-public-data.crypto_bitcoin.transactions`
    
              
    
              
    
                3
                
    WHERE block_timestamp_month = '2013-12-01'
    
              
    
          
    
    
    
  
    

    4. 

      
  4. 
  
    
    
    
      
    
        
    
            
          lightdash/lightdash  lightdash/lightdash          Public
        
    
      
    


      
    
        Self-serve BI to 10x your data team ⚡️
      
    

      
    
          
  
  TypeScript


          
            
    

            4.1k
          
          
            
    

            437
          
      
    
    
    
  
    

    5.