DAY | CUMULATIVE_BALANCE_APRIORI | CUMULATIVE_BALANCE_SHMONAD | CUMULATIVE_BALANCE_MAGMA | |
|---|---|---|---|---|
1 | 2025-02-19 00:00:00.000 | 29246.29894 | 292.174192 | 805.414752 |
2 | 2025-02-20 00:00:00.000 | 137671.390938 | 2997.744104 | 96376.276053 |
3 | 2025-02-21 00:00:00.000 | 263663.421748 | 5031.363549 | 204239.217436 |
4 | 2025-02-22 00:00:00.000 | 325606.808041 | 7805.464887 | 205626.938116 |
5 | 2025-02-23 00:00:00.000 | 347068.388322 | 11213.647871 | 174393.951292 |
6 | 2025-02-24 00:00:00.000 | 404665.491218 | 14096.481443 | 188186.905591 |
7 | 2025-02-25 00:00:00.000 | 459527.7489 | 21983.285929 | 191254.253872 |
8 | 2025-02-26 00:00:00.000 | 545701.22534 | 33354.036967 | 209561.540318 |
9 | 2025-02-27 00:00:00.000 | 575515.853475 | 37792.990441 | 226338.376773 |
10 | 2025-02-28 00:00:00.000 | 580026.562047 | 52659.023242 | 242114.501393 |
11 | 2025-03-01 00:00:00.000 | 603247.645052 | 55836.633869 | 254714.73596 |
12 | 2025-03-02 00:00:00.000 | 614585.859104 | 59906.376163 | 237699.130933 |
13 | 2025-03-03 00:00:00.000 | 633532.013125 | 61548.360415 | 236909.794114 |
14 | 2025-03-04 00:00:00.000 | 637535.96409 | 168609.281606 | 235982.168974 |
15 | 2025-03-05 00:00:00.000 | 649333.398433 | 198228.291174 | 269043.60604 |
16 | 2025-03-06 00:00:00.000 | 658702.346857 | 205774.321022 | 288414.404014 |
17 | 2025-03-07 00:00:00.000 | 670452.660912 | 208291.705255 | 287212.501246 |
18 | 2025-03-08 00:00:00.000 | 669810.844587 | 214868.171791 | 290149.132173 |
19 | 2025-03-09 00:00:00.000 | 666491.138579 | 217627.508649 | 293624.965105 |
20 | 2025-03-10 00:00:00.000 | 695493.930285 | 226188.49916 | 321954.012797 |
matejchiMonad liquid staking TVL
Updated 5 hours ago
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: about 5 hours ago
54
4KB
188s