WITH price_summary AS (

SELECT

DATE_TRUNC('day', hour) AS price_date,

AVG(price) AS daily_avg_price,

CASE

WHEN AVG(price) BETWEEN 13.5 AND 14.49 THEN 'Highs: 13.5-14.49'

WHEN AVG(price) BETWEEN 12.5 AND 13.49 THEN 'Highs: 12.5-13.49'

WHEN AVG(price) BETWEEN 8.50 AND 9.45 THEN 'Lows: 8.50-9.45'

WHEN AVG(price) BETWEEN 9.50 AND 10.49 THEN 'Lows: 9.50-10.49'

END AS price_band

FROM

aptos.price.ez_prices_hourly

WHERE

token_address = '0x1::aptos_coin::AptosCoin'

AND (

price BETWEEN 13.5 AND 14.49

OR price BETWEEN 12.5 AND 13.49

OR price BETWEEN 8.50 AND 9.45

OR price BETWEEN 9.50 AND 10.49

)

AND hour >= '2024-12-01'

AND hour <= '2025-01-31'

GROUP BY

DATE_TRUNC('day', hour)

),

swap_activity AS (

SELECT

DATE_TRUNC('day', block_timestamp) AS swap_date,

swapper,

SUM(amount_in_usd) AS total_amount

FROM

aptos.defi.ez_dex_swaps

WHERE

token_in = '0x1::aptos_coin::AptosCoin'

AND block_timestamp >= '2024-12-01'