PREVIEW / futures_1hour / 2023-08-22

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-08-22.parquet
  size:    64 KB
  rows:    1,992

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-08-22 00:00:00	ES	Futures	4842.66	4842.93	4839.64	4839.91	2501.0
2023-08-22 01:00:00	ES	Futures	4839.91	4842.38	4837.44	4841.56	6105.0
2023-08-22 02:00:00	ES	Futures	4841.56	4848.97	4839.64	4848.15	9314.0
2023-08-22 03:00:00	ES	Futures	4847.87	4859.95	4846.77	4858.3	27293.0
2023-08-22 04:00:00	ES	Futures	4858.3	4862.42	4857.75	4861.87	15271.0
2023-08-22 05:00:00	ES	Futures	4861.87	4866.26	4858.03	4864.34	12618.0
2023-08-22 06:00:00	ES	Futures	4864.07	4867.36	4862.69	4864.34	10878.0
2023-08-22 07:00:00	ES	Futures	4864.07	4873.13	4862.15	4871.75	21596.0
2023-08-22 08:00:00	ES	Futures	4871.75	4875.32	4865.17	4865.17	29649.0
2023-08-22 09:00:00	ES	Futures	4865.17	4866.54	4847.32	4848.15	184665.0
2023-08-22 10:00:00	ES	Futures	4848.15	4856.66	4836.89	4849.52	220700.0
2023-08-22 11:00:00	ES	Futures	4849.52	4850.62	4836.07	4837.44	156428.0
2023-08-22 12:00:00	ES	Futures	4837.71	4845.13	4827.01	4837.71	144839.0
2023-08-22 13:00:00	ES	Futures	4837.71	4838.54	4825.64	4831.68	115712.0
2023-08-22 14:00:00	ES	Futures	4831.4	4839.91	4827.01	4835.24	95143.0
2023-08-22 15:00:00	ES	Futures	4835.52	4846.22	4825.09	4831.13	194566.0
2023-08-22 16:00:00	ES	Futures	4831.13	4832.5	4829.2	4831.68	36903.0
2023-08-22 18:00:00	ES	Futures	4831.4	4835.52	4830.85	4833.32	4408.0
2023-08-22 19:00:00	ES	Futures	4833.32	4834.15	4831.13	4832.22	2308.0
2023-08-22 20:00:00	ES	Futures	4832.22	4839.09	4831.68	4838.54	6049.0
2023-08-22 21:00:00	ES	Futures	4838.81	4847.32	4837.71	4843.48	11079.0
2023-08-22 22:00:00	ES	Futures	4843.48	4846.5	4842.11	4843.75	6044.0
2023-08-22 23:00:00	ES	Futures	4843.48	4844.85	4841.56	4843.75	4055.0
2023-08-22 00:00:00	NQ	Futures	16659.22	16660.33	16643.37	16645.31	1665.0
2023-08-22 01:00:00	NQ	Futures	16645.59	16655.88	16635.02	16654.21	3583.0
2023-08-22 02:00:00	NQ	Futures	16653.94	16691.21	16649.49	16687.31	6486.0
2023-08-22 03:00:00	NQ	Futures	16687.31	16742.1	16684.25	16733.2	15156.0
2023-08-22 04:00:00	NQ	Futures	16733.2	16758.51	16733.2	16750.17	11041.0
2023-08-22 05:00:00	NQ	Futures	16751.0	16770.75	16735.43	16763.24	7755.0
2023-08-22 06:00:00	NQ	Futures	16762.96	16776.31	16754.62	16761.3	7726.0
2023-08-22 07:00:00	NQ	Futures	16761.02	16806.91	16748.5	16797.45	13615.0
2023-08-22 08:00:00	NQ	Futures	16797.73	16819.42	16783.82	16784.66	18686.0
2023-08-22 09:00:00	NQ	Futures	16784.66	16796.34	16685.37	16693.43	97880.0
2023-08-22 10:00:00	NQ	Futures	16692.6	16751.28	16653.66	16740.44	101890.0
2023-08-22 11:00:00	NQ	Futures	16740.99	16749.06	16657.0	16670.62	72655.0
2023-08-22 12:00:00	NQ	Futures	16670.62	16685.09	16613.89	16658.66	64201.0
2023-08-22 13:00:00	NQ	Futures	16658.66	16667.56	16612.22	16641.98	53513.0
2023-08-22 14:00:00	NQ	Futures	16642.53	16677.3	16620.28	16659.5	45429.0
2023-08-22 15:00:00	NQ	Futures	16659.5	16700.11	16612.77	16643.92	63006.0
2023-08-22 16:00:00	NQ	Futures	16643.92	16652.55	16639.75	16646.98	9967.0
2023-08-22 18:00:00	NQ	Futures	16643.09	16666.17	16643.09	16655.05	2584.0
2023-08-22 19:00:00	NQ	Futures	16655.33	16658.94	16640.31	16648.37	2512.0
2023-08-22 20:00:00	NQ	Futures	16648.37	16683.42	16644.48	16682.86	4435.0
2023-08-22 21:00:00	NQ	Futures	16682.58	16711.23	16677.02	16703.44	6582.0
2023-08-22 22:00:00	NQ	Futures	16704.0	16720.97	16695.1	16703.17	4621.0
2023-08-22 23:00:00	NQ	Futures	16703.17	16707.34	16690.09	16700.66	3170.0
2023-08-22 00:00:00	YM	Futures	37805.1	37805.1	37789.7	37791.9	364.0
2023-08-22 01:00:00	YM	Futures	37793.0	37808.4	37774.4	37798.5	807.0
2023-08-22 02:00:00	YM	Futures	37797.4	37839.0	37783.2	37828.1	1896.0
2023-08-22 03:00:00	YM	Futures	37827.0	37897.1	37809.5	37882.9	4157.0

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

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