claim_txs as (

select distinct

block_timestamp

, tx_id

from solana.core.fact_events

where succeeded

and program_id = 'mERKcfxMC5SqJn4Ld4BUris3WKZZ1ojjWJ3A3J5CKxv'

and block_timestamp > '2023-12-07 16:00:00'

),

transfers as (

select

block_timestamp

, tx_id

, tx_to

, amount

from solana.core.fact_transfers

inner join claim_txs

using(block_timestamp, tx_id)

where mint = 'jtojtomepa8beP8AuQc6eXt5FriJwfFMwQx2v2f9mCL'

and tx_from = 'HS8EQ8QkQSBJggY8r255AKdWbtYRtyNMoRt4LjNkkWm1'

and block_timestamp > '2023-12-07 16:00:00'

),

aggregated as (

select