0xaimanANC aidrop selling
    Updated 2021-12-18
    with c as (with a as
    (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),
    Run a query to Download Data