PREVIEW / futures_1hour / 2011-01-04

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-01-04.parquet
  size:    50 KB
  rows:    1,494

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
2011-01-04 00:00:00	ES	Futures	1252.97	1253.47	1252.72	1252.97	1433.0
2011-01-04 01:00:00	ES	Futures	1252.97	1253.47	1251.98	1251.98	2507.0
2011-01-04 02:00:00	ES	Futures	1251.98	1253.22	1251.98	1252.72	7176.0
2011-01-04 03:00:00	ES	Futures	1252.72	1253.96	1251.49	1252.72	24237.0
2011-01-04 04:00:00	ES	Futures	1252.72	1255.2	1252.72	1254.46	21309.0
2011-01-04 05:00:00	ES	Futures	1254.46	1255.44	1253.96	1255.44	10536.0
2011-01-04 06:00:00	ES	Futures	1255.44	1256.68	1255.2	1255.94	15976.0
2011-01-04 07:00:00	ES	Futures	1255.94	1256.68	1255.2	1255.69	11489.0
2011-01-04 08:00:00	ES	Futures	1255.44	1255.94	1253.96	1254.7	26302.0
2011-01-04 09:00:00	ES	Futures	1254.7	1256.93	1251.98	1252.23	207975.0
2011-01-04 10:00:00	ES	Futures	1252.23	1253.22	1250.0	1250.5	289185.0
2011-01-04 11:00:00	ES	Futures	1250.5	1251.49	1248.52	1249.01	189207.0
2011-01-04 12:00:00	ES	Futures	1249.26	1249.51	1245.3	1246.54	213918.0
2011-01-04 13:00:00	ES	Futures	1246.54	1249.51	1246.29	1249.26	140523.0
2011-01-04 14:00:00	ES	Futures	1249.26	1252.23	1248.52	1250.74	223031.0
2011-01-04 15:00:00	ES	Futures	1250.99	1253.47	1249.75	1252.48	256322.0
2011-01-04 16:00:00	ES	Futures	1252.48	1253.47	1251.49	1252.48	105044.0
2011-01-04 17:00:00	ES	Futures	1252.48	1252.48	1251.98	1252.23	991.0
2011-01-04 18:00:00	ES	Futures	1251.98	1252.23	1251.49	1251.73	3576.0
2011-01-04 19:00:00	ES	Futures	1251.98	1251.98	1251.24	1251.73	2433.0
2011-01-04 20:00:00	ES	Futures	1251.49	1251.73	1247.03	1248.52	12153.0
2011-01-04 21:00:00	ES	Futures	1248.52	1250.0	1248.52	1249.26	3199.0
2011-01-04 22:00:00	ES	Futures	1249.26	1250.0	1249.26	1249.75	2902.0
2011-01-04 23:00:00	ES	Futures	1249.75	1250.0	1248.52	1248.76	2748.0
2011-01-04 00:00:00	NQ	Futures	2586.74	2586.74	2585.88	2586.16	108.0
2011-01-04 01:00:00	NQ	Futures	2586.45	2586.74	2582.72	2582.72	416.0
2011-01-04 02:00:00	NQ	Futures	2582.72	2585.3	2582.72	2584.73	948.0
2011-01-04 03:00:00	NQ	Futures	2584.73	2586.16	2582.14	2583.87	1729.0
2011-01-04 04:00:00	NQ	Futures	2583.87	2587.88	2583.87	2587.02	1490.0
2011-01-04 05:00:00	NQ	Futures	2587.31	2588.46	2585.59	2588.46	763.0
2011-01-04 06:00:00	NQ	Futures	2588.46	2592.76	2587.88	2592.48	1917.0
2011-01-04 07:00:00	NQ	Futures	2592.19	2593.34	2591.33	2592.19	1540.0
2011-01-04 08:00:00	NQ	Futures	2591.9	2594.49	2589.32	2590.47	5211.0
2011-01-04 09:00:00	NQ	Futures	2590.75	2597.64	2587.31	2589.89	32925.0
2011-01-04 10:00:00	NQ	Futures	2589.89	2591.62	2581.86	2583.0	33583.0
2011-01-04 11:00:00	NQ	Futures	2582.72	2584.15	2573.82	2574.11	29444.0
2011-01-04 12:00:00	NQ	Futures	2573.82	2575.83	2567.79	2573.82	28395.0
2011-01-04 13:00:00	NQ	Futures	2574.11	2577.55	2573.53	2576.69	15932.0
2011-01-04 14:00:00	NQ	Futures	2576.69	2585.59	2575.54	2583.0	19679.0
2011-01-04 15:00:00	NQ	Futures	2583.29	2586.45	2579.27	2583.87	32171.0
2011-01-04 16:00:00	NQ	Futures	2583.87	2584.15	2578.13	2580.13	8744.0
2011-01-04 17:00:00	NQ	Futures	2579.27	2579.56	2578.41	2578.41	97.0
2011-01-04 18:00:00	NQ	Futures	2578.41	2578.99	2577.84	2577.84	260.0
2011-01-04 19:00:00	NQ	Futures	2578.41	2578.7	2577.84	2578.41	117.0
2011-01-04 20:00:00	NQ	Futures	2578.13	2578.13	2568.37	2571.24	1342.0
2011-01-04 21:00:00	NQ	Futures	2570.95	2573.53	2570.95	2572.1	799.0
2011-01-04 22:00:00	NQ	Futures	2572.67	2573.53	2572.1	2572.96	196.0
2011-01-04 23:00:00	NQ	Futures	2573.25	2573.82	2571.52	2571.81	144.0
2011-01-04 00:00:00	YM	Futures	11113.1	11114.1	11108.4	11109.3	179.0
2011-01-04 01:00:00	YM	Futures	11111.2	11112.2	11102.6	11102.6	226.0

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

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