(with ad as (select block_timestamp as t, claimer, amount

from terra.airdrop_claims

where --tx_id='5D75E2FB0044753312976F5A4133665AF0DC0779FF29A8180C53F603F2EC5C13' AND

contract_address='terra146ahqn6d3qgdvmj8cj96hh03dzmeedhsf0kxqm'

),

ancswap as (

select block_timestamp as t1, msg_value:sender as sender, msg_value:execute_msg:send:amount/1000000 as ANC_swapped

from terra.msgs

where --tx_id='0601AAAFF413B0A668355AD8C98D606B678C49E27E5E9303141AC7A410943C19' and

msg_value:contract='terra14z56l0fp2lsf86zy3hty2z47ezkhnthtr9yq76' AND

msg_value:execute_msg:send:contract='terra1gm5p3ner9x9xpwugn9sp6gvhd0lwrtkyrecdn3'

select date_trunc('day',t1) as date, count( distinct sender) as n_ad_claim_n_swap

from ad

inner join ancswap on ad.claimer=ancswap.sender

where t1>'2021-10-01'

group by 1 order by 1),

b as (select date_trunc('day',block_timestamp) as date2 , count(distinct claimer) as n_aird_claimer

from terra.airdrop_claims

where --tx_id='5D75E2FB0044753312976F5A4133665AF0DC0779FF29A8180C53F603F2EC5C13' AND

contract_address='terra146ahqn6d3qgdvmj8cj96hh03dzmeedhsf0kxqm' and block_timestamp>'2021-10-01'

group by 1 order by 1)

select date,n_aird_claimer, n_ad_claim_n_swap

from a

inner join b on a.date=b.date2),