SELECT

LEFT(BLOCK_TIMESTAMP, 11) AS burn_date,

succeeded,

Burn_amount / 100000 AS BERN_Burned,

mint,

event_type,

tx_id,

FACT_TOKEN_BURN_ACTIONS_ID,

ROUND(SUM(Burn_amount / 100000) OVER (ORDER BY LEFT(BLOCK_TIMESTAMP, 11) ASC), 5) AS Running_Total

FROM

solana.defi.fact_token_burn_actions

WHERE

mint = 'CKfatsPMUf8SkiURsDXs7eK6GWb4Jsd6UDbs7twMCWxo'

AND succeeded = 'TRUE'

ORDER BY

LEFT(BLOCK_TIMESTAMP, 11) DESC

LIMIT 200

),

RankedBurnData AS (

SELECT

burn_date,

succeeded,

event_type,

BERN_Burned,

mint,

tx_id,

Running_Total,

FACT_TOKEN_BURN_ACTIONS_ID,

ROW_NUMBER() OVER (PARTITION BY Running_Total ORDER BY LEFT(burn_date, 11) ASC) AS row_num

FROM

BurnData

SELECT

burn_date,

succeeded,