par_rndaily ankr
Updated 2022-11-04
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
select date_trunc('day', block_timestamp) as day,
count (distinct tx_hash) as TX_Count,
sum(amount) as ETH_staked,
sum(ETH_staked) over (order by day) as cumulative_ETH_staked,
sum(TX_Count) over (order by day) as cumulative_ETH_staked_TX_Count
from ethereum.core.ez_eth_transfers
where --tx_id = '0x4026d646872f7cb6da67725b2a0b7dc20665c4aa02d1893c6cec51ea3022820d'
eth_to_address = '0x84db6ee82b7cf3b47e8f19270abde5718b936670'
--and block_timestamp >= current_date - 90
group by 1
order by 1 desc
Run a query to Download Data