select avg_swap_size_ranges, 'before Nitro' as type, case when avg_swap_size_ranges = 'Fish > 0 and <= 100' then 1 when avg_swap_size_ranges = 'Shrimp > 100 and <= 1K' then 2 when avg_swap_size_ranges = 'Crab > 1K and <= 10K' then 3 when avg_swap_size_ranges = 'Dolphin > 10K and <= 100K' then 4 when avg_swap_size_ranges = 'Shark > 100K and <= 1M' then 5 when avg_swap_size_ranges = 'Whale > 1M' then 6 end as orderings, sum(numbering) from (select swapper, avg(swap_size) as avg_swap_size, case when avg_swap_size > 0 and avg_swap_size <= 100 then 'Fish > 0 and <= 100' when avg_swap_size > 100 and avg_swap_size <= 1000 then 'Shrimp > 100 and <= 1K' when avg_swap_size > 1000 and avg_swap_size <= 10000 then 'Crab > 1K and <= 10K' when avg_swap_size > 10000 and avg_swap_size <= 100000 then 'Dolphin > 10K and <= 100K' when avg_swap_size > 100000 and avg_swap_size <= 1000000 then 'Shark > 100K and <= 1M' else 'Whale > 1M' end as avg_swap_size_ranges, 1 as numbering from (select block_timestamp, event_inputs:from as swapper, event_inputs:value/1e6 as swap_size from arbitrum.core.fact_event_logs where contract_address ilike '0xFF970A61A04b1cA14834A43f5dE4533eBDDB5CC8' and event_name = 'Transfer' and tx_hash in (select tx_hash from (select tx_hash from arbitrum.core.fact_event_logs where event_name = 'Swap' ) ) and event_inputs:value > 0 and block_timestamp >= '2022-08-26' and block_timestamp < '2022-08-31' ) group by 1 ) group by 1, 2 UNION select avg_swap_size_ranges, 'after Nitro' as type, case when avg_swap_size_ranges = 'Fish > 0 and <= 100' then 1 when avg_swap_size_ranges = 'Shrimp > 100 and <= 1K' then 2 when avg_swap_size_ranges = 'Crab > 1K and <= 10K' then 3 when avg_swap_size_ranges = 'Dolphin > 10K and <= 100K' then 4 when avg_swap_size_ranges = 'Shark > 100K and <= 1M' then 5 when avg_swap_size_ranges = 'Whale > 1M' then 6 end as orderings, sum(numbering) from (select swapper, avg(swap_size) as avg_swap_size, case when avg_swap_size > 0 and avg_swap_size <= 100 then 'Fish > 0 and <= 100' when avg_swap_size > 100 and avg_swap_size <= 1000 then 'Shrimp > 100 and <= 1K' when avg_swap_size > 1000 and avg_swap_size <= 10000 then 'Crab > 1K and <= 10K' when avg_swap_size > 10000 and avg_swap_size <= 100000 then 'Dolphin > 10K and <= 100K' when avg_swap_size > 100000 and avg_swap_size <= 1000000 then 'Shark > 100K and <= 1M' else 'Whale > 1M' end as avg_swap_size_ranges, 1 as numbering from (select block_timestamp, event_inputs:from as swapper, event_inputs:value/1e6 as swap_size from arbitrum.core.fact_event_logs where contract_address ilike '0xFF970A61A04b1cA14834A43f5dE4533eBDDB5CC8' and event_name = 'Transfer' and tx_hash in (select tx_hash from (select tx_hash from arbitrum.core.fact_event_logs where event_name = 'Swap' ) ) and event_inputs:value > 0 and block_timestamp > '2022-08-31' ) group by 1 ) group by 1, 2

Arbitrum: Before and After Nitro Upgrade