PREVIEW / futures_1hour / 2023-11-23

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-11-23.parquet
  size:    50 KB
  rows:    1,583

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-11-23 00:00:00	ES	Futures	4959.47	4963.27	4959.2	4963.0	2910.0
2023-11-23 01:00:00	ES	Futures	4963.27	4965.72	4962.19	4963.82	5242.0
2023-11-23 02:00:00	ES	Futures	4963.82	4966.53	4962.46	4965.17	5734.0
2023-11-23 03:00:00	ES	Futures	4965.17	4966.26	4961.1	4965.72	9457.0
2023-11-23 04:00:00	ES	Futures	4965.72	4966.8	4963.27	4965.17	6886.0
2023-11-23 05:00:00	ES	Futures	4965.44	4966.53	4961.37	4963.27	4986.0
2023-11-23 06:00:00	ES	Futures	4963.27	4964.36	4961.37	4963.54	4118.0
2023-11-23 07:00:00	ES	Futures	4963.27	4965.72	4961.37	4961.91	4474.0
2023-11-23 08:00:00	ES	Futures	4962.19	4964.36	4961.64	4963.82	5329.0
2023-11-23 09:00:00	ES	Futures	4963.82	4965.72	4961.37	4962.46	11970.0
2023-11-23 10:00:00	ES	Futures	4962.46	4967.07	4962.46	4967.07	8422.0
2023-11-23 11:00:00	ES	Futures	4966.8	4967.07	4964.9	4965.17	6504.0
2023-11-23 12:00:00	ES	Futures	4965.44	4965.44	4962.19	4963.54	3907.0
2023-11-23 18:00:00	ES	Futures	4966.26	4966.26	4963.0	4964.9	3392.0
2023-11-23 19:00:00	ES	Futures	4964.9	4966.26	4963.82	4965.72	3125.0
2023-11-23 20:00:00	ES	Futures	4965.72	4966.53	4963.82	4965.99	3177.0
2023-11-23 21:00:00	ES	Futures	4965.99	4965.99	4963.27	4964.63	3715.0
2023-11-23 22:00:00	ES	Futures	4964.63	4965.17	4963.0	4964.09	2498.0
2023-11-23 23:00:00	ES	Futures	4964.09	4964.36	4963.0	4963.54	1444.0
2023-11-23 00:00:00	NQ	Futures	17632.34	17649.65	17631.79	17648.82	1811.0
2023-11-23 01:00:00	NQ	Futures	17649.1	17660.08	17647.17	17654.04	3267.0
2023-11-23 02:00:00	NQ	Futures	17653.77	17669.42	17653.77	17662.83	4309.0
2023-11-23 03:00:00	NQ	Futures	17663.1	17668.05	17647.45	17666.4	4585.0
2023-11-23 04:00:00	NQ	Futures	17665.85	17672.99	17654.32	17668.6	3886.0
2023-11-23 05:00:00	NQ	Futures	17668.6	17673.54	17649.65	17656.51	3244.0
2023-11-23 06:00:00	NQ	Futures	17656.51	17663.65	17653.22	17657.61	2860.0
2023-11-23 07:00:00	NQ	Futures	17657.89	17663.93	17642.23	17644.43	3549.0
2023-11-23 08:00:00	NQ	Futures	17644.98	17653.22	17641.13	17652.39	3199.0
2023-11-23 09:00:00	NQ	Futures	17652.67	17657.34	17638.66	17640.03	9913.0
2023-11-23 10:00:00	NQ	Futures	17640.86	17660.63	17635.09	17659.26	8573.0
2023-11-23 11:00:00	NQ	Futures	17658.98	17660.08	17646.9	17647.45	5308.0
2023-11-23 12:00:00	NQ	Futures	17647.45	17651.57	17642.78	17647.17	3154.0
2023-11-23 18:00:00	NQ	Futures	17647.17	17663.1	17643.88	17649.92	1884.0
2023-11-23 19:00:00	NQ	Futures	17649.37	17656.24	17644.15	17654.59	2030.0
2023-11-23 20:00:00	NQ	Futures	17654.32	17655.69	17642.78	17651.29	2391.0
2023-11-23 21:00:00	NQ	Futures	17651.57	17653.22	17641.41	17650.74	2573.0
2023-11-23 22:00:00	NQ	Futures	17651.02	17654.04	17643.6	17647.72	1888.0
2023-11-23 23:00:00	NQ	Futures	17648.0	17648.55	17644.15	17645.8	1139.0
2023-11-23 00:00:00	YM	Futures	38292.1	38316.0	38292.1	38314.9	432.0
2023-11-23 01:00:00	YM	Futures	38314.9	38333.3	38310.6	38317.1	1018.0
2023-11-23 02:00:00	YM	Futures	38317.1	38330.1	38310.6	38326.8	1229.0
2023-11-23 03:00:00	YM	Futures	38326.8	38334.4	38299.7	38326.8	2730.0
2023-11-23 04:00:00	YM	Futures	38325.8	38331.2	38307.3	38320.3	2731.0
2023-11-23 05:00:00	YM	Futures	38321.4	38331.2	38295.4	38312.7	2302.0
2023-11-23 06:00:00	YM	Futures	38312.7	38322.5	38296.5	38318.2	1561.0
2023-11-23 07:00:00	YM	Futures	38317.1	38325.8	38298.6	38300.8	1382.0
2023-11-23 08:00:00	YM	Futures	38299.7	38332.3	38297.6	38331.2	1956.0
2023-11-23 09:00:00	YM	Futures	38331.2	38365.9	38317.1	38345.3	5865.0
2023-11-23 10:00:00	YM	Futures	38346.4	38384.3	38332.3	38371.3	3101.0
2023-11-23 11:00:00	YM	Futures	38370.2	38389.8	38360.5	38368.1	1699.0

> showing 50 of 1,583 rows — these rows as CSV

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