PREVIEW / futures_1hour / 2009-01-20

all futures 1-hour files

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

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-20 00:00:00	ES	Futures	791.72	795.05	790.54	794.33	3446.0
2009-01-20 01:00:00	ES	Futures	794.1	798.84	793.86	798.6	2672.0
2009-01-20 02:00:00	ES	Futures	798.37	798.84	793.62	794.81	7664.0
2009-01-20 03:00:00	ES	Futures	794.57	801.45	794.57	798.84	20826.0
2009-01-20 04:00:00	ES	Futures	798.84	803.82	798.37	801.21	13507.0
2009-01-20 05:00:00	ES	Futures	801.21	802.87	794.81	795.76	14233.0
2009-01-20 06:00:00	ES	Futures	795.76	797.42	792.44	795.52	16413.0
2009-01-20 07:00:00	ES	Futures	795.76	800.97	794.81	795.28	23579.0
2009-01-20 08:00:00	ES	Futures	795.52	796.47	791.25	795.05	37947.0
2009-01-20 09:00:00	ES	Futures	795.05	797.65	779.87	782.0	314625.0
2009-01-20 10:00:00	ES	Futures	782.24	787.93	778.21	781.53	364490.0
2009-01-20 11:00:00	ES	Futures	781.76	786.51	778.44	781.05	277093.0
2009-01-20 12:00:00	ES	Futures	781.05	786.03	774.88	778.68	326393.0
2009-01-20 13:00:00	ES	Futures	778.44	782.47	773.7	774.17	266026.0
2009-01-20 14:00:00	ES	Futures	774.17	776.78	767.53	768.95	303934.0
2009-01-20 15:00:00	ES	Futures	769.19	770.38	759.23	760.89	487661.0
2009-01-20 16:00:00	ES	Futures	760.89	766.35	756.62	763.26	160755.0
2009-01-20 17:00:00	ES	Futures	763.26	764.45	762.55	763.26	2523.0
2009-01-20 18:00:00	ES	Futures	763.5	766.11	761.36	762.55	5555.0
2009-01-20 19:00:00	ES	Futures	762.79	765.63	762.55	764.69	4241.0
2009-01-20 20:00:00	ES	Futures	764.92	768.01	763.97	767.53	4971.0
2009-01-20 21:00:00	ES	Futures	767.53	771.8	767.53	770.85	7639.0
2009-01-20 22:00:00	ES	Futures	770.85	773.22	770.14	771.09	8106.0
2009-01-20 23:00:00	ES	Futures	770.85	772.51	770.62	771.09	2858.0
2009-01-20 00:00:00	NQ	Futures	1333.97	1337.07	1333.4	1336.23	522.0
2009-01-20 01:00:00	NQ	Futures	1336.79	1343.0	1335.94	1341.87	241.0
2009-01-20 02:00:00	NQ	Futures	1342.72	1342.72	1334.81	1335.66	562.0
2009-01-20 03:00:00	NQ	Futures	1336.23	1346.96	1336.23	1343.28	1577.0
2009-01-20 04:00:00	NQ	Futures	1343.28	1349.5	1342.44	1345.54	922.0
2009-01-20 05:00:00	NQ	Futures	1345.83	1348.65	1335.38	1338.2	807.0
2009-01-20 06:00:00	NQ	Futures	1337.92	1341.87	1334.81	1339.61	823.0
2009-01-20 07:00:00	NQ	Futures	1340.46	1347.8	1338.48	1339.05	1197.0
2009-01-20 08:00:00	NQ	Futures	1339.33	1342.16	1334.25	1339.33	2511.0
2009-01-20 09:00:00	NQ	Futures	1339.61	1349.21	1318.72	1320.41	44237.0
2009-01-20 10:00:00	NQ	Futures	1320.41	1324.93	1311.66	1314.76	47354.0
2009-01-20 11:00:00	NQ	Futures	1315.05	1320.41	1308.27	1311.09	30431.0
2009-01-20 12:00:00	NQ	Futures	1311.09	1319.85	1304.88	1307.14	33050.0
2009-01-20 13:00:00	NQ	Futures	1306.86	1311.94	1296.69	1298.1	39316.0
2009-01-20 14:00:00	NQ	Futures	1298.1	1302.06	1289.91	1294.15	31160.0
2009-01-20 15:00:00	NQ	Futures	1294.15	1300.65	1281.16	1283.42	57923.0
2009-01-20 16:00:00	NQ	Futures	1283.14	1297.82	1278.62	1289.63	20751.0
2009-01-20 17:00:00	NQ	Futures	1289.91	1291.61	1287.66	1287.94	518.0
2009-01-20 18:00:00	NQ	Futures	1289.91	1293.02	1288.79	1290.48	326.0
2009-01-20 19:00:00	NQ	Futures	1291.04	1294.15	1289.91	1293.02	297.0
2009-01-20 20:00:00	NQ	Futures	1294.43	1298.95	1294.43	1298.39	301.0
2009-01-20 21:00:00	NQ	Futures	1298.67	1302.62	1297.26	1301.21	403.0
2009-01-20 22:00:00	NQ	Futures	1301.21	1303.47	1299.52	1299.52	323.0
2009-01-20 23:00:00	NQ	Futures	1299.52	1302.06	1299.52	1300.08	145.0
2009-01-20 00:00:00	YM	Futures	7401.4	7426.9	7394.1	7419.6	320.0
2009-01-20 01:00:00	YM	Futures	7420.5	7457.0	7419.6	7454.2	355.0

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

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