LTirrellDaily Bonk Burned copy Total
    Updated 2024-04-03
    select
    date(block_timestamp) as date,
    sum(instruction:parsed:info:amount::int * POWER(10, -5) ) as "daily_bonk_burned",
    sum("daily_bonk_burned") over (order by date) as "total_bonk_burned"
    from solana.core.fact_events
    where
    date(block_timestamp) >= '2022-12-23' and
    instruction:parsed:info:mint::string = 'DezXAZ8z7PnrnRJjz3wXBoRgixCa6xjnB7YaB1pPB263'
    and event_type = 'burn'
    group by 1
    order by 2 desc

    Auto-refreshes every 12 hours
    QueryRunArchived: QueryRun has been archived