select

-- block_timestamp::date as day

-- ,count(DISTINCT tx_id) as count_tx

-- count(DISTINCT INSTRUCTION:parsed:info:wallet) as wallet_count

INSTRUCTION:parsed:info:wallet as wallet

,case

when PRETOKENBALANCES[0]:owner=INSTRUCTION:parsed:info:wallet and PRETOKENBALANCES[0]:mint='9n4nbM75f5Ui33ZbPYXn59EwSgE8CGsHtAeTH5YFeJ9E' then PRETOKENBALANCES[0]:uiTokenAmount:uiAmount

when PRETOKENBALANCES[1]:owner=INSTRUCTION:parsed:info:wallet and PRETOKENBALANCES[1]:mint='9n4nbM75f5Ui33ZbPYXn59EwSgE8CGsHtAeTH5YFeJ9E' then PRETOKENBALANCES[1]:uiTokenAmount:uiAmount

when PRETOKENBALANCES[2]:owner=INSTRUCTION:parsed:info:wallet and PRETOKENBALANCES[2]:mint='9n4nbM75f5Ui33ZbPYXn59EwSgE8CGsHtAeTH5YFeJ9E' then PRETOKENBALANCES[2]:uiTokenAmount:uiAmount

when PRETOKENBALANCES[3]:owner=INSTRUCTION:parsed:info:wallet and PRETOKENBALANCES[3]:mint='9n4nbM75f5Ui33ZbPYXn59EwSgE8CGsHtAeTH5YFeJ9E' then PRETOKENBALANCES[3]:uiTokenAmount:uiAmount

when PRETOKENBALANCES[4]:owner=INSTRUCTION:parsed:info:wallet and PRETOKENBALANCES[4]:mint='9n4nbM75f5Ui33ZbPYXn59EwSgE8CGsHtAeTH5YFeJ9E' then PRETOKENBALANCES[4]:uiTokenAmount:uiAmount

when PRETOKENBALANCES[5]:owner=INSTRUCTION:parsed:info:wallet and PRETOKENBALANCES[5]:mint='9n4nbM75f5Ui33ZbPYXn59EwSgE8CGsHtAeTH5YFeJ9E' then PRETOKENBALANCES[5]:uiTokenAmount:uiAmount

when PRETOKENBALANCES[6]:owner=INSTRUCTION:parsed:info:wallet and PRETOKENBALANCES[6]:mint='9n4nbM75f5Ui33ZbPYXn59EwSgE8CGsHtAeTH5YFeJ9E' then PRETOKENBALANCES[6]:uiTokenAmount:uiAmount

when PRETOKENBALANCES[7]:owner=INSTRUCTION:parsed:info:wallet and PRETOKENBALANCES[7]:mint='9n4nbM75f5Ui33ZbPYXn59EwSgE8CGsHtAeTH5YFeJ9E' then PRETOKENBALANCES[7]:uiTokenAmount:uiAmount

when PRETOKENBALANCES[8]:owner=INSTRUCTION:parsed:info:wallet and PRETOKENBALANCES[8]:mint='9n4nbM75f5Ui33ZbPYXn59EwSgE8CGsHtAeTH5YFeJ9E' then PRETOKENBALANCES[8]:uiTokenAmount:uiAmount

when PRETOKENBALANCES[9]:owner=INSTRUCTION:parsed:info:wallet and PRETOKENBALANCES[9]:mint='9n4nbM75f5Ui33ZbPYXn59EwSgE8CGsHtAeTH5YFeJ9E' then PRETOKENBALANCES[9]:uiTokenAmount:uiAmount

when PRETOKENBALANCES[10]:owner=INSTRUCTION:parsed:info:wallet and PRETOKENBALANCES[10]:mint='9n4nbM75f5Ui33ZbPYXn59EwSgE8CGsHtAeTH5YFeJ9E' then PRETOKENBALANCES[0]:uiTokenAmount:uiAmount

else 0 end amount_btc

from solana.events

Where block_timestamp:: date >= '2022-01-28'

-- where tx_id='cAPgJr1JXSFcW8CCD4BK98HmoYrCHX4dozZEk1gNQm6yESMJg2rcC22GBoEE677wVVTxuhhQ217VUnUKe4khzc3'

-- and (PRETOKENBALANCES[3]:mint='9n4nbM75f5Ui33ZbPYXn59EwSgE8CGsHtAeTH5YFeJ9E')

and INSTRUCTION:parsed:info:mint='3BjcHXvyzMsjmeqE2qFLx45K4XFx3JPiyRnjJiF5MAHt'

-- and INSTRUCTION:parsed:info:systemProgram='11111111111111111111111111111111'

and SUCCEEDED=true

and INDEX=0

order by amount_btc DESC

limit 10

-- group by 1

-- order by 1

,lst_remove as (

select

count(tx_id) as count_tx