farid-c9j0VMankr weeky 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('0xE95A203B1a91a908F9B9CE46459d101078c2c3cb')
and from_address = '0x0000000000000000000000000000000000000000'
and raw_amount > 0
and block_timestamp >= '2022-01-01'
group by week
Run a query to Download Data