DATE | POOL_DEPTH_USD | SAVERS_DEPTH_USD | SWAP_COUNT | TOTAL_SWAP_FEES_USD | SWAP_VOLUME_USD | |
|---|---|---|---|---|---|---|
1 | 2024-04-01 00:00:00.000 | 503787676.485666 | 134548969.318125 | 51837 | 41410.378569473 | 122528487.148589 |
2 | 2024-06-30 00:00:00.000 | 259736921.757074 | 94043288.8204488 | 35707 | 12193.923838264 | 51086144.1228407 |
NineRealmsSOD/EOD THORChain Pool Stats
Updated 4 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
›
⌄
WITH base AS (
SELECT
p.day AS date,
p.pool_name,
p.asset_liquidity * p.asset_price_usd + p.rune_liquidity * p.rune_price_usd AS POOL_DEPTH_USD,
COALESCE(s.asset_liquidity, 0) * p.asset_price_usd AS SAVERS_DEPTH_USD,
p.SWAP_COUNT,
p.TOTAL_SWAP_FEES_USD,
p.SWAP_VOLUME_RUNE_USD
FROM thorchain.defi.fact_daily_pool_stats AS p
LEFT JOIN thorchain.defi.fact_daily_pool_stats AS s
ON p.day = s.day
AND SPLIT_PART(p.pool_name, '.', 1) = SPLIT_PART(s.pool_name, '/', 1)
AND SPLIT_PART(p.pool_name, '.', 2) = SPLIT_PART(s.pool_name, '/', 2)
WHERE p.day IN ('{{start_date}}'::DATE - INTERVAL '1 day', '{{end_date}}'::DATE)
AND p.pool_name LIKE '%.%'
)
SELECT
GREATEST('{{start_date}}'::DATE, DATE) AS date,
SUM(POOL_DEPTH_USD) AS POOL_DEPTH_USD,
SUM(SAVERS_DEPTH_USD) AS SAVERS_DEPTH_USD,
SUM(SWAP_COUNT) AS SWAP_COUNT,
SUM(TOTAL_SWAP_FEES_USD) AS TOTAL_SWAP_FEES_USD,
SUM(SWAP_VOLUME_RUNE_USD) AS SWAP_VOLUME_USD
FROM base
GROUP BY 1
Last run: about 4 hours ago
2
203B
10s