DAY | LIQUIDTY_USD | |
|---|---|---|
1 | 2025-03-06 00:00:00.000 | 15029947.3565779 |
2 | 2025-03-05 00:00:00.000 | 15371043.9748453 |
3 | 2025-03-04 00:00:00.000 | 14653420.065715 |
4 | 2025-03-03 00:00:00.000 | 15745346.3725841 |
5 | 2025-03-02 00:00:00.000 | 14656833.4746554 |
6 | 2025-03-01 00:00:00.000 | 14753696.6621802 |
7 | 2025-02-28 00:00:00.000 | 14927653.26596 |
8 | 2025-02-27 00:00:00.000 | 17759638.7854708 |
9 | 2025-02-26 00:00:00.000 | 17801978.2490738 |
10 | 2025-02-25 00:00:00.000 | 17488285.998192 |
11 | 2025-02-24 00:00:00.000 | 18820299.9767593 |
12 | 2025-02-23 00:00:00.000 | 19270601.226339 |
13 | 2025-02-22 00:00:00.000 | 19510415.8341989 |
14 | 2025-02-21 00:00:00.000 | 19277596.1557727 |
15 | 2025-02-20 00:00:00.000 | 18837809.5414368 |
16 | 2025-02-19 00:00:00.000 | 18729625.9896543 |
17 | 2025-02-18 00:00:00.000 | 19453778.3654416 |
18 | 2025-02-17 00:00:00.000 | 21135527.6263844 |
19 | 2025-02-16 00:00:00.000 | 22085298.0244984 |
20 | 2025-02-15 00:00:00.000 | 22264100.7598573 |
Pine Analyticsinevitable-scarlet
Updated 2025-03-08
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
select
week as day,
sum(liquidty_usd) as liquidty_usd
from (
select
date_trunc('day', block_timestamp) as week,
pool_name,
avg(CACAO_AMOUNT_USD + ASSET_AMOUNT_USD + SYNTH_AMOUNT_USD) as liquidty_usd
from maya.defi.fact_pool_block_balances
group by 1,2
)
group by 1
order by 1 desc
Last run: 14 days ago
...
720
32KB
2s