Utiliser les time buckets pour la génération de csv
Utiliser les time buckets
SELECT time_bucket('15 min', at) AS bucket,
sum(distance),
sum(duration),
min(speed),
max(speed)
FROM osrm.segments_states as ss
WHERE at >= '2023-05-23' and at < '2023-05-24'
GROUP BY ss.route_id, ss.part_rank, ss.rank, bucket
ORDER BY bucket ASC;