with fa as (select date(block_timestamp) as day, from_asset, sum(from_amount) as total_amt from thorchain.swaps
group by date(block_timestamp),from_asset )
select day,
to_asset as asset,
total_amt/total_amt_to as swapping_ratio from
(
select * from
(select date(block_timestamp) as day_,to_asset, sum(from_amount) as total_amt_to from thorchain.swaps
group by day_,to_asset )
inner join fa
on to_asset= from_asset and day=day_ )