NR_WALLETS_CLAIMED | TOTAL_MOCKJUP_CLAIMED | |
---|---|---|
1 | 70112 | 1752462250 |
crypto_edgarmockJUP - Generic Stats
Updated 2024-01-25
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
›
⌄
with airdrop_claims as (
SELECT
TX_ID
from
solana.core.fact_events
where
succeeded
and block_timestamp >= '2024-01-15'
and program_id = 'meRjbQXFNf5En86FXT2YPz1dQzLj4Yb3xK8u1MVgqpb'
),
claims_as_transfers as (
SELECT
*
from
solana.core.fact_transfers
where
block_timestamp >= '2024-01-15'
and mint = 'JxxWsvm9jHt4ah7DT9NuLyVLYZcZLUdPD93PcPQ71Ka'
and TX_ID IN (
SELECT
TX_ID
FROM
airdrop_claims
)
)
select
COUNT(DISTINCT TX_TO) as NR_WALLETS_CLAIMED,
SUM(AMOUNT) AS TOTAL_MOCKJUP_CLAIMED
from
claims_as_transfers
where
amount != '2e-7'
Last run: about 1 year ago
1
20B
36s