PREVIEW / futures_1hour / 2008-04-28

all futures 1-hour files

  file:    by_date/futures_1hour/2008/2008-04-28.parquet
  size:    41 KB
  rows:    1,209

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-04-28 00:00:00	ES	Futures	1301.36	1301.83	1298.34	1298.8	1264.0
2008-04-28 01:00:00	ES	Futures	1298.8	1301.36	1297.87	1300.43	1597.0
2008-04-28 02:00:00	ES	Futures	1300.43	1304.16	1299.97	1302.76	6154.0
2008-04-28 03:00:00	ES	Futures	1302.76	1306.25	1301.13	1303.46	18519.0
2008-04-28 04:00:00	ES	Futures	1303.46	1304.39	1302.06	1303.69	5982.0
2008-04-28 05:00:00	ES	Futures	1303.92	1305.55	1302.99	1305.32	5554.0
2008-04-28 06:00:00	ES	Futures	1305.55	1308.35	1305.32	1306.95	13736.0
2008-04-28 07:00:00	ES	Futures	1307.18	1307.65	1304.86	1305.09	14779.0
2008-04-28 08:00:00	ES	Futures	1305.32	1306.72	1302.53	1302.99	43386.0
2008-04-28 09:00:00	ES	Futures	1302.99	1305.32	1299.5	1302.76	168448.0
2008-04-28 10:00:00	ES	Futures	1302.53	1306.49	1300.2	1305.32	205555.0
2008-04-28 11:00:00	ES	Futures	1305.55	1305.79	1301.13	1303.23	122394.0
2008-04-28 12:00:00	ES	Futures	1303.23	1306.72	1302.99	1304.62	90789.0
2008-04-28 13:00:00	ES	Futures	1304.39	1307.42	1304.16	1306.72	105524.0
2008-04-28 14:00:00	ES	Futures	1306.72	1307.65	1304.39	1305.55	95748.0
2008-04-28 15:00:00	ES	Futures	1305.55	1307.65	1299.5	1301.83	200377.0
2008-04-28 16:00:00	ES	Futures	1301.83	1302.29	1300.9	1302.06	49109.0
2008-04-28 17:00:00	ES	Futures	1301.83	1302.06	1300.9	1301.6	1965.0
2008-04-28 18:00:00	ES	Futures	1301.83	1302.76	1301.13	1302.53	1576.0
2008-04-28 19:00:00	ES	Futures	1302.53	1302.76	1301.83	1301.83	595.0
2008-04-28 20:00:00	ES	Futures	1302.06	1302.76	1301.13	1301.6	1041.0
2008-04-28 21:00:00	ES	Futures	1301.13	1301.83	1300.9	1301.36	929.0
2008-04-28 22:00:00	ES	Futures	1301.36	1302.29	1301.13	1302.06	621.0
2008-04-28 23:00:00	ES	Futures	1302.06	1302.29	1301.6	1301.83	387.0
2008-04-28 00:00:00	NQ	Futures	2174.67	2174.67	2170.71	2170.71	122.0
2008-04-28 01:00:00	NQ	Futures	2170.99	2175.23	2170.71	2174.1	55.0
2008-04-28 02:00:00	NQ	Futures	2173.82	2179.48	2172.97	2178.06	165.0
2008-04-28 03:00:00	NQ	Futures	2177.78	2180.89	2176.08	2177.78	739.0
2008-04-28 04:00:00	NQ	Futures	2177.5	2179.19	2174.39	2178.06	435.0
2008-04-28 05:00:00	NQ	Futures	2178.06	2180.61	2176.93	2179.48	434.0
2008-04-28 06:00:00	NQ	Futures	2179.76	2185.13	2179.76	2182.31	1919.0
2008-04-28 07:00:00	NQ	Futures	2182.87	2183.44	2178.35	2179.48	434.0
2008-04-28 08:00:00	NQ	Futures	2179.48	2182.02	2175.8	2179.48	3053.0
2008-04-28 09:00:00	NQ	Futures	2179.19	2184.0	2174.1	2182.31	24973.0
2008-04-28 10:00:00	NQ	Futures	2182.31	2189.38	2178.35	2189.38	29567.0
2008-04-28 11:00:00	NQ	Futures	2189.38	2189.94	2180.61	2184.0	20072.0
2008-04-28 12:00:00	NQ	Futures	2184.29	2190.51	2183.72	2187.96	16322.0
2008-04-28 13:00:00	NQ	Futures	2187.68	2196.45	2187.4	2195.03	25419.0
2008-04-28 14:00:00	NQ	Futures	2195.32	2196.73	2188.25	2191.07	21188.0
2008-04-28 15:00:00	NQ	Futures	2191.07	2193.05	2178.06	2179.76	36480.0
2008-04-28 16:00:00	NQ	Futures	2179.48	2181.17	2178.06	2180.89	7562.0
2008-04-28 17:00:00	NQ	Futures	2180.61	2180.61	2178.06	2180.04	226.0
2008-04-28 18:00:00	NQ	Futures	2179.48	2181.17	2179.48	2180.33	49.0
2008-04-28 19:00:00	NQ	Futures	2181.17	2181.17	2180.04	2180.04	29.0
2008-04-28 20:00:00	NQ	Futures	2181.17	2182.31	2179.48	2179.48	34.0
2008-04-28 21:00:00	NQ	Futures	2179.48	2179.48	2178.06	2178.06	21.0
2008-04-28 22:00:00	NQ	Futures	2178.91	2180.61	2178.63	2180.61	21.0
2008-04-28 23:00:00	NQ	Futures	2180.61	2180.61	2178.63	2178.63	89.0
2008-04-28 00:00:00	YM	Futures	11697.1	11697.1	11677.1	11678.9	131.0
2008-04-28 01:00:00	YM	Futures	11678.9	11694.3	11671.6	11694.3	118.0

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

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