Eran Tromer tromer

## zcash-fully-shielded-per-month.sql
/* Count the number of fully-shielded Zcash transactions per month */

SELECT FORMAT_DATE("%E4Y-%m", Date(block_timestamp)) as month, count(distinct `hash`) as fully_shielded_tx FROM
(
  SELECT /* fully shielded transactions with 0 fee */
    `hash`,
    block_timestamp,
    fee
  FROM
    `bigquery-public-data.crypto_zcash.transactions`

## keybase.md

      
        
          
            
              
              1 file
            
          
          
            
              
              0 forks
            
          
          
            
              
              0 comments
            
          
          
            
              
              0 stars
            
          
        
        
          
              
          
          
            
                tromer
                / keybase.md
            
            
              Created
              November 19, 2016 17:07
            
          
        
      
        
  
      
    Keybase proof

I hereby claim:

I am tromer on github.
I am tromer (https://keybase.io/tromer) on keybase.
I have a public key ASBo_Yz4GayQDxPqF-gb2Z2uvfoRfIU0g23utAD56UIdPwo

To claim this, I am signing this object:
	/* Count the number of fully-shielded Zcash transactions per month */

	SELECT FORMAT_DATE("%E4Y-%m", Date(block_timestamp)) as month, count(distinct `hash`) as fully_shielded_tx FROM
	(
	SELECT /* fully shielded transactions with 0 fee */
	`hash`,
	block_timestamp,
	fee
	FROM
	`bigquery-public-data.crypto_zcash.transactions`