WITH MarkedTransactions AS (

SELECT

BLOCK_TIMESTAMP,

TX_ID,

MINT,

OWNER,

PRE_BALANCE,

BALANCE,

CASE

WHEN COUNT(TX_ID) OVER (PARTITION BY TX_ID) > 1 AND BALANCE > PRE_BALANCE THEN 'TRANSFER_RECEIVING'

WHEN COUNT(TX_ID) OVER (PARTITION BY TX_ID) > 1 AND BALANCE < PRE_BALANCE THEN 'TRANSFER_SENDING'

WHEN PRE_BALANCE > BALANCE THEN 'BURN'

WHEN BALANCE > PRE_BALANCE THEN 'MINT'

ELSE 'UNKNOWN'

END AS TRANSACTION_TYPE,

ABS(BALANCE - PRE_BALANCE) AS TOKEN_CHANGE

FROM

solana.core.fact_token_balances

WHERE

MINT IN ('C1FxQEMa7ZPmzpP8ak5PYg8iMdYaxZVNHF7pfaAcCx3D')

AND BLOCK_TIMESTAMP >= '2025-02-01'

AND SUCCEEDED = TRUE

SELECT

BLOCK_TIMESTAMP,

TX_ID,

MINT,

OWNER,

PRE_BALANCE,

BALANCE,

TRANSACTION_TYPE,

TOKEN_CHANGE,

-- Calculate minutes since the transaction occurred

DATEDIFF(MINUTE, '2025-02-01', BLOCK_TIMESTAMP) AS MINUTES_SINCE_TRANSACTION,