farid-c9j0VMUntitled Query
    Updated 2022-09-04
    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