SELECT * FROM $query('24eefe5a-ba15-4c37-b217-2e4788dceaa8')

),

valannia_nft_collections AS (

SELECT * FROM $query('943ad751-52b1-4098-aa65-555ce771f935')

),

MARKET_SOURCE_MONTHLY AS (

--MARKET_SOURCE_202501

SELECT * FROM $query('b2a2a4d1-428c-40b3-90a8-b2162c99dac8')

UNION ALL

--MARKET_SOURCE_202502

SELECT * FROM $query('a5f07f3c-337e-4876-99fc-c8004e85d47b')

),

buy_orders AS (

select

BLOCK_TIMESTAMP as date,

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) > TIMESTAMPADD(HOUR, -24, CURRENT_TIMESTAMP)

AND SIGNERS[0] = INSTRUCTIONS[6]:parsed:info:source AND SIGNERS[1] = '2vTuoHNQiief6RGTwmeUKNTkHdK5DpzaRHcs6XNfUxsV'

AND (INSTRUCTIONS[4]:parsed:info:mint<>'' OR INSTRUCTIONS[4]:programId='CoREENxT6tW1HoK8ypY1SxRMZTcVPm7R94rH4PZNhX7d')

AND LEFT(INSTRUCTIONS[3]:parsed,8) <> 'VVII Add' AND LEFT(INSTRUCTIONS[3]:parsed,11) <> 'VVII Remove' AND LEFT(INSTRUCTIONS[3]:parsed,15) <> 'VVII CancelSell'

AND tx.SUCCEEDED = TRUE