DAY | POOLS | CHANGE_PERCENTAGE | |
|---|---|---|---|
1 | 2025-01-28 00:00:00.000 | BTC.BTC | -73.200077164 |
2 | 2025-01-28 00:00:00.000 | BSC.BNB | -17.425573681 |
3 | 2025-01-28 00:00:00.000 | ETH.ETH | -66.489658375 |
4 | 2025-01-28 00:00:00.000 | ETH.WBTC | -42.310109629 |
5 | 2025-01-28 00:00:00.000 | ETH.USDC | -35.074322648 |
6 | 2025-01-28 00:00:00.000 | ETH.USDT | -45.949844884 |
7 | 2025-01-28 00:00:00.000 | DOGE.DOGE | -64.512559042 |
8 | 2025-01-28 00:00:00.000 | BCH.BCH | -51.854978411 |
hessChanges in Pool TVL Compared to January (%)
Updated 2025-01-29
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 top_pools AS (
SELECT
pool_name,
ASSET_LIQUIDITY * ASSET_PRICE_USD AS volume,
RUNE_LIQUIDITY * RUNE_PRICE_USD AS volumeI,
volume + volumeI AS amount
FROM
thorchain.defi.fact_daily_pool_stats
WHERE
pool_name != 'THOR.TOR'
AND DAY = CURRENT_DATE - 1
ORDER BY
4 DESC
LIMIT
8
)
,
first_day_tvl AS (
SELECT
pool_name,
day,
ASSET_LIQUIDITY AS liquidity
FROM
thorchain.defi.fact_daily_pool_stats
WHERE
pool_name IN (SELECT pool_name FROM top_pools)
and day = '2024-01-01'
)
,
daily as ( select day,
pool_name,
ASSET_LIQUIDITY
from thorchain.defi.fact_daily_pool_stats
WHERE
pool_name IN (SELECT pool_name FROM top_pools)
Last run: 3 months ago
8
422B
1s