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

),

daily_prices AS (

SELECT

DATE_TRUNC('day', hour) as date,

token_address,

FIRST_VALUE(price) OVER (PARTITION BY DATE_TRUNC('day', hour), token_address ORDER BY hour) as day_open,

LAST_VALUE(price) OVER (PARTITION BY DATE_TRUNC('day', hour), token_address ORDER BY hour) as day_close,