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('0xae7ab96520de3a18e5e111b5eaab095312d7fe84')
    and event_inputs:from = '0x0000000000000000000000000000000000000000'
    --- and event_name = 'Transfer'
    ---group by 1
    limit 100
    Run a query to Download Data