PREVIEW / futures_1hour / 2008-10-27

all futures 1-hour files

  file:    by_date/futures_1hour/2008/2008-10-27.parquet
  size:    46 KB
  rows:    1,272

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-10-27 00:00:00	ES	Futures	821.17	822.59	817.39	817.62	3395.0
2008-10-27 01:00:00	ES	Futures	817.62	817.62	804.61	807.21	9184.0
2008-10-27 02:00:00	ES	Futures	806.98	811.23	801.53	801.77	7093.0
2008-10-27 03:00:00	ES	Futures	802.01	803.9	781.18	784.97	30679.0
2008-10-27 04:00:00	ES	Futures	784.73	791.59	780.94	786.15	39370.0
2008-10-27 05:00:00	ES	Futures	786.15	794.67	785.91	790.65	30737.0
2008-10-27 06:00:00	ES	Futures	790.41	798.46	789.46	790.17	28019.0
2008-10-27 07:00:00	ES	Futures	790.17	803.43	790.17	797.98	36092.0
2008-10-27 08:00:00	ES	Futures	797.98	814.07	794.43	812.89	57717.0
2008-10-27 09:00:00	ES	Futures	812.42	825.91	806.5	823.3	362737.0
2008-10-27 10:00:00	ES	Futures	823.3	834.9	812.65	825.2	423682.0
2008-10-27 11:00:00	ES	Futures	825.43	834.43	817.15	822.59	285918.0
2008-10-27 12:00:00	ES	Futures	822.36	839.4	822.12	838.45	303041.0
2008-10-27 13:00:00	ES	Futures	838.45	846.26	831.11	837.74	267028.0
2008-10-27 14:00:00	ES	Futures	837.74	839.63	819.04	819.99	323055.0
2008-10-27 15:00:00	ES	Futures	820.23	830.64	798.93	800.82	486096.0
2008-10-27 16:00:00	ES	Futures	800.82	801.3	789.46	792.78	174858.0
2008-10-27 17:00:00	ES	Futures	792.78	793.01	789.94	791.12	4117.0
2008-10-27 18:00:00	ES	Futures	791.12	791.12	783.07	785.68	10519.0
2008-10-27 19:00:00	ES	Futures	785.44	792.3	785.2	791.59	7071.0
2008-10-27 20:00:00	ES	Futures	791.83	798.22	789.94	793.72	14387.0
2008-10-27 21:00:00	ES	Futures	793.72	794.67	788.52	793.96	7606.0
2008-10-27 22:00:00	ES	Futures	793.96	799.17	791.36	794.67	8616.0
2008-10-27 23:00:00	ES	Futures	794.91	800.82	793.25	799.17	9704.0
2008-10-27 00:00:00	NQ	Futures	1351.43	1354.83	1346.91	1346.91	105.0
2008-10-27 01:00:00	NQ	Futures	1346.62	1346.62	1326.82	1329.93	436.0
2008-10-27 02:00:00	NQ	Futures	1330.21	1335.59	1323.14	1323.14	507.0
2008-10-27 03:00:00	NQ	Futures	1323.7	1324.55	1286.63	1292.01	1813.0
2008-10-27 04:00:00	NQ	Futures	1292.58	1312.95	1290.88	1300.5	2158.0
2008-10-27 05:00:00	NQ	Futures	1301.91	1316.91	1299.08	1303.9	1440.0
2008-10-27 06:00:00	NQ	Futures	1303.33	1316.06	1299.37	1301.07	2327.0
2008-10-27 07:00:00	NQ	Futures	1303.05	1327.1	1303.05	1321.16	2298.0
2008-10-27 08:00:00	NQ	Futures	1321.16	1349.17	1318.61	1347.19	5877.0
2008-10-27 09:00:00	NQ	Futures	1346.91	1356.53	1329.08	1351.43	54012.0
2008-10-27 10:00:00	NQ	Futures	1352.0	1368.98	1327.38	1347.47	66385.0
2008-10-27 11:00:00	NQ	Futures	1347.47	1361.9	1339.27	1348.6	40431.0
2008-10-27 12:00:00	NQ	Futures	1348.32	1377.75	1348.04	1376.05	42347.0
2008-10-27 13:00:00	NQ	Futures	1376.05	1390.48	1365.02	1381.43	40110.0
2008-10-27 14:00:00	NQ	Futures	1381.71	1383.41	1349.45	1350.3	40606.0
2008-10-27 15:00:00	NQ	Futures	1350.58	1370.96	1316.63	1319.74	73684.0
2008-10-27 16:00:00	NQ	Futures	1319.46	1324.55	1312.1	1312.67	18199.0
2008-10-27 17:00:00	NQ	Futures	1312.95	1315.21	1310.12	1312.95	331.0
2008-10-27 18:00:00	NQ	Futures	1312.95	1313.8	1303.05	1306.16	1141.0
2008-10-27 19:00:00	NQ	Futures	1306.16	1314.08	1306.16	1314.08	276.0
2008-10-27 20:00:00	NQ	Futures	1314.08	1325.12	1312.1	1320.31	713.0
2008-10-27 21:00:00	NQ	Futures	1320.02	1320.59	1311.25	1318.61	377.0
2008-10-27 22:00:00	NQ	Futures	1317.48	1327.1	1315.5	1319.74	296.0
2008-10-27 23:00:00	NQ	Futures	1320.87	1328.23	1317.48	1325.97	184.0
2008-10-27 00:00:00	YM	Futures	7525.4	7548.1	7499.9	7501.7	539.0
2008-10-27 01:00:00	YM	Futures	7501.7	7501.7	7382.6	7413.5	1849.0

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

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