AMOUNT | WALLET | |
|---|---|---|
1 | 20200 | 4475 |
2 | 8200 | 12 |
3 | 7450 | 7 |
4 | 33700 | 2 |
5 | 15450 | 1 |
6 | 510 | 1 |
7 | 0 | 1 |
8 | 17 | 1 |
9 | 5200 | 32 |
10 | 2200 | 12 |
11 | 10950 | 5 |
12 | 15700 | 4 |
13 | 15200 | 2 |
14 | 95200 | 2 |
15 | 6200 | 18 |
16 | 156000 | 1 |
17 | 30450 | 1 |
18 | 93450 | 1 |
19 | 72.5 | 1 |
20 | 207 | 1 |
freemartianAirdrop Claim Distribution copy
Updated 2024-02-14
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
›
⌄
with txs AS (
SELECT
*
FROM solana.core.fact_events
WHERE block_timestamp::date >= '2024-01-31'
-- AND tx_id = '3wWcrgvBLsuZBwVCeM2m78EJM7tv1VvsbqeHJmo52sPvKdLEKe4VNr75TAcbSSABzqTRTFaRs7vdEoXagYAJA1ta'
-- AND mint = 'JUPyiwrYJFskUPiHa7hkeR8VUtAeFoSYbKedZNsDvCN'
AND program_id = 'meRjbQXFNf5En86FXT2YPz1dQzLj4Yb3xK8u1MVgqpb'
),
claim AS(
SELECT
block_timestamp,
tx_id,
tx_to,
amount
FROM solana.core.fact_transfers
WHERE tx_id IN (SELECT tx_id FROM txs)
AND block_timestamp::date >= '2024-01-31'
-- AND tx_id = '3wWcrgvBLsuZBwVCeM2m78EJM7tv1VvsbqeHJmo52sPvKdLEKe4VNr75TAcbSSABzqTRTFaRs7vdEoXagYAJA1ta'
AND mint = 'JUPyiwrYJFskUPiHa7hkeR8VUtAeFoSYbKedZNsDvCN'
)
SELECT
amount,
count(DISTINCT tx_to) AS wallet
FROM claim
GROUP BY 1
Last run: about 1 year ago
...
145
1KB
442s