mlhDistribution of Swaps in $RUNE and USD Values4
    Updated 2022-09-05
    select count (distinct tx_id) as trxs,
    pool_name as pool,
    case when from_amount_usd < 50 then 'less than 50 USD'
    when from_amount_usd >= 50 and from_amount_usd < 100 then 'between 50 to 100 USD'
    when from_amount_usd >= 100 and from_amount_usd < 1000 then 'between 100 to 1K USD'
    when from_amount_usd >= 1000 and from_amount_usd < 2000 then 'between 1K to 2K USD'
    when from_amount_usd >= 2000 and from_amount_usd < 3000 then 'between 2K to 3K USD'
    when from_amount_usd >= 3000 and from_amount_usd < 5000 then 'between 3K to 5K USD'
    when from_amount_usd >= 5000 and from_amount_usd < 10000 then 'between 5K to 10K USD'
    else 'more than 10K USD' end as type
    from (select pool_name,
    tx_id,
    from_amount_usd
    from flipside_prod_db.thorchain.swaps
    )
    group by 2, 3
    Run a query to Download Data