SELECT

mint,

SUM(CASE WHEN succeeded = TRUE THEN mint_amount/POWER(10, decimal) ELSE 0 END) as total_minted

FROM solana.defi.fact_token_mint_actions

WHERE mint = 'mSoLzYCxHdYgdzU16g5QSh3i5K3z3KZK7ytfqcJm7So'

AND succeeded = TRUE

GROUP BY 1

),

token_burns AS (

SELECT

mint,

SUM(CASE WHEN succeeded = TRUE THEN burn_amount/POWER(10, decimal) ELSE 0 END) as total_burned

FROM solana.defi.fact_token_burn_actions

WHERE mint = 'mSoLzYCxHdYgdzU16g5QSh3i5K3z3KZK7ytfqcJm7So'

AND succeeded = TRUE

GROUP BY 1

),

latest_price AS (

SELECT

token_address,

price as current_price,

name,

symbol

FROM solana.price.ez_prices_hourly

WHERE token_address = 'mSoLzYCxHdYgdzU16g5QSh3i5K3z3KZK7ytfqcJm7So'

AND hour >= DATEADD('hour', -1, CURRENT_TIMESTAMP())

ORDER BY hour DESC

LIMIT 1

SELECT

tm.mint as token_address,

p.name,

p.symbol,

(tm.total_minted - COALESCE(tb.total_burned, 0)) as current_supply,