TOTAL_CLAIMING | TOTAL_CLAIMER | USD_VALUE | AMOUNTS | AVG_CLAIM | MIN_CLAIM | MAX_CLAIM | INITIAL_CLAIM | UNCLAIMED_AMOUNT | UNCLAIMED_PERCENTAGE | |
---|---|---|---|---|---|---|---|---|---|---|
1 | 216186 | 183583 | 541148959.48 | 108577348 | 2503.16375473 | 61.469166667 | 803563.558888889 | 125000000 | 16422652 | 13.1381216 |
damidezMagic Eden - $ME Claim agg
Updated 19 hours ago
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
›
⌄
WITH meprice AS (
SELECT
trunc(hour, 'day') AS day,
AVG(price) AS price
FROM
solana.price.ez_prices_hourly
WHERE
token_address = 'MEFNBXixkEbait3xn9bkm8WsJzXtVsaJEn4c8Sam21u'
GROUP BY
day
),
claim_txs AS (
SELECT
block_timestamp,
tx_id,
signers[0] AS fee_payer,
instruction :accounts[1] AS claimer,
utils.udf_hex_to_int(
to_char(reverse(to_binary(substr(utils.udf_base58_to_hex(instruction :data), 19, 16))))
) / pow(10, 6) AS amount,
'veT' AS claim_program
FROM solana.core.fact_events
WHERE succeeded
AND fact_events.program_id = 'veTbq5fF2HWYpgmkwjGKTYLVpY6miWYYmakML7R7LRf'
AND substr(utils.udf_base58_to_hex(fact_events.instruction :data), 3, 16) = '0438e530aa0ffd05' -- Claim From Distribution
AND block_timestamp >= '2024-12-10 14:05:13.000'
UNION ALL
SELECT
block_timestamp,
tx_id,
signers[0] AS fee_payer,
instruction :accounts[4] AS claimer,
utils.udf_hex_to_int(
to_char(reverse(to_binary(substr(utils.udf_base58_to_hex(instruction :data), 19, 16))))
Last run: about 19 hours ago
1
116B
125s