PREVIEW / futures_1hour / 2011-07-12

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-07-12.parquet
  size:    51 KB
  rows:    1,502

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-07-12 00:00:00	ES	Futures	1305.89	1306.89	1305.39	1306.39	3859.0
2011-07-12 01:00:00	ES	Futures	1306.64	1308.38	1305.64	1306.39	8581.0
2011-07-12 02:00:00	ES	Futures	1306.64	1307.63	1303.39	1303.89	29992.0
2011-07-12 03:00:00	ES	Futures	1304.14	1304.39	1292.17	1294.91	138304.0
2011-07-12 04:00:00	ES	Futures	1295.16	1303.64	1292.92	1300.15	108028.0
2011-07-12 05:00:00	ES	Futures	1300.15	1309.38	1299.4	1302.15	87791.0
2011-07-12 06:00:00	ES	Futures	1302.15	1306.14	1301.4	1302.15	41219.0
2011-07-12 07:00:00	ES	Futures	1301.9	1310.38	1298.65	1309.13	92873.0
2011-07-12 08:00:00	ES	Futures	1309.13	1313.12	1307.38	1309.88	124815.0
2011-07-12 09:00:00	ES	Futures	1309.88	1312.62	1305.64	1312.62	382018.0
2011-07-12 10:00:00	ES	Futures	1312.62	1314.62	1308.88	1311.12	378164.0
2011-07-12 11:00:00	ES	Futures	1310.88	1316.36	1310.13	1314.37	286150.0
2011-07-12 12:00:00	ES	Futures	1314.62	1315.86	1311.87	1312.87	164941.0
2011-07-12 13:00:00	ES	Futures	1312.87	1314.87	1310.38	1311.62	122592.0
2011-07-12 14:00:00	ES	Futures	1311.62	1320.1	1310.63	1313.87	301008.0
2011-07-12 15:00:00	ES	Futures	1313.87	1315.12	1305.64	1306.14	432980.0
2011-07-12 16:00:00	ES	Futures	1306.14	1308.38	1305.64	1307.13	105516.0
2011-07-12 17:00:00	ES	Futures	1307.13	1307.38	1306.39	1306.89	1811.0
2011-07-12 18:00:00	ES	Futures	1306.64	1306.64	1304.14	1304.39	6669.0
2011-07-12 19:00:00	ES	Futures	1304.64	1307.38	1304.39	1306.89	4693.0
2011-07-12 20:00:00	ES	Futures	1307.13	1310.63	1306.89	1310.13	11195.0
2011-07-12 21:00:00	ES	Futures	1310.13	1311.62	1307.63	1308.63	11732.0
2011-07-12 22:00:00	ES	Futures	1308.63	1311.62	1308.38	1311.37	9677.0
2011-07-12 23:00:00	ES	Futures	1311.37	1312.87	1310.88	1312.62	10417.0
2011-07-12 00:00:00	NQ	Futures	2705.57	2707.87	2704.42	2707.3	226.0
2011-07-12 01:00:00	NQ	Futures	2707.87	2712.48	2705.86	2708.16	580.0
2011-07-12 02:00:00	NQ	Futures	2708.16	2710.17	2703.27	2705.28	2253.0
2011-07-12 03:00:00	NQ	Futures	2705.28	2705.86	2683.12	2688.3	11149.0
2011-07-12 04:00:00	NQ	Futures	2688.59	2702.69	2682.55	2698.09	7582.0
2011-07-12 05:00:00	NQ	Futures	2698.38	2711.32	2696.65	2699.81	4702.0
2011-07-12 06:00:00	NQ	Futures	2700.1	2707.58	2699.53	2702.4	2940.0
2011-07-12 07:00:00	NQ	Futures	2702.12	2714.2	2694.92	2713.05	6803.0
2011-07-12 08:00:00	NQ	Futures	2712.76	2723.99	2712.19	2720.25	13612.0
2011-07-12 09:00:00	NQ	Futures	2719.96	2721.11	2693.77	2703.55	62448.0
2011-07-12 10:00:00	NQ	Futures	2703.55	2715.07	2699.53	2705.28	42986.0
2011-07-12 11:00:00	NQ	Futures	2704.99	2714.2	2704.13	2706.72	28654.0
2011-07-12 12:00:00	NQ	Futures	2706.72	2711.04	2700.68	2704.42	17316.0
2011-07-12 13:00:00	NQ	Futures	2704.13	2710.75	2700.68	2705.28	14561.0
2011-07-12 14:00:00	NQ	Futures	2705.28	2721.11	2703.55	2706.14	32849.0
2011-07-12 15:00:00	NQ	Futures	2706.14	2710.46	2692.33	2694.63	42263.0
2011-07-12 16:00:00	NQ	Futures	2694.63	2698.95	2694.06	2696.94	7427.0
2011-07-12 17:00:00	NQ	Futures	2696.65	2696.94	2696.36	2696.94	92.0
2011-07-12 18:00:00	NQ	Futures	2696.07	2696.65	2690.89	2692.04	415.0
2011-07-12 19:00:00	NQ	Futures	2692.62	2696.65	2692.33	2694.92	546.0
2011-07-12 20:00:00	NQ	Futures	2694.63	2702.69	2694.63	2701.25	789.0
2011-07-12 21:00:00	NQ	Futures	2701.83	2704.13	2695.21	2696.07	917.0
2011-07-12 22:00:00	NQ	Futures	2696.65	2703.84	2696.65	2703.55	547.0
2011-07-12 23:00:00	NQ	Futures	2703.55	2708.45	2701.83	2707.87	811.0
2011-07-12 00:00:00	YM	Futures	12017.8	12027.5	12014.9	12025.6	197.0
2011-07-12 01:00:00	YM	Futures	12025.6	12039.1	12018.8	12025.6	292.0

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

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