MLDZMNbbon1
    Updated 2023-01-04
    with tb1 as (select
    date_trunc('day',recorded_at) as day,
    avg (price) as usd_price
    from osmosis.core.dim_prices
    where symbol='OSMO'
    and recorded_at::date>='2022-03-01'
    group by 1
    )

    select
    date_trunc('day', block_timestamp) as day,
    16104002.4212317 as "Average transfer before Terra Collapse",
    5331222.08447821 as "Average transfer before Listing",
    sum((amount/POW (10,decimal))*usd_price) as transfer_usd,
    avg((amount/POW (10,decimal))*usd_price) as avg_transfer_usd
    from osmosis.core.fact_transfers s left join tb1 b on s.block_timestamp::date = b.day
    where currency='uosmo'
    and TX_STATUS = 'SUCCEEDED'
    and block_timestamp::date>='2022-10-21'
    group by 1
    Run a query to Download Data