Updated 2022-06-06
    select
    date_trunc('week',s.BLOCK_TIMESTAMP) as dt,
    count(distinct s.tx_id) as burns,
    sum(s.amount/1e6) as burn_vol

    from osmosis.core.FACT_TRANSFERS s left outer join osmosis.core.fact_msg_attributes b on s.tx_id=b.tx_id
    where s.tx_id is not NULL
    and TX_STATUS='SUCCEEDED'
    and b.MSG_TYPE='burn'

    group by 1
    order by 3 desc
    Run a query to Download Data