PREVIEW / futures_1hour / 2009-02-02

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-02-02.parquet
  size:    44 KB
  rows:    1,271

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-02 00:00:00	ES	Futures	776.78	778.21	776.31	777.73	1847.0
2009-02-02 01:00:00	ES	Futures	777.97	779.15	775.12	775.6	3138.0
2009-02-02 02:00:00	ES	Futures	775.83	775.83	771.09	773.46	7578.0
2009-02-02 03:00:00	ES	Futures	773.7	775.6	770.62	770.85	24486.0
2009-02-02 04:00:00	ES	Futures	770.85	771.09	765.16	766.82	30909.0
2009-02-02 05:00:00	ES	Futures	766.82	769.43	764.92	766.58	12607.0
2009-02-02 06:00:00	ES	Futures	766.35	770.85	766.35	770.62	11230.0
2009-02-02 07:00:00	ES	Futures	770.62	772.04	766.58	768.48	20868.0
2009-02-02 08:00:00	ES	Futures	768.48	770.38	765.4	767.29	49959.0
2009-02-02 09:00:00	ES	Futures	767.29	771.8	765.87	770.62	187433.0
2009-02-02 10:00:00	ES	Futures	770.62	779.63	770.38	775.6	338206.0
2009-02-02 11:00:00	ES	Futures	775.6	778.44	772.28	777.02	215249.0
2009-02-02 12:00:00	ES	Futures	776.78	784.85	776.78	783.19	221318.0
2009-02-02 13:00:00	ES	Futures	783.19	783.66	773.22	773.94	196465.0
2009-02-02 14:00:00	ES	Futures	773.94	775.83	771.09	771.8	204879.0
2009-02-02 15:00:00	ES	Futures	771.8	785.08	771.09	779.63	347831.0
2009-02-02 16:00:00	ES	Futures	779.15	779.87	777.97	778.92	63957.0
2009-02-02 17:00:00	ES	Futures	778.92	779.63	778.68	779.15	1673.0
2009-02-02 18:00:00	ES	Futures	778.92	779.15	776.31	778.68	4250.0
2009-02-02 19:00:00	ES	Futures	778.92	780.81	778.68	780.81	2586.0
2009-02-02 20:00:00	ES	Futures	780.81	782.71	780.58	782.0	3571.0
2009-02-02 21:00:00	ES	Futures	782.0	784.85	781.29	783.42	6925.0
2009-02-02 22:00:00	ES	Futures	783.42	787.22	783.19	786.27	5157.0
2009-02-02 23:00:00	ES	Futures	786.51	786.98	782.24	782.71	3760.0
2009-02-02 00:00:00	NQ	Futures	1326.34	1328.88	1325.78	1328.88	79.0
2009-02-02 01:00:00	NQ	Futures	1327.47	1330.58	1321.82	1322.67	196.0
2009-02-02 02:00:00	NQ	Futures	1322.67	1323.8	1313.07	1318.44	775.0
2009-02-02 03:00:00	NQ	Futures	1318.15	1323.52	1313.63	1315.61	1430.0
2009-02-02 04:00:00	NQ	Futures	1315.33	1315.89	1304.88	1307.14	1960.0
2009-02-02 05:00:00	NQ	Futures	1307.14	1311.94	1302.9	1306.58	1363.0
2009-02-02 06:00:00	NQ	Futures	1306.29	1310.81	1305.45	1309.96	1072.0
2009-02-02 07:00:00	NQ	Futures	1310.25	1312.79	1305.45	1309.68	2010.0
2009-02-02 08:00:00	NQ	Futures	1309.68	1315.33	1309.12	1311.94	5020.0
2009-02-02 09:00:00	NQ	Futures	1311.94	1329.45	1311.09	1327.19	30985.0
2009-02-02 10:00:00	NQ	Futures	1326.91	1348.93	1326.91	1339.33	60586.0
2009-02-02 11:00:00	NQ	Futures	1339.05	1343.85	1335.1	1341.31	29433.0
2009-02-02 12:00:00	NQ	Futures	1341.31	1352.6	1341.31	1350.34	32306.0
2009-02-02 13:00:00	NQ	Futures	1350.34	1350.91	1333.4	1335.94	26344.0
2009-02-02 14:00:00	NQ	Futures	1335.94	1337.92	1329.73	1333.4	27478.0
2009-02-02 15:00:00	NQ	Futures	1333.4	1357.69	1331.14	1347.52	57967.0
2009-02-02 16:00:00	NQ	Futures	1348.09	1348.65	1341.59	1343.28	10180.0
2009-02-02 17:00:00	NQ	Futures	1343.28	1344.13	1342.72	1343.57	66.0
2009-02-02 18:00:00	NQ	Futures	1343.0	1343.57	1339.33	1340.74	586.0
2009-02-02 19:00:00	NQ	Futures	1342.16	1345.83	1342.16	1344.41	292.0
2009-02-02 20:00:00	NQ	Futures	1345.26	1348.65	1345.26	1346.96	130.0
2009-02-02 21:00:00	NQ	Futures	1346.96	1352.04	1345.83	1350.06	266.0
2009-02-02 22:00:00	NQ	Futures	1350.91	1355.71	1350.06	1354.3	253.0
2009-02-02 23:00:00	NQ	Futures	1355.43	1355.43	1348.09	1348.37	181.0
2009-02-02 00:00:00	YM	Futures	7211.8	7220.9	7209.1	7217.3	105.0
2009-02-02 01:00:00	YM	Futures	7218.2	7229.1	7193.6	7199.1	368.0

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

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