with swaps as ( select ORIGIN_FROM_ADDRESS , count(DISTINCT(tx_hash)) as total_swaps ,sum(amount_in_usd) as swap_volume from optimism.velodrome.ez_swaps where block_timestamp::date >= CURRENT_DATE - 180 group by 1) select '1-10$' as type, count(DISTINCT(origin_from_address)) as total from swaps where swap_volume > 0 and swap_volume <= 10 group by 1 UNION select '11-20$' as type, count(DISTINCT(origin_from_address)) as total from swaps where swap_volume > 10 and swap_volume <= 20 group by 1 UNION select '21-30$' as type, count(DISTINCT(origin_from_address)) as total from swaps where swap_volume > 20 and swap_volume <= 30 group by 1 UNION select '31-40$' as type, count(DISTINCT(origin_from_address)) as total from swaps where swap_volume > 31 and swap_volume <= 40 group by 1 UNION select '41-50$' as type, count(DISTINCT(origin_from_address)) as total from swaps where swap_volume > 40 and swap_volume <= 50 group by 1 UNION select '51-100$' as type, count(DISTINCT(origin_from_address)) as total from swaps where swap_volume > 50 and swap_volume <= 100 group by 1 UNION select '101-250$' as type, count(DISTINCT(origin_from_address)) as total from swaps where swap_volume > 100 and swap_volume <= 250 group by 1 UNION select '251-500$' as type, count(DISTINCT(origin_from_address)) as total from swaps where swap_volume > 251 and swap_volume <= 500 group by 1 UNION select '501-1000$' as type, count(DISTINCT(origin_from_address)) as total from swaps where swap_volume > 500 and swap_volume <= 1000 group by 1 UNION select '1001-10K$' as type, count(DISTINCT(origin_from_address)) as total from swaps where swap_volume > 1000 and swap_volume <= 10000 group by 1 UNION select '10.1K-10000K$' as type, count(DISTINCT(origin_from_address)) as total from swaps where swap_volume > 10000 and swap_volume <= 100000 group by 1 UNION select '100.1K-1M$' as type, count(DISTINCT(origin_from_address)) as total from swaps where swap_volume > 100000 and swap_volume <= 1000000 group by 1 UNION select '+1M$' as type, count(DISTINCT(origin_from_address)) as total from swaps where swap_volume > 1000000 group by 1

Velodrome Health (Redux)