keshanThorra-UST
    Updated 2022-04-19
    select *, (to_rune_count/to_asset_count) as rune_to_asset_swap_count_ratio, (to_rune_vol/to_asset_vol) as rune_to_asset_swap_vol_ratio
    from (select day, pool_name,
    sum(to_rune_swap_count) as to_rune_count, sum(to_rune_swap_volume) as to_rune_vol,
    sum(to_asset_swap_count) as to_asset_count, sum(to_asset_swap_volume) as to_asset_vol
    from thorchain.daily_pool_stats
    where day >= '2022-3-25'
    and (pool_name = 'TERRA.UST' or pool_name = 'TERRA.LUNA')
    group by day, pool_name)

    Run a query to Download Data