SELECT
recorded_hour::DATE AS DATE,
AVG(close) AS atlas_price
FROM
SOLANA.price.ez_token_prices_hourly
WHERE
recorded_hour::DATE >= date_trunc('week', current_timestamp) --- interval '1 week'
AND token_address = 'ATLASXmbPQxBUYbxPsV97usA3fPQYEqzQBUHgiFCUsXx'
GROUP BY ALL