farid-c9j0VMUntitled Query
Updated 2022-09-04
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
select *
--- 'Ankr' as "Protocol",
--- count(*) as "Total Number of Stakes",
---count(distinct event_inputs:to) as "Total Number of Unique Staker",
--- sum(event_inputs:value/1e18) as "Total Amount of ETH Staked",
-- ("Total Amount of ETH Staked"/"Total Number of Stakes") as "Average Deposit Size",
-- ("Total Amount of ETH Staked"/"Total Number of Unique Staker") as "Average Amount of ETH Staked per Staker"
from ethereum_core.fact_event_logs
where CONTRACT_ADDRESS = lower('0xae7ab96520de3a18e5e111b5eaab095312d7fe84')
and event_inputs:from = '0x0000000000000000000000000000000000000000'
--- and event_name = 'Transfer'
---group by 1
limit 100
Run a query to Download Data