ZSaed1.Daily data
    Updated 2023-02-11
    select
    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


    Run a query to Download Data