Crazy_KidInitial swap volumes of LUNA and UST 2
Updated 2022-04-18
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
WITH luna as (SELECT day as date1,pool_name as luna,sum(swap_volume_rune_usd) as swap_volume_luna
FROM thorchain.daily_pool_stats
WHERE pool_name LIKE '%LUNA%' and swap_volume_rune_usd !=0
GROUP by date1, luna
ORDER BY date1
limit 3),
ust as (SELECT day as date2, pool_name as ust, sum(swap_volume_rune_usd) as swap_volume_ust
FROM thorchain.daily_pool_stats
WHERE pool_name LIKE '%UST%' and swap_volume_rune_usd !=0
GROUP by date2, ust
ORDER BY date2
limit 3)
SELECT date1 as date, luna, swap_volume_luna, ust, swap_volume_ust
FROM luna JOIN ust ON date1 = date2
Run a query to Download Data