INSTALL httpfs;
LOAD httpfs;

SELECT
  zone_name,
  CAST(date AS DATE) AS day,
  sum(requests) AS requests
FROM read_parquet('hf://datasets/Lightcap/multi-domain-cloudflare-observability/data/http_daily.parquet')
WHERE CAST(date AS DATE) < DATE '2026-01-01'
GROUP BY 1, 2
ORDER BY day DESC, requests DESC;
