PREVIEW / futures_30min / 2023-07-31

all futures 30-min files

  file:    by_date/futures_30min/2023/2023-07-31.parquet
  size:    107 KB
  rows:    3,832

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-31 00:00:00	ES	Futures	5048.81	5049.36	5045.79	5048.54	3429.0
2023-07-31 00:30:00	ES	Futures	5048.54	5049.91	5046.89	5048.81	1748.0
2023-07-31 01:00:00	ES	Futures	5048.81	5052.11	5047.17	5051.01	3973.0
2023-07-31 01:30:00	ES	Futures	5051.01	5054.3	5050.46	5052.66	3431.0
2023-07-31 02:00:00	ES	Futures	5052.93	5058.97	5051.01	5057.87	6321.0
2023-07-31 02:30:00	ES	Futures	5057.87	5057.87	5052.38	5054.3	4154.0
2023-07-31 03:00:00	ES	Futures	5054.03	5059.25	5052.38	5058.97	10822.0
2023-07-31 03:30:00	ES	Futures	5058.97	5060.34	5051.83	5054.85	7990.0
2023-07-31 04:00:00	ES	Futures	5055.13	5059.79	5055.13	5058.15	6268.0
2023-07-31 04:30:00	ES	Futures	5058.15	5063.09	5058.15	5062.81	7288.0
2023-07-31 05:00:00	ES	Futures	5062.54	5064.19	5061.72	5062.54	5467.0
2023-07-31 05:30:00	ES	Futures	5062.26	5062.54	5058.42	5060.07	4976.0
2023-07-31 06:00:00	ES	Futures	5060.07	5061.99	5058.7	5061.44	4297.0
2023-07-31 06:30:00	ES	Futures	5061.44	5063.64	5060.62	5063.64	4616.0
2023-07-31 07:00:00	ES	Futures	5063.36	5066.11	5062.81	5065.28	6657.0
2023-07-31 07:30:00	ES	Futures	5065.28	5066.66	5063.09	5066.66	7294.0
2023-07-31 08:00:00	ES	Futures	5066.66	5067.21	5064.46	5066.38	10908.0
2023-07-31 08:30:00	ES	Futures	5066.38	5071.6	5065.83	5070.23	13402.0
2023-07-31 09:00:00	ES	Futures	5070.23	5070.23	5062.81	5063.36	19503.0
2023-07-31 09:30:00	ES	Futures	5063.64	5072.15	5052.93	5058.97	166182.0
2023-07-31 10:00:00	ES	Futures	5058.7	5067.21	5055.13	5066.93	77592.0
2023-07-31 10:30:00	ES	Futures	5066.93	5068.3	5060.89	5064.74	67577.0
2023-07-31 11:00:00	ES	Futures	5065.01	5068.58	5060.34	5062.26	49098.0
2023-07-31 11:30:00	ES	Futures	5062.54	5063.09	5055.4	5058.15	68192.0
2023-07-31 12:00:00	ES	Futures	5058.42	5061.72	5056.77	5061.17	32417.0
2023-07-31 12:30:00	ES	Futures	5061.17	5061.72	5053.48	5054.85	35518.0
2023-07-31 13:00:00	ES	Futures	5054.85	5059.25	5050.46	5054.85	50147.0
2023-07-31 13:30:00	ES	Futures	5054.58	5061.17	5054.3	5057.87	30653.0
2023-07-31 14:00:00	ES	Futures	5057.87	5059.52	5053.48	5055.68	34735.0
2023-07-31 14:30:00	ES	Futures	5055.68	5061.17	5054.3	5059.79	34615.0
2023-07-31 15:00:00	ES	Futures	5059.79	5060.34	5052.93	5055.68	46799.0
2023-07-31 15:30:00	ES	Futures	5055.68	5069.13	5048.54	5068.58	231958.0
2023-07-31 16:00:00	ES	Futures	5068.58	5071.32	5066.66	5069.68	88308.0
2023-07-31 16:30:00	ES	Futures	5069.4	5070.5	5068.85	5069.95	26062.0
2023-07-31 18:00:00	ES	Futures	5070.5	5071.87	5069.13	5069.4	2398.0
2023-07-31 18:30:00	ES	Futures	5069.13	5069.13	5067.48	5068.03	1969.0
2023-07-31 19:00:00	ES	Futures	5068.03	5068.58	5066.93	5067.21	1529.0
2023-07-31 19:30:00	ES	Futures	5066.93	5068.85	5066.93	5068.03	1180.0
2023-07-31 20:00:00	ES	Futures	5068.3	5070.23	5067.48	5068.58	3661.0
2023-07-31 20:30:00	ES	Futures	5068.3	5071.87	5067.48	5071.87	2860.0
2023-07-31 21:00:00	ES	Futures	5071.87	5072.97	5069.95	5072.15	3897.0
2023-07-31 21:30:00	ES	Futures	5072.15	5074.89	5070.77	5073.52	5780.0
2023-07-31 22:00:00	ES	Futures	5073.52	5073.52	5070.77	5072.7	3047.0
2023-07-31 22:30:00	ES	Futures	5072.97	5073.25	5070.23	5070.77	2372.0
2023-07-31 23:00:00	ES	Futures	5070.77	5071.6	5070.23	5070.5	1521.0
2023-07-31 23:30:00	ES	Futures	5070.5	5070.77	5069.4	5069.95	2131.0
2023-07-31 00:00:00	NQ	Futures	17585.4	17591.24	17568.15	17582.06	2401.0
2023-07-31 00:30:00	NQ	Futures	17583.45	17589.01	17572.6	17582.89	1502.0
2023-07-31 01:00:00	NQ	Futures	17582.89	17597.91	17574.55	17592.63	2326.0
2023-07-31 01:30:00	NQ	Futures	17592.91	17610.43	17591.24	17602.36	2301.0

> showing 50 of 3,832 rows — these rows as CSV

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