PREVIEW / futures_30min / 2023-07-19

all futures 30-min files

  file:    by_date/futures_30min/2023/2023-07-19.parquet
  size:    108 KB
  rows:    3,851

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-19 00:00:00	ES	Futures	5035.91	5036.19	5035.36	5035.91	1308.0
2023-07-19 00:30:00	ES	Futures	5036.19	5036.19	5035.09	5035.64	1455.0
2023-07-19 01:00:00	ES	Futures	5035.64	5036.74	5035.36	5036.19	3252.0
2023-07-19 01:30:00	ES	Futures	5036.19	5037.56	5035.64	5035.91	3905.0
2023-07-19 02:00:00	ES	Futures	5036.19	5040.58	5034.81	5039.21	11468.0
2023-07-19 02:30:00	ES	Futures	5039.21	5040.58	5037.01	5040.3	5101.0
2023-07-19 03:00:00	ES	Futures	5040.58	5043.05	5039.21	5039.48	13019.0
2023-07-19 03:30:00	ES	Futures	5039.48	5039.48	5034.81	5035.64	9493.0
2023-07-19 04:00:00	ES	Futures	5035.36	5040.3	5034.54	5039.21	8419.0
2023-07-19 04:30:00	ES	Futures	5039.21	5041.4	5038.66	5040.85	5657.0
2023-07-19 05:00:00	ES	Futures	5040.85	5041.4	5038.93	5040.3	5760.0
2023-07-19 05:30:00	ES	Futures	5040.03	5042.23	5039.21	5040.58	6552.0
2023-07-19 06:00:00	ES	Futures	5040.3	5040.85	5038.66	5039.48	5336.0
2023-07-19 06:30:00	ES	Futures	5039.48	5040.85	5038.11	5040.85	5471.0
2023-07-19 07:00:00	ES	Futures	5040.85	5040.85	5033.99	5038.66	13214.0
2023-07-19 07:30:00	ES	Futures	5038.38	5038.66	5033.99	5036.74	8601.0
2023-07-19 08:00:00	ES	Futures	5037.01	5039.21	5036.19	5037.01	10497.0
2023-07-19 08:30:00	ES	Futures	5037.01	5040.58	5035.91	5039.48	15342.0
2023-07-19 09:00:00	ES	Futures	5039.21	5046.34	5038.66	5045.79	24889.0
2023-07-19 09:30:00	ES	Futures	5045.79	5058.15	5045.52	5056.5	168328.0
2023-07-19 10:00:00	ES	Futures	5056.77	5060.34	5054.03	5054.3	100131.0
2023-07-19 10:30:00	ES	Futures	5054.3	5058.42	5040.85	5048.54	128559.0
2023-07-19 11:00:00	ES	Futures	5048.26	5056.23	5046.62	5054.03	94947.0
2023-07-19 11:30:00	ES	Futures	5054.03	5058.15	5053.48	5056.5	64996.0
2023-07-19 12:00:00	ES	Futures	5056.5	5061.17	5046.34	5049.36	135950.0
2023-07-19 12:30:00	ES	Futures	5049.36	5049.36	5042.5	5049.36	86539.0
2023-07-19 13:00:00	ES	Futures	5049.36	5049.91	5041.4	5046.89	59739.0
2023-07-19 13:30:00	ES	Futures	5046.62	5049.36	5042.77	5046.34	45625.0
2023-07-19 14:00:00	ES	Futures	5046.07	5047.44	5038.38	5042.23	69976.0
2023-07-19 14:30:00	ES	Futures	5042.23	5050.74	5041.95	5049.64	54572.0
2023-07-19 15:00:00	ES	Futures	5049.64	5057.32	5049.64	5054.58	58042.0
2023-07-19 15:30:00	ES	Futures	5054.3	5054.58	5045.52	5046.62	134911.0
2023-07-19 16:00:00	ES	Futures	5046.34	5048.81	5041.4	5045.25	70315.0
2023-07-19 16:30:00	ES	Futures	5045.25	5047.72	5044.7	5046.34	5820.0
2023-07-19 18:00:00	ES	Futures	5043.6	5044.7	5030.97	5033.44	9851.0
2023-07-19 18:30:00	ES	Futures	5033.44	5035.09	5030.15	5032.07	5373.0
2023-07-19 19:00:00	ES	Futures	5031.79	5035.09	5030.97	5034.81	3374.0
2023-07-19 19:30:00	ES	Futures	5034.81	5034.81	5032.07	5034.26	2585.0
2023-07-19 20:00:00	ES	Futures	5034.26	5038.38	5033.99	5037.01	4185.0
2023-07-19 20:30:00	ES	Futures	5037.28	5038.93	5036.74	5038.11	2320.0
2023-07-19 21:00:00	ES	Futures	5038.11	5041.13	5037.56	5040.3	3521.0
2023-07-19 21:30:00	ES	Futures	5040.3	5041.68	5039.48	5040.03	4514.0
2023-07-19 22:00:00	ES	Futures	5040.03	5040.85	5037.28	5037.83	3919.0
2023-07-19 22:30:00	ES	Futures	5038.11	5039.21	5036.46	5038.93	2563.0
2023-07-19 23:00:00	ES	Futures	5038.66	5039.48	5037.56	5039.21	1733.0
2023-07-19 23:30:00	ES	Futures	5038.93	5040.03	5038.11	5039.48	1842.0
2023-07-19 00:00:00	NQ	Futures	17759.51	17759.79	17755.34	17756.73	587.0
2023-07-19 00:30:00	NQ	Futures	17757.28	17758.67	17752.55	17752.55	702.0
2023-07-19 01:00:00	NQ	Futures	17752.83	17759.79	17752.55	17757.0	1314.0
2023-07-19 01:30:00	NQ	Futures	17757.28	17763.96	17755.34	17759.51	1744.0

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

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