SELECT

CASE

WHEN '{{time_range}}' = '1d' THEN DATEADD('day', -1, CURRENT_DATE)

WHEN '{{time_range}}' = '7d' THEN DATEADD('day', -7, CURRENT_DATE)

WHEN '{{time_range}}' = '30d' THEN DATEADD('day', -30, CURRENT_DATE)

WHEN '{{time_range}}' = '90d' THEN DATEADD('day', -90, CURRENT_DATE)

ELSE TO_DATE('2021-01-01')

END AS start_date

hour AS timestamp,

price * 371177700 AS market_cap_usd

FROM avalanche.price.ez_prices_hourly

WHERE symbol = 'AVAX'

AND hour >= CURRENT_DATE - INTERVAL '30 days'

ORDER BY hour;