count (distinct (tx_hash)) as swaps_number,

count (distinct (recipient)) as swappers_number,

sum(iff(amount0_usd > 0, amount0_usd , -1 * amount0_usd)) as total_amount_usd,

avg(iff(amount0_usd > 0, amount0_usd , -1 * amount0_usd)) as average_amount_usd,

median(iff(amount0_usd > 0, amount0_usd , -1 * amount0_usd)) as median_amount_usd,

sum(swaps_number) over (order by day asc) as comulative_swaps_number,

sum(swappers_number) over (order by day asc) as comulative_swappers_number,

sum(total_amount_usd) over (order by day asc) as comulative_total_amount_usd

from ethereum.uniswapv3.ez_swaps

where block_timestamp::date >= '2022-11-01'

group by day

order by day asc