Hello Database Connectors

SELECT
  DATE_TRUNC('hour', pickup_datetime) AS date,
  COUNT(*) AS count
FROM read_parquet("static/data-local/fhvhv_tripdata_2025-05.parquet")
GROUP BY 1
ORDER BY 1 DESC

Plot.plot({
  height: 300,
  grid: true,
  marks: [
    Plot.axisX({ticks: "week", tickFormat: "%b %d", label: "Date"}),
    Plot.axisY({tickFormat: (d) => d / 1000, label: "Trips per hour (thousands)"}),
    Plot.areaY(trips, { x: 'date', y: 'count', fill: "#cccccc", fillOpacity: 0.5}),
    Plot.line(trips, { x: 'date', y: 'count', curve: "step", stroke: "#333333", strokeWidth: 1.2, tip: true})
  ]
})