BLOCK_TIMESTAMP as date,

SPLIT_PART(INSTRUCTIONS[3]:parsed, ' ', 1) || ' ' || SPLIT_PART(INSTRUCTIONS[3]:parsed, ' ', 2) AS Instruction,

tx.tx_id,

CASE WHEN INSTRUCTIONS[4]:programId='CoREENxT6tW1HoK8ypY1SxRMZTcVPm7R94rH4PZNhX7d' THEN INSTRUCTIONS[4]:accounts[0] ELSE INSTRUCTIONS[4]:parsed:info:mint END AS token_address,

CASE WHEN INSTRUCTIONS[4]:programId='CoREENxT6tW1HoK8ypY1SxRMZTcVPm7R94rH4PZNhX7d' THEN INSTRUCTIONS[4]:accounts[1] ELSE '' END AS Collection_ID,

'BUY' AS market_order,

CASE WHEN INSTRUCTIONS[4]:programId='CoREENxT6tW1HoK8ypY1SxRMZTcVPm7R94rH4PZNhX7d' THEN 1 WHEN INSTRUCTIONS[4]:program = 'spl-associated-token-account' THEN INSTRUCTIONS[5]:parsed:info:tokenAmount:uiAmount ELSE INSTRUCTIONS[4]:parsed:info:tokenAmount:uiAmount END AS token_amount,

CASE WHEN INSTRUCTIONS[4]:program = 'spl-associated-token-account' THEN INSTRUCTIONS[7]:parsed:info:source ELSE INSTRUCTIONS[6]:parsed:info:source END AS Buyer,

CASE WHEN INSTRUCTIONS[4]:program = 'spl-associated-token-account' THEN INSTRUCTIONS[7]:parsed:info:destination ELSE INSTRUCTIONS[6]:parsed:info:destination END AS Seller,

CASE WHEN INSTRUCTIONS[4]:program = 'spl-associated-token-account' THEN INSTRUCTIONS[7]:parsed:info:lamports/0.94/1e9 ELSE INSTRUCTIONS[6]:parsed:info:lamports/0.94/1e9 END AS sol_amount

FROM solana.core.fact_transactions tx

WHERE (DATE(tx.block_timestamp) BETWEEN DATE('2025-02-01') AND DATE('2025-02-28'))

AND SIGNERS[1] = '2vTuoHNQiief6RGTwmeUKNTkHdK5DpzaRHcs6XNfUxsV'

AND tx.SUCCEEDED = TRUE;