select

*

from

solana.core.fact_events

join solana.core.fact_transfers using (block_timestamp, tx_id)

where

block_timestamp > '2024-01-31 14:00:00'

and program_id = 'meRjbQXFNf5En86FXT2YPz1dQzLj4Yb3xK8u1MVgqpb'

and MINT = 'JUPyiwrYJFskUPiHa7hkeR8VUtAeFoSYbKedZNsDvCN'

and tx_to = instruction :accounts [4]

),

post_claim as (

select

*

from

solana.core.fact_transfers

where

mint = 'JUPyiwrYJFskUPiHa7hkeR8VUtAeFoSYbKedZNsDvCN'

and block_timestamp > '2024-01-31 14:00:00'

and amount > 0

and tx_id not in (

select

tx_id

from

claims

)

),

tos as(

select

tx_to,

sum(amount) as ins

from

post_claim

group by

1