COUNT(distinct origin_from_address) as unique_users,

SUM(amount_in_usd) AS volume,

AVG(amount_in_usd) AS avg_swap_size_usd,

MEDIAN(amount_in_usd) AS median_swap_size_usd

(

SELECT amount_in_usd, origin_from_address FROM arbitrum.defi.ez_dex_swaps WHERE platform ILIKE '%uniswap%' and block_timestamp::date < '2024-01-19'

UNION ALL

SELECT amount_in_usd, origin_from_address FROM avalanche.defi.ez_dex_swaps WHERE platform ILIKE '%uniswap%' and block_timestamp::date < '2024-01-19'

UNION ALL

SELECT amount_in_usd, origin_from_address FROM base.defi.ez_dex_swaps WHERE platform ILIKE '%uniswap%' and block_timestamp::date < '2024-01-19'

UNION ALL

SELECT amount_in_usd, origin_from_address FROM bsc.defi.ez_dex_swaps WHERE platform ILIKE '%uniswap%' and block_timestamp::date < '2024-01-19'

UNION ALL

SELECT amount_in_usd, origin_from_address FROM optimism.defi.ez_dex_swaps WHERE platform ILIKE '%uniswap%' and block_timestamp::date < '2024-01-19'

UNION ALL

SELECT amount_in_usd, origin_from_address FROM polygon.defi.ez_dex_swaps WHERE platform ILIKE '%uniswap%' and block_timestamp::date < '2024-01-19'

)