m3jiLiquidity Dynamics
Updated 2024-10-22
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
SELECT
DAY,
SUM(ADD_ASSET_LIQUIDITY_USD) AS total_add_liquidity,
SUM(WITHDRAW_ASSET_LIQUIDITY_USD) AS total_withdraw_liquidity,
SUM(ADD_RUNE_LIQUIDITY_USD) AS total_rune_add_liquidity,
SUM(WITHDRAW_RUNE_LIQUIDITY_USD) AS total_rune_withdraw_liquidity,
SUM(
ADD_ASSET_LIQUIDITY_USD - WITHDRAW_ASSET_LIQUIDITY_USD
) AS net_asset_liquidity,
SUM(
ADD_RUNE_LIQUIDITY_USD - WITHDRAW_RUNE_LIQUIDITY_USD
) AS net_rune_liquidity
FROM
thorchain.defi.fact_daily_pool_stats
WHERE
DAY BETWEEN '2024-01-01'
AND CURRENT_DATE
GROUP BY
DAY
ORDER BY
DAY DESC;
Auto-refreshes every 24 hours
QueryRunArchived: QueryRun has been archived