select 'Uniswap' as platform,

mindate::date as day,

count (distinct recipient) as New_Users

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 Collapse'

else 'Before Collapse' 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