PREVIEW / futures_1hour / 2008-11-18

all futures 1-hour files

  file:    by_date/futures_1hour/2008/2008-11-18.parquet
  size:    42 KB
  rows:    1,220

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-18 00:00:00	ES	Futures	802.24	803.19	800.35	802.95	3237.0
2008-11-18 01:00:00	ES	Futures	802.95	802.95	795.62	798.46	5708.0
2008-11-18 02:00:00	ES	Futures	798.22	802.95	796.33	802.24	7078.0
2008-11-18 03:00:00	ES	Futures	802.24	807.45	793.72	794.91	38754.0
2008-11-18 04:00:00	ES	Futures	794.91	795.85	786.86	787.33	31843.0
2008-11-18 05:00:00	ES	Futures	787.33	793.72	787.33	791.36	16136.0
2008-11-18 06:00:00	ES	Futures	791.36	793.01	784.97	789.7	23000.0
2008-11-18 07:00:00	ES	Futures	789.7	793.96	789.23	791.36	22445.0
2008-11-18 08:00:00	ES	Futures	791.59	804.14	790.88	800.35	98528.0
2008-11-18 09:00:00	ES	Futures	800.35	812.42	797.98	806.5	304908.0
2008-11-18 10:00:00	ES	Futures	806.27	818.33	799.4	811.94	423999.0
2008-11-18 11:00:00	ES	Futures	811.71	819.99	805.32	818.81	315538.0
2008-11-18 12:00:00	ES	Futures	819.04	819.04	801.77	804.61	235237.0
2008-11-18 13:00:00	ES	Futures	804.61	804.61	786.15	797.04	401245.0
2008-11-18 14:00:00	ES	Futures	797.04	797.27	780.71	783.55	396477.0
2008-11-18 15:00:00	ES	Futures	783.55	812.65	782.6	812.18	735109.0
2008-11-18 16:00:00	ES	Futures	811.94	822.59	810.76	818.33	181767.0
2008-11-18 17:00:00	ES	Futures	818.1	818.81	816.44	816.68	4712.0
2008-11-18 18:00:00	ES	Futures	816.2	816.91	813.6	813.84	5540.0
2008-11-18 19:00:00	ES	Futures	813.84	815.26	811.0	811.47	8482.0
2008-11-18 20:00:00	ES	Futures	811.47	813.13	809.82	810.76	5127.0
2008-11-18 21:00:00	ES	Futures	811.23	812.65	809.82	811.0	3106.0
2008-11-18 22:00:00	ES	Futures	811.0	811.71	807.92	811.23	4993.0
2008-11-18 23:00:00	ES	Futures	811.23	813.84	810.76	813.6	3918.0
2008-11-18 00:00:00	NQ	Futures	1306.44	1308.42	1305.59	1307.86	71.0
2008-11-18 01:00:00	NQ	Futures	1306.16	1306.16	1294.84	1301.35	425.0
2008-11-18 02:00:00	NQ	Futures	1300.22	1305.88	1297.67	1304.74	448.0
2008-11-18 03:00:00	NQ	Futures	1304.74	1312.67	1290.31	1292.86	1417.0
2008-11-18 04:00:00	NQ	Futures	1292.86	1293.99	1280.13	1282.11	2332.0
2008-11-18 05:00:00	NQ	Futures	1282.11	1289.75	1279.56	1286.63	2507.0
2008-11-18 06:00:00	NQ	Futures	1286.92	1289.75	1276.73	1281.82	1414.0
2008-11-18 07:00:00	NQ	Futures	1282.39	1291.44	1282.39	1288.62	1764.0
2008-11-18 08:00:00	NQ	Futures	1288.9	1318.89	1285.22	1311.82	11982.0
2008-11-18 09:00:00	NQ	Futures	1312.1	1322.85	1300.5	1306.44	49868.0
2008-11-18 10:00:00	NQ	Futures	1306.72	1320.87	1297.1	1312.38	67852.0
2008-11-18 11:00:00	NQ	Futures	1312.38	1318.04	1299.08	1317.48	38375.0
2008-11-18 12:00:00	NQ	Futures	1317.19	1317.48	1293.14	1295.12	37958.0
2008-11-18 13:00:00	NQ	Futures	1294.84	1294.84	1267.11	1277.3	58348.0
2008-11-18 14:00:00	NQ	Futures	1277.3	1284.65	1259.75	1263.43	51159.0
2008-11-18 15:00:00	NQ	Futures	1263.15	1305.59	1261.73	1304.74	83782.0
2008-11-18 16:00:00	NQ	Futures	1304.46	1330.49	1301.91	1322.29	26066.0
2008-11-18 17:00:00	NQ	Futures	1322.29	1323.42	1320.87	1321.44	614.0
2008-11-18 18:00:00	NQ	Futures	1321.44	1321.44	1318.33	1318.89	252.0
2008-11-18 19:00:00	NQ	Futures	1318.61	1319.74	1311.82	1312.38	234.0
2008-11-18 20:00:00	NQ	Futures	1312.38	1315.21	1311.25	1312.38	166.0
2008-11-18 21:00:00	NQ	Futures	1312.38	1314.08	1309.55	1311.54	215.0
2008-11-18 22:00:00	NQ	Futures	1311.82	1312.67	1307.29	1312.1	203.0
2008-11-18 23:00:00	NQ	Futures	1312.1	1316.06	1311.54	1316.06	176.0
2008-11-18 00:00:00	YM	Futures	7490.8	7500.8	7482.6	7496.3	174.0
2008-11-18 01:00:00	YM	Futures	7494.4	7494.4	7436.2	7461.7	733.0

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

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