PREVIEW / futures_1hour / 2009-01-29

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-01-29.parquet
  size:    45 KB
  rows:    1,295

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
2009-01-29 00:00:00	ES	Futures	821.61	824.46	821.61	823.51	2354.0
2009-01-29 01:00:00	ES	Futures	823.51	824.46	822.32	824.22	2053.0
2009-01-29 02:00:00	ES	Futures	824.22	824.46	818.53	818.53	10584.0
2009-01-29 03:00:00	ES	Futures	818.53	820.66	815.68	816.87	25481.0
2009-01-29 04:00:00	ES	Futures	817.1	818.29	812.12	813.78	24104.0
2009-01-29 05:00:00	ES	Futures	813.78	819.24	813.78	817.82	15368.0
2009-01-29 06:00:00	ES	Futures	817.82	818.76	814.49	818.05	15095.0
2009-01-29 07:00:00	ES	Futures	818.05	822.08	817.82	818.05	26297.0
2009-01-29 08:00:00	ES	Futures	818.05	818.76	814.26	816.63	53550.0
2009-01-29 09:00:00	ES	Futures	816.63	816.87	808.8	810.46	236385.0
2009-01-29 10:00:00	ES	Futures	810.23	815.21	806.9	814.49	319823.0
2009-01-29 11:00:00	ES	Futures	814.26	814.97	807.62	809.04	191866.0
2009-01-29 12:00:00	ES	Futures	808.8	809.28	801.69	802.64	212609.0
2009-01-29 13:00:00	ES	Futures	802.4	804.77	799.55	801.45	227842.0
2009-01-29 14:00:00	ES	Futures	801.45	806.9	800.74	803.11	211346.0
2009-01-29 15:00:00	ES	Futures	803.11	806.43	797.18	798.13	344811.0
2009-01-29 16:00:00	ES	Futures	798.13	801.21	797.18	800.03	104919.0
2009-01-29 17:00:00	ES	Futures	800.03	800.74	798.84	799.31	1259.0
2009-01-29 18:00:00	ES	Futures	799.55	802.4	799.31	801.69	2976.0
2009-01-29 19:00:00	ES	Futures	801.69	801.92	797.65	800.5	4927.0
2009-01-29 20:00:00	ES	Futures	800.5	801.92	799.79	801.45	2773.0
2009-01-29 21:00:00	ES	Futures	801.69	802.87	800.5	801.45	2869.0
2009-01-29 22:00:00	ES	Futures	801.69	802.4	800.74	801.69	2390.0
2009-01-29 23:00:00	ES	Futures	801.92	804.53	801.69	804.06	3663.0
2009-01-29 00:00:00	NQ	Futures	1381.69	1385.64	1381.69	1383.95	104.0
2009-01-29 01:00:00	NQ	Futures	1383.67	1385.64	1383.1	1384.79	67.0
2009-01-29 02:00:00	NQ	Futures	1385.08	1385.92	1376.89	1377.45	788.0
2009-01-29 03:00:00	NQ	Futures	1377.17	1380.56	1372.93	1376.61	1792.0
2009-01-29 04:00:00	NQ	Futures	1377.45	1379.99	1370.96	1373.78	1533.0
2009-01-29 05:00:00	NQ	Futures	1373.78	1381.97	1373.5	1377.74	1159.0
2009-01-29 06:00:00	NQ	Futures	1378.02	1378.86	1372.65	1378.86	925.0
2009-01-29 07:00:00	NQ	Futures	1378.58	1389.31	1378.58	1381.69	2844.0
2009-01-29 08:00:00	NQ	Futures	1381.69	1382.82	1375.76	1378.58	4319.0
2009-01-29 09:00:00	NQ	Futures	1378.3	1378.86	1365.88	1369.26	38660.0
2009-01-29 10:00:00	NQ	Futures	1368.98	1376.89	1364.18	1375.76	44083.0
2009-01-29 11:00:00	NQ	Futures	1375.76	1376.32	1367.29	1369.55	24338.0
2009-01-29 12:00:00	NQ	Futures	1369.26	1369.83	1355.99	1356.84	30577.0
2009-01-29 13:00:00	NQ	Futures	1356.84	1359.95	1350.91	1355.99	38429.0
2009-01-29 14:00:00	NQ	Futures	1355.99	1366.16	1354.86	1360.51	26801.0
2009-01-29 15:00:00	NQ	Futures	1360.51	1366.16	1351.76	1355.99	40637.0
2009-01-29 16:00:00	NQ	Futures	1356.27	1364.46	1355.43	1361.64	10642.0
2009-01-29 17:00:00	NQ	Futures	1361.64	1363.9	1357.69	1357.69	315.0
2009-01-29 18:00:00	NQ	Futures	1358.25	1362.77	1357.69	1361.07	361.0
2009-01-29 19:00:00	NQ	Futures	1361.07	1361.07	1356.27	1359.38	193.0
2009-01-29 20:00:00	NQ	Futures	1359.66	1362.2	1359.66	1362.2	34.0
2009-01-29 21:00:00	NQ	Futures	1361.92	1362.49	1360.23	1361.92	41.0
2009-01-29 22:00:00	NQ	Futures	1360.79	1362.77	1360.79	1362.2	28.0
2009-01-29 23:00:00	NQ	Futures	1361.07	1365.88	1361.07	1365.88	119.0
2009-01-29 00:00:00	YM	Futures	7544.4	7566.3	7544.4	7557.2	283.0
2009-01-29 01:00:00	YM	Futures	7557.2	7566.3	7552.6	7565.4	243.0

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

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