DAY | CUMULATIVE_BALANCE_APRIORI | CUMULATIVE_BALANCE_SHMONAD | CUMULATIVE_BALANCE_MAGMA | |
|---|---|---|---|---|
1 | 2025-02-19 00:00:00.000 | 29246.29894 | 292.174192 | 805.914752 |
2 | 2025-02-20 00:00:00.000 | 137671.390938 | 2997.744104 | 96376.776053 |
3 | 2025-02-21 00:00:00.000 | 263663.421748 | 5031.363549 | 204239.717436 |
4 | 2025-02-22 00:00:00.000 | 325618.379341 | 7806.534884 | 205631.589777 |
5 | 2025-02-23 00:00:00.000 | 347076.170822 | 11214.728366 | 174401.867093 |
6 | 2025-02-24 00:00:00.000 | 404673.373818 | 14097.561938 | 188194.854792 |
7 | 2025-02-25 00:00:00.000 | 459535.6315 | 21984.366424 | 191262.203073 |
8 | 2025-02-26 00:00:00.000 | 545709.10794 | 33355.117462 | 209569.489519 |
9 | 2025-02-27 00:00:00.000 | 575524.113216 | 37794.074662 | 226348.743754 |
10 | 2025-02-28 00:00:00.000 | 580034.991188 | 52598.919639 | 242125.355923 |
11 | 2025-03-01 00:00:00.000 | 603256.058818 | 55776.530266 | 254724.642249 |
12 | 2025-03-02 00:00:00.000 | 614594.30687 | 59847.238158 | 237708.056419 |
13 | 2025-03-03 00:00:00.000 | 633540.587961 | 61488.500012 | 236919.021975 |
14 | 2025-03-04 00:00:00.000 | 637544.538926 | 168549.421203 | 235991.396835 |
15 | 2025-03-05 00:00:00.000 | 649341.973269 | 198168.430771 | 269052.833901 |
16 | 2025-03-06 00:00:00.000 | 658710.921693 | 205714.460619 | 288423.631875 |
17 | 2025-03-07 00:00:00.000 | 670461.235748 | 208231.844852 | 287221.729107 |
18 | 2025-03-08 00:00:00.000 | 669819.419423 | 214808.311388 | 290158.360034 |
19 | 2025-03-09 00:00:00.000 | 666499.713415 | 217567.648246 | 293634.192966 |
20 | 2025-03-10 00:00:00.000 | 695502.505121 | 226128.638757 | 321963.240658 |
matejchiMonad liquid staking TVL
Updated 2025-06-04
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 filtered_apriori as (
select
block_timestamp,
contract_address,
origin_function_signature,
tx_hash,
data,
topic_2,
row_number() over(partition by tx_hash order by event_index asc) as row_no
from monad.testnet.fact_event_logs
where contract_address = lower('0xb2f82D0f38dc453D596Ad40A37799446Cc89274A')
and block_timestamp >= '2025-02-19'
),
daily_balance_apriori as (
select
date_trunc('day', block_timestamp) as day,
sum(case
when origin_function_signature = '0x6e553f65' then livequery.utils.udf_hex_to_int(data)::int /1e18 -- deposit
when origin_function_signature = '0x492e47d2' then - livequery.utils.udf_hex_to_int(data)::int /1e18 -- redeem 0x7d41c86e
else 0 end) as daily_balance_apriori
from filtered_apriori
where row_no = 1
and day < date_trunc('day', current_date)
group by day
),
filtered_shmonad as (
select
block_timestamp,
contract_address,
origin_function_signature,
tx_hash,
data,
topic_2,
row_number() over(partition by tx_hash order by event_index asc) as row_no
Last run: 14 days ago
...
105
7KB
575s