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