PREVIEW / futures_1hour / 2025-01-17

all futures 1-hour files

  file:    by_date/futures_1hour/2025/2025-01-17.parquet
  size:    56 KB
  rows:    1,658

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-01-17 00:00:00	ES	Futures	6138.71	6141.78	6137.17	6139.22	3846.0
2025-01-17 01:00:00	ES	Futures	6139.22	6140.5	6135.63	6137.17	3896.0
2025-01-17 02:00:00	ES	Futures	6137.42	6137.94	6129.48	6136.4	6301.0
2025-01-17 03:00:00	ES	Futures	6136.14	6144.6	6135.63	6143.32	9241.0
2025-01-17 04:00:00	ES	Futures	6143.32	6152.04	6142.29	6148.19	12173.0
2025-01-17 05:00:00	ES	Futures	6148.19	6151.52	6145.11	6147.68	7867.0
2025-01-17 06:00:00	ES	Futures	6147.68	6153.83	6145.63	6146.91	9810.0
2025-01-17 07:00:00	ES	Futures	6146.91	6152.04	6142.81	6149.73	13742.0
2025-01-17 08:00:00	ES	Futures	6149.73	6174.85	6149.47	6172.55	65383.0
2025-01-17 09:00:00	ES	Futures	6172.55	6189.47	6166.14	6174.09	272360.0
2025-01-17 10:00:00	ES	Futures	6173.83	6193.57	6171.27	6193.06	208750.0
2025-01-17 11:00:00	ES	Futures	6193.06	6203.31	6188.96	6194.85	138185.0
2025-01-17 12:00:00	ES	Futures	6194.6	6203.31	6189.72	6201.0	87457.0
2025-01-17 13:00:00	ES	Futures	6201.0	6205.88	6193.83	6197.93	96102.0
2025-01-17 14:00:00	ES	Futures	6197.93	6199.72	6191.52	6193.83	87675.0
2025-01-17 15:00:00	ES	Futures	6193.83	6197.67	6184.85	6186.9	222651.0
2025-01-17 16:00:00	ES	Futures	6187.16	6187.93	6182.8	6186.39	48980.0
2025-01-17 00:00:00	NQ	Futures	21915.13	21935.97	21913.84	21924.65	2570.0
2025-01-17 01:00:00	NQ	Futures	21923.88	21931.34	21902.52	21914.36	2741.0
2025-01-17 02:00:00	NQ	Futures	21914.36	21918.73	21876.27	21901.23	4313.0
2025-01-17 03:00:00	NQ	Futures	21900.97	21947.81	21897.11	21940.86	5294.0
2025-01-17 04:00:00	NQ	Futures	21940.86	21984.35	21935.2	21970.46	7182.0
2025-01-17 05:00:00	NQ	Futures	21970.97	21981.27	21950.9	21961.19	5187.0
2025-01-17 06:00:00	NQ	Futures	21961.45	21990.02	21947.04	21955.53	5659.0
2025-01-17 07:00:00	NQ	Futures	21955.27	21980.75	21932.89	21972.26	7906.0
2025-01-17 08:00:00	NQ	Futures	21972.52	22178.65	21971.23	22174.53	35243.0
2025-01-17 09:00:00	NQ	Futures	22174.79	22319.68	22118.43	22137.48	121885.0
2025-01-17 10:00:00	NQ	Futures	22137.48	22232.69	22112.51	22228.32	92500.0
2025-01-17 11:00:00	NQ	Futures	22227.8	22273.87	22204.39	22218.03	60674.0
2025-01-17 12:00:00	NQ	Futures	22217.77	22265.63	22193.32	22261.77	41077.0
2025-01-17 13:00:00	NQ	Futures	22261.52	22308.87	22247.11	22267.44	46243.0
2025-01-17 14:00:00	NQ	Futures	22267.69	22280.82	22244.02	22257.91	36331.0
2025-01-17 15:00:00	NQ	Futures	22257.4	22274.38	22213.65	22235.53	67812.0
2025-01-17 16:00:00	NQ	Futures	22235.01	22239.39	22205.67	22223.43	16655.0
2025-01-17 00:00:00	YM	Futures	44699.0	44710.3	44683.5	44696.9	424.0
2025-01-17 01:00:00	YM	Futures	44697.9	44709.3	44685.6	44701.0	623.0
2025-01-17 02:00:00	YM	Futures	44702.1	44719.6	44669.1	44707.2	1058.0
2025-01-17 03:00:00	YM	Futures	44707.2	44755.6	44703.1	44749.4	1476.0
2025-01-17 04:00:00	YM	Futures	44749.4	44786.5	44735.0	44749.4	1691.0
2025-01-17 05:00:00	YM	Futures	44750.4	44787.5	44739.1	44779.3	1475.0
2025-01-17 06:00:00	YM	Futures	44782.3	44826.6	44782.3	44793.7	1630.0
2025-01-17 07:00:00	YM	Futures	44789.5	44824.5	44764.8	44811.2	1942.0
2025-01-17 08:00:00	YM	Futures	44809.1	44926.4	44809.1	44893.5	5736.0
2025-01-17 09:00:00	YM	Futures	44893.5	45020.1	44891.4	44968.6	23291.0
2025-01-17 10:00:00	YM	Futures	44968.6	45047.9	44932.6	45041.7	11594.0
2025-01-17 11:00:00	YM	Futures	45040.7	45117.9	45013.9	45083.9	8660.0
2025-01-17 12:00:00	YM	Futures	45081.9	45149.8	45052.0	45096.3	4903.0
2025-01-17 13:00:00	YM	Futures	45097.3	45116.9	45029.4	45056.1	5135.0
2025-01-17 14:00:00	YM	Futures	45056.1	45060.2	44994.4	45011.9	3947.0
2025-01-17 15:00:00	YM	Futures	45010.8	45054.1	44963.5	44967.6	10825.0

> showing 50 of 1,658 rows — these rows as CSV

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