NUM_CLAIMERS | TXS | TOTAL_AMOUNT | PCT_CLAIMED | |
|---|---|---|---|---|
1 | 9549 | 24461 | 84838656.098972 | 84.838656099 |
Blazejito agg numbers
Updated 2024-02-12
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
›
⌄
-- forked from jito agg numbers @ https://flipsidecrypto.xyz/edit/queries/53e11bbe-45e9-4702-9991-5cbfc09cf476
-- forked from jup agg numbers @ https://flipsidecrypto.xyz/edit/queries/57778068-2de6-4e8d-add5-d9b11433ede2
WITH airdrops AS (
SELECT DISTINCT
block_timestamp,
tx_id
FROM solana.core.fact_events
WHERE succeeded
AND program_id = 'mERKcfxMC5SqJn4Ld4BUris3WKZZ1ojjWJ3A3J5CKxv'
-- and block_timestamp<'2024-01-30'
),
transfers AS (
SELECT
block_timestamp,
tx_id,
tx_to,
amount
FROM solana.core.fact_transfers
INNER JOIN airdrops USING (block_timestamp, tx_id)
WHERE lower(mint) = lower('jtojtomepa8beP8AuQc6eXt5FriJwfFMwQx2v2f9mCL')
)
SELECT
COUNT(DISTINCT tx_to) AS num_claimers,
COUNT(DISTINCT tx_id) AS txs,
SUM(amount) AS total_amount,
total_amount/100000000 * 100 as pct_claimed
FROM transfers
Last run: about 1 year ago
1
43B
127s