PREVIEW / futures_1hour / 2023-11-24

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-11-24.parquet
  size:    45 KB
  rows:    1,330

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-24 00:00:00	ES	Futures	4963.54	4964.36	4962.73	4964.09	2417.0
2023-11-24 01:00:00	ES	Futures	4964.09	4964.36	4962.46	4964.09	3345.0
2023-11-24 02:00:00	ES	Futures	4964.09	4964.09	4959.74	4962.19	5973.0
2023-11-24 03:00:00	ES	Futures	4962.46	4964.63	4961.1	4961.91	9987.0
2023-11-24 04:00:00	ES	Futures	4961.91	4968.43	4961.91	4965.17	11775.0
2023-11-24 05:00:00	ES	Futures	4965.44	4967.62	4963.54	4967.07	7742.0
2023-11-24 06:00:00	ES	Futures	4967.07	4967.62	4962.46	4965.72	7984.0
2023-11-24 07:00:00	ES	Futures	4965.99	4968.16	4964.9	4965.44	9401.0
2023-11-24 08:00:00	ES	Futures	4965.44	4965.72	4960.29	4964.09	17011.0
2023-11-24 09:00:00	ES	Futures	4964.09	4964.36	4956.48	4961.91	94602.0
2023-11-24 10:00:00	ES	Futures	4962.19	4965.17	4956.21	4960.83	81082.0
2023-11-24 11:00:00	ES	Futures	4960.56	4961.91	4957.57	4958.38	61215.0
2023-11-24 12:00:00	ES	Futures	4958.38	4963.0	4957.03	4962.19	83732.0
2023-11-24 13:00:00	ES	Futures	4962.19	4964.09	4961.37	4962.19	21394.0
2023-11-24 00:00:00	NQ	Futures	17645.8	17647.45	17641.41	17644.98	1773.0
2023-11-24 01:00:00	NQ	Futures	17644.98	17644.98	17627.12	17633.72	3129.0
2023-11-24 02:00:00	NQ	Futures	17633.99	17634.27	17607.35	17616.69	5046.0
2023-11-24 03:00:00	NQ	Futures	17616.69	17638.93	17610.09	17625.48	6140.0
2023-11-24 04:00:00	NQ	Futures	17626.3	17657.06	17624.65	17639.21	8194.0
2023-11-24 05:00:00	NQ	Futures	17639.48	17641.13	17610.92	17632.07	7203.0
2023-11-24 06:00:00	NQ	Futures	17632.07	17637.84	17605.43	17621.08	6720.0
2023-11-24 07:00:00	NQ	Futures	17620.81	17632.62	17614.49	17618.88	6711.0
2023-11-24 08:00:00	NQ	Futures	17619.16	17637.29	17607.35	17633.99	10305.0
2023-11-24 09:00:00	NQ	Futures	17634.27	17637.29	17580.71	17607.62	51146.0
2023-11-24 10:00:00	NQ	Futures	17608.45	17618.33	17558.46	17581.53	50003.0
2023-11-24 11:00:00	NQ	Futures	17581.8	17606.25	17573.84	17599.38	28553.0
2023-11-24 12:00:00	NQ	Futures	17599.11	17604.33	17583.18	17603.5	23314.0
2023-11-24 13:00:00	NQ	Futures	17602.95	17606.25	17589.49	17590.59	4006.0
2023-11-24 00:00:00	YM	Futures	38333.3	38337.7	38326.8	38335.5	485.0
2023-11-24 01:00:00	YM	Futures	38336.6	38340.9	38329.0	38339.9	741.0
2023-11-24 02:00:00	YM	Futures	38339.9	38354.0	38322.5	38354.0	1087.0
2023-11-24 03:00:00	YM	Futures	38354.0	38364.8	38343.1	38350.7	1210.0
2023-11-24 04:00:00	YM	Futures	38350.7	38387.6	38350.7	38375.7	1739.0
2023-11-24 05:00:00	YM	Futures	38375.7	38412.5	38370.2	38409.3	3684.0
2023-11-24 06:00:00	YM	Futures	38410.4	38411.5	38389.8	38411.5	1803.0
2023-11-24 07:00:00	YM	Futures	38411.5	38424.5	38395.2	38397.4	2973.0
2023-11-24 08:00:00	YM	Futures	38397.4	38399.5	38343.1	38369.1	2976.0
2023-11-24 09:00:00	YM	Futures	38369.1	38406.0	38338.8	38396.3	12123.0
2023-11-24 10:00:00	YM	Futures	38396.3	38445.1	38396.3	38431.0	8645.0
2023-11-24 11:00:00	YM	Futures	38429.9	38441.8	38367.0	38377.8	5330.0
2023-11-24 12:00:00	YM	Futures	38378.9	38440.7	38371.3	38432.1	5892.0
2023-11-24 13:00:00	YM	Futures	38432.1	38444.0	38421.2	38437.5	1170.0
2023-11-24 00:00:00	CL	Futures	64.16	64.25	64.07	64.23	1672.0
2023-11-24 01:00:00	CL	Futures	64.23	64.38	64.12	64.26	2141.0
2023-11-24 02:00:00	CL	Futures	64.25	64.28	64.12	64.26	2154.0
2023-11-24 03:00:00	CL	Futures	64.25	64.36	64.12	64.26	4866.0
2023-11-24 04:00:00	CL	Futures	64.25	64.43	64.1	64.3	4477.0
2023-11-24 05:00:00	CL	Futures	64.32	64.45	64.28	64.42	3203.0
2023-11-24 06:00:00	CL	Futures	64.43	64.5	64.36	64.47	2755.0
2023-11-24 07:00:00	CL	Futures	64.48	64.54	64.26	64.28	4514.0

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

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