PREVIEW / futures_1hour / 2025-09-04

all futures 1-hour files

  file:    by_date/futures_1hour/2025/2025-09-04.parquet
  size:    62 KB
  rows:    2,001

schema

  timestamp    TIMESTAMP
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

timestamp	symbol	asset_type	open	high	low	close	volume
2025-09-04 00:00:00	ES	Futures	6508.69	6515.24	6508.69	6514.49	3338.0
2025-09-04 01:00:00	ES	Futures	6514.23	6517.51	6508.95	6510.96	4452.0
2025-09-04 02:00:00	ES	Futures	6510.71	6514.49	6507.43	6507.69	7086.0
2025-09-04 03:00:00	ES	Futures	6507.69	6518.01	6506.93	6514.49	11489.0
2025-09-04 04:00:00	ES	Futures	6514.74	6517.76	6511.72	6514.99	8378.0
2025-09-04 05:00:00	ES	Futures	6514.99	6518.77	6513.73	6518.52	5330.0
2025-09-04 06:00:00	ES	Futures	6518.26	6522.29	6515.75	6518.01	11457.0
2025-09-04 07:00:00	ES	Futures	6517.76	6520.78	6511.21	6513.98	9773.0
2025-09-04 08:00:00	ES	Futures	6514.23	6520.28	6509.95	6513.73	19221.0
2025-09-04 09:00:00	ES	Futures	6513.48	6523.3	6509.7	6519.02	137769.0
2025-09-04 10:00:00	ES	Futures	6518.77	6527.84	6504.66	6526.32	204564.0
2025-09-04 11:00:00	ES	Futures	6526.58	6536.4	6523.3	6531.87	130882.0
2025-09-04 12:00:00	ES	Futures	6531.87	6535.9	6528.09	6529.6	79552.0
2025-09-04 13:00:00	ES	Futures	6529.6	6544.96	6529.35	6541.69	92626.0
2025-09-04 14:00:00	ES	Futures	6541.69	6546.98	6540.93	6546.73	68757.0
2025-09-04 15:00:00	ES	Futures	6546.47	6561.59	6546.22	6560.08	218002.0
2025-09-04 16:00:00	ES	Futures	6559.82	6565.62	6557.31	6561.34	68418.0
2025-09-04 18:00:00	ES	Futures	6564.61	6566.62	6561.84	6565.37	5927.0
2025-09-04 19:00:00	ES	Futures	6565.11	6566.88	6563.85	6564.61	3302.0
2025-09-04 20:00:00	ES	Futures	6564.61	6568.64	6563.35	6568.14	5089.0
2025-09-04 21:00:00	ES	Futures	6568.39	6569.9	6566.88	6568.64	3419.0
2025-09-04 22:00:00	ES	Futures	6568.39	6569.65	6566.37	6568.39	2773.0
2025-09-04 23:00:00	ES	Futures	6568.39	6569.14	6566.88	6568.89	2023.0
2025-09-04 00:00:00	NQ	Futures	23673.66	23699.63	23673.66	23695.6	2695.0
2025-09-04 01:00:00	NQ	Futures	23695.6	23707.45	23664.08	23673.41	3130.0
2025-09-04 02:00:00	NQ	Futures	23672.15	23686.77	23657.02	23659.03	3961.0
2025-09-04 03:00:00	NQ	Futures	23658.78	23710.22	23655.25	23693.33	6567.0
2025-09-04 04:00:00	NQ	Futures	23692.82	23714.51	23681.22	23701.4	5628.0
2025-09-04 05:00:00	NQ	Futures	23702.41	23722.83	23696.1	23720.31	2713.0
2025-09-04 06:00:00	NQ	Futures	23721.07	23739.98	23707.7	23713.75	5510.0
2025-09-04 07:00:00	NQ	Futures	23713.75	23725.61	23684.5	23702.15	5722.0
2025-09-04 08:00:00	NQ	Futures	23701.15	23727.62	23673.91	23689.55	12874.0
2025-09-04 09:00:00	NQ	Futures	23689.29	23753.35	23661.55	23678.45	72686.0
2025-09-04 10:00:00	NQ	Futures	23681.98	23735.19	23613.89	23726.62	88776.0
2025-09-04 11:00:00	NQ	Futures	23726.87	23761.16	23696.86	23743.51	57371.0
2025-09-04 12:00:00	NQ	Futures	23743.26	23770.49	23717.29	23743.26	38170.0
2025-09-04 13:00:00	NQ	Futures	23743.51	23813.87	23741.49	23789.16	38996.0
2025-09-04 14:00:00	NQ	Futures	23788.65	23830.77	23787.9	23825.97	29895.0
2025-09-04 15:00:00	NQ	Futures	23825.72	23886.5	23822.19	23872.63	53803.0
2025-09-04 16:00:00	NQ	Futures	23872.12	23915.24	23864.56	23890.28	21726.0
2025-09-04 18:00:00	NQ	Futures	23906.42	23920.29	23898.1	23913.23	4105.0
2025-09-04 19:00:00	NQ	Futures	23913.48	23922.81	23910.96	23913.23	2795.0
2025-09-04 20:00:00	NQ	Futures	23912.47	23938.45	23907.68	23936.43	3950.0
2025-09-04 21:00:00	NQ	Futures	23935.67	23946.51	23928.86	23941.47	2504.0
2025-09-04 22:00:00	NQ	Futures	23941.72	23949.04	23922.81	23943.74	2501.0
2025-09-04 23:00:00	NQ	Futures	23942.73	23949.54	23932.64	23947.78	1746.0
2025-09-04 00:00:00	YM	Futures	46246.6	46295.6	46246.6	46283.3	431.0
2025-09-04 01:00:00	YM	Futures	46281.3	46299.7	46252.7	46268.0	469.0
2025-09-04 02:00:00	YM	Futures	46266.0	46289.5	46230.2	46230.2	846.0
2025-09-04 03:00:00	YM	Futures	46230.2	46307.9	46224.1	46282.3	984.0

> showing 50 of 2,001 rows — these rows as CSV

> unlock the full archive -- $79 one-time