PREVIEW / futures_1hour / 2023-08-09

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-08-09.parquet
  size:    65 KB
  rows:    2,023

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-08-09 00:00:00	ES	Futures	4963.99	4966.19	4963.17	4965.91	2360.0
2023-08-09 01:00:00	ES	Futures	4965.91	4970.03	4965.64	4967.56	4316.0
2023-08-09 02:00:00	ES	Futures	4967.56	4971.4	4965.91	4970.03	7622.0
2023-08-09 03:00:00	ES	Futures	4970.3	4978.81	4966.46	4973.6	25841.0
2023-08-09 04:00:00	ES	Futures	4973.6	4980.46	4971.13	4979.09	13347.0
2023-08-09 05:00:00	ES	Futures	4978.81	4981.01	4972.5	4974.7	10460.0
2023-08-09 06:00:00	ES	Futures	4974.42	4977.72	4970.3	4970.58	9566.0
2023-08-09 07:00:00	ES	Futures	4970.85	4977.17	4966.46	4975.52	21426.0
2023-08-09 08:00:00	ES	Futures	4975.52	4976.89	4966.73	4967.83	29956.0
2023-08-09 09:00:00	ES	Futures	4968.11	4968.93	4951.36	4954.93	193503.0
2023-08-09 10:00:00	ES	Futures	4954.93	4959.87	4942.85	4944.5	194769.0
2023-08-09 11:00:00	ES	Futures	4944.22	4947.79	4917.32	4922.26	251639.0
2023-08-09 12:00:00	ES	Futures	4921.99	4935.99	4920.34	4931.6	144023.0
2023-08-09 13:00:00	ES	Futures	4931.6	4949.72	4929.4	4945.6	126181.0
2023-08-09 14:00:00	ES	Futures	4945.87	4960.97	4943.95	4953.56	132010.0
2023-08-09 15:00:00	ES	Futures	4953.56	4954.38	4922.54	4926.11	318137.0
2023-08-09 16:00:00	ES	Futures	4926.38	4934.34	4926.11	4933.79	66628.0
2023-08-09 18:00:00	ES	Futures	4933.79	4937.36	4933.24	4936.54	6174.0
2023-08-09 19:00:00	ES	Futures	4936.54	4939.28	4935.44	4937.91	4186.0
2023-08-09 20:00:00	ES	Futures	4937.91	4941.48	4936.54	4940.93	6959.0
2023-08-09 21:00:00	ES	Futures	4941.21	4941.21	4935.71	4937.64	7798.0
2023-08-09 22:00:00	ES	Futures	4937.36	4943.68	4937.09	4942.3	7523.0
2023-08-09 23:00:00	ES	Futures	4942.58	4945.32	4942.58	4944.22	4814.0
2023-08-09 00:00:00	NQ	Futures	17103.95	17111.74	17098.95	17110.35	2181.0
2023-08-09 01:00:00	NQ	Futures	17110.63	17131.77	17109.52	17121.2	3838.0
2023-08-09 02:00:00	NQ	Futures	17120.64	17142.33	17108.68	17135.38	5769.0
2023-08-09 03:00:00	NQ	Futures	17136.22	17169.04	17117.58	17134.55	11731.0
2023-08-09 04:00:00	NQ	Futures	17135.1	17163.47	17125.37	17157.91	9066.0
2023-08-09 05:00:00	NQ	Futures	17157.35	17159.58	17125.37	17134.55	5656.0
2023-08-09 06:00:00	NQ	Futures	17133.43	17140.94	17112.57	17114.52	5449.0
2023-08-09 07:00:00	NQ	Futures	17115.08	17136.77	17091.99	17130.38	11009.0
2023-08-09 08:00:00	NQ	Futures	17130.93	17141.5	17094.5	17102.01	15926.0
2023-08-09 09:00:00	NQ	Futures	17102.28	17107.01	16981.3	16998.54	86560.0
2023-08-09 10:00:00	NQ	Futures	16998.82	17024.13	16915.94	16917.6	93638.0
2023-08-09 11:00:00	NQ	Futures	16917.6	16940.41	16850.85	16874.77	100506.0
2023-08-09 12:00:00	NQ	Futures	16874.22	16931.23	16868.93	16898.69	51516.0
2023-08-09 13:00:00	NQ	Futures	16898.97	16981.02	16888.68	16964.33	50001.0
2023-08-09 14:00:00	NQ	Futures	16964.33	17028.86	16955.71	16990.75	55016.0
2023-08-09 15:00:00	NQ	Futures	16991.03	16996.04	16873.94	16888.4	96009.0
2023-08-09 16:00:00	NQ	Futures	16888.68	16923.45	16887.84	16914.55	17291.0
2023-08-09 18:00:00	NQ	Futures	16913.15	16934.01	16911.21	16928.73	3514.0
2023-08-09 19:00:00	NQ	Futures	16928.17	16939.02	16914.82	16931.23	3293.0
2023-08-09 20:00:00	NQ	Futures	16931.23	16950.7	16922.33	16949.59	3932.0
2023-08-09 21:00:00	NQ	Futures	16949.87	16951.54	16920.94	16927.34	4329.0
2023-08-09 22:00:00	NQ	Futures	16926.78	16959.88	16923.17	16950.98	4901.0
2023-08-09 23:00:00	NQ	Futures	16952.09	16959.05	16950.42	16954.6	2018.0
2023-08-09 00:00:00	YM	Futures	38762.6	38774.6	38757.1	38771.3	370.0
2023-08-09 01:00:00	YM	Futures	38772.4	38800.9	38768.1	38782.3	874.0
2023-08-09 02:00:00	YM	Futures	38782.3	38814.1	38776.8	38788.9	1801.0
2023-08-09 03:00:00	YM	Futures	38788.9	38852.4	38765.9	38833.8	4395.0

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

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