PREVIEW / futures_1hour / 2009-01-26

all futures 1-hour files

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

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-26 00:00:00	ES	Futures	778.44	778.92	774.17	774.41	1832.0
2009-01-26 01:00:00	ES	Futures	774.41	774.65	769.19	772.28	5249.0
2009-01-26 02:00:00	ES	Futures	772.51	774.41	771.09	773.7	5208.0
2009-01-26 03:00:00	ES	Futures	773.7	782.24	773.7	781.05	21745.0
2009-01-26 04:00:00	ES	Futures	781.05	782.47	778.21	779.15	10962.0
2009-01-26 05:00:00	ES	Futures	779.15	786.98	778.92	786.27	17164.0
2009-01-26 06:00:00	ES	Futures	786.27	786.27	783.19	786.03	11562.0
2009-01-26 07:00:00	ES	Futures	786.03	787.46	779.15	782.71	34666.0
2009-01-26 08:00:00	ES	Futures	782.71	790.06	781.29	787.46	41465.0
2009-01-26 09:00:00	ES	Futures	787.46	799.08	786.03	796.23	268086.0
2009-01-26 10:00:00	ES	Futures	796.47	805.96	796.23	802.16	351711.0
2009-01-26 11:00:00	ES	Futures	802.16	804.06	795.76	798.13	212894.0
2009-01-26 12:00:00	ES	Futures	797.89	801.45	795.99	797.89	199824.0
2009-01-26 13:00:00	ES	Futures	798.13	800.26	788.17	789.83	265238.0
2009-01-26 14:00:00	ES	Futures	789.83	791.72	781.53	790.78	335388.0
2009-01-26 15:00:00	ES	Futures	790.78	797.65	787.22	790.3	376105.0
2009-01-26 16:00:00	ES	Futures	790.3	791.49	787.69	791.49	76010.0
2009-01-26 17:00:00	ES	Futures	791.49	791.49	790.06	790.54	732.0
2009-01-26 18:00:00	ES	Futures	791.01	793.62	790.78	792.2	3272.0
2009-01-26 19:00:00	ES	Futures	791.96	792.91	791.49	792.67	1588.0
2009-01-26 20:00:00	ES	Futures	792.67	794.1	792.67	793.86	1618.0
2009-01-26 21:00:00	ES	Futures	793.86	795.76	792.67	795.52	1958.0
2009-01-26 22:00:00	ES	Futures	795.52	797.65	795.05	797.42	4509.0
2009-01-26 23:00:00	ES	Futures	797.42	799.08	796.47	796.94	2710.0
2009-01-26 00:00:00	NQ	Futures	1311.94	1311.94	1303.47	1305.16	153.0
2009-01-26 01:00:00	NQ	Futures	1304.32	1304.88	1295.28	1300.08	296.0
2009-01-26 02:00:00	NQ	Futures	1301.49	1304.32	1297.54	1302.9	273.0
2009-01-26 03:00:00	NQ	Futures	1303.19	1315.89	1302.9	1313.63	1162.0
2009-01-26 04:00:00	NQ	Futures	1313.63	1316.46	1309.4	1311.09	507.0
2009-01-26 05:00:00	NQ	Futures	1311.38	1324.93	1309.96	1324.65	1244.0
2009-01-26 06:00:00	NQ	Futures	1324.65	1324.93	1318.44	1322.67	599.0
2009-01-26 07:00:00	NQ	Futures	1322.67	1324.08	1314.76	1323.52	2966.0
2009-01-26 08:00:00	NQ	Futures	1322.95	1329.73	1320.13	1325.49	3805.0
2009-01-26 09:00:00	NQ	Futures	1325.78	1341.59	1322.67	1337.07	39895.0
2009-01-26 10:00:00	NQ	Futures	1337.07	1356.84	1336.79	1349.21	47241.0
2009-01-26 11:00:00	NQ	Futures	1349.21	1352.89	1339.33	1343.28	28499.0
2009-01-26 12:00:00	NQ	Futures	1343.57	1349.5	1341.31	1345.54	27824.0
2009-01-26 13:00:00	NQ	Futures	1345.26	1347.8	1330.58	1332.84	38019.0
2009-01-26 14:00:00	NQ	Futures	1332.84	1334.81	1317.59	1333.68	51298.0
2009-01-26 15:00:00	NQ	Futures	1333.4	1344.41	1327.19	1333.97	48237.0
2009-01-26 16:00:00	NQ	Futures	1334.25	1337.92	1330.58	1337.64	7772.0
2009-01-26 17:00:00	NQ	Futures	1337.35	1337.92	1334.81	1335.1	19.0
2009-01-26 18:00:00	NQ	Futures	1335.38	1339.33	1335.38	1337.64	180.0
2009-01-26 19:00:00	NQ	Futures	1336.51	1337.92	1336.51	1337.92	100.0
2009-01-26 20:00:00	NQ	Futures	1337.64	1339.61	1337.35	1339.61	77.0
2009-01-26 21:00:00	NQ	Futures	1339.61	1342.72	1337.92	1342.44	63.0
2009-01-26 22:00:00	NQ	Futures	1341.87	1345.26	1341.59	1345.26	237.0
2009-01-26 23:00:00	NQ	Futures	1344.98	1347.52	1344.13	1344.98	59.0
2009-01-26 00:00:00	YM	Futures	7250.1	7251.9	7216.4	7216.4	82.0
2009-01-26 01:00:00	YM	Futures	7216.4	7216.4	7173.5	7204.5	334.0

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

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