PREVIEW / futures_1hour / 2023-06-27

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-06-27.parquet
  size:    66 KB
  rows:    2,051

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-27 00:00:00	ES	Futures	4808.07	4810.54	4807.24	4809.71	3626.0
2023-06-27 01:00:00	ES	Futures	4809.71	4813.83	4808.89	4813.28	6597.0
2023-06-27 02:00:00	ES	Futures	4813.28	4815.75	4811.64	4812.18	10319.0
2023-06-27 03:00:00	ES	Futures	4812.18	4817.95	4809.44	4811.09	24775.0
2023-06-27 04:00:00	ES	Futures	4810.81	4813.28	4805.32	4807.52	17184.0
2023-06-27 05:00:00	ES	Futures	4807.24	4808.62	4805.87	4806.97	10065.0
2023-06-27 06:00:00	ES	Futures	4806.97	4811.36	4805.32	4810.54	9314.0
2023-06-27 07:00:00	ES	Futures	4810.54	4810.54	4800.38	4802.3	17308.0
2023-06-27 08:00:00	ES	Futures	4802.3	4810.81	4800.11	4806.15	31536.0
2023-06-27 09:00:00	ES	Futures	4806.42	4819.32	4804.5	4813.01	175321.0
2023-06-27 10:00:00	ES	Futures	4812.73	4820.69	4803.4	4819.87	265979.0
2023-06-27 11:00:00	ES	Futures	4819.6	4830.85	4810.54	4829.48	182842.0
2023-06-27 12:00:00	ES	Futures	4829.48	4842.11	4828.11	4839.36	126795.0
2023-06-27 13:00:00	ES	Futures	4839.36	4852.81	4835.79	4852.26	118351.0
2023-06-27 14:00:00	ES	Futures	4852.26	4856.66	4850.62	4851.17	119668.0
2023-06-27 15:00:00	ES	Futures	4851.44	4858.58	4850.62	4851.17	219264.0
2023-06-27 16:00:00	ES	Futures	4851.17	4851.71	4845.95	4847.6	57277.0
2023-06-27 18:00:00	ES	Futures	4846.77	4847.87	4843.48	4844.03	5979.0
2023-06-27 19:00:00	ES	Futures	4844.03	4844.85	4841.28	4843.48	6647.0
2023-06-27 20:00:00	ES	Futures	4843.48	4845.95	4839.64	4841.56	8440.0
2023-06-27 21:00:00	ES	Futures	4841.56	4842.66	4839.09	4840.46	8512.0
2023-06-27 22:00:00	ES	Futures	4840.73	4845.4	4839.09	4843.75	7651.0
2023-06-27 23:00:00	ES	Futures	4843.75	4845.68	4843.2	4843.75	5570.0
2023-06-27 00:00:00	NQ	Futures	16549.64	16561.04	16546.86	16555.76	1828.0
2023-06-27 01:00:00	NQ	Futures	16556.31	16584.13	16552.42	16581.9	3855.0
2023-06-27 02:00:00	NQ	Futures	16581.9	16594.97	16573.0	16580.23	4790.0
2023-06-27 03:00:00	NQ	Futures	16579.68	16603.32	16578.01	16583.01	7225.0
2023-06-27 04:00:00	NQ	Futures	16582.46	16604.15	16572.44	16585.52	6356.0
2023-06-27 05:00:00	NQ	Futures	16585.79	16599.7	16578.28	16595.81	4256.0
2023-06-27 06:00:00	NQ	Futures	16596.09	16616.39	16590.8	16608.88	4517.0
2023-06-27 07:00:00	NQ	Futures	16609.16	16610.55	16574.67	16583.57	6684.0
2023-06-27 08:00:00	NQ	Futures	16583.29	16618.06	16566.33	16591.64	13955.0
2023-06-27 09:00:00	NQ	Futures	16592.75	16655.05	16574.39	16641.98	85680.0
2023-06-27 10:00:00	NQ	Futures	16641.7	16664.51	16563.27	16616.95	104556.0
2023-06-27 11:00:00	NQ	Futures	16616.39	16702.89	16565.21	16698.72	74411.0
2023-06-27 12:00:00	NQ	Futures	16698.72	16764.08	16690.93	16748.5	52114.0
2023-06-27 13:00:00	NQ	Futures	16748.78	16817.2	16727.64	16815.81	49728.0
2023-06-27 14:00:00	NQ	Futures	16815.81	16836.95	16800.51	16805.8	43990.0
2023-06-27 15:00:00	NQ	Futures	16805.8	16842.79	16800.23	16808.3	57171.0
2023-06-27 16:00:00	NQ	Futures	16808.3	16809.41	16782.71	16786.33	16853.0
2023-06-27 18:00:00	NQ	Futures	16786.05	16791.06	16745.72	16749.89	6504.0
2023-06-27 19:00:00	NQ	Futures	16749.34	16761.85	16734.59	16754.34	5996.0
2023-06-27 20:00:00	NQ	Futures	16754.34	16763.24	16729.59	16737.93	5438.0
2023-06-27 21:00:00	NQ	Futures	16738.49	16746.55	16728.48	16740.44	4291.0
2023-06-27 22:00:00	NQ	Futures	16740.44	16761.57	16728.75	16755.45	4532.0
2023-06-27 23:00:00	NQ	Futures	16755.18	16764.35	16755.18	16757.96	2758.0
2023-06-27 00:00:00	YM	Futures	37279.2	37293.5	37271.5	37290.2	549.0
2023-06-27 01:00:00	YM	Futures	37290.2	37311.0	37285.8	37303.3	1663.0
2023-06-27 02:00:00	YM	Futures	37303.3	37325.2	37295.6	37301.1	3404.0
2023-06-27 03:00:00	YM	Futures	37300.0	37338.4	37268.3	37286.9	7633.0

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

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