PREVIEW / futures_1hour / 2023-12-06

all futures 1-hour files

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

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-06 00:00:00	ES	Futures	4984.18	4986.08	4982.28	4984.18	7415.0
2023-12-06 01:00:00	ES	Futures	4984.18	4984.73	4981.2	4981.74	6105.0
2023-12-06 02:00:00	ES	Futures	4981.74	4982.55	4977.66	4981.74	10224.0
2023-12-06 03:00:00	ES	Futures	4981.74	4983.91	4978.48	4980.11	21515.0
2023-12-06 04:00:00	ES	Futures	4980.11	4983.1	4975.76	4979.57	17210.0
2023-12-06 05:00:00	ES	Futures	4979.84	4984.45	4978.48	4983.91	11811.0
2023-12-06 06:00:00	ES	Futures	4983.64	4983.91	4976.31	4978.48	15085.0
2023-12-06 07:00:00	ES	Futures	4978.21	4979.84	4974.95	4979.29	18246.0
2023-12-06 08:00:00	ES	Futures	4979.02	4992.6	4977.12	4990.7	73931.0
2023-12-06 09:00:00	ES	Futures	4990.43	4995.04	4982.55	4984.73	233325.0
2023-12-06 10:00:00	ES	Futures	4984.73	4989.07	4971.15	4975.76	291578.0
2023-12-06 11:00:00	ES	Futures	4975.76	4978.75	4962.73	4971.15	212450.0
2023-12-06 12:00:00	ES	Futures	4971.15	4971.96	4960.29	4961.1	147981.0
2023-12-06 13:00:00	ES	Futures	4961.1	4969.25	4958.11	4967.62	122492.0
2023-12-06 14:00:00	ES	Futures	4967.89	4968.7	4960.56	4960.83	99931.0
2023-12-06 15:00:00	ES	Futures	4960.83	4961.64	4944.53	4948.88	310047.0
2023-12-06 16:00:00	ES	Futures	4949.15	4951.05	4947.52	4949.42	56439.0
2023-12-06 18:00:00	ES	Futures	4948.88	4949.97	4945.08	4948.06	11136.0
2023-12-06 19:00:00	ES	Futures	4948.06	4949.97	4945.89	4946.71	8739.0
2023-12-06 20:00:00	ES	Futures	4946.71	4948.88	4944.53	4945.35	9387.0
2023-12-06 21:00:00	ES	Futures	4945.08	4946.98	4943.72	4945.35	7363.0
2023-12-06 22:00:00	ES	Futures	4945.62	4947.25	4943.99	4945.62	5946.0
2023-12-06 23:00:00	ES	Futures	4945.62	4947.52	4945.35	4946.71	3937.0
2023-12-06 00:00:00	NQ	Futures	17555.99	17565.05	17546.37	17552.69	3553.0
2023-12-06 01:00:00	NQ	Futures	17553.24	17557.63	17544.18	17546.37	3430.0
2023-12-06 02:00:00	NQ	Futures	17546.37	17551.32	17527.15	17549.12	5714.0
2023-12-06 03:00:00	NQ	Futures	17549.39	17565.32	17530.99	17536.48	10608.0
2023-12-06 04:00:00	NQ	Futures	17536.76	17555.16	17515.61	17530.72	10347.0
2023-12-06 05:00:00	NQ	Futures	17530.99	17548.84	17523.03	17547.47	6212.0
2023-12-06 06:00:00	NQ	Futures	17546.92	17547.75	17504.35	17517.26	9432.0
2023-12-06 07:00:00	NQ	Futures	17516.71	17519.73	17492.54	17513.69	10468.0
2023-12-06 08:00:00	NQ	Futures	17513.69	17597.46	17504.35	17593.07	32028.0
2023-12-06 09:00:00	NQ	Futures	17593.07	17619.98	17508.47	17522.2	107981.0
2023-12-06 10:00:00	NQ	Futures	17522.2	17549.12	17442.0	17507.1	121969.0
2023-12-06 11:00:00	NQ	Futures	17507.37	17523.3	17428.54	17486.77	84225.0
2023-12-06 12:00:00	NQ	Futures	17486.5	17495.83	17429.37	17434.03	51830.0
2023-12-06 13:00:00	NQ	Futures	17434.31	17456.01	17407.12	17451.34	49288.0
2023-12-06 14:00:00	NQ	Futures	17451.61	17455.73	17421.13	17432.66	38744.0
2023-12-06 15:00:00	NQ	Futures	17432.66	17438.7	17360.97	17375.26	74358.0
2023-12-06 16:00:00	NQ	Futures	17375.26	17382.95	17368.94	17374.71	13385.0
2023-12-06 18:00:00	NQ	Futures	17374.71	17386.24	17359.6	17377.45	5590.0
2023-12-06 19:00:00	NQ	Futures	17376.63	17386.24	17367.29	17375.53	3899.0
2023-12-06 20:00:00	NQ	Futures	17375.81	17384.6	17358.5	17363.17	3988.0
2023-12-06 21:00:00	NQ	Futures	17362.9	17375.26	17362.07	17370.04	3586.0
2023-12-06 22:00:00	NQ	Futures	17370.04	17380.2	17363.17	17373.06	3479.0
2023-12-06 23:00:00	NQ	Futures	17372.51	17377.73	17371.14	17373.88	1748.0
2023-12-06 00:00:00	YM	Futures	39332.4	39342.2	39317.3	39331.4	882.0
2023-12-06 01:00:00	YM	Futures	39332.4	39334.6	39305.3	39305.3	621.0
2023-12-06 02:00:00	YM	Futures	39306.4	39312.9	39277.1	39295.6	1579.0
2023-12-06 03:00:00	YM	Futures	39294.5	39317.3	39273.9	39284.7	4465.0

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

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