select

tx_hash,

block_timestamp,

iff(block_timestamp::date >= '2023-08-27', 'Bull Market', 'Bear Market') as timespan,

sender as user,

abs(amount0_usd) as amount_usd

from

ethereum.uniswapv3.ez_swaps

where amount_usd < 1e7

),

t2 as (

select

date_trunc('month', min_date) as month,

count(distinct user) as new_user

from

(

select

user,

min(block_timestamp) as min_date

from

t

group by

1

)

group by

1

),

t3 as (

select

date_trunc('month', block_timestamp) as month,

timespan,

count(distinct tx_hash) as transactions,

count(distinct user) as users,

sum(amount_usd) as volume,

avg(amount_usd) as avg_volume