with fa as (select from_asset, sum(from_amount) as total_amt from thorchain.swaps
where date(block_timestamp)>= CURRENT_DATE -30
group by from_asset )
select to_asset as asset, total_amt/total_amt_to as swapping_ratio from
(
select * from
(select to_asset, sum(from_amount) as total_amt_to from thorchain.swaps
where date(block_timestamp)>= CURRENT_DATE -30
group by to_asset )
inner join fa
on to_asset= from_asset)
order by swapping_ratio desc
limit 100