PREVIEW / futures_1hour / 2009-01-14

all futures 1-hour files

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

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-14 00:00:00	ES	Futures	828.25	829.67	828.01	828.96	988.0
2009-01-14 01:00:00	ES	Futures	828.73	829.44	827.54	828.73	1733.0
2009-01-14 02:00:00	ES	Futures	828.73	829.2	826.12	828.25	4687.0
2009-01-14 03:00:00	ES	Futures	828.25	828.49	821.14	822.32	16886.0
2009-01-14 04:00:00	ES	Futures	822.08	823.27	817.34	818.53	18861.0
2009-01-14 05:00:00	ES	Futures	818.53	821.14	816.39	820.66	19798.0
2009-01-14 06:00:00	ES	Futures	820.66	821.14	814.26	817.1	17669.0
2009-01-14 07:00:00	ES	Futures	817.1	818.05	815.44	815.44	15751.0
2009-01-14 08:00:00	ES	Futures	815.68	816.15	806.67	808.33	110990.0
2009-01-14 09:00:00	ES	Futures	808.33	809.51	800.5	802.16	328091.0
2009-01-14 10:00:00	ES	Futures	802.16	804.3	790.78	793.62	565909.0
2009-01-14 11:00:00	ES	Futures	793.62	797.89	789.83	796.71	303485.0
2009-01-14 12:00:00	ES	Futures	796.47	798.84	792.67	798.13	212399.0
2009-01-14 13:00:00	ES	Futures	798.13	799.31	793.15	795.28	148663.0
2009-01-14 14:00:00	ES	Futures	795.05	802.87	793.15	798.37	308803.0
2009-01-14 15:00:00	ES	Futures	798.37	798.6	790.06	796.23	523179.0
2009-01-14 16:00:00	ES	Futures	796.23	797.89	790.06	793.62	135574.0
2009-01-14 17:00:00	ES	Futures	793.86	795.52	790.3	790.54	10832.0
2009-01-14 18:00:00	ES	Futures	790.54	793.15	788.4	792.2	11289.0
2009-01-14 19:00:00	ES	Futures	792.2	793.38	790.78	791.25	5170.0
2009-01-14 20:00:00	ES	Futures	791.49	792.91	789.12	789.83	5288.0
2009-01-14 21:00:00	ES	Futures	790.06	791.72	789.83	790.54	3078.0
2009-01-14 22:00:00	ES	Futures	790.54	791.25	788.88	788.88	4021.0
2009-01-14 23:00:00	ES	Futures	789.12	790.06	788.4	789.59	2660.0
2009-01-14 00:00:00	NQ	Futures	1364.18	1366.44	1364.18	1366.16	31.0
2009-01-14 01:00:00	NQ	Futures	1364.46	1366.16	1363.05	1366.16	49.0
2009-01-14 02:00:00	NQ	Futures	1365.88	1366.44	1361.36	1363.62	161.0
2009-01-14 03:00:00	NQ	Futures	1363.33	1364.18	1354.58	1356.27	628.0
2009-01-14 04:00:00	NQ	Futures	1355.99	1357.97	1349.5	1351.19	860.0
2009-01-14 05:00:00	NQ	Futures	1351.76	1354.02	1346.67	1353.17	998.0
2009-01-14 06:00:00	NQ	Futures	1353.17	1354.3	1343.57	1348.65	616.0
2009-01-14 07:00:00	NQ	Futures	1348.65	1351.19	1346.96	1347.52	1230.0
2009-01-14 08:00:00	NQ	Futures	1347.8	1348.93	1335.1	1338.2	6801.0
2009-01-14 09:00:00	NQ	Futures	1338.2	1343.28	1324.37	1330.58	40388.0
2009-01-14 10:00:00	NQ	Futures	1330.01	1333.97	1311.66	1316.18	59765.0
2009-01-14 11:00:00	NQ	Futures	1316.18	1324.37	1308.83	1322.11	32965.0
2009-01-14 12:00:00	NQ	Futures	1322.11	1323.8	1312.79	1321.26	26005.0
2009-01-14 13:00:00	NQ	Futures	1320.98	1322.39	1313.35	1316.74	17300.0
2009-01-14 14:00:00	NQ	Futures	1316.74	1326.34	1313.92	1319.28	31107.0
2009-01-14 15:00:00	NQ	Futures	1319.28	1319.56	1304.88	1313.92	59006.0
2009-01-14 16:00:00	NQ	Futures	1313.63	1317.59	1289.07	1293.02	16714.0
2009-01-14 17:00:00	NQ	Futures	1292.74	1299.23	1289.63	1293.02	3994.0
2009-01-14 18:00:00	NQ	Futures	1293.59	1299.52	1293.02	1297.54	1482.0
2009-01-14 19:00:00	NQ	Futures	1297.26	1297.82	1293.87	1296.13	375.0
2009-01-14 20:00:00	NQ	Futures	1295.56	1297.82	1294.15	1294.72	249.0
2009-01-14 21:00:00	NQ	Futures	1296.13	1297.82	1296.13	1297.54	211.0
2009-01-14 22:00:00	NQ	Futures	1295.84	1297.82	1294.15	1295.84	141.0
2009-01-14 23:00:00	NQ	Futures	1295.56	1297.82	1294.43	1295.84	177.0
2009-01-14 00:00:00	YM	Futures	7695.7	7706.6	7694.8	7703.0	65.0
2009-01-14 01:00:00	YM	Futures	7702.1	7709.4	7693.0	7706.6	180.0

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

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