PREVIEW / futures_1hour / 2022-06-27

all futures 1-hour files

  file:    by_date/futures_1hour/2022/2022-06-27.parquet
  size:    67 KB
  rows:    2,049

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-06-27 00:00:00	ES	Futures	4449.06	4450.48	4446.23	4449.63	3970.0
2022-06-27 01:00:00	ES	Futures	4449.63	4451.04	4436.31	4442.55	9046.0
2022-06-27 02:00:00	ES	Futures	4442.83	4443.11	4432.35	4435.75	10698.0
2022-06-27 03:00:00	ES	Futures	4435.46	4472.01	4432.92	4469.74	32601.0
2022-06-27 04:00:00	ES	Futures	4469.74	4473.42	4457.28	4459.83	18161.0
2022-06-27 05:00:00	ES	Futures	4459.83	4462.94	4453.31	4458.13	15409.0
2022-06-27 06:00:00	ES	Futures	4458.41	4459.83	4446.8	4453.88	13763.0
2022-06-27 07:00:00	ES	Futures	4453.88	4460.39	4452.18	4456.14	13557.0
2022-06-27 08:00:00	ES	Futures	4456.14	4457.84	4439.71	4443.96	34254.0
2022-06-27 09:00:00	ES	Futures	4444.25	4455.01	4411.67	4418.47	214055.0
2022-06-27 10:00:00	ES	Futures	4418.47	4449.63	4416.77	4443.96	233478.0
2022-06-27 11:00:00	ES	Futures	4444.25	4452.74	4432.92	4446.51	137600.0
2022-06-27 12:00:00	ES	Futures	4446.51	4448.21	4422.72	4437.73	120102.0
2022-06-27 13:00:00	ES	Futures	4437.73	4439.15	4417.9	4421.58	107304.0
2022-06-27 14:00:00	ES	Futures	4421.58	4432.35	4416.49	4423.57	105291.0
2022-06-27 15:00:00	ES	Futures	4423.57	4430.93	4410.54	4425.27	248077.0
2022-06-27 16:00:00	ES	Futures	4425.55	4433.2	4424.13	4430.37	54408.0
2022-06-27 18:00:00	ES	Futures	4431.78	4433.48	4425.27	4428.38	3818.0
2022-06-27 19:00:00	ES	Futures	4428.67	4432.63	4426.4	4430.08	3733.0
2022-06-27 20:00:00	ES	Futures	4429.8	4439.15	4429.52	4433.77	10183.0
2022-06-27 21:00:00	ES	Futures	4433.77	4436.03	4412.24	4413.94	11924.0
2022-06-27 22:00:00	ES	Futures	4413.94	4421.02	4402.89	4412.8	14542.0
2022-06-27 23:00:00	ES	Futures	4412.8	4421.87	4411.1	4418.75	7414.0
2022-06-27 00:00:00	NQ	Futures	14123.25	14132.8	14110.53	14122.67	2430.0
2022-06-27 01:00:00	NQ	Futures	14123.25	14126.44	14049.21	14070.32	7382.0
2022-06-27 02:00:00	NQ	Futures	14070.9	14073.5	14030.41	14045.74	5097.0
2022-06-27 03:00:00	NQ	Futures	14044.87	14178.5	14037.35	14158.25	15751.0
2022-06-27 04:00:00	NQ	Futures	14157.67	14186.6	14128.75	14136.85	9714.0
2022-06-27 05:00:00	NQ	Futures	14137.14	14147.84	14115.15	14137.72	7682.0
2022-06-27 06:00:00	NQ	Futures	14138.29	14142.34	14089.41	14111.68	7797.0
2022-06-27 07:00:00	NQ	Futures	14112.55	14139.16	14106.19	14121.52	6754.0
2022-06-27 08:00:00	NQ	Futures	14121.81	14128.46	14054.7	14067.72	17137.0
2022-06-27 09:00:00	NQ	Futures	14068.59	14128.75	13907.77	13958.39	85526.0
2022-06-27 10:00:00	NQ	Futures	13958.39	14055.86	13912.4	14041.69	89671.0
2022-06-27 11:00:00	NQ	Futures	14041.69	14058.75	13982.68	14020.57	55891.0
2022-06-27 12:00:00	NQ	Futures	14021.44	14030.41	13929.75	13991.94	45208.0
2022-06-27 13:00:00	NQ	Futures	13991.94	13997.43	13918.76	13928.6	36133.0
2022-06-27 14:00:00	NQ	Futures	13929.46	13971.69	13914.42	13940.17	35940.0
2022-06-27 15:00:00	NQ	Futures	13940.45	13956.65	13876.82	13934.96	70499.0
2022-06-27 16:00:00	NQ	Futures	13935.25	13975.74	13933.8	13969.96	16617.0
2022-06-27 18:00:00	NQ	Futures	13971.69	13978.06	13945.37	13955.49	2035.0
2022-06-27 19:00:00	NQ	Futures	13955.78	13970.25	13947.97	13961.57	2135.0
2022-06-27 20:00:00	NQ	Futures	13960.7	13994.25	13958.1	13975.74	3561.0
2022-06-27 21:00:00	NQ	Futures	13976.32	13984.71	13894.18	13904.01	5808.0
2022-06-27 22:00:00	NQ	Futures	13904.01	13925.12	13849.92	13888.68	9346.0
2022-06-27 23:00:00	NQ	Futures	13889.55	13920.79	13883.47	13910.08	4707.0
2022-06-27 00:00:00	YM	Futures	35574.4	35582.3	35554.1	35582.3	523.0
2022-06-27 01:00:00	YM	Futures	35581.2	35595.9	35502.2	35557.5	1959.0
2022-06-27 02:00:00	YM	Futures	35558.6	35559.7	35487.5	35513.5	1717.0
2022-06-27 03:00:00	YM	Futures	35510.1	35760.6	35488.7	35755.0	4983.0

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

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