TOTAL_MSOL_MINTED | TOTAL_MSOL_BURNED | NET_MSOL_CHANGE | TOTAL_MSOL_MINTED_USD | TOTAL_MSOL_BURNED_USD | NET_MSOL_CHANGE_USD | STAKING_TREND | |
|---|---|---|---|---|---|---|---|
1 | 858474.302407842 | 1133338.93591959 | -274864.633511744 | 192715300.720976 | 260691767.415803 | -67976466.6948272 | Contracting |
gigiokobamsol 2
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 daily_metrics AS (
SELECT
DATE_TRUNC('day', block_timestamp) AS date,
SUM(msol_minted) AS total_msol_minted,
SUM(msol_burned) AS total_msol_burned,
SUM(msol_minted) - SUM(msol_burned) AS net_msol_change
FROM solana.marinade.ez_liquid_staking_actions
WHERE block_timestamp >= DATEADD(day, -30, CURRENT_DATE)
AND block_timestamp < CURRENT_DATE
GROUP BY 1
),
price_daily AS (
SELECT
DATE_TRUNC('day', hour) AS date,
AVG(price) AS avg_price
FROM solana.price.ez_prices_hourly
WHERE TOKEN_ADDRESS = 'mSoLzYCxHdYgdzU16g5QSh3i5K3z3KZK7ytfqcJm7So'
AND DATE_TRUNC('day', hour) >= DATEADD(day, -30, CURRENT_DATE)
AND DATE_TRUNC('day', hour) < CURRENT_DATE
GROUP BY 1
)
SELECT
SUM(dm.total_msol_minted) AS total_msol_minted,
SUM(dm.total_msol_burned) AS total_msol_burned,
SUM(dm.net_msol_change) AS net_msol_change,
SUM(dm.total_msol_minted * pd.avg_price) AS total_msol_minted_usd,
SUM(dm.total_msol_burned * pd.avg_price) AS total_msol_burned_usd,
SUM(dm.net_msol_change * pd.avg_price) AS net_msol_change_usd,
CASE
WHEN SUM(dm.net_msol_change) > 0 THEN 'Growing'
WHEN SUM(dm.net_msol_change) < 0 THEN 'Contracting'
ELSE 'Neutral'
END AS staking_trend
FROM daily_metrics dm
JOIN price_daily pd ON dm.date = pd.date;
Last run: 13 days ago
1
121B
2s