PREVIEW / futures_1hour / 2008-11-13

all futures 1-hour files

  file:    by_date/futures_1hour/2008/2008-11-13.parquet
  size:    45 KB
  rows:    1,243

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
2008-11-13 00:00:00	ES	Futures	800.59	805.32	799.4	802.72	6032.0
2008-11-13 01:00:00	ES	Futures	802.72	806.74	800.82	806.27	3995.0
2008-11-13 02:00:00	ES	Futures	806.27	806.27	799.4	800.35	15017.0
2008-11-13 03:00:00	ES	Futures	800.35	812.89	800.35	808.4	32501.0
2008-11-13 04:00:00	ES	Futures	808.16	817.39	807.21	813.36	22527.0
2008-11-13 05:00:00	ES	Futures	813.36	813.36	799.88	804.61	27414.0
2008-11-13 06:00:00	ES	Futures	804.61	808.63	797.98	806.03	27684.0
2008-11-13 07:00:00	ES	Futures	806.03	814.55	805.08	806.03	35606.0
2008-11-13 08:00:00	ES	Futures	806.27	809.11	801.77	804.85	66571.0
2008-11-13 09:00:00	ES	Futures	804.85	818.57	801.06	802.01	323116.0
2008-11-13 10:00:00	ES	Futures	802.01	820.46	801.06	809.58	483701.0
2008-11-13 11:00:00	ES	Futures	809.58	811.71	800.59	804.37	355110.0
2008-11-13 12:00:00	ES	Futures	804.37	806.5	773.61	774.08	421575.0
2008-11-13 13:00:00	ES	Futures	773.84	815.97	773.13	802.48	762692.0
2008-11-13 14:00:00	ES	Futures	802.24	834.9	799.88	826.38	674607.0
2008-11-13 15:00:00	ES	Futures	826.38	864.95	812.42	863.06	970696.0
2008-11-13 16:00:00	ES	Futures	863.06	864.01	857.14	857.38	178900.0
2008-11-13 17:00:00	ES	Futures	857.62	860.69	857.62	859.51	3449.0
2008-11-13 18:00:00	ES	Futures	859.51	860.93	856.67	859.04	5718.0
2008-11-13 19:00:00	ES	Futures	859.04	859.27	854.07	854.54	7051.0
2008-11-13 20:00:00	ES	Futures	854.31	855.73	852.41	852.65	7657.0
2008-11-13 21:00:00	ES	Futures	852.65	853.83	850.28	851.94	6765.0
2008-11-13 22:00:00	ES	Futures	852.18	852.89	849.57	851.47	4626.0
2008-11-13 23:00:00	ES	Futures	851.47	852.18	847.92	849.34	5473.0
2008-11-13 00:00:00	NQ	Futures	1297.67	1302.76	1294.56	1297.95	355.0
2008-11-13 01:00:00	NQ	Futures	1301.07	1307.01	1298.52	1304.74	195.0
2008-11-13 02:00:00	NQ	Futures	1305.59	1305.59	1294.56	1298.24	714.0
2008-11-13 03:00:00	NQ	Futures	1298.24	1317.19	1298.24	1307.29	1827.0
2008-11-13 04:00:00	NQ	Futures	1307.29	1321.72	1306.16	1313.52	1652.0
2008-11-13 05:00:00	NQ	Futures	1313.23	1313.52	1294.84	1300.22	1622.0
2008-11-13 06:00:00	NQ	Futures	1299.93	1307.29	1292.29	1303.33	2305.0
2008-11-13 07:00:00	NQ	Futures	1303.9	1318.04	1301.63	1304.74	2428.0
2008-11-13 08:00:00	NQ	Futures	1304.74	1308.71	1298.24	1305.59	8006.0
2008-11-13 09:00:00	NQ	Futures	1305.59	1330.49	1299.08	1301.07	48170.0
2008-11-13 10:00:00	NQ	Futures	1300.78	1332.76	1299.65	1316.06	60090.0
2008-11-13 11:00:00	NQ	Futures	1316.06	1319.18	1299.93	1304.18	45304.0
2008-11-13 12:00:00	NQ	Futures	1304.46	1307.86	1255.79	1256.36	52729.0
2008-11-13 13:00:00	NQ	Futures	1256.07	1323.99	1254.66	1302.2	92036.0
2008-11-13 14:00:00	NQ	Futures	1301.91	1363.6	1295.41	1349.74	105636.0
2008-11-13 15:00:00	NQ	Futures	1349.74	1406.04	1327.38	1404.63	128527.0
2008-11-13 16:00:00	NQ	Futures	1403.78	1407.74	1396.99	1397.84	22433.0
2008-11-13 17:00:00	NQ	Futures	1398.97	1400.1	1397.27	1398.97	172.0
2008-11-13 18:00:00	NQ	Futures	1397.84	1400.1	1393.31	1396.42	250.0
2008-11-13 19:00:00	NQ	Futures	1396.14	1397.84	1392.18	1393.31	254.0
2008-11-13 20:00:00	NQ	Futures	1393.31	1394.16	1390.48	1390.48	286.0
2008-11-13 21:00:00	NQ	Futures	1391.05	1393.03	1387.09	1390.48	389.0
2008-11-13 22:00:00	NQ	Futures	1391.05	1393.03	1387.37	1391.05	185.0
2008-11-13 23:00:00	NQ	Futures	1389.63	1391.05	1385.11	1387.65	191.0
2008-11-13 00:00:00	YM	Futures	7473.5	7512.6	7459.0	7488.1	430.0
2008-11-13 01:00:00	YM	Futures	7488.1	7520.8	7477.2	7519.0	268.0

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

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