maybeyonasrune_burn_q4
    Updated 2022-06-24
    select
    -- *
    last_day(block_timestamp,'week') as date,
    -- date(block_timestamp) as date,
    split(burn_asset,'-')[0]::string as burn_asset,
    -- year(block_timestamp) as year,
    count(to_address) as txs,
    count(distinct to_address) as users,
    sum(rune_amount) as rune_burned,
    sum(rune_amount_usd) as usd_burned
    from thorchain.upgrades
    -- where rune_amount <= 20000000
    where block_timestamp > '2022-02-01'
    group by 1,2
    order by date DESC
    -- order by rune_amount desc

    Run a query to Download Data