PREVIEW / futures_1hour / 2022-08-23

all futures 1-hour files

  file:    by_date/futures_1hour/2022/2022-08-23.parquet
  size:    67 KB
  rows:    2,000

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-08-23 00:00:00	ES	Futures	4698.62	4700.32	4691.54	4693.81	5235.0
2022-08-23 01:00:00	ES	Futures	4693.53	4694.66	4681.34	4685.59	11783.0
2022-08-23 02:00:00	ES	Futures	4685.31	4689.84	4666.05	4673.98	22376.0
2022-08-23 03:00:00	ES	Futures	4674.26	4702.87	4673.7	4700.61	29802.0
2022-08-23 04:00:00	ES	Futures	4700.32	4710.24	4700.32	4700.89	16110.0
2022-08-23 05:00:00	ES	Futures	4700.61	4706.27	4696.07	4705.42	11012.0
2022-08-23 06:00:00	ES	Futures	4705.42	4705.42	4693.24	4696.64	14531.0
2022-08-23 07:00:00	ES	Futures	4696.64	4702.31	4691.83	4700.61	17129.0
2022-08-23 08:00:00	ES	Futures	4700.61	4701.74	4687.01	4688.99	33704.0
2022-08-23 09:00:00	ES	Futures	4689.28	4705.71	4681.06	4698.34	218627.0
2022-08-23 10:00:00	ES	Futures	4698.06	4715.62	4685.31	4687.01	301474.0
2022-08-23 11:00:00	ES	Futures	4687.01	4694.38	4676.81	4687.58	190314.0
2022-08-23 12:00:00	ES	Futures	4687.58	4690.69	4673.98	4688.99	144365.0
2022-08-23 13:00:00	ES	Futures	4689.28	4694.94	4677.1	4681.91	130578.0
2022-08-23 14:00:00	ES	Futures	4682.19	4691.54	4678.8	4686.16	112191.0
2022-08-23 15:00:00	ES	Futures	4686.16	4694.09	4678.51	4680.78	200922.0
2022-08-23 16:00:00	ES	Futures	4681.06	4683.33	4676.81	4677.38	41377.0
2022-08-23 18:00:00	ES	Futures	4677.66	4681.63	4675.96	4680.49	3787.0
2022-08-23 19:00:00	ES	Futures	4680.78	4683.04	4676.81	4678.23	4517.0
2022-08-23 20:00:00	ES	Futures	4678.23	4681.34	4673.98	4675.96	7606.0
2022-08-23 21:00:00	ES	Futures	4675.68	4676.81	4663.5	4667.18	14082.0
2022-08-23 22:00:00	ES	Futures	4667.46	4669.16	4661.52	4663.78	8940.0
2022-08-23 23:00:00	ES	Futures	4663.78	4665.48	4662.08	4663.78	4068.0
2022-08-23 00:00:00	NQ	Futures	14963.49	14968.7	14941.22	14946.72	2291.0
2022-08-23 01:00:00	NQ	Futures	14945.27	14948.45	14897.84	14916.93	6149.0
2022-08-23 02:00:00	NQ	Futures	14917.5	14933.12	14836.23	14866.89	10787.0
2022-08-23 03:00:00	NQ	Futures	14867.47	14971.01	14866.89	14957.13	16631.0
2022-08-23 04:00:00	NQ	Futures	14957.42	14999.94	14957.13	14971.3	10831.0
2022-08-23 05:00:00	NQ	Futures	14971.01	14986.92	14946.14	14984.03	6996.0
2022-08-23 06:00:00	NQ	Futures	14983.74	14984.32	14933.99	14949.32	8325.0
2022-08-23 07:00:00	NQ	Futures	14949.61	14982.58	14936.59	14973.04	7347.0
2022-08-23 08:00:00	NQ	Futures	14972.17	14981.43	14922.42	14925.02	13856.0
2022-08-23 09:00:00	NQ	Futures	14925.89	15023.37	14885.4	14980.27	88069.0
2022-08-23 10:00:00	NQ	Futures	14979.98	15061.83	14918.37	14923.87	106274.0
2022-08-23 11:00:00	NQ	Futures	14924.16	14976.22	14895.81	14947.58	64950.0
2022-08-23 12:00:00	NQ	Futures	14948.16	14969.86	14903.62	14964.07	51756.0
2022-08-23 13:00:00	NQ	Futures	14964.36	14996.18	14925.89	14947.3	51079.0
2022-08-23 14:00:00	NQ	Futures	14947.87	14987.21	14935.15	14961.76	36804.0
2022-08-23 15:00:00	NQ	Futures	14962.05	14983.16	14903.91	14924.16	56492.0
2022-08-23 16:00:00	NQ	Futures	14923.87	14931.97	14909.12	14912.3	9541.0
2022-08-23 18:00:00	NQ	Futures	14915.48	14927.63	14907.38	14925.02	1703.0
2022-08-23 19:00:00	NQ	Futures	14924.73	14934.86	14912.88	14919.24	2009.0
2022-08-23 20:00:00	NQ	Futures	14918.95	14930.23	14901.31	14906.8	3632.0
2022-08-23 21:00:00	NQ	Futures	14907.09	14910.56	14856.19	14870.94	5328.0
2022-08-23 22:00:00	NQ	Futures	14872.67	14876.72	14845.19	14856.76	5239.0
2022-08-23 23:00:00	NQ	Futures	14856.47	14865.44	14849.82	14859.95	2151.0
2022-08-23 00:00:00	YM	Futures	37356.1	37364.0	37310.9	37316.6	682.0
2022-08-23 01:00:00	YM	Futures	37318.8	37326.7	37234.2	37259.0	2113.0
2022-08-23 02:00:00	YM	Futures	37256.8	37288.4	37127.0	37172.2	4076.0
2022-08-23 03:00:00	YM	Futures	37173.3	37397.8	37169.9	37380.9	7756.0

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

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