UNIQUE_DEPOSITORS | TOTAL_DEPOSITS | TOTAL_SOL_DEPOSITED | TOTAL_USD_VALUE | AVG_SOL_DEPOSIT | AVG_USD_DEPOSIT | |
|---|---|---|---|---|---|---|
1 | 6192 | 9910 | 1092601.66366086 | 244100470.231773 | 110.497741066 | 24686.536228941 |
gigiokobahelpful-purple
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
›
⌄
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 hour >= DATEADD(day, -30, CURRENT_DATE())
GROUP BY 1, TOKEN_ADDRESS, SYMBOL
)
SELECT
COUNT(DISTINCT ls.PROVIDER_ADDRESS) AS unique_depositors,
COUNT(*) AS total_deposits,
SUM(ls.DEPOSIT_AMOUNT) AS total_sol_deposited,
SUM(ls.DEPOSIT_AMOUNT * price_cte.avg_price) AS total_usd_value,
AVG(ls.DEPOSIT_AMOUNT) AS avg_sol_deposit,
AVG(ls.DEPOSIT_AMOUNT * price_cte.avg_price) AS avg_usd_deposit
FROM solana.marinade.ez_liquid_staking_actions ls
JOIN price_cte ON TRUNC(ls.BLOCK_TIMESTAMP, 'hour') = price_cte.hour_ts
WHERE ls.ACTION_TYPE IN ('deposit', 'depositStakeAccount')
AND ls.BLOCK_TIMESTAMP >= DATEADD(day, -30, CURRENT_DATE());
Last run: 13 days ago
1
77B
2s