PREVIEW / futures_1hour / 2008-11-19

all futures 1-hour files

  file:    by_date/futures_1hour/2008/2008-11-19.parquet
  size:    44 KB
  rows:    1,221

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
2008-11-19 00:00:00	ES	Futures	813.6	816.44	813.36	816.44	2929.0
2008-11-19 01:00:00	ES	Futures	816.44	819.75	816.2	818.81	5109.0
2008-11-19 02:00:00	ES	Futures	818.81	819.04	813.36	815.02	9925.0
2008-11-19 03:00:00	ES	Futures	814.78	815.02	806.03	807.45	22773.0
2008-11-19 04:00:00	ES	Futures	807.69	808.87	802.72	806.98	24780.0
2008-11-19 05:00:00	ES	Futures	806.74	813.13	805.79	811.47	13530.0
2008-11-19 06:00:00	ES	Futures	811.47	811.47	805.56	809.82	11562.0
2008-11-19 07:00:00	ES	Futures	809.58	812.18	804.14	804.61	34248.0
2008-11-19 08:00:00	ES	Futures	804.37	810.29	799.64	801.77	70419.0
2008-11-19 09:00:00	ES	Futures	801.77	817.62	801.06	806.27	334657.0
2008-11-19 10:00:00	ES	Futures	806.27	818.33	793.49	794.2	473798.0
2008-11-19 11:00:00	ES	Futures	794.43	798.93	783.78	788.99	411042.0
2008-11-19 12:00:00	ES	Futures	789.23	790.41	781.42	788.52	286489.0
2008-11-19 13:00:00	ES	Futures	788.52	793.72	778.58	787.81	281404.0
2008-11-19 14:00:00	ES	Futures	787.81	792.3	775.26	788.99	443584.0
2008-11-19 15:00:00	ES	Futures	788.75	791.83	761.3	763.67	761348.0
2008-11-19 16:00:00	ES	Futures	763.67	769.58	763.43	765.32	198587.0
2008-11-19 17:00:00	ES	Futures	765.32	768.4	765.09	767.93	2506.0
2008-11-19 18:00:00	ES	Futures	766.51	769.58	764.38	768.64	8063.0
2008-11-19 19:00:00	ES	Futures	768.87	769.82	763.91	768.4	7613.0
2008-11-19 20:00:00	ES	Futures	768.4	771.95	767.69	769.82	6370.0
2008-11-19 21:00:00	ES	Futures	770.06	771.24	768.87	770.29	4842.0
2008-11-19 22:00:00	ES	Futures	770.53	770.53	768.64	768.64	4998.0
2008-11-19 23:00:00	ES	Futures	768.64	769.11	759.65	760.12	9823.0
2008-11-19 00:00:00	NQ	Futures	1316.91	1319.18	1315.21	1318.33	301.0
2008-11-19 01:00:00	NQ	Futures	1318.89	1326.53	1318.89	1324.55	201.0
2008-11-19 02:00:00	NQ	Futures	1324.55	1324.83	1315.21	1318.04	378.0
2008-11-19 03:00:00	NQ	Futures	1315.78	1315.78	1304.18	1306.16	1741.0
2008-11-19 04:00:00	NQ	Futures	1305.88	1307.57	1298.8	1303.9	1164.0
2008-11-19 05:00:00	NQ	Futures	1303.9	1315.78	1302.48	1314.08	778.0
2008-11-19 06:00:00	NQ	Futures	1313.8	1313.8	1302.76	1307.57	1555.0
2008-11-19 07:00:00	NQ	Futures	1306.72	1312.38	1301.35	1301.35	2715.0
2008-11-19 08:00:00	NQ	Futures	1301.63	1310.4	1294.84	1299.37	6410.0
2008-11-19 09:00:00	NQ	Futures	1299.37	1317.76	1296.82	1307.86	54932.0
2008-11-19 10:00:00	NQ	Futures	1307.86	1323.99	1288.9	1291.16	68532.0
2008-11-19 11:00:00	NQ	Futures	1291.16	1299.37	1268.24	1273.34	63032.0
2008-11-19 12:00:00	NQ	Futures	1273.34	1277.3	1264.28	1271.07	44791.0
2008-11-19 13:00:00	NQ	Futures	1271.07	1279.28	1257.77	1271.64	37185.0
2008-11-19 14:00:00	NQ	Futures	1271.64	1278.71	1253.24	1274.47	62139.0
2008-11-19 15:00:00	NQ	Futures	1274.47	1278.99	1231.74	1232.02	99374.0
2008-11-19 16:00:00	NQ	Futures	1232.02	1237.96	1225.51	1231.74	21643.0
2008-11-19 17:00:00	NQ	Futures	1232.31	1234.85	1232.02	1233.44	346.0
2008-11-19 18:00:00	NQ	Futures	1233.44	1238.25	1230.89	1234.0	345.0
2008-11-19 19:00:00	NQ	Futures	1234.85	1237.12	1228.63	1235.98	351.0
2008-11-19 20:00:00	NQ	Futures	1237.12	1242.21	1236.83	1239.95	210.0
2008-11-19 21:00:00	NQ	Futures	1240.51	1241.36	1238.81	1240.23	71.0
2008-11-19 22:00:00	NQ	Futures	1241.08	1241.08	1237.12	1237.12	84.0
2008-11-19 23:00:00	NQ	Futures	1237.4	1237.4	1222.97	1222.97	442.0
2008-11-19 00:00:00	YM	Futures	7658.1	7680.0	7653.6	7676.3	275.0
2008-11-19 01:00:00	YM	Futures	7678.2	7707.3	7676.3	7701.8	338.0

> showing 50 of 1,221 rows — these rows as CSV

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