tx_hash,

block_timestamp,

nvl(amount_in_usd, amount_out_usd) as amount_usd,

origin_from_address as swapper,

case

when block_timestamp <= '2023-10-17' then 'Before Frontend Fee'

when block_timestamp <= '2024-04-10' then '0.15 Fee'

else '0.25 Fee'

end as timespan

from ethereum.defi.ez_dex_swaps

where amount_usd <= 1e6

and platform = 'uniswap-v3'

and block_timestamp >= '2023-01-01'

timespan,

sum(amount_usd) as volume_usd,

avg(amount_usd) as average_volume_usd,

median(amount_usd) as median_volume_usd,

count(distinct swapper) as swappers,

count(distinct tx_hash) as swaps,

swaps / count(distinct block_timestamp::date) as daily_average_swaps,

swappers / count(distinct block_timestamp::date) as daily_average_swappers

from t

group by 1