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,

swap_to_mint,

tx_id

FROM

solana.defi.fact_swaps

WHERE

swap_from_mint = 'So11111111111111111111111111111111111111112'

AND succeeded = TRUE

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