winnie-fsGTM Airdrop Data copy
999
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
›
⌄
-- forked from mkq / GTM Airdrop Data @ https://flipsidecrypto.xyz/mkq/q/SebJpm6KCd3i/gtm-airdrop-data
-- forked from cristinatinto / PYTH airdropers actions @ https://flipsidecrypto.xyz/cristinatinto/q/oUbtymvvZhZE/pyth-airdropers-actions
--credits to marqu
with
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 (
Run a query to Download Data