SELECT

CAST(LEFT(BLOCK_TIMESTAMP, 10) AS DATE) AS burn_date,

SUM(Burn_amount / 100000) AS Daily_BONK_Burned,

(SUM(Burn_amount) / 100000000000000000) AS Daily_Percent_of_Supply_Burned

FROM

solana.defi.fact_token_burn_actions

WHERE

mint = 'DezXAZ8z7PnrnRJjz3wXBoRgixCa6xjnB7YaB1pPB263'

GROUP BY

CAST(LEFT(BLOCK_TIMESTAMP, 10) AS DATE)

),

RunningTotals AS (

SELECT

burn_date,

Daily_BONK_Burned,

SUM(Daily_BONK_Burned) OVER (ORDER BY burn_date ASC) AS Running_Total,

Daily_Percent_of_Supply_Burned,

SUM(Daily_Percent_of_Supply_Burned) OVER (ORDER BY burn_date ASC) AS Cumulative_Percent_of_Supply_Burned

FROM

DailyBurns

),

MaxValues AS (

SELECT

MAX(Daily_BONK_Burned) AS Max_Daily_BONK_Burned

FROM

DailyBurns

),

PriceData AS (

SELECT

price,

price * (100000000000000 - (SELECT MAX(Running_Total) FROM RunningTotals)) AS Bonk_Market_Cap

FROM

solana.price.ez_prices_hourly

WHERE

token_address = 'DezXAZ8z7PnrnRJjz3wXBoRgixCa6xjnB7YaB1pPB263'