WEEK | AVG_PRICE | TOTAL_MINT | TOTAL_BURNT | TOTAL_SUPPLY | TOTAL_SUPPLY_USD | |
|---|---|---|---|---|---|---|
1 | 2025-02-17 00:00:00.000 | 232.85 | 120471.800627318 | -180157.558668834 | 3904035.28825957 | 909054616.871242 |
2 | 2025-02-10 00:00:00.000 | 256.9 | 175263.368307195 | -143119.244168958 | 3963721.04630109 | 1018279936.79475 |
3 | 2025-02-03 00:00:00.000 | 250.54 | 189263.203910661 | -417349.218761851 | 3931576.92216285 | 985017282.078681 |
4 | 2025-01-27 00:00:00.000 | 291.85 | 87282.824703684 | -156325.026791717 | 4159662.93701404 | 1213997628.16755 |
5 | 2025-01-20 00:00:00.000 | 311.125 | 176391.98016964 | -171609.718337215 | 4228705.13910208 | 1315655886.40313 |
6 | 2025-01-13 00:00:00.000 | 226.09 | 119200.571753792 | -218142.609982419 | 4223922.87726966 | 954986723.321896 |
7 | 2025-01-06 00:00:00.000 | 270.645 | 273421.964885854 | -283616.799543983 | 4322864.91549828 | 1169961775.05503 |
8 | 2024-12-30 00:00:00.000 | 239.15 | 76199.866012755 | -94039.260812154 | 4333059.75015641 | 1036251239.24991 |
9 | 2024-12-23 00:00:00.000 | 228.43 | 167693.931940209 | -223510.085944976 | 4350899.14495581 | 993875891.682256 |
10 | 2024-12-16 00:00:00.000 | 272.835 | 175513.528945252 | -146391.679803806 | 4406715.29896058 | 1202306168.59191 |
11 | 2024-12-09 00:00:00.000 | 285.505 | 176980.734029981 | -80818.909206692 | 4377593.44981913 | 1249824817.89061 |
12 | 2024-12-02 00:00:00.000 | 280.705 | 240905.592231499 | -204608.579909947 | 4281431.62499584 | 1201819264.29446 |
13 | 2024-11-25 00:00:00.000 | 310.35 | 96401.738418309 | -86497.185635059 | 4245134.61267429 | 1317477527.04347 |
14 | 2024-11-18 00:00:00.000 | 297.885 | 88653.015734248 | -129768.131446509 | 4235230.05989104 | 1261611506.39064 |
15 | 2024-11-11 00:00:00.000 | 263.23 | 123350.825069843 | -179209.338690499 | 4276345.1756033 | 1125662340.57406 |
16 | 2024-11-04 00:00:00.000 | 199.32 | 75558.990095855 | -111387.525175328 | 4332203.68922396 | 863494839.33612 |
17 | 2024-10-28 00:00:00.000 | 215.695 | 150933.512343074 | -58783.947578563 | 4368032.22430344 | 942162710.62113 |
18 | 2024-10-21 00:00:00.000 | 204.77 | 370875.673137191 | -299485.131564289 | 4275882.65953892 | 875572492.193786 |
19 | 2024-10-14 00:00:00.000 | 187.37 | 66709.800591027 | -97356.841167284 | 4204492.11796602 | 787795688.143294 |
20 | 2024-10-07 00:00:00.000 | 181.465 | 155190.844249125 | -177775.873347437 | 4235139.15854228 | 768529527.404875 |
0xHaM-dWeekly Mint and Burn
Updated 2025-02-19
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 priceTb as (
select
date_trunc('day',hour) as week,
median(price) as avg_price,
from solana.price.ez_prices_hourly
where token_address = 'mSoLzYCxHdYgdzU16g5QSh3i5K3z3KZK7ytfqcJm7So'
group by 1
)
,
mintEvent as (
select
trunc(block_timestamp,'week') as date,
sum(MSOL_MINTED) as total_mint,
sum(total_mint) over (order by date asc) as total_minted
from solana.marinade.ez_liquid_staking_actions
where action_type in ('depositStakeAccount','deposit')
group by 1
order by 1 desc
)
,
burnEvent as (
select
trunc(block_timestamp,'week') as date,
sum(MSOL_BURNED*-1) as total_burnt,
sum(total_burnt) over (order by date asc) as total_burned
from solana.marinade.ez_liquid_staking_actions
where action_type in ('orderUnstake')
group by 1
order by 1 desc
)
select
COALESCE(me.date,be.date) as week,
avg_price,
total_mint,
total_burnt,
total_minted + total_burned as total_supply,
Last run: about 1 month ago
...
187
20KB
2s