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('0x84db6eE82b7Cf3b47E8F19270abdE5718B936670')
---and event_inputs:from = '0x0000000000000000000000000000000000000000'
and event_name = 'Transfer'
group by 1