STAKING_TYPE | TOTAL_UNIQUE_CLAIMERS | TOTAL_SOL_CLAIMED | TOTAL_USD_CLAIMED | AVG_SOL_PER_CLAIM | |
|---|---|---|---|---|---|
1 | Liquid Staking Claim | 241 | 1465555.73293014 | 338204272.216528 | 1807.097081295 |
gigiokobamsol 1
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
›
⌄
WITH price_cte AS (
SELECT
TRUNC(hour, 'hour') AS hour_ts,
TOKEN_ADDRESS,
SYMBOL,
AVG(price) AS avg_price
FROM solana.price.ez_prices_hourly
WHERE TOKEN_ADDRESS = 'mSoLzYCxHdYgdzU16g5QSh3i5K3z3KZK7ytfqcJm7So'
AND TRUNC(hour, 'day') BETWEEN DATEADD(day, -30, CURRENT_DATE) AND CURRENT_DATE
GROUP BY 1, TOKEN_ADDRESS, SYMBOL
),
msol_claims AS (
SELECT
'Liquid Staking Claim' AS staking_type,
COUNT(DISTINCT a.provider_address) AS total_unique_claimers,
COALESCE(SUM(a.claim_amount), 0) AS total_sol_claimed,
COALESCE(SUM(a.claim_amount * price_cte.avg_price), 0) AS total_usd_claimed,
COALESCE(AVG(a.claim_amount), 0) AS avg_sol_per_claim
FROM solana.marinade.ez_liquid_staking_actions a
JOIN price_cte
ON TRUNC(a.block_timestamp, 'hour') = price_cte.hour_ts
WHERE a.block_timestamp >= DATEADD(day, -30, CURRENT_DATE)
AND a.action_type = 'claim'
)
SELECT *
FROM msol_claims;
Last run: 13 days ago
1
79B
1s