PREVIEW / futures_1hour / 2023-12-07

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-12-07.parquet
  size:    66 KB
  rows:    2,038

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-12-07 00:00:00	ES	Futures	4946.71	4947.25	4943.45	4944.53	6909.0
2023-12-07 01:00:00	ES	Futures	4944.81	4947.52	4942.91	4943.45	6000.0
2023-12-07 02:00:00	ES	Futures	4943.72	4948.34	4942.63	4947.25	11278.0
2023-12-07 03:00:00	ES	Futures	4947.52	4950.24	4943.18	4943.18	25563.0
2023-12-07 04:00:00	ES	Futures	4943.18	4949.42	4941.0	4948.06	23070.0
2023-12-07 05:00:00	ES	Futures	4948.34	4949.69	4945.08	4948.34	11807.0
2023-12-07 06:00:00	ES	Futures	4948.06	4950.78	4947.52	4949.42	14447.0
2023-12-07 07:00:00	ES	Futures	4949.15	4953.5	4947.25	4952.95	24415.0
2023-12-07 08:00:00	ES	Futures	4952.95	4964.36	4950.78	4963.54	65386.0
2023-12-07 09:00:00	ES	Futures	4963.54	4974.13	4962.19	4965.44	263738.0
2023-12-07 10:00:00	ES	Futures	4965.72	4984.18	4964.9	4981.2	266818.0
2023-12-07 11:00:00	ES	Futures	4981.2	4983.91	4965.99	4983.64	240091.0
2023-12-07 12:00:00	ES	Futures	4983.64	4987.44	4978.48	4984.18	143904.0
2023-12-07 13:00:00	ES	Futures	4984.18	4988.53	4981.74	4985.81	87831.0
2023-12-07 14:00:00	ES	Futures	4985.54	4992.33	4982.28	4982.82	107634.0
2023-12-07 15:00:00	ES	Futures	4982.55	4987.71	4981.47	4984.18	199511.0
2023-12-07 16:00:00	ES	Futures	4984.18	4984.73	4978.75	4981.2	57734.0
2023-12-07 18:00:00	ES	Futures	4982.01	4983.1	4979.02	4979.84	4937.0
2023-12-07 19:00:00	ES	Futures	4980.11	4984.18	4979.57	4983.1	7295.0
2023-12-07 20:00:00	ES	Futures	4983.1	4983.37	4979.57	4980.65	7903.0
2023-12-07 21:00:00	ES	Futures	4980.38	4983.64	4980.11	4983.64	5050.0
2023-12-07 22:00:00	ES	Futures	4983.64	4985.27	4982.55	4985.0	4299.0
2023-12-07 23:00:00	ES	Futures	4985.0	4985.81	4984.18	4985.54	2958.0
2023-12-07 00:00:00	NQ	Futures	17373.88	17376.63	17350.81	17357.95	4242.0
2023-12-07 01:00:00	NQ	Futures	17358.5	17368.39	17350.54	17353.01	2834.0
2023-12-07 02:00:00	NQ	Futures	17353.28	17376.08	17348.89	17374.43	4914.0
2023-12-07 03:00:00	NQ	Futures	17374.71	17399.43	17374.43	17381.57	10208.0
2023-12-07 04:00:00	NQ	Futures	17381.02	17416.18	17362.07	17407.67	11967.0
2023-12-07 05:00:00	NQ	Futures	17407.94	17415.36	17396.96	17411.24	5894.0
2023-12-07 06:00:00	NQ	Futures	17410.41	17421.95	17398.05	17415.63	6953.0
2023-12-07 07:00:00	NQ	Futures	17415.63	17425.8	17401.08	17423.6	8668.0
2023-12-07 08:00:00	NQ	Futures	17423.87	17486.5	17407.67	17479.35	27614.0
2023-12-07 09:00:00	NQ	Futures	17479.63	17558.73	17454.91	17476.33	118693.0
2023-12-07 10:00:00	NQ	Futures	17476.61	17586.75	17473.04	17575.76	101828.0
2023-12-07 11:00:00	NQ	Futures	17575.76	17609.27	17502.43	17607.62	90607.0
2023-12-07 12:00:00	NQ	Futures	17607.62	17640.03	17589.49	17615.59	51265.0
2023-12-07 13:00:00	NQ	Futures	17615.86	17636.19	17596.64	17615.59	33924.0
2023-12-07 14:00:00	NQ	Futures	17615.59	17651.02	17602.68	17604.33	39732.0
2023-12-07 15:00:00	NQ	Futures	17604.33	17634.54	17599.66	17617.24	54969.0
2023-12-07 16:00:00	NQ	Futures	17616.96	17617.51	17585.1	17598.28	15507.0
2023-12-07 18:00:00	NQ	Futures	17597.73	17610.92	17596.09	17599.93	2601.0
2023-12-07 19:00:00	NQ	Futures	17600.48	17612.29	17598.83	17604.05	3388.0
2023-12-07 20:00:00	NQ	Futures	17603.78	17605.43	17585.65	17591.42	4021.0
2023-12-07 21:00:00	NQ	Futures	17590.59	17602.13	17589.49	17598.28	1912.0
2023-12-07 22:00:00	NQ	Futures	17597.46	17607.62	17594.99	17606.25	1750.0
2023-12-07 23:00:00	NQ	Futures	17606.25	17610.37	17603.23	17607.9	1538.0
2023-12-07 00:00:00	YM	Futures	39145.9	39153.5	39130.7	39139.3	716.0
2023-12-07 01:00:00	YM	Futures	39140.4	39157.8	39133.9	39138.3	626.0
2023-12-07 02:00:00	YM	Futures	39139.3	39175.1	39135.0	39158.9	1882.0
2023-12-07 03:00:00	YM	Futures	39158.9	39175.1	39096.0	39096.0	3516.0

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

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