PREVIEW / futures_1hour / 2023-06-26

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-06-26.parquet
  size:    65 KB
  rows:    2,034

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-06-26 00:00:00	ES	Futures	4831.68	4831.95	4827.28	4828.38	4834.0
2023-06-26 01:00:00	ES	Futures	4828.66	4828.93	4825.09	4827.01	5491.0
2023-06-26 02:00:00	ES	Futures	4826.46	4827.01	4823.44	4825.91	6964.0
2023-06-26 03:00:00	ES	Futures	4825.91	4826.18	4804.77	4814.93	40946.0
2023-06-26 04:00:00	ES	Futures	4814.93	4814.93	4804.77	4807.52	26015.0
2023-06-26 05:00:00	ES	Futures	4807.52	4816.3	4807.24	4814.66	14765.0
2023-06-26 06:00:00	ES	Futures	4814.38	4814.93	4810.54	4811.09	11419.0
2023-06-26 07:00:00	ES	Futures	4811.09	4818.77	4810.26	4817.68	13800.0
2023-06-26 08:00:00	ES	Futures	4817.4	4820.42	4813.01	4816.3	19976.0
2023-06-26 09:00:00	ES	Futures	4816.58	4832.77	4811.91	4830.58	145593.0
2023-06-26 10:00:00	ES	Futures	4830.85	4834.69	4809.44	4821.79	265633.0
2023-06-26 11:00:00	ES	Futures	4822.07	4822.34	4808.34	4818.22	175001.0
2023-06-26 12:00:00	ES	Futures	4818.22	4819.6	4801.48	4809.99	205834.0
2023-06-26 13:00:00	ES	Futures	4809.99	4813.28	4805.05	4807.52	129164.0
2023-06-26 14:00:00	ES	Futures	4807.24	4815.48	4802.58	4812.73	138516.0
2023-06-26 15:00:00	ES	Futures	4813.01	4815.75	4796.81	4799.83	241023.0
2023-06-26 16:00:00	ES	Futures	4799.83	4805.6	4799.56	4803.67	66135.0
2023-06-26 18:00:00	ES	Futures	4804.77	4806.15	4802.3	4806.15	4362.0
2023-06-26 19:00:00	ES	Futures	4806.15	4808.62	4805.87	4808.62	3879.0
2023-06-26 20:00:00	ES	Futures	4808.89	4809.17	4804.77	4805.05	6563.0
2023-06-26 21:00:00	ES	Futures	4805.05	4809.17	4802.58	4808.62	9702.0
2023-06-26 22:00:00	ES	Futures	4808.89	4810.26	4806.97	4808.62	6843.0
2023-06-26 23:00:00	ES	Futures	4808.34	4810.54	4807.24	4808.07	6884.0
2023-06-26 00:00:00	NQ	Futures	16801.07	16804.13	16788.83	16793.28	2286.0
2023-06-26 01:00:00	NQ	Futures	16794.11	16794.67	16777.15	16781.6	2980.0
2023-06-26 02:00:00	NQ	Futures	16781.32	16785.49	16758.79	16768.25	4389.0
2023-06-26 03:00:00	NQ	Futures	16767.41	16768.25	16699.27	16742.38	12524.0
2023-06-26 04:00:00	NQ	Futures	16742.66	16742.94	16686.48	16697.88	10823.0
2023-06-26 05:00:00	NQ	Futures	16697.32	16731.54	16696.21	16722.91	6069.0
2023-06-26 06:00:00	NQ	Futures	16722.36	16728.48	16706.5	16710.4	4723.0
2023-06-26 07:00:00	NQ	Futures	16710.12	16747.11	16705.11	16740.16	6730.0
2023-06-26 08:00:00	NQ	Futures	16739.88	16764.08	16722.36	16752.12	11046.0
2023-06-26 09:00:00	NQ	Futures	16752.95	16843.34	16715.13	16839.73	69925.0
2023-06-26 10:00:00	NQ	Futures	16840.28	16857.53	16719.85	16777.98	105756.0
2023-06-26 11:00:00	NQ	Futures	16777.98	16779.93	16663.39	16702.61	90440.0
2023-06-26 12:00:00	NQ	Futures	16702.61	16704.28	16552.7	16593.3	93622.0
2023-06-26 13:00:00	NQ	Futures	16593.58	16609.71	16562.71	16577.73	51869.0
2023-06-26 14:00:00	NQ	Futures	16578.01	16631.13	16568.55	16611.1	49209.0
2023-06-26 15:00:00	NQ	Futures	16611.1	16630.02	16524.88	16529.06	76510.0
2023-06-26 16:00:00	NQ	Futures	16529.61	16567.44	16529.06	16546.3	18876.0
2023-06-26 18:00:00	NQ	Futures	16548.8	16558.26	16534.62	16553.25	2755.0
2023-06-26 19:00:00	NQ	Futures	16552.97	16569.66	16551.86	16568.83	3361.0
2023-06-26 20:00:00	NQ	Futures	16568.55	16571.61	16549.92	16549.92	3387.0
2023-06-26 21:00:00	NQ	Futures	16550.47	16562.71	16535.45	16560.76	5263.0
2023-06-26 22:00:00	NQ	Futures	16560.76	16568.55	16554.37	16560.76	2799.0
2023-06-26 23:00:00	NQ	Futures	16561.32	16563.27	16546.58	16549.64	2699.0
2023-06-26 00:00:00	YM	Futures	37303.3	37307.7	37281.4	37288.0	416.0
2023-06-26 01:00:00	YM	Futures	37288.0	37293.5	37270.4	37282.5	819.0
2023-06-26 02:00:00	YM	Futures	37282.5	37285.8	37268.3	37282.5	1473.0
2023-06-26 03:00:00	YM	Futures	37281.4	37284.7	37114.9	37185.0	5639.0

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

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