PREVIEW / futures_1hour / 2008-11-04

all futures 1-hour files

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

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-04 00:00:00	ES	Futures	917.25	919.15	915.6	917.96	3949.0
2008-11-04 01:00:00	ES	Futures	918.44	920.57	918.2	918.67	1834.0
2008-11-04 02:00:00	ES	Futures	918.67	921.75	918.2	921.51	5604.0
2008-11-04 03:00:00	ES	Futures	921.28	924.59	915.36	923.88	19476.0
2008-11-04 04:00:00	ES	Futures	924.12	932.16	921.99	931.93	19510.0
2008-11-04 05:00:00	ES	Futures	931.93	936.42	929.8	936.19	21301.0
2008-11-04 06:00:00	ES	Futures	936.19	938.55	934.53	934.77	26702.0
2008-11-04 07:00:00	ES	Futures	934.77	942.58	934.53	939.74	36413.0
2008-11-04 08:00:00	ES	Futures	939.97	940.92	934.77	936.19	29855.0
2008-11-04 09:00:00	ES	Futures	936.19	938.08	927.9	928.85	228669.0
2008-11-04 10:00:00	ES	Futures	928.85	947.78	927.67	945.18	412794.0
2008-11-04 11:00:00	ES	Futures	945.18	951.8	944.94	949.67	276066.0
2008-11-04 12:00:00	ES	Futures	949.67	950.62	942.81	944.47	156615.0
2008-11-04 13:00:00	ES	Futures	944.23	950.86	942.34	947.07	156243.0
2008-11-04 14:00:00	ES	Futures	947.07	947.31	934.77	937.37	280626.0
2008-11-04 15:00:00	ES	Futures	937.37	952.99	932.87	948.26	524108.0
2008-11-04 16:00:00	ES	Futures	948.49	949.91	945.89	947.31	105424.0
2008-11-04 17:00:00	ES	Futures	947.31	948.97	947.07	948.02	1843.0
2008-11-04 18:00:00	ES	Futures	948.02	951.09	947.31	949.91	4084.0
2008-11-04 19:00:00	ES	Futures	949.91	949.91	947.07	948.97	4461.0
2008-11-04 20:00:00	ES	Futures	948.97	948.97	942.81	943.76	7892.0
2008-11-04 21:00:00	ES	Futures	943.76	952.51	943.29	950.15	9255.0
2008-11-04 22:00:00	ES	Futures	950.15	954.64	948.73	949.2	10468.0
2008-11-04 23:00:00	ES	Futures	949.2	953.93	944.94	948.26	13614.0
2008-11-04 00:00:00	NQ	Futures	1518.95	1520.93	1516.97	1520.65	123.0
2008-11-04 01:00:00	NQ	Futures	1521.21	1524.32	1520.93	1520.93	94.0
2008-11-04 02:00:00	NQ	Futures	1519.8	1528.0	1519.23	1527.15	505.0
2008-11-04 03:00:00	NQ	Futures	1525.74	1536.77	1518.66	1533.66	1814.0
2008-11-04 04:00:00	NQ	Futures	1533.94	1547.81	1530.27	1547.81	1477.0
2008-11-04 05:00:00	NQ	Futures	1547.81	1554.03	1544.98	1553.47	1065.0
2008-11-04 06:00:00	NQ	Futures	1552.62	1560.26	1550.64	1551.21	2188.0
2008-11-04 07:00:00	NQ	Futures	1551.21	1558.56	1550.36	1552.62	2112.0
2008-11-04 08:00:00	NQ	Futures	1552.62	1553.75	1544.13	1545.83	2810.0
2008-11-04 09:00:00	NQ	Futures	1546.11	1547.81	1518.66	1522.63	40528.0
2008-11-04 10:00:00	NQ	Futures	1522.34	1553.19	1518.38	1547.53	57183.0
2008-11-04 11:00:00	NQ	Futures	1547.81	1566.2	1547.24	1562.81	41826.0
2008-11-04 12:00:00	NQ	Futures	1562.81	1563.94	1550.07	1555.45	30147.0
2008-11-04 13:00:00	NQ	Futures	1555.45	1563.66	1550.64	1558.28	22292.0
2008-11-04 14:00:00	NQ	Futures	1558.0	1558.85	1538.75	1542.15	42365.0
2008-11-04 15:00:00	NQ	Futures	1541.87	1563.09	1531.68	1561.11	64640.0
2008-11-04 16:00:00	NQ	Futures	1560.83	1566.49	1558.56	1559.69	10750.0
2008-11-04 17:00:00	NQ	Futures	1559.69	1562.81	1559.69	1561.96	135.0
2008-11-04 18:00:00	NQ	Futures	1561.39	1565.35	1559.13	1563.09	203.0
2008-11-04 19:00:00	NQ	Futures	1561.67	1562.52	1559.41	1562.52	163.0
2008-11-04 20:00:00	NQ	Futures	1562.24	1562.24	1550.92	1552.34	414.0
2008-11-04 21:00:00	NQ	Futures	1552.34	1567.62	1552.34	1563.66	340.0
2008-11-04 22:00:00	NQ	Futures	1563.37	1572.14	1561.96	1565.35	359.0
2008-11-04 23:00:00	NQ	Futures	1562.24	1571.58	1556.58	1562.24	510.0
2008-11-04 00:00:00	YM	Futures	8489.4	8504.0	8478.5	8498.5	237.0
2008-11-04 01:00:00	YM	Futures	8498.5	8514.9	8497.6	8502.2	175.0

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

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