PREVIEW / futures_30min / 2023-07-02

all futures 30-min files

  file:    by_date/futures_30min/2023/2023-07-02.parquet
  size:    27 KB
  rows:    789

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	4928.3	6586.0
2023-07-02 18:30:00	ES	Futures	4928.58	4928.85	4925.56	4926.11	2160.0
2023-07-02 19:00:00	ES	Futures	4926.38	4929.13	4926.11	4928.58	2285.0
2023-07-02 19:30:00	ES	Futures	4928.58	4929.68	4926.93	4929.4	2302.0
2023-07-02 20:00:00	ES	Futures	4929.68	4931.05	4925.56	4925.83	4650.0
2023-07-02 20:30:00	ES	Futures	4925.83	4926.93	4924.73	4926.11	2546.0
2023-07-02 21:00:00	ES	Futures	4926.11	4926.93	4924.73	4925.83	2439.0
2023-07-02 21:30:00	ES	Futures	4926.11	4929.13	4926.11	4927.21	4807.0
2023-07-02 22:00:00	ES	Futures	4927.21	4928.3	4926.38	4927.21	3288.0
2023-07-02 22:30:00	ES	Futures	4927.21	4928.03	4926.11	4927.75	1860.0
2023-07-02 23:00:00	ES	Futures	4927.75	4928.58	4926.11	4928.58	1928.0
2023-07-02 23:30:00	ES	Futures	4928.3	4929.4	4927.48	4928.58	2217.0
2023-07-02 18:00:00	NQ	Futures	17056.11	17091.16	17055.56	17071.13	3963.0
2023-07-02 18:30:00	NQ	Futures	17071.97	17072.25	17056.39	17062.23	1486.0
2023-07-02 19:00:00	NQ	Futures	17062.51	17075.86	17059.73	17073.91	1689.0
2023-07-02 19:30:00	NQ	Futures	17074.19	17079.48	17065.85	17077.81	1079.0
2023-07-02 20:00:00	NQ	Futures	17078.09	17085.6	17059.17	17060.56	2407.0
2023-07-02 20:30:00	NQ	Futures	17061.12	17065.29	17056.95	17061.4	1268.0
2023-07-02 21:00:00	NQ	Futures	17060.56	17066.13	17055.84	17062.51	1353.0
2023-07-02 21:30:00	NQ	Futures	17062.51	17075.86	17062.51	17073.36	1903.0
2023-07-02 22:00:00	NQ	Futures	17073.08	17075.58	17069.19	17071.69	1208.0
2023-07-02 22:30:00	NQ	Futures	17071.41	17071.97	17065.29	17069.74	991.0
2023-07-02 23:00:00	NQ	Futures	17070.02	17078.09	17067.24	17076.97	1174.0
2023-07-02 23:30:00	NQ	Futures	17076.7	17082.81	17076.14	17079.76	1187.0
2023-07-02 18:00:00	YM	Futures	37926.7	37970.5	37925.6	37939.8	1055.0
2023-07-02 18:30:00	YM	Futures	37939.8	37943.1	37921.2	37925.6	390.0
2023-07-02 19:00:00	YM	Futures	37926.7	37944.2	37926.7	37944.2	298.0
2023-07-02 19:30:00	YM	Futures	37943.1	37949.7	37933.3	37945.3	257.0
2023-07-02 20:00:00	YM	Futures	37946.4	37958.5	37933.3	37935.4	609.0
2023-07-02 20:30:00	YM	Futures	37936.5	37942.0	37932.2	37938.7	376.0
2023-07-02 21:00:00	YM	Futures	37937.6	37940.9	37926.7	37936.5	368.0
2023-07-02 21:30:00	YM	Futures	37935.4	37955.2	37935.4	37938.7	466.0
2023-07-02 22:00:00	YM	Futures	37938.7	37942.0	37927.8	37936.5	409.0
2023-07-02 22:30:00	YM	Futures	37936.5	37944.2	37932.2	37943.1	328.0
2023-07-02 23:00:00	YM	Futures	37943.1	37944.2	37928.9	37943.1	220.0
2023-07-02 23:30:00	YM	Futures	37942.0	37951.9	37940.9	37948.6	331.0
2023-07-02 18:00:00	CL	Futures	57.17	57.5	57.09	57.19	1611.0
2023-07-02 18:30:00	CL	Futures	57.17	57.17	57.1	57.1	309.0
2023-07-02 19:00:00	CL	Futures	57.1	57.13	57.02	57.04	535.0
2023-07-02 19:30:00	CL	Futures	57.03	57.16	57.03	57.14	545.0
2023-07-02 20:00:00	CL	Futures	57.14	57.18	57.09	57.09	800.0
2023-07-02 20:30:00	CL	Futures	57.1	57.17	57.1	57.14	502.0
2023-07-02 21:00:00	CL	Futures	57.13	57.28	57.1	57.21	1306.0
2023-07-02 21:30:00	CL	Futures	57.21	57.38	57.2	57.27	1493.0
2023-07-02 22:00:00	CL	Futures	57.28	57.36	57.23	57.35	1034.0
2023-07-02 22:30:00	CL	Futures	57.36	57.39	57.31	57.32	794.0
2023-07-02 23:00:00	CL	Futures	57.33	57.34	57.26	57.29	822.0
2023-07-02 23:30:00	CL	Futures	57.28	57.36	57.27	57.36	481.0
2023-07-02 18:00:00	GC	Futures	2196.0	2196.0	2194.2	2194.2	714.0
2023-07-02 18:30:00	GC	Futures	2194.3	2195.2	2194.2	2194.8	474.0

> showing 50 of 789 rows — these rows as CSV

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