BLOCK_TIMESTAMP::date as day ,

count(DISTINCT tx_hash) as num_tx ,

count(DISTINCT tx_hash)/(24*60*60) as TPS ,

count(DISTINCT FROM_ADDRESS) as daily_users,

sum(TX_FEE) as fee,

sum(ETH_VALUE) as eth_volume,

sum(fee) over(order by day ) as cum_fee,

sum(eth_volume) over(order by day ) as cum_eth_volume

from ethereum.core.fact_transactions

where STATUS ='SUCCESS'

group by day