maybeyonasthor_swapsize_chain
    Updated 2021-12-05
    select
    -- split(from_asset,'-')[0]::string || ' to ' || split(to_asset,'-')[0]::string as combination,
    blockchain,
    count(tx_id) as swaps,
    sum(from_amount_usd) as vol,
    median(from_amount_usd) as median_swap_size,
    avg(from_amount_usd) as avg_swap_size
    from thorchain.swaps
    group by 1
    order by avg_swap_size desc
    -- limit 100

    -- select * from thorchain.swaps
    -- limit 100
    Run a query to Download Data