alirstop-pool-05
Updated 2022-09-07
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
with base as(select iff(len(POOL_NAME)>10,(SUBSTRING(POOL_NAME, 0, charindex('-', POOL_NAME, 0)-1)),POOL_NAME)as Pool_Name,
sum(RUNE_LIQUIDITY) as amount_of_RUNE_LIQUIDITY,
row_number() over (order by amount_of_RUNE_LIQUIDITY desc) as rank
from flipside_prod_db.thorchain.daily_pool_stats
where SWAP_VOLUME_RUNE_USD>0 and SWAP_VOLUME_RUNE>0
group by 1
order by 2 desc
)
SELECT * from base
where rank<=10
Run a query to Download Data