SELECT

owner AS account_owner,

pre_balance,

balance,

(balance - pre_balance) / NULLIF(pre_balance, 0) * 100 AS percentage_balance_change,

CASE

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

WHEN pre_balance BETWEEN 101 AND 200 THEN '101-200 SOL'

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

WHEN pre_balance > 500 THEN '500+ SOL'

ELSE 'OTHER OR LESS THAN 1'

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'