Crazy_KidInitial swap volumes of LUNA and UST 2
    Updated 2022-04-18
    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