PREVIEW / futures_1hour / 2023-01-02

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-01-02.parquet
  size:    27 KB
  rows:    692

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-01-02 18:00:00	ES	Futures	4356.27	4361.86	4326.91	4329.99	25020.0
2023-01-02 19:00:00	ES	Futures	4329.71	4330.27	4312.65	4313.49	19194.0
2023-01-02 20:00:00	ES	Futures	4313.21	4313.77	4297.83	4309.58	26829.0
2023-01-02 21:00:00	ES	Futures	4309.86	4321.04	4306.78	4318.8	14261.0
2023-01-02 22:00:00	ES	Futures	4318.52	4325.79	4316.57	4324.39	9970.0
2023-01-02 23:00:00	ES	Futures	4324.67	4325.79	4321.04	4321.6	4290.0
2023-01-02 18:00:00	NQ	Futures	12657.14	12688.44	12560.41	12577.2	9720.0
2023-01-02 19:00:00	NQ	Futures	12577.2	12578.9	12512.33	12514.61	6935.0
2023-01-02 20:00:00	NQ	Futures	12514.89	12514.89	12463.12	12501.24	9181.0
2023-01-02 21:00:00	NQ	Futures	12500.95	12536.52	12489.86	12528.55	5320.0
2023-01-02 22:00:00	NQ	Futures	12528.55	12557.57	12523.71	12555.01	4245.0
2023-01-02 23:00:00	NQ	Futures	12555.86	12560.41	12541.64	12542.77	2602.0
2023-01-02 18:00:00	YM	Futures	37308.4	37383.0	37162.4	37183.6	3445.0
2023-01-02 19:00:00	YM	Futures	37184.7	37186.9	37078.9	37085.5	2153.0
2023-01-02 20:00:00	YM	Futures	37082.2	37082.2	36956.3	37036.5	3175.0
2023-01-02 21:00:00	YM	Futures	37035.4	37125.7	37017.6	37105.6	1686.0
2023-01-02 22:00:00	YM	Futures	37110.1	37152.4	37090.0	37141.3	1219.0
2023-01-02 23:00:00	YM	Futures	37143.5	37149.0	37115.6	37124.5	469.0
2023-01-02 18:00:00	CL	Futures	65.94	66.11	65.61	65.83	2096.0
2023-01-02 19:00:00	CL	Futures	65.84	65.91	65.64	65.68	1181.0
2023-01-02 20:00:00	CL	Futures	65.68	65.78	64.96	65.14	6227.0
2023-01-02 21:00:00	CL	Futures	65.14	65.43	64.92	65.43	3226.0
2023-01-02 22:00:00	CL	Futures	65.43	65.59	65.31	65.5	1989.0
2023-01-02 23:00:00	CL	Futures	65.51	65.53	65.37	65.38	895.0
2023-01-02 18:00:00	GC	Futures	2145.6	2152.8	2145.0	2150.2	4830.0
2023-01-02 19:00:00	GC	Futures	2150.2	2153.3	2149.4	2151.7	3387.0
2023-01-02 20:00:00	GC	Futures	2151.5	2154.2	2147.0	2149.0	5897.0
2023-01-02 21:00:00	GC	Futures	2149.1	2162.7	2148.7	2160.9	8550.0
2023-01-02 22:00:00	GC	Futures	2160.9	2166.2	2160.9	2164.1	6417.0
2023-01-02 23:00:00	GC	Futures	2164.1	2165.6	2163.1	2163.2	3196.0
2023-01-02 18:00:00	ZN	Futures	115.954301	116.03478	115.777247	115.889918	30561.0
2023-01-02 19:00:00	ZN	Futures	115.889918	115.954301	115.873822	115.954301	11458.0
2023-01-02 20:00:00	ZN	Futures	115.938205	115.986493	115.889918	115.986493	6197.0
2023-01-02 21:00:00	ZN	Futures	115.970397	116.03478	115.954301	116.018684	6770.0
2023-01-02 22:00:00	ZN	Futures	116.018684	116.066972	115.986493	116.03478	8324.0
2023-01-02 23:00:00	ZN	Futures	116.03478	116.050876	116.002588	116.050876	5063.0

> showing 36 of 692 rows — these rows as CSV

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