INSTALL httpfs;
LOAD httpfs;

SELECT
  zone_name,
  date_trunc('day', CAST(datetime_hour AS TIMESTAMP)) AS day,
  sum(requests) AS requests
FROM read_parquet('hf://datasets/Lightcap/multi-domain-cloudflare-observability/data/http_hourly.parquet')
GROUP BY 1, 2
ORDER BY day DESC, requests DESC;
