realisttop 10 pools[TVL]
Updated 2024-10-09
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
--forked from hess (top 8 pools based on TVL)
SELECT
CASE when pool_name ='ETH.USDT-0XDAC17F958D2EE523A2206206994597C13D831EC7' then 'ETH.USDT'
when pool_name ='ETH.USDC-0XA0B86991C6218B36C1D19D4A2E9EB0CE3606EB48' then 'ETH.USDC'
when pool_name ='ETH.THOR-0XA5F2211B9B8170F694421F2046281775E8468044' then 'ETH.THOR'
when pool_name ='ETH.WBTC-0X2260FAC5E5542A773AA44FBCFEDF7C193BC2C599' then 'ETH.WBTC'
else pool_name end as pool,
day,
asset_liquidity * asset_price_usd as pool_size_usd,
rune_liquidity * rune_price_usd as rune_size_usd,
pool_size_usd + rune_size_usd as total_volume
FROM thorchain.defi.fact_daily_pool_stats
WHERE pool_name !='THOR.TOR'
and day= current_date
ORDER by total_volume DESC
limit 10