TOTAL_CLAIMING | TOTAL_CLAIMER | USD_VALUE | AMOUNTS | AVG_CLAIM | MIN_CLAIM | MAX_CLAIM | |
|---|---|---|---|---|---|---|---|
1 | 400722 | 246610 | 29493885.1406523 | 67050029.29 | 73.601861492 | 0 | 15319346.7486222 |
Spectersonic onchain
Updated 2025-03-02
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 = 'SonicxvLud67EceaEzCLRnMTBqzYUUYNr93DBkBdDES'
GROUP BY
day
),
claim_txs AS (
SELECT block_timestamp, tx_id, tx_to AS claimer, amount
FROM solana.core.fact_transfers
WHERE tx_from = 'BU7ig4oPEUhqXhGzuPjfBE5xwETqFtuBk352TXQaaXK7'
and mint = 'SonicxvLud67EceaEzCLRnMTBqzYUUYNr93DBkBdDES'
--AND tx_id = '5383a12jv34btw2rUAf3KBmdDX2jwDf4o3CrMNJj6EGDXvTYJdkNkkhj9zrD5N4cGqmSKarnsTkHWZPMC1fiGS6t'
)
SELECT
COUNT(ct.tx_id) AS total_claiming,
COUNT(DISTINCT ct.claimer) AS total_claimer,
SUM(ct.amount * np.price) AS usd_value,
SUM(ct.amount) AS amounts,
AVG(ct.amount * np.price) AS avg_claim,
MIN(ct.amount * np.price) AS min_claim,
MAX(ct.amount * np.price) AS max_claim
FROM
claim_txs AS ct
LEFT JOIN
meprice AS np
ON
DATE_TRUNC('day', ct.block_timestamp) = np.day
Last run: about 2 months ago
1
78B
76s