LTirrellgenesis_airdrop_claims_pylon
Updated 2021-10-04
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
›
⌄
WITH L_Airdrops AS (
select
distinct date_trunc('week', m.block_timestamp) as date,
m.tx_id,
m.msg_value : contract :: string AS contract,
m.msg_value : sender :: string AS sender,
m.msg_value : execute_msg : claim : amount / POW(10, 6) AS token_amount,
m.msg_value : execute_msg : claim : stage AS stage
from
terra.msgs m
where
m.msg_value : execute_msg : claim is not null
and m.tx_status = 'SUCCEEDED'
and stage = 1
and m.msg_value : contract :: string = 'terra1ud39n6c42hmtp2z0qmy8svsk7z3zmdkxzfwcf2'
)
select
date,
count(tx_id),
sum(token_amount)
from
L_airdrops
group by
date
order by
date
Run a query to Download Data