claim_txs as (

select distinct

block_timestamp

, tx_id

from solana.core.fact_events

where succeeded

and program_id = 'EXxqB6XPLczReFcZyigfbdowB6WGYtnkLYC4XZ2ae9ch'

and block_timestamp > '2023-11-20'

),

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 = 'HZ1JovNiVvGrGNiiYvEozEVgZ58xaU3RKwX8eACQBCt3'

and tx_from in (

'75WTeS4ZKruLJH4mz6omtbMNz8H9HEG1kY4G6VNQLX5i'

, '9Mb26cH5A1c9YaJ95A95HNZwPD3WxLEnucG446umE8bc'

)

and block_timestamp > '2023-11-20'

),

aggregated as (