PREVIEW / futures_1hour / 2023-09-24

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-09-24.parquet
  size:    19 KB
  rows:    415

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-09-24 18:00:00	ES	Futures	4741.41	4747.38	4740.59	4743.58	8972.0
2023-09-24 19:00:00	ES	Futures	4743.85	4744.67	4741.68	4743.58	3829.0
2023-09-24 20:00:00	ES	Futures	4743.58	4743.58	4736.52	4740.87	8857.0
2023-09-24 21:00:00	ES	Futures	4740.87	4747.93	4740.87	4743.85	9720.0
2023-09-24 22:00:00	ES	Futures	4744.12	4749.01	4743.31	4748.47	7501.0
2023-09-24 23:00:00	ES	Futures	4748.47	4751.19	4747.93	4749.56	6242.0
2023-09-24 18:00:00	NQ	Futures	16348.29	16386.47	16348.29	16370.81	4357.0
2023-09-24 19:00:00	NQ	Futures	16371.36	16377.13	16360.92	16368.34	2601.0
2023-09-24 20:00:00	NQ	Futures	16367.51	16368.34	16334.28	16357.08	5447.0
2023-09-24 21:00:00	NQ	Futures	16356.8	16393.06	16356.25	16372.73	6541.0
2023-09-24 22:00:00	NQ	Futures	16373.56	16391.41	16371.08	16388.11	3309.0
2023-09-24 23:00:00	NQ	Futures	16387.56	16400.47	16385.64	16394.16	3110.0
2023-09-24 18:00:00	YM	Futures	37175.9	37196.5	37168.3	37182.4	982.0
2023-09-24 19:00:00	YM	Futures	37180.2	37184.6	37169.4	37178.0	549.0
2023-09-24 20:00:00	YM	Futures	37180.2	37182.4	37133.6	37165.0	1026.0
2023-09-24 21:00:00	YM	Futures	37163.9	37203.0	37162.9	37180.2	913.0
2023-09-24 22:00:00	YM	Futures	37180.2	37213.8	37177.0	37209.5	591.0
2023-09-24 23:00:00	YM	Futures	37210.6	37224.7	37207.3	37213.8	559.0
2023-09-24 18:00:00	CL	Futures	74.82	74.82	74.51	74.71	1738.0
2023-09-24 19:00:00	CL	Futures	74.71	74.9	74.68	74.89	866.0
2023-09-24 20:00:00	CL	Futures	74.89	74.89	74.57	74.74	1907.0
2023-09-24 21:00:00	CL	Futures	74.74	74.88	74.49	74.49	3200.0
2023-09-24 22:00:00	CL	Futures	74.49	74.63	74.47	74.56	2100.0
2023-09-24 23:00:00	CL	Futures	74.57	74.63	74.43	74.49	1556.0
2023-09-24 18:00:00	GC	Futures	2172.2	2173.7	2172.0	2172.7	1257.0
2023-09-24 19:00:00	GC	Futures	2172.6	2172.9	2171.4	2171.7	1526.0
2023-09-24 20:00:00	GC	Futures	2171.8	2172.2	2169.9	2171.8	1961.0
2023-09-24 21:00:00	GC	Futures	2171.9	2172.5	2169.6	2170.5	2701.0
2023-09-24 22:00:00	GC	Futures	2170.4	2170.5	2169.1	2170.3	1332.0
2023-09-24 23:00:00	GC	Futures	2170.4	2170.9	2169.4	2170.3	1399.0
2023-09-24 18:00:00	ZN	Futures	110.434195	110.497672	110.434195	110.450064	9538.0
2023-09-24 19:00:00	ZN	Futures	110.450064	110.497672	110.402456	110.402456	5676.0
2023-09-24 20:00:00	ZN	Futures	110.418325	110.418325	110.307241	110.338979	21976.0
2023-09-24 21:00:00	ZN	Futures	110.338979	110.370718	110.275502	110.32311	12036.0
2023-09-24 22:00:00	ZN	Futures	110.32311	110.338979	110.275502	110.291371	8459.0
2023-09-24 23:00:00	ZN	Futures	110.291371	110.338979	110.275502	110.32311	7896.0

> showing 36 of 415 rows — these rows as CSV

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