sarathInitial swap volumes of LUNA and UST 1
Updated 2022-04-18
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
with data1 as (
SELECT day,pool_name,sum(swap_volume_rune_usd) as swap_volume from thorchain.daily_pool_stats WHERE pool_name LIKE '%DOGE%' AND swap_volume_rune_usd !=0
GROUP by 1,2
ORDER by DAY
limit 3),
data2 as (
SELECT day,pool_name,sum(swap_volume_rune_usd) as swap_volume from thorchain.daily_pool_stats WHERE pool_name LIKE '%LUNA%' and swap_volume_rune_usd !=0
GROUP by 1,2
ORDER by DAY
limit 3
),
data3 as (
SELECT day,pool_name,sum(swap_volume_rune_usd) as swap_volume from thorchain.daily_pool_stats WHERE pool_name LIKE '%UST%' and swap_volume_rune_usd !=0
GROUP by 1,2
ORDER by DAY
limit 3 )
SELECT * from data1
UNION ALL
SELECT * from data2
union ALL
SELECT * from data3
Run a query to Download Data