DATE | NUM_CLAIMERS | TXS | AMT | TOTAL_CLAIMERS | CUM_AMT | PCT_CLAIMED | |
|---|---|---|---|---|---|---|---|
1 | 2024-01-24 00:00:00.000 | 1 | 92 | 59215984 | 1 | 59215984 | 0.0085 |
2 | 2024-01-25 00:00:00.000 | 1 | 92 | 59215984 | 2 | 118431968 | 0.0169 |
3 | 2024-01-26 00:00:00.000 | 441642 | 441629 | 284720749504 | 441644 | 284839181472 | 40.6913 |
4 | 2024-01-27 00:00:00.000 | 145576 | 145570 | 93704789116 | 587220 | 378543970588 | 54.0777 |
5 | 2024-01-28 00:00:00.000 | 48676 | 48649 | 31640001364 | 635896 | 410183971952 | 58.5977 |
6 | 2024-01-29 00:00:00.000 | 30904 | 30971 | 20015646244 | 666800 | 430199618196 | 61.4571 |
Blazewen claim progress
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 jup claim progress @ https://flipsidecrypto.xyz/edit/queries/e8a48679-db37-414e-8459-b182069a67b7
WITH airdrops AS (
SELECT DISTINCT
block_timestamp,
tx_id
FROM solana.core.fact_events
WHERE succeeded
AND program_id = 'meRjbQXFNf5En86FXT2YPz1dQzLj4Yb3xK8u1MVgqpb'
and block_timestamp<'2024-01-30'
),
transfers AS (
SELECT
block_timestamp,
tx_id,
tx_to,
643652 as amount
FROM solana.core.fact_transfers
INNER JOIN airdrops USING (block_timestamp, tx_id)
WHERE lower(mint) = lower('WENWENvqqNya429ubCdR81ZmD69brwQaaBYY6p3LCpk')
)
SELECT
DATE_TRUNC('day', block_timestamp) AS date,
COUNT(DISTINCT tx_to) AS num_claimers,
COUNT(DISTINCT tx_id) AS txs,
SUM(amount) AS amt,
SUM(num_claimers) OVER (ORDER BY date) AS total_claimers,
SUM(amt) OVER (ORDER BY date) AS cum_amt,
cum_amt/700000000000 * 100 as pct_claimed
FROM transfers
GROUP BY 1
order by 1
Last run: about 1 year ago
6
447B
18s