nitsHighest Swapping Ratio Over Time
    Updated 2022-01-19
    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_ )

    Run a query to Download Data