MLDZMNlido4
    Updated 2023-05-20
    -- forked from lido1 @ https://flipsidecrypto.xyz/edit/queries/dbc77b38-a863-4e1d-aaa4-0d3490aa2ee3

    with pp as (select
    hour::date as day,
    avg(price) as token_price
    from ethereum.core.fact_hourly_token_prices
    where token_address=lower('0xae7ab96520DE3A18E5e111B5EaAb095312D7fE84')
    group by 1
    ),

    t1 as (SELECT
    block_timestamp::date as day,
    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>=current_date-15
    and from_address in ('0x0000000000000000000000000000000000000000')
    GROUP BY 1
    ),


    t2 as (SELECT
    block_timestamp::date as day,
    count(distinct tx_hash) as no_txn1,
    count(distinct origin_to_address) as no_users1,
    sum(amount) as volume1,
    avg(amount) as avg_volume1,
    median(amount) as median_volume1


    Run a query to Download Data