farid-c9j0VMUntitled Query
Updated 2022-09-04
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
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 TX_HASH = lower('0x810bfeaea79cf9cfd1d39e7a3d2c978fa6ad6c9bcedf3ee903ef7c5bff1e1458')
---and event_inputs:from = '0x0000000000000000000000000000000000000000'
--- and event_name = 'Transfer'
---group by 1
Run a query to Download Data