date_trunc('day', block_timestamp) AS date,

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 fee

FROM solana.core.fact_events,

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

WHERE 1 = 1

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

AND f.value:parsed:info:destination = '61VstiXJ3No9KdhxXu5vG51F68uWsoTDigycQsTgdePm'

AND date >= '2024-06-01'

AND date <= '2024-09-01'

GROUP BY 1;