0xaimanANC aidrop selling
Updated 2021-12-18
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
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