PREVIEW / futures_1hour / 2008-05-29

all futures 1-hour files

  file:    by_date/futures_1hour/2008/2008-05-29.parquet
  size:    42 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-05-29 00:00:00	ES	Futures	1294.84	1295.08	1293.68	1294.61	712.0
2008-05-29 01:00:00	ES	Futures	1294.38	1296.94	1294.15	1296.24	1477.0
2008-05-29 02:00:00	ES	Futures	1296.24	1297.41	1295.54	1296.47	5629.0
2008-05-29 03:00:00	ES	Futures	1296.47	1296.94	1293.91	1296.24	10570.0
2008-05-29 04:00:00	ES	Futures	1296.47	1300.2	1296.47	1297.64	15036.0
2008-05-29 05:00:00	ES	Futures	1297.64	1297.87	1295.78	1296.94	8202.0
2008-05-29 06:00:00	ES	Futures	1296.94	1297.17	1293.91	1294.84	12601.0
2008-05-29 07:00:00	ES	Futures	1294.84	1297.17	1294.61	1296.71	11482.0
2008-05-29 08:00:00	ES	Futures	1296.71	1298.1	1292.28	1292.52	56783.0
2008-05-29 09:00:00	ES	Futures	1292.52	1298.1	1291.58	1297.17	163683.0
2008-05-29 10:00:00	ES	Futures	1297.17	1302.76	1292.98	1301.13	401436.0
2008-05-29 11:00:00	ES	Futures	1301.13	1305.09	1300.2	1304.16	239594.0
2008-05-29 12:00:00	ES	Futures	1304.39	1309.05	1303.23	1308.12	163613.0
2008-05-29 13:00:00	ES	Futures	1308.12	1309.05	1305.79	1306.95	123173.0
2008-05-29 14:00:00	ES	Futures	1307.18	1310.44	1304.16	1305.32	179545.0
2008-05-29 15:00:00	ES	Futures	1305.32	1305.55	1301.36	1302.06	226710.0
2008-05-29 16:00:00	ES	Futures	1302.29	1303.69	1301.13	1302.76	75168.0
2008-05-29 17:00:00	ES	Futures	1302.76	1303.46	1301.83	1302.76	3105.0
2008-05-29 18:00:00	ES	Futures	1302.53	1302.76	1299.27	1299.97	6258.0
2008-05-29 19:00:00	ES	Futures	1299.97	1301.36	1299.73	1300.66	796.0
2008-05-29 20:00:00	ES	Futures	1300.43	1302.53	1300.2	1301.83	917.0
2008-05-29 21:00:00	ES	Futures	1301.83	1302.06	1300.9	1300.9	797.0
2008-05-29 22:00:00	ES	Futures	1300.9	1301.13	1300.2	1300.66	892.0
2008-05-29 23:00:00	ES	Futures	1300.66	1302.53	1300.43	1302.06	794.0
2008-05-29 00:00:00	NQ	Futures	2267.15	2268.0	2265.46	2266.02	50.0
2008-05-29 01:00:00	NQ	Futures	2265.74	2269.98	2265.74	2268.57	80.0
2008-05-29 02:00:00	NQ	Futures	2268.57	2271.11	2268.57	2269.42	632.0
2008-05-29 03:00:00	NQ	Futures	2268.85	2271.11	2265.46	2269.42	850.0
2008-05-29 04:00:00	NQ	Futures	2269.7	2279.88	2269.7	2272.81	1731.0
2008-05-29 05:00:00	NQ	Futures	2272.25	2272.81	2269.42	2271.68	662.0
2008-05-29 06:00:00	NQ	Futures	2271.4	2271.4	2265.46	2266.59	904.0
2008-05-29 07:00:00	NQ	Futures	2266.59	2271.4	2266.02	2270.55	806.0
2008-05-29 08:00:00	NQ	Futures	2270.55	2273.94	2262.35	2263.19	6390.0
2008-05-29 09:00:00	NQ	Futures	2263.19	2281.01	2262.63	2278.75	43746.0
2008-05-29 10:00:00	NQ	Futures	2278.47	2285.26	2267.15	2279.88	76090.0
2008-05-29 11:00:00	NQ	Futures	2279.88	2289.21	2275.92	2286.1	49551.0
2008-05-29 12:00:00	NQ	Futures	2286.1	2297.13	2283.28	2294.02	39236.0
2008-05-29 13:00:00	NQ	Futures	2293.74	2297.13	2290.06	2290.91	27692.0
2008-05-29 14:00:00	NQ	Futures	2291.19	2299.96	2288.37	2291.19	33269.0
2008-05-29 15:00:00	NQ	Futures	2291.19	2292.61	2284.97	2286.67	55426.0
2008-05-29 16:00:00	NQ	Futures	2286.39	2292.89	2285.82	2292.33	17142.0
2008-05-29 17:00:00	NQ	Futures	2292.61	2295.15	2291.76	2294.87	1796.0
2008-05-29 18:00:00	NQ	Futures	2294.31	2294.87	2290.06	2291.76	578.0
2008-05-29 19:00:00	NQ	Futures	2290.91	2293.17	2290.91	2291.48	119.0
2008-05-29 20:00:00	NQ	Futures	2292.04	2293.46	2291.48	2293.17	47.0
2008-05-29 21:00:00	NQ	Futures	2292.89	2293.17	2291.76	2292.04	67.0
2008-05-29 22:00:00	NQ	Futures	2291.48	2292.33	2291.48	2292.04	33.0
2008-05-29 23:00:00	NQ	Futures	2291.48	2293.46	2291.48	2293.46	65.0
2008-05-29 00:00:00	YM	Futures	11437.2	11438.1	11429.0	11437.2	86.0
2008-05-29 01:00:00	YM	Futures	11437.2	11449.9	11433.6	11444.5	130.0

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

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