farid-c9j0VMro weekly eth
Updated 2022-09-05
9
1
2
3
4
5
6
7
8
9
›
⌄
select date_trunc('week', block_timestamp) as week,
COUNT (DISTINCT to_address) as "Total Number of Unique Staker",
sum(raw_amount)/pow(10,18) as "Total Amount of ETH Staked"
from ethereum_core.fact_token_transfers
where contract_address = lower('0xae78736Cd615f374D3085123A210448E74Fc6393')
and from_address = '0x0000000000000000000000000000000000000000'
and raw_amount > 0
and block_timestamp >= '2022-01-01'
group by week
Run a query to Download Data