PREVIEW / futures_1hour / 2022-01-05

all futures 1-hour files

  file:    by_date/futures_1hour/2022/2022-01-05.parquet
  size:    67 KB
  rows:    2,044

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
2022-01-05 00:00:00	ES	Futures	5398.97	5399.82	5392.47	5393.88	6055.0
2022-01-05 01:00:00	ES	Futures	5394.17	5402.65	5391.9	5400.67	5365.0
2022-01-05 02:00:00	ES	Futures	5400.95	5407.74	5399.26	5405.48	6828.0
2022-01-05 03:00:00	ES	Futures	5405.48	5409.44	5402.37	5404.91	12656.0
2022-01-05 04:00:00	ES	Futures	5404.91	5413.96	5403.78	5411.42	10600.0
2022-01-05 05:00:00	ES	Futures	5411.7	5415.94	5408.59	5409.16	12712.0
2022-01-05 06:00:00	ES	Futures	5409.44	5409.72	5405.2	5408.31	15036.0
2022-01-05 07:00:00	ES	Futures	5408.31	5411.42	5403.78	5406.33	16241.0
2022-01-05 08:00:00	ES	Futures	5406.33	5411.7	5401.52	5410.0	31618.0
2022-01-05 09:00:00	ES	Futures	5410.0	5413.11	5395.86	5408.02	183141.0
2022-01-05 10:00:00	ES	Futures	5407.74	5416.51	5402.65	5408.59	164660.0
2022-01-05 11:00:00	ES	Futures	5408.59	5410.0	5397.56	5400.11	106402.0
2022-01-05 12:00:00	ES	Futures	5400.39	5408.31	5392.47	5393.6	103741.0
2022-01-05 13:00:00	ES	Futures	5393.32	5395.3	5385.97	5391.9	107891.0
2022-01-05 14:00:00	ES	Futures	5392.19	5404.35	5338.46	5344.96	412149.0
2022-01-05 15:00:00	ES	Futures	5345.24	5345.24	5306.5	5307.91	443200.0
2022-01-05 16:00:00	ES	Futures	5307.91	5315.83	5304.8	5307.63	96875.0
2022-01-05 18:00:00	ES	Futures	5307.63	5315.55	5296.03	5314.7	20886.0
2022-01-05 19:00:00	ES	Futures	5314.42	5320.07	5307.35	5314.7	16468.0
2022-01-05 20:00:00	ES	Futures	5314.7	5320.07	5304.24	5314.7	14978.0
2022-01-05 21:00:00	ES	Futures	5314.7	5315.27	5303.1	5309.33	13549.0
2022-01-05 22:00:00	ES	Futures	5309.33	5310.17	5286.7	5287.27	17602.0
2022-01-05 23:00:00	ES	Futures	5287.55	5289.53	5280.48	5281.89	17752.0
2022-01-05 00:00:00	NQ	Futures	18785.66	18787.98	18752.33	18761.02	4345.0
2022-01-05 01:00:00	NQ	Futures	18760.44	18797.25	18747.4	18789.43	3832.0
2022-01-05 02:00:00	NQ	Futures	18790.58	18817.83	18773.78	18799.57	4883.0
2022-01-05 03:00:00	NQ	Futures	18799.28	18816.96	18783.34	18806.52	7661.0
2022-01-05 04:00:00	NQ	Futures	18805.66	18832.9	18800.15	18818.41	6262.0
2022-01-05 05:00:00	NQ	Futures	18819.28	18848.84	18806.52	18811.16	5733.0
2022-01-05 06:00:00	NQ	Futures	18809.71	18816.96	18778.7	18801.89	5762.0
2022-01-05 07:00:00	NQ	Futures	18802.47	18814.06	18774.36	18792.03	6079.0
2022-01-05 08:00:00	NQ	Futures	18792.61	18814.64	18760.73	18806.81	14094.0
2022-01-05 09:00:00	NQ	Futures	18806.52	18809.71	18667.7	18794.93	102301.0
2022-01-05 10:00:00	NQ	Futures	18794.93	18834.93	18690.6	18748.56	98242.0
2022-01-05 11:00:00	NQ	Futures	18747.98	18765.66	18684.8	18703.35	59626.0
2022-01-05 12:00:00	NQ	Futures	18702.77	18723.06	18602.2	18608.0	63918.0
2022-01-05 13:00:00	NQ	Futures	18608.58	18649.73	18579.02	18623.94	49556.0
2022-01-05 14:00:00	NQ	Futures	18623.94	18697.84	18408.03	18431.5	147240.0
2022-01-05 15:00:00	NQ	Futures	18431.79	18433.53	18268.91	18274.13	132355.0
2022-01-05 16:00:00	NQ	Futures	18274.71	18308.62	18261.67	18263.41	23535.0
2022-01-05 18:00:00	NQ	Futures	18274.42	18303.4	18212.4	18298.77	11790.0
2022-01-05 19:00:00	NQ	Futures	18298.19	18319.92	18261.38	18295.58	9481.0
2022-01-05 20:00:00	NQ	Futures	18295.87	18331.51	18250.37	18314.13	9253.0
2022-01-05 21:00:00	NQ	Futures	18314.71	18316.44	18266.89	18297.32	8144.0
2022-01-05 22:00:00	NQ	Futures	18297.03	18300.21	18170.67	18175.01	11640.0
2022-01-05 23:00:00	NQ	Futures	18175.3	18184.29	18108.07	18132.12	12569.0
2022-01-05 00:00:00	YM	Futures	41128.8	41133.3	41091.8	41101.9	1166.0
2022-01-05 01:00:00	YM	Futures	41104.1	41163.7	41092.9	41144.6	1801.0
2022-01-05 02:00:00	YM	Futures	41146.8	41201.9	41137.8	41195.1	2722.0
2022-01-05 03:00:00	YM	Futures	41194.0	41224.4	41158.1	41178.3	4200.0

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

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