SELECT

date_trunc('hour', block_timestamp) as hour,

--mint,

SUM(CASE

WHEN tx_to = 'AQfP7s3m2zJh3pE57yHqErZ3uqzSArarr7ZwnhZHFLQE' THEN amount

ELSE -amount

END) AS balance

FROM solana.core.fact_transfers

WHERE

(tx_from = 'AQfP7s3m2zJh3pE57yHqErZ3uqzSArarr7ZwnhZHFLQE'

OR tx_to = 'AQfP7s3m2zJh3pE57yHqErZ3uqzSArarr7ZwnhZHFLQE')

and mint like 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v'

GROUP BY 1

),

tab2 AS (

SELECT

DATE_TRUNC('hour', block_timestamp) AS hour,

SUM(

CASE

WHEN type = 'Mint' THEN amount

ELSE -amount

END / POWER(10, 9)

) AS supply

FROM (

SELECT block_timestamp, mint_amount AS amount, 'Mint' AS type

FROM solana.defi.fact_token_mint_actions

WHERE mint = '6mnrEFQoYs7LujnQfWL3d9reYfEb3N1EN3qLk8dtSWj4'

UNION ALL

SELECT block_timestamp, burn_amount AS amount, 'Burn' AS type

FROM solana.defi.fact_token_burn_actions

WHERE mint = '6mnrEFQoYs7LujnQfWL3d9reYfEb3N1EN3qLk8dtSWj4'

)