PREVIEW / futures_1hour / 2009-02-05

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-02-05.parquet
  size:    45 KB
  rows:    1,296

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-02-05 00:00:00	ES	Futures	783.42	783.66	781.05	781.53	3520.0
2009-02-05 01:00:00	ES	Futures	781.53	782.71	780.81	782.47	2241.0
2009-02-05 02:00:00	ES	Futures	782.71	784.61	781.76	781.76	5138.0
2009-02-05 03:00:00	ES	Futures	782.0	786.03	780.81	785.32	16461.0
2009-02-05 04:00:00	ES	Futures	785.32	786.74	782.95	784.61	9962.0
2009-02-05 05:00:00	ES	Futures	784.37	787.93	784.37	786.27	10059.0
2009-02-05 06:00:00	ES	Futures	786.27	787.69	784.61	786.03	10647.0
2009-02-05 07:00:00	ES	Futures	786.03	786.98	780.34	782.24	27177.0
2009-02-05 08:00:00	ES	Futures	782.24	786.03	778.44	780.58	67295.0
2009-02-05 09:00:00	ES	Futures	780.58	783.19	775.12	775.6	244040.0
2009-02-05 10:00:00	ES	Futures	775.36	793.62	774.88	791.01	457541.0
2009-02-05 11:00:00	ES	Futures	790.78	796.71	790.06	796.71	351251.0
2009-02-05 12:00:00	ES	Futures	796.47	804.3	796.23	800.26	363255.0
2009-02-05 13:00:00	ES	Futures	800.5	803.11	795.76	797.18	263472.0
2009-02-05 14:00:00	ES	Futures	797.18	805.48	796.47	797.42	306945.0
2009-02-05 15:00:00	ES	Futures	797.65	802.4	793.86	798.84	353857.0
2009-02-05 16:00:00	ES	Futures	798.84	799.55	795.76	798.13	96647.0
2009-02-05 17:00:00	ES	Futures	798.13	798.37	796.23	797.18	3556.0
2009-02-05 18:00:00	ES	Futures	797.42	797.89	796.23	797.89	2414.0
2009-02-05 19:00:00	ES	Futures	797.89	799.79	796.47	797.65	4990.0
2009-02-05 20:00:00	ES	Futures	797.65	798.37	796.94	797.65	1934.0
2009-02-05 21:00:00	ES	Futures	797.42	801.21	797.42	799.55	4374.0
2009-02-05 22:00:00	ES	Futures	799.55	800.03	798.13	798.37	1214.0
2009-02-05 23:00:00	ES	Futures	798.13	798.37	795.99	796.94	2080.0
2009-02-05 00:00:00	NQ	Futures	1345.26	1345.26	1338.77	1339.05	824.0
2009-02-05 01:00:00	NQ	Futures	1340.18	1343.85	1338.48	1343.85	481.0
2009-02-05 02:00:00	NQ	Futures	1343.85	1346.39	1343.28	1343.57	902.0
2009-02-05 03:00:00	NQ	Futures	1343.57	1352.89	1343.57	1352.04	1829.0
2009-02-05 04:00:00	NQ	Futures	1352.04	1353.17	1347.52	1349.5	1027.0
2009-02-05 05:00:00	NQ	Futures	1349.5	1354.86	1349.5	1352.04	1006.0
2009-02-05 06:00:00	NQ	Futures	1351.76	1354.86	1349.5	1353.17	1094.0
2009-02-05 07:00:00	NQ	Futures	1353.17	1354.3	1345.54	1351.19	2410.0
2009-02-05 08:00:00	NQ	Futures	1350.63	1357.4	1345.83	1350.34	7089.0
2009-02-05 09:00:00	NQ	Futures	1350.34	1364.18	1348.09	1355.43	47348.0
2009-02-05 10:00:00	NQ	Futures	1355.99	1394.4	1354.58	1388.75	91204.0
2009-02-05 11:00:00	NQ	Futures	1388.75	1397.22	1384.23	1397.22	53201.0
2009-02-05 12:00:00	NQ	Futures	1396.94	1409.64	1392.42	1398.91	58877.0
2009-02-05 13:00:00	NQ	Futures	1398.91	1402.58	1393.83	1395.53	37332.0
2009-02-05 14:00:00	NQ	Futures	1395.81	1411.06	1395.53	1398.63	47480.0
2009-02-05 15:00:00	NQ	Futures	1398.63	1404.28	1389.88	1401.74	48009.0
2009-02-05 16:00:00	NQ	Futures	1402.02	1402.3	1391.85	1394.96	19239.0
2009-02-05 17:00:00	NQ	Futures	1394.96	1396.09	1389.6	1390.72	1147.0
2009-02-05 18:00:00	NQ	Futures	1390.72	1395.81	1390.72	1394.96	406.0
2009-02-05 19:00:00	NQ	Futures	1394.96	1397.22	1394.11	1394.96	588.0
2009-02-05 20:00:00	NQ	Futures	1396.37	1397.22	1395.53	1396.65	197.0
2009-02-05 21:00:00	NQ	Futures	1396.37	1401.17	1396.37	1398.07	308.0
2009-02-05 22:00:00	NQ	Futures	1398.07	1399.2	1397.22	1397.22	157.0
2009-02-05 23:00:00	NQ	Futures	1397.22	1397.5	1393.83	1395.81	205.0
2009-02-05 00:00:00	YM	Futures	7203.6	7203.6	7185.4	7190.9	356.0
2009-02-05 01:00:00	YM	Futures	7189.0	7196.3	7183.6	7194.5	363.0

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

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