flipside

    avg swap size by pool past 30 days
    boomer77avg swap size by pool past 30 days
    Updated 2021-12-06
    select pool_name, avg(from_amount_usd) as avg_swap_size, count(distinct tx_id) as swap_count, sum(from_amount_usd) as volume_usd
    from thorchain.swaps
    where block_timestamp >= CURRENT_DATE - 30
    group by 1
    order by 2 desc
    Run a query to Download Data