SELECT

DATE_TRUNC('day', hour) AS day,

AVG(price) AS avg_price,

CASE

WHEN AVG(price) BETWEEN 176

AND 183 THEN '176-183 highs'

WHEN AVG(price) BETWEEN 155

AND 161 THEN '151-161 highs'

WHEN AVG(price) BETWEEN 136

AND 145 THEN '136 level lows'

WHEN AVG(price) BETWEEN 121

AND 133 THEN '121-133 level lows'

END AS price_range

FROM

solana.price.ez_prices_hourly

WHERE

token_address = 'So11111111111111111111111111111111111111112'

AND (

price BETWEEN 176

AND 183

OR price BETWEEN 155

AND 161

OR price BETWEEN 136

AND 145

OR price BETWEEN 121

AND 133

)

AND hour >= '2024-07-01' AND hour < '2024-10-01'

GROUP BY

DATE_TRUNC('day', hour)

),

sol_swap_data AS (

SELECT

DATE_TRUNC('day', block_timestamp) AS day,

swapper,