nitsHighest Swapping Ratio Past 30 days
    Updated 2022-01-19
    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
    Run a query to Download Data