with main as (

select

tx_hash,

block_timestamp,

case

when block_timestamp :: date between '2020-09-01'

and '2021-04-17' then 'Bull'

when block_timestamp :: date between '2020-04-17'

and '2021-07-18' then 'Bear'

when block_timestamp :: date between '2021-07-18'

and '2021-11-14' then 'Bull'

when block_timestamp :: date between '2021-11-14'

and '2023-01-03' then 'Bear'

else 'Bull'

end as type,

abs(amount0_usd) as amount,

liquidity_provider as user

from

ethereum.uniswapv3.ez_lp_actions

where

amount < 1000000

and block_timestamp :: date >= '2020-09-01'

type,

case when amount < 5 then '< 5$'

when amount < 15 then 'Between 5$ - 15$'

when amount < 50 then 'Between 15$ - 50$'

when amount < 100 then 'Between 50$ - 100$'

when amount < 500 then 'Between 100$ - 500$'

when amount < 1000 then 'Between 500$ - 1000$'

when amount < 5000 then 'Between 1000$ - 5000$'

when amount < 10000 then 'Between 5000$ - 10000$'

when amount < 100000 then 'Between 10000$ - 100000$'