PREVIEW / futures_1hour / 2008-11-05

all futures 1-hour files

  file:    by_date/futures_1hour/2008/2008-11-05.parquet
  size:    46 KB
  rows:    1,288

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-05 00:00:00	ES	Futures	948.02	953.7	946.84	952.28	6776.0
2008-11-05 01:00:00	ES	Futures	952.51	954.17	949.67	949.91	5385.0
2008-11-05 02:00:00	ES	Futures	949.91	950.15	937.37	938.32	21913.0
2008-11-05 03:00:00	ES	Futures	938.55	939.97	932.64	934.53	28759.0
2008-11-05 04:00:00	ES	Futures	934.29	935.95	930.51	932.64	22341.0
2008-11-05 05:00:00	ES	Futures	932.87	935.0	928.85	934.53	15981.0
2008-11-05 06:00:00	ES	Futures	934.53	943.76	934.29	940.92	22996.0
2008-11-05 07:00:00	ES	Futures	940.92	943.29	934.77	938.08	22107.0
2008-11-05 08:00:00	ES	Futures	938.08	939.26	932.87	937.84	43168.0
2008-11-05 09:00:00	ES	Futures	938.08	938.55	930.03	934.29	248158.0
2008-11-05 10:00:00	ES	Futures	934.06	946.36	932.16	939.74	397431.0
2008-11-05 11:00:00	ES	Futures	939.5	941.87	929.09	933.35	300493.0
2008-11-05 12:00:00	ES	Futures	933.35	934.29	916.54	921.51	305255.0
2008-11-05 13:00:00	ES	Futures	921.51	924.35	916.07	918.44	199335.0
2008-11-05 14:00:00	ES	Futures	918.44	924.12	913.94	918.91	292759.0
2008-11-05 15:00:00	ES	Futures	918.91	923.17	896.43	900.45	627223.0
2008-11-05 16:00:00	ES	Futures	900.45	907.55	895.48	896.19	135585.0
2008-11-05 17:00:00	ES	Futures	895.96	896.67	893.59	896.19	7067.0
2008-11-05 18:00:00	ES	Futures	895.48	897.14	892.64	896.67	6427.0
2008-11-05 19:00:00	ES	Futures	896.67	897.14	893.59	893.83	4588.0
2008-11-05 20:00:00	ES	Futures	894.06	896.43	893.35	895.25	3056.0
2008-11-05 21:00:00	ES	Futures	895.01	897.85	894.06	897.61	3218.0
2008-11-05 22:00:00	ES	Futures	897.61	899.51	895.48	899.03	5544.0
2008-11-05 23:00:00	ES	Futures	899.03	899.27	895.48	895.72	2541.0
2008-11-05 00:00:00	NQ	Futures	1560.83	1570.45	1559.98	1570.45	136.0
2008-11-05 01:00:00	NQ	Futures	1570.73	1572.14	1563.09	1563.09	195.0
2008-11-05 02:00:00	NQ	Futures	1563.37	1563.66	1543.85	1545.55	663.0
2008-11-05 03:00:00	NQ	Futures	1546.68	1547.53	1535.36	1539.6	1925.0
2008-11-05 04:00:00	NQ	Futures	1539.32	1541.87	1535.36	1537.06	1344.0
2008-11-05 05:00:00	NQ	Futures	1537.06	1541.58	1531.68	1540.74	838.0
2008-11-05 06:00:00	NQ	Futures	1541.02	1554.32	1540.17	1550.92	1097.0
2008-11-05 07:00:00	NQ	Futures	1550.92	1553.75	1540.74	1543.57	1916.0
2008-11-05 08:00:00	NQ	Futures	1543.57	1545.26	1534.79	1541.58	4117.0
2008-11-05 09:00:00	NQ	Futures	1541.58	1544.98	1531.96	1535.08	35461.0
2008-11-05 10:00:00	NQ	Futures	1535.08	1547.24	1531.96	1535.64	46323.0
2008-11-05 11:00:00	NQ	Futures	1535.64	1540.17	1521.49	1526.02	43843.0
2008-11-05 12:00:00	NQ	Futures	1526.3	1528.0	1497.16	1509.89	50872.0
2008-11-05 13:00:00	NQ	Futures	1509.89	1511.59	1497.73	1498.86	33225.0
2008-11-05 14:00:00	NQ	Futures	1498.86	1507.35	1490.09	1502.54	44219.0
2008-11-05 15:00:00	NQ	Futures	1502.25	1508.48	1468.58	1471.41	86179.0
2008-11-05 16:00:00	NQ	Futures	1470.84	1480.46	1445.66	1447.64	23203.0
2008-11-05 17:00:00	NQ	Futures	1447.64	1449.34	1440.28	1444.25	1155.0
2008-11-05 18:00:00	NQ	Futures	1445.38	1448.77	1441.42	1448.49	889.0
2008-11-05 19:00:00	NQ	Futures	1448.77	1449.34	1445.38	1447.92	402.0
2008-11-05 20:00:00	NQ	Futures	1446.23	1449.34	1446.23	1449.34	315.0
2008-11-05 21:00:00	NQ	Futures	1447.92	1450.75	1447.36	1450.47	540.0
2008-11-05 22:00:00	NQ	Futures	1449.9	1451.32	1447.36	1451.04	368.0
2008-11-05 23:00:00	NQ	Futures	1450.47	1451.32	1444.25	1446.51	193.0
2008-11-05 00:00:00	YM	Futures	8711.4	8747.8	8701.4	8744.1	440.0
2008-11-05 01:00:00	YM	Futures	8744.1	8756.8	8721.4	8722.3	337.0

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

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