TOTAL_CLAIMED | TOTAL_CLAIMED_PERCENTAGE | |
|---|---|---|
1 | 181000202 | 72.361110579 |
crypto_edgarAirdrop Total Claimed
Updated 2025-04-14
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
SELECT
SUM(AMOUNT) AS TOTAL_CLAIMED,
(
SUM(AMOUNT) / (
SELECT
AMOUNT
FROM
solana.core.fact_transfers
WHERE
BLOCK_ID = 231015331
AND MINT = 'HZ1JovNiVvGrGNiiYvEozEVgZ58xaU3RKwX8eACQBCt3'
AND TX_ID = '27jGRN1rKA2Kutv5hJGxp2TQ1jgguy2q2AAAQ1fA99a7wAyxXSkeqZs5WsnfwfNsCsrpY5FmHJWBaz85dDEE9adF'
)
) * 100 AS TOTAL_CLAIMED_PERCENTAGE
FROM
solana.core.fact_transfers
WHERE
BLOCK_ID >= 231020157
AND TX_FROM = '75WTeS4ZKruLJH4mz6omtbMNz8H9HEG1kY4G6VNQLX5i'
AND MINT = 'HZ1JovNiVvGrGNiiYvEozEVgZ58xaU3RKwX8eACQBCt3'
AND TX_ID != '5reax2Qx1M7H9Ycmha5NePxue18sRy5oU5CWiQYmjySTSC8k5wPw73HFr3Rz38bd77sJjBEvDdLHazQ5DPfeyxEC'
Last run: 2 months ago
1
26B
35s