SELECT

date_trunc('day', block_timestamp) AS date,

tx_id,

signers[0] AS signer,

f.value:parsed:info:destination AS recipient,

SUM(CASE WHEN f.value:parsed:type = 'transferChecked'

THEN f.value:parsed:info:tokenAmount:uiAmount

WHEN f.value:parsed:type = 'transfer'

THEN f.value:parsed:info:amount / pow(10, 6)

ELSE 0 END) AS amount

FROM solana.core.fact_events,

LATERAL FLATTEN(input => inner_instruction:instructions) AS f

WHERE 1 = 1

AND date BETWEEN '2024-01-01' AND '2024-06-06'

AND succeeded

AND program_id IN ('JUP6LkbZbjS1jKKwapdHNy74zcZ3tLUZoi5QNyVTaV4', 'RainEraPU5yDoJmTrHdYynK9739GkEfDsE4ffqce2BR')

AND f.value:parsed:info:destination = '2iFuMfAJi8s74WfwREnoDtyupGUMBDYhTes23j5NN6ZL'

GROUP BY 1, 2, 3, 4

date AS date,

tx_id,

signer,

recipient,

amount AS amount,

'USDC' as Currency

revenue