PREVIEW / futures_1hour / 2009-01-21

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-01-21.parquet
  size:    46 KB
  rows:    1,297

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-21 00:00:00	ES	Futures	770.85	771.8	770.38	771.56	2683.0
2009-01-21 01:00:00	ES	Futures	771.56	771.56	768.95	769.43	3140.0
2009-01-21 02:00:00	ES	Futures	769.43	769.67	763.74	767.06	12759.0
2009-01-21 03:00:00	ES	Futures	767.06	772.04	764.92	769.67	36682.0
2009-01-21 04:00:00	ES	Futures	769.67	771.09	763.97	764.45	24515.0
2009-01-21 05:00:00	ES	Futures	764.69	773.22	763.5	772.51	23520.0
2009-01-21 06:00:00	ES	Futures	772.28	776.07	765.87	770.85	35787.0
2009-01-21 07:00:00	ES	Futures	771.09	772.28	767.06	767.77	23377.0
2009-01-21 08:00:00	ES	Futures	767.77	773.7	767.06	772.51	61721.0
2009-01-21 09:00:00	ES	Futures	772.51	777.97	769.67	776.54	289222.0
2009-01-21 10:00:00	ES	Futures	776.78	778.44	759.47	760.18	500182.0
2009-01-21 11:00:00	ES	Futures	760.18	771.33	760.18	767.53	324549.0
2009-01-21 12:00:00	ES	Futures	767.53	772.51	765.87	770.62	211419.0
2009-01-21 13:00:00	ES	Futures	770.38	775.36	766.35	775.12	245510.0
2009-01-21 14:00:00	ES	Futures	775.36	784.13	772.28	782.95	314556.0
2009-01-21 15:00:00	ES	Futures	783.19	795.52	781.29	793.86	572340.0
2009-01-21 16:00:00	ES	Futures	793.62	799.55	792.67	795.76	142526.0
2009-01-21 17:00:00	ES	Futures	795.99	797.89	795.76	797.89	2917.0
2009-01-21 18:00:00	ES	Futures	797.18	798.6	796.47	796.47	4726.0
2009-01-21 19:00:00	ES	Futures	796.47	796.71	793.62	794.1	7146.0
2009-01-21 20:00:00	ES	Futures	794.33	796.47	793.15	795.99	4595.0
2009-01-21 21:00:00	ES	Futures	795.99	796.94	794.57	796.23	3497.0
2009-01-21 22:00:00	ES	Futures	796.23	797.89	795.05	797.18	3254.0
2009-01-21 23:00:00	ES	Futures	796.94	798.6	796.23	798.37	4320.0
2009-01-21 00:00:00	NQ	Futures	1300.65	1300.93	1298.39	1299.8	72.0
2009-01-21 01:00:00	NQ	Futures	1299.8	1300.65	1296.69	1298.39	156.0
2009-01-21 02:00:00	NQ	Futures	1298.67	1299.23	1288.79	1294.15	593.0
2009-01-21 03:00:00	NQ	Futures	1294.43	1301.49	1291.04	1297.26	1687.0
2009-01-21 04:00:00	NQ	Futures	1297.54	1300.08	1288.79	1290.76	1220.0
2009-01-21 05:00:00	NQ	Futures	1291.04	1303.47	1289.35	1302.9	1091.0
2009-01-21 06:00:00	NQ	Futures	1302.9	1308.27	1294.15	1301.49	2341.0
2009-01-21 07:00:00	NQ	Futures	1300.93	1303.19	1293.3	1295.0	1479.0
2009-01-21 08:00:00	NQ	Futures	1294.72	1303.19	1292.74	1302.06	4510.0
2009-01-21 09:00:00	NQ	Futures	1302.06	1313.35	1298.67	1311.09	39269.0
2009-01-21 10:00:00	NQ	Futures	1311.38	1314.76	1287.94	1288.79	48772.0
2009-01-21 11:00:00	NQ	Futures	1289.07	1301.49	1287.94	1297.26	31593.0
2009-01-21 12:00:00	NQ	Futures	1297.26	1304.88	1294.15	1299.8	24986.0
2009-01-21 13:00:00	NQ	Futures	1299.52	1307.99	1294.15	1307.14	26388.0
2009-01-21 14:00:00	NQ	Futures	1307.42	1318.44	1300.65	1318.44	34268.0
2009-01-21 15:00:00	NQ	Futures	1318.44	1338.48	1315.89	1335.94	65858.0
2009-01-21 16:00:00	NQ	Futures	1336.23	1357.97	1331.14	1349.78	17249.0
2009-01-21 17:00:00	NQ	Futures	1349.78	1351.76	1347.8	1350.34	472.0
2009-01-21 18:00:00	NQ	Futures	1348.09	1351.76	1348.09	1350.06	315.0
2009-01-21 19:00:00	NQ	Futures	1349.21	1349.21	1345.26	1347.52	249.0
2009-01-21 20:00:00	NQ	Futures	1347.52	1350.63	1345.26	1349.78	117.0
2009-01-21 21:00:00	NQ	Futures	1350.06	1351.47	1347.8	1350.06	125.0
2009-01-21 22:00:00	NQ	Futures	1350.91	1353.73	1348.93	1353.17	167.0
2009-01-21 23:00:00	NQ	Futures	1352.04	1355.14	1351.76	1354.3	185.0
2009-01-21 00:00:00	YM	Futures	7295.7	7301.1	7290.2	7295.7	233.0
2009-01-21 01:00:00	YM	Futures	7295.7	7297.5	7274.7	7285.6	225.0

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

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