PREVIEW / futures_1hour / 2023-07-02

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-07-02.parquet
  size:    19 KB
  rows:    420

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-07-02 18:00:00	ES	Futures	4925.28	4932.15	4925.28	4926.11	8746.0
2023-07-02 19:00:00	ES	Futures	4926.38	4929.68	4926.11	4929.4	4587.0
2023-07-02 20:00:00	ES	Futures	4929.68	4931.05	4924.73	4926.11	7196.0
2023-07-02 21:00:00	ES	Futures	4926.11	4929.13	4924.73	4927.21	7246.0
2023-07-02 22:00:00	ES	Futures	4927.21	4928.3	4926.11	4927.75	5148.0
2023-07-02 23:00:00	ES	Futures	4927.75	4929.4	4926.11	4928.58	4145.0
2023-07-02 18:00:00	NQ	Futures	17056.11	17091.16	17055.56	17062.23	5449.0
2023-07-02 19:00:00	NQ	Futures	17062.51	17079.48	17059.73	17077.81	2768.0
2023-07-02 20:00:00	NQ	Futures	17078.09	17085.6	17056.95	17061.4	3675.0
2023-07-02 21:00:00	NQ	Futures	17060.56	17075.86	17055.84	17073.36	3256.0
2023-07-02 22:00:00	NQ	Futures	17073.08	17075.58	17065.29	17069.74	2199.0
2023-07-02 23:00:00	NQ	Futures	17070.02	17082.81	17067.24	17079.76	2361.0
2023-07-02 18:00:00	YM	Futures	37926.7	37970.5	37921.2	37925.6	1445.0
2023-07-02 19:00:00	YM	Futures	37926.7	37949.7	37926.7	37945.3	555.0
2023-07-02 20:00:00	YM	Futures	37946.4	37958.5	37932.2	37938.7	985.0
2023-07-02 21:00:00	YM	Futures	37937.6	37955.2	37926.7	37938.7	834.0
2023-07-02 22:00:00	YM	Futures	37938.7	37944.2	37927.8	37943.1	737.0
2023-07-02 23:00:00	YM	Futures	37943.1	37951.9	37928.9	37948.6	551.0
2023-07-02 18:00:00	CL	Futures	57.17	57.5	57.09	57.1	1920.0
2023-07-02 19:00:00	CL	Futures	57.1	57.16	57.02	57.14	1080.0
2023-07-02 20:00:00	CL	Futures	57.14	57.18	57.09	57.14	1302.0
2023-07-02 21:00:00	CL	Futures	57.13	57.38	57.1	57.27	2799.0
2023-07-02 22:00:00	CL	Futures	57.28	57.39	57.23	57.32	1828.0
2023-07-02 23:00:00	CL	Futures	57.33	57.36	57.26	57.36	1303.0
2023-07-02 18:00:00	GC	Futures	2196.0	2196.0	2194.2	2194.8	1188.0
2023-07-02 19:00:00	GC	Futures	2194.9	2194.9	2193.4	2194.1	1637.0
2023-07-02 20:00:00	GC	Futures	2194.0	2194.8	2192.4	2192.8	1846.0
2023-07-02 21:00:00	GC	Futures	2192.7	2194.8	2191.7	2193.0	4086.0
2023-07-02 22:00:00	GC	Futures	2193.0	2193.6	2189.6	2190.0	3951.0
2023-07-02 23:00:00	GC	Futures	2190.0	2194.6	2189.7	2194.0	2542.0
2023-07-02 18:00:00	ZN	Futures	114.299785	114.347583	114.26792	114.347583	7326.0
2023-07-02 19:00:00	ZN	Futures	114.347583	114.363515	114.220123	114.251988	4832.0
2023-07-02 20:00:00	ZN	Futures	114.236055	114.299785	114.20419	114.220123	15799.0
2023-07-02 21:00:00	ZN	Futures	114.220123	114.347583	114.220123	114.33165	13100.0
2023-07-02 22:00:00	ZN	Futures	114.33165	114.363515	114.299785	114.315718	6029.0
2023-07-02 23:00:00	ZN	Futures	114.315718	114.33165	114.283853	114.299785	4414.0

> showing 36 of 420 rows — these rows as CSV

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