SELECT tx_id

From solana.core.fact_events

Where block_timestamp >= CURRENT_DATE()-INTERVAL'30 day' And SUCCEEDED = 'TRUE'

And INSTRUCTION:parsed:info:mint = '4Hnh1UCC6HLzx9NaGKnTVHR2bANcRrhydumdHCnrT3i2' and index = 2 and event_type = 'create'

, sol_deposits as (

SELECT block_timestamp::date as date, e.tx_id, INNER_INSTRUCTION:instructions[1]:parsed:info:amount / POW(10,9) as amount, INNER_INSTRUCTION:instructions[1]:parsed:info:authority as wallet

FROM solana.core.fact_events e INNER JOIN tx_sol t ON e.tx_id = t.tx_id

WHERE index = 3 and date >= CURRENT_DATE()-INTERVAL'30 day' And SUCCEEDED = 'TRUE' and INNER_INSTRUCTION:instructions[1]:parsed:type = 'transfer'

, tx_msol as (

SELECT tx_id

From solana.core.fact_events

Where block_timestamp >= CURRENT_DATE()-INTERVAL'30 day' And SUCCEEDED = 'TRUE'

And INSTRUCTION:parsed:info:mint = '6UA3yn28XecAHLTwoCtjfzy3WcyQj1x13bxnH8urUiKt' and index = 0 and event_type = 'create'

, msol_deposits as (

SELECT block_timestamp::date as date, e.tx_id, INNER_INSTRUCTION:instructions[1]:parsed:info:amount / POW(10,9) as amount,

INNER_INSTRUCTION:instructions[1]:parsed:info:authority as wallet

FROM solana.core.fact_events e INNER JOIN tx_msol t ON e.tx_id = t.tx_id

WHERE index = 1 and date >= CURRENT_DATE()-INTERVAL'30 day' And SUCCEEDED = 'TRUE' and INNER_INSTRUCTION:instructions[1]:parsed:type = 'transfer'

, deposits as (

SELECT 'mSOL' as type, wallet, SUM(amount) as msol_deposited

FROM msol_deposits

GROUP BY 1, 2

SELECT