keshanThorra-UST
Updated 2022-04-19
9
1
2
3
4
5
6
7
8
9
›
⌄
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