from ( select recipient, min(block_timestamp) as mindate

from ethereum.uniswapv3.ez_swaps group by 1)

group by 1,2)

select block_timestamp::date as date, case when date >= '2022-11-08' then 'After FTX' else 'Before FTX' end as timespan, New_Users,

count (distinct tx_hash) as Swaps_Count, count (distinct recipient) as Swappers_Count, abs (sum (amount0_usd)) as Total_Volume, abs (avg (amount0_usd)) as Average_Volume

from ethereum.uniswapv3.ez_swaps t1 join table1 t2 on t1.block_timestamp::date = t2.day

where block_timestamp >= CURRENT_DATE - 14

group by 1,2,3

order by 1