MLDZMNshare1
    Updated 2023-05-21
    SELECT
    block_timestamp::date as day,
    'Lido' as staking_platform,
    count(distinct tx_hash) as no_txn,
    count(distinct origin_from_address) as no_users,
    sum(amount) as volume,
    avg(amount) as avg_volume,
    median(amount) as median_volume

    FROM ethereum.core.ez_token_transfers
    WHERE contract_address = lower('0xae7ab96520DE3A18E5e111B5EaAb095312D7fE84')
    and block_timestamp>='2023-05-15'
    and from_address in ('0x0000000000000000000000000000000000000000')
    GROUP BY 1

    union all

    SELECT
    block_timestamp::date as day,
    'Rocketpool' as staking_platform,
    count(distinct tx_hash) as no_txn,
    count(distinct origin_from_address) as no_users,
    sum(amount) as volume,
    avg(amount) as avg_volume,
    median(amount) as median_volume

    FROM ethereum.core.ez_token_transfers
    WHERE contract_address = lower('0xae78736Cd615f374D3085123A210448E74Fc6393')
    and block_timestamp>='2023-05-15'
    and from_address in ('0x0000000000000000000000000000000000000000')
    GROUP BY 1

    union all

    SELECT
    block_timestamp::date as day,
    Run a query to Download Data