SELECT '0x912ce59144191c1204e64559fe8253a0e49e6548' AS token_address, 'ARB' AS symbol

UNION ALL

SELECT '0x82af49447d8a07e3bd95bd0d56f35241523fbab1', 'ETH'

),

prices AS (

SELECT

tm.symbol,

TO_CHAR(DATE_TRUNC('day', eph.hour), 'DD/MM/YYYY') AS date,

AVG(eph.price) AS avg_price

FROM arbitrum.price.ez_prices_hourly eph

JOIN token_mapping tm ON eph.token_address = tm.token_address

WHERE DATE_TRUNC('day', eph.hour)::date IN (

'2025-03-13', '2025-03-06', '2025-02-27', '2025-02-20', '2025-02-14', '2025-02-13', '2025-02-06',

'2025-01-30', '2025-01-23', '2025-01-16', '2024-12-19', '2024-12-12', '2024-12-06', '2024-12-05',

'2024-11-29', '2024-11-28'

)

GROUP BY tm.symbol, DATE_TRUNC('day', eph.hour)

SELECT *

FROM prices

ORDER BY TO_DATE(date, 'DD/MM/YYYY') DESC, symbol;