transfers as (

select

block_timestamp

, tx_id

, tx_to

, amount

from solana.core.fact_transfers

where mint = '7i5KKsX2weiTkry7jA4ZwSuXGhs5eJBEjY8vVxR4pfRx' -- Token Contract

and tx_from = 'STEPNq2UGeGSzCyGVr2nMQAzf8xuejwqebd84wcksCK' -- Airdrop Contract

and block_timestamp between '2022-03-15' and dateadd(month, 3, '2022-03-15')

),

aggregated as (

select

tx_to as claimer

, sum(amount) as gmt

, count(1) as txs

from transfers

group by 1

),

swap_activity as (

select

claimer

, sum(iff(swap_from_mint = '7i5KKsX2weiTkry7jA4ZwSuXGhs5eJBEjY8vVxR4pfRx', swap_from_amount, 0)) as swap_from_amount

, sum(iff(swap_to_mint = '7i5KKsX2weiTkry7jA4ZwSuXGhs5eJBEjY8vVxR4pfRx', swap_to_amount, 0)) as swap_to_amount