ZSaed1.Daily data
Updated 2023-02-11
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
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