PREVIEW / futures_1hour / 2008-09-02

all futures 1-hour files

  file:    by_date/futures_1hour/2008/2008-09-02.parquet
  size:    44 KB
  rows:    1,244

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-09-02 00:00:00	ES	Futures	1193.92	1194.15	1192.29	1192.76	2628.0
2008-09-02 01:00:00	ES	Futures	1192.52	1192.52	1187.41	1187.87	6149.0
2008-09-02 02:00:00	ES	Futures	1187.87	1190.66	1187.41	1190.2	7033.0
2008-09-02 03:00:00	ES	Futures	1190.2	1195.54	1186.95	1195.08	25452.0
2008-09-02 04:00:00	ES	Futures	1195.08	1202.75	1194.85	1199.73	39846.0
2008-09-02 05:00:00	ES	Futures	1199.73	1204.14	1199.5	1202.05	19026.0
2008-09-02 06:00:00	ES	Futures	1201.82	1203.45	1199.96	1200.66	12928.0
2008-09-02 07:00:00	ES	Futures	1200.43	1202.52	1200.19	1202.28	16266.0
2008-09-02 08:00:00	ES	Futures	1202.28	1204.84	1201.82	1203.68	38189.0
2008-09-02 09:00:00	ES	Futures	1203.68	1211.81	1203.45	1208.33	299274.0
2008-09-02 10:00:00	ES	Futures	1208.33	1210.88	1200.43	1203.45	399530.0
2008-09-02 11:00:00	ES	Futures	1203.21	1205.54	1201.35	1202.28	159387.0
2008-09-02 12:00:00	ES	Futures	1202.05	1203.21	1194.15	1195.78	207126.0
2008-09-02 13:00:00	ES	Futures	1195.78	1198.57	1189.27	1189.97	208048.0
2008-09-02 14:00:00	ES	Futures	1189.97	1191.36	1182.3	1183.46	361361.0
2008-09-02 15:00:00	ES	Futures	1183.46	1187.87	1182.06	1187.41	303661.0
2008-09-02 16:00:00	ES	Futures	1187.18	1187.87	1186.02	1186.71	85515.0
2008-09-02 17:00:00	ES	Futures	1186.71	1186.71	1186.25	1186.48	850.0
2008-09-02 18:00:00	ES	Futures	1186.48	1186.71	1185.32	1185.55	1985.0
2008-09-02 19:00:00	ES	Futures	1185.55	1186.95	1184.85	1186.71	1314.0
2008-09-02 20:00:00	ES	Futures	1186.71	1187.18	1185.78	1186.48	1624.0
2008-09-02 21:00:00	ES	Futures	1186.48	1187.18	1186.25	1186.71	1222.0
2008-09-02 22:00:00	ES	Futures	1186.71	1186.95	1185.32	1185.55	695.0
2008-09-02 23:00:00	ES	Futures	1185.55	1186.25	1185.55	1185.78	372.0
2008-09-02 00:00:00	NQ	Futures	2115.29	2115.29	2112.2	2112.2	68.0
2008-09-02 01:00:00	NQ	Futures	2112.2	2112.2	2102.92	2102.92	589.0
2008-09-02 02:00:00	NQ	Futures	2102.92	2107.42	2102.63	2105.73	747.0
2008-09-02 03:00:00	NQ	Futures	2106.29	2118.67	2099.82	2117.26	3395.0
2008-09-02 04:00:00	NQ	Futures	2117.26	2132.45	2117.26	2127.67	5224.0
2008-09-02 05:00:00	NQ	Futures	2127.95	2134.7	2127.95	2133.01	2622.0
2008-09-02 06:00:00	NQ	Futures	2132.73	2134.42	2128.79	2129.36	949.0
2008-09-02 07:00:00	NQ	Futures	2129.36	2134.7	2128.79	2132.45	3522.0
2008-09-02 08:00:00	NQ	Futures	2131.89	2145.11	2131.33	2138.36	11460.0
2008-09-02 09:00:00	NQ	Futures	2138.64	2155.23	2138.08	2148.2	73422.0
2008-09-02 10:00:00	NQ	Futures	2147.92	2152.14	2128.79	2133.29	73161.0
2008-09-02 11:00:00	NQ	Futures	2133.29	2137.23	2127.39	2129.07	33524.0
2008-09-02 12:00:00	NQ	Futures	2128.79	2130.48	2111.07	2115.29	52067.0
2008-09-02 13:00:00	NQ	Futures	2115.29	2118.1	2086.6	2089.41	55813.0
2008-09-02 14:00:00	NQ	Futures	2089.41	2095.04	2074.79	2078.72	62714.0
2008-09-02 15:00:00	NQ	Futures	2078.72	2089.98	2075.91	2084.91	55556.0
2008-09-02 16:00:00	NQ	Futures	2084.91	2086.32	2082.66	2084.91	12277.0
2008-09-02 17:00:00	NQ	Futures	2084.63	2085.19	2084.35	2085.19	97.0
2008-09-02 18:00:00	NQ	Futures	2084.63	2084.63	2081.54	2083.22	500.0
2008-09-02 19:00:00	NQ	Futures	2083.22	2084.91	2082.38	2084.35	180.0
2008-09-02 20:00:00	NQ	Futures	2084.91	2085.48	2083.22	2084.63	246.0
2008-09-02 21:00:00	NQ	Futures	2084.63	2085.76	2084.63	2084.91	190.0
2008-09-02 22:00:00	NQ	Futures	2084.63	2084.63	2083.22	2083.22	46.0
2008-09-02 23:00:00	NQ	Futures	2083.51	2083.79	2083.51	2083.51	46.0
2008-09-02 00:00:00	YM	Futures	10512.9	10515.7	10501.1	10502.0	149.0
2008-09-02 01:00:00	YM	Futures	10500.2	10500.2	10461.1	10461.1	441.0

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

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