Alexaystaking daily
    Updated 2022-09-12
    with lido as ( select block_timestamp::date as date, sum (raw_amount/1e18) as lido_amount
    from ethereum.core.fact_token_transfers
    where contract_address = lower('0xae7ab96520DE3A18E5e111B5EaAb095312D7fE84')
    and from_address = '0x0000000000000000000000000000000000000000'
    group by 1),

    rocketpool as (select block_timestamp::date as date, sum (raw_amount/1e18) as rocket_amount
    from ethereum.core.fact_token_transfers
    where contract_address = lower('0xae78736cd615f374d3085123a210448e74fc6393')
    and from_address = '0x0000000000000000000000000000000000000000'
    group by 1),

    ankr as ( select block_timestamp::date as date, sum (raw_amount/1e18) as ankr_amount
    from ethereum.core.fact_token_transfers
    where contract_address = lower('0xe95a203b1a91a908f9b9ce46459d101078c2c3cb')
    and from_address = '0x0000000000000000000000000000000000000000'
    group by 1)

    select a.*, b.rocket_amount, c.ankr_amount
    from lido a
    full join rocketpool b on a.date = b.date
    full join ankr c on a.date = c.date
    where a.date >= '2022-01-01'
    order by a.date desc
    Run a query to Download Data