SELECT DISTINCT

b.tx_id

FROM solana.defi.fact_token_burn_actions b

JOIN solana.core.fact_events e

on b.tx_id = e.tx_id

WHERE 1 = 1

AND mint IN ('4G6cezvPtS3Z8XAkpZ2UD888864SJacfHSUDT5GmVHsA', 'EdgaCn1LbwacE6yDZa5ve3wJe7JV1JEjiiqzuxn84GM2')

AND e.program_id = 'VAU1T7S5UuEHmMvXtXMVmpEoQtZ2ya7eRb7gcN47wDp'

),

base_data AS (

SELECT

t.block_timestamp as date,

date_trunc('hour', t.block_timestamp) AS hour,

t.tx_id AS transaction_id,

e.signers[0] AS trader,

CASE WHEN t.mint = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v' THEN 'Higher/Buy Cloud'

WHEN t.mint = 'CLoUDKc4Ane7HeQcPpE3YHnznRxhMimJ4MyaUqyHFzAu' THEN 'Lower/Sell Cloud'

ELSE NULL

END as vote_choice,

amount,

mint

FROM solana.core.fact_transfers t

JOIN solana.core.fact_events e

ON e.tx_id = t.tx_id

WHERE 1 = 1

AND t.tx_from = e.signers[0]

AND instruction:accounts[0] IN ('UV83TfkpPieqqqmg6TjFdTd1hPJvDfWaN1CFgeaRahY', 'HLBb7uV4693U8AerojT9ZLHG3x8q5sEUdPQYmTNXqnfU') -- USDC and Cloud Vaults

AND tx_to = instruction:accounts[0] -- Vault

AND e.program_id = 'VAU1T7S5UuEHmMvXtXMVmpEoQtZ2ya7eRb7gcN47wDp'

AND e.succeeded

AND e.block_timestamp > '2025-02-03 16:38'

AND t.tx_id NOT IN (SELECT tx_id FROM merge_condition)

),