PREVIEW / futures_1hour / 2023-04-03

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-04-03.parquet
  size:    67 KB
  rows:    2,058

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
2023-04-03 00:00:00	ES	Futures	4575.5	4579.38	4575.5	4578.83	3768.0
2023-04-03 01:00:00	ES	Futures	4578.83	4579.1	4574.11	4576.33	6584.0
2023-04-03 02:00:00	ES	Futures	4576.61	4583.82	4574.11	4583.82	11251.0
2023-04-03 03:00:00	ES	Futures	4583.82	4589.64	4578.83	4588.53	28214.0
2023-04-03 04:00:00	ES	Futures	4588.26	4589.92	4579.38	4582.43	16510.0
2023-04-03 05:00:00	ES	Futures	4582.71	4586.59	4582.71	4585.21	11408.0
2023-04-03 06:00:00	ES	Futures	4585.21	4590.2	4584.93	4588.81	15256.0
2023-04-03 07:00:00	ES	Futures	4588.81	4590.2	4582.99	4586.87	17853.0
2023-04-03 08:00:00	ES	Futures	4586.87	4587.43	4578.83	4586.32	30017.0
2023-04-03 09:00:00	ES	Futures	4586.32	4604.9	4582.99	4598.52	165777.0
2023-04-03 10:00:00	ES	Futures	4598.52	4612.66	4585.48	4586.04	269103.0
2023-04-03 11:00:00	ES	Futures	4586.04	4591.59	4579.38	4591.31	160154.0
2023-04-03 12:00:00	ES	Futures	4591.59	4595.75	4588.53	4589.37	87431.0
2023-04-03 13:00:00	ES	Futures	4589.37	4594.64	4585.21	4588.81	90952.0
2023-04-03 14:00:00	ES	Futures	4588.81	4602.68	4587.15	4601.85	92875.0
2023-04-03 15:00:00	ES	Futures	4601.85	4611.0	4600.74	4607.95	200762.0
2023-04-03 16:00:00	ES	Futures	4607.67	4609.89	4606.01	4607.95	50120.0
2023-04-03 18:00:00	ES	Futures	4606.84	4607.12	4602.12	4603.23	3544.0
2023-04-03 19:00:00	ES	Futures	4603.23	4605.73	4602.96	4604.34	3651.0
2023-04-03 20:00:00	ES	Futures	4604.07	4607.67	4601.85	4606.29	6988.0
2023-04-03 21:00:00	ES	Futures	4606.29	4607.67	4603.51	4603.79	5793.0
2023-04-03 22:00:00	ES	Futures	4604.07	4604.62	4601.29	4602.96	5043.0
2023-04-03 23:00:00	ES	Futures	4602.96	4606.56	4602.4	4606.29	4754.0
2023-04-03 00:00:00	NQ	Futures	14884.02	14897.25	14883.17	14894.15	2291.0
2023-04-03 01:00:00	NQ	Futures	14893.59	14898.38	14878.67	14887.68	3857.0
2023-04-03 02:00:00	NQ	Futures	14887.4	14902.32	14875.57	14901.47	5041.0
2023-04-03 03:00:00	NQ	Futures	14901.76	14918.65	14886.83	14912.74	9981.0
2023-04-03 04:00:00	NQ	Futures	14912.74	14918.09	14869.38	14874.73	8974.0
2023-04-03 05:00:00	NQ	Futures	14875.29	14891.06	14874.73	14887.68	5072.0
2023-04-03 06:00:00	NQ	Futures	14887.96	14902.04	14886.27	14889.09	5844.0
2023-04-03 07:00:00	NQ	Futures	14888.81	14897.53	14868.25	14878.11	8558.0
2023-04-03 08:00:00	NQ	Futures	14877.82	14882.33	14842.91	14879.51	16378.0
2023-04-03 09:00:00	NQ	Futures	14879.51	14935.54	14864.03	14897.81	69017.0
2023-04-03 10:00:00	NQ	Futures	14897.81	14942.86	14840.66	14842.63	97507.0
2023-04-03 11:00:00	NQ	Futures	14842.91	14859.81	14814.19	14851.64	54973.0
2023-04-03 12:00:00	NQ	Futures	14851.64	14876.7	14833.9	14835.87	38391.0
2023-04-03 13:00:00	NQ	Futures	14835.87	14847.14	14818.98	14838.13	40281.0
2023-04-03 14:00:00	NQ	Futures	14838.13	14896.41	14821.23	14894.15	43765.0
2023-04-03 15:00:00	NQ	Futures	14894.44	14954.69	14889.93	14943.14	76772.0
2023-04-03 16:00:00	NQ	Futures	14943.14	14944.83	14933.85	14935.54	12631.0
2023-04-03 18:00:00	NQ	Futures	14932.45	14934.14	14918.09	14919.21	2031.0
2023-04-03 19:00:00	NQ	Futures	14919.49	14929.07	14918.65	14919.49	2114.0
2023-04-03 20:00:00	NQ	Futures	14919.78	14932.16	14907.67	14922.03	4247.0
2023-04-03 21:00:00	NQ	Futures	14922.03	14925.97	14906.26	14907.11	2697.0
2023-04-03 22:00:00	NQ	Futures	14907.11	14909.08	14895.84	14902.88	3098.0
2023-04-03 23:00:00	NQ	Futures	14902.32	14916.12	14900.07	14916.12	2785.0
2023-04-03 00:00:00	YM	Futures	36977.0	37001.3	36977.0	36999.1	686.0
2023-04-03 01:00:00	YM	Futures	36999.1	37002.4	36968.1	36979.2	964.0
2023-04-03 02:00:00	YM	Futures	36980.3	37058.8	36968.1	37057.7	1985.0
2023-04-03 03:00:00	YM	Futures	37058.8	37117.4	37016.8	37109.6	4043.0

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

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