SELECT

date_trunc('day', block_timestamp) AS date,

SUM(mint_amount / POW(10, 8)) AS mints

FROM solana.defi.fact_token_mint_actions

WHERE mint = 'cbbtcf3aa214zXHbiAZQwf4122FBYbraNdFqgw4iMij'

AND succeeded

GROUP BY 1

ORDER BY 1 DESC

),

burns AS (

SELECT

date_trunc('day', block_timestamp) AS date,

-SUM(burn_amount / POW(10, 8)) AS burns

FROM solana.defi.fact_token_burn_actions

WHERE mint = 'cbbtcf3aa214zXHbiAZQwf4122FBYbraNdFqgw4iMij'

AND succeeded

GROUP BY 1

ORDER BY 1 DESC

),

price AS (

SELECT

price

FROM crosschain.price.ez_prices_hourly

WHERE token_address = 'cbbtcf3aa214zXHbiAZQwf4122FBYbraNdFqgw4iMij'

ORDER BY hour DESC

LIMIT 1

SELECT

COALESCE(m.date, b.date) AS date,

COALESCE(m.mints, 0) AS daily_mints,

COALESCE(b.burns, 0) AS daily_burns,

SUM(COALESCE(m.mints, 0)) OVER (ORDER BY COALESCE(m.date, b.date)) AS cumulative_minted,

SUM(COALESCE(b.burns, 0)) OVER (ORDER BY COALESCE(m.date, b.date)) AS cumulative_burned,

(cumulative_minted + cumulative_burned) AS supply,

round((supply * p.price), 2) AS market_cap