SELECT

owner AS account_owner,

pre_balance,

balance,

balance - pre_balance AS balance_change, -- Calculate the absolute balance change

CASE

WHEN pre_balance BETWEEN 1 AND 100 THEN '1-100 SOL'

WHEN pre_balance BETWEEN 100 AND 500 THEN '100-500 SOL'

WHEN pre_balance > 500 THEN '500+ SOL'

ELSE 'Unknown'

END AS balance_range,

DATE_TRUNC('day', block_timestamp) AS day

FROM

solana.core.fact_sol_balances

WHERE

block_timestamp >= '2024-07-01'

AND block_timestamp < '2024-10-01'

AND succeeded = TRUE

AND pre_balance >= 1

),

sol_price_filtered AS (

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 '155-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 (