alirsRUNE-01
Updated 2022-09-06
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
SELECT POOL_NAME,
iff(len(POOL_NAME)>10,(SUBSTRING(POOL_NAME, 0, charindex('-', POOL_NAME, 0)-1)),POOL_NAME)as Pool_Name,
sum(SWAP_VOLUME_RUNE_USD) as Swap_Volume_USD,
sum(SWAP_VOLUME_RUNE) as Swap_Volume_RUNE,
sum(SWAP_COUNT) as Number_of_Swap,
sum(RUNE_LIQUIDITY) as RUNE_LIQUIDITY,
sum(TO_RUNE_SWAP_COUNT) as Number_of_Swap_from_asset__to_RUNE,
sum(TO_ASSET_SWAP_COUNT) as Number_of_Swap_from_RUNE__to_Asset,
sum(TO_ASSET_SWAP_VOLUME) as Volume_of_Swap_from_RUNE_to_Asset,
sum(TO_RUNE_SWAP_VOLUME) as Volume_of_Swap_From_Asset_to_RUNE,
sum(TOTAL_SWAP_FEES_RUNE) as Total_swap_fees_in_RUNE,
sum(TOTAL_SWAP_FEES_USD) as Total_swap_fees_in_USD,
sum(UNIQUE_SWAPPER_COUNT) as Number_of_unique_Swapper
from flipside_prod_db.thorchain.daily_pool_stats
where SWAP_VOLUME_RUNE_USD>0 and SWAP_VOLUME_RUNE>0
GROUP by POOL_NAME
Run a query to Download Data