flipside

    10
    avaema10
    Updated 2022-11-13
    with top as (select top 10 sender , sum(AMOUNT/1e6) from osmosis.core.fact_transfers
    where date_trunc('day', block_timestamp) > current_date - interval '15 days' and CURRENCY='uosmo'
    group by 1
    order by 2 desc)

    select date_trunc('day', block_timestamp), sender , sum(AMOUNT/1e6) from osmosis.core.fact_transfers
    where date_trunc('day', block_timestamp) > current_date - interval '15 days' and CURRENCY='uosmo'
    and sender in (select sender from top)
    group by 1,2
    Run a query to Download Data