SELECT tx_id, inner_instruction:instructions[3]:parsed:info:owner as wallet

from solana.core.fact_events

where block_timestamp >= CURRENT_DATE()-INTERVAL'30 day' and index = 0 and inner_instruction:instructions[3]:parsed:info:mint = '3BjcHXvyzMsjmeqE2qFLx45K4XFx3JPiyRnjJiF5MAHt'

, all_deposit as (

SELECT block_timestamp::date as date, tx_id, INNER_INSTRUCTION:instructions[0]:parsed:info:authority::string as authority,

INNER_INSTRUCTION:instructions[0]:parsed:info:amount::number / POW(10,6) as amount

FROM solana.core.fact_events --e, lateral flatten(e.PRETOKENBALANCES) f

WHERE INSTRUCTION:programId = 'VoLT1mJz1sbnxwq5Fv2SXjdVDgPXrb9tJyC8WpMDkSp'

and authority <> 'DA1M8mw7GnPNKU9ReANtHPQyuVzKZtsuuSbCyc2uX2du'

and INNER_INSTRUCTION:instructions[0]:parsed:type = 'transfer'

and block_timestamp >= CURRENT_DATE()-INTERVAL'30 day' and array_contains('3BjcHXvyzMsjmeqE2qFLx45K4XFx3JPiyRnjJiF5MAHt'::variant, instruction:accounts)

UNION

SELECT block_timestamp::date as date, e.tx_id, d.wallet as authority,

INNER_INSTRUCTION:instructions[1]:parsed:info:amount::number / POW(10,6) as amount

FROM solana.core.fact_events e INNER JOIN first_deposit d ON e.tx_id = d.tx_id

WHERE index = 1 and INSTRUCTION:programId = 'VoLT1mJz1sbnxwq5Fv2SXjdVDgPXrb9tJyC8WpMDkSp' and INNER_INSTRUCTION:instructions[1]:parsed:type = 'transfer'

and authority <> 'DA1M8mw7GnPNKU9ReANtHPQyuVzKZtsuuSbCyc2uX2du'

SELECT authority, SUM(amount) as deposited_amount

FROM all_deposit

GROUP BY 1

ORDER BY 2 DESC

LIMIT 50