PREVIEW / futures_1hour / 2011-12-14

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-12-14.parquet
  size:    47 KB
  rows:    1,429

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-12-14 00:00:00	ES	Futures	1232.98	1233.48	1232.22	1233.23	2928.0
2011-12-14 01:00:00	ES	Futures	1233.23	1234.49	1231.72	1231.97	5550.0
2011-12-14 02:00:00	ES	Futures	1231.97	1235.25	1231.47	1232.98	8947.0
2011-12-14 03:00:00	ES	Futures	1232.98	1236.25	1230.96	1233.73	36532.0
2011-12-14 04:00:00	ES	Futures	1233.73	1234.99	1230.96	1234.49	26978.0
2011-12-14 05:00:00	ES	Futures	1234.49	1235.5	1231.21	1232.47	25296.0
2011-12-14 06:00:00	ES	Futures	1232.22	1232.98	1226.17	1227.43	38068.0
2011-12-14 07:00:00	ES	Futures	1227.18	1229.7	1224.91	1228.95	57443.0
2011-12-14 08:00:00	ES	Futures	1228.95	1230.96	1225.67	1226.17	81737.0
2011-12-14 09:00:00	ES	Futures	1226.17	1228.19	1218.36	1222.14	345180.0
2011-12-14 10:00:00	ES	Futures	1222.14	1222.14	1215.34	1215.59	394864.0
2011-12-14 11:00:00	ES	Futures	1215.59	1217.61	1212.82	1214.33	323415.0
2011-12-14 12:00:00	ES	Futures	1214.08	1220.38	1213.57	1219.12	253456.0
2011-12-14 13:00:00	ES	Futures	1219.12	1223.4	1217.61	1218.36	182527.0
2011-12-14 14:00:00	ES	Futures	1218.36	1219.37	1212.82	1214.33	235407.0
2011-12-14 15:00:00	ES	Futures	1214.33	1218.61	1212.06	1214.83	311356.0
2011-12-14 16:00:00	ES	Futures	1214.83	1216.6	1214.08	1215.84	106824.0
2011-12-14 17:00:00	ES	Futures	1215.84	1216.85	1214.58	1215.09	2604.0
2011-12-14 18:00:00	ES	Futures	1215.09	1215.84	1213.57	1215.84	5363.0
2011-12-14 19:00:00	ES	Futures	1215.84	1217.61	1215.09	1215.59	7970.0
2011-12-14 20:00:00	ES	Futures	1215.34	1217.1	1214.33	1215.34	5991.0
2011-12-14 21:00:00	ES	Futures	1215.09	1216.09	1211.81	1214.08	10534.0
2011-12-14 22:00:00	ES	Futures	1214.08	1215.84	1214.08	1215.34	4397.0
2011-12-14 23:00:00	ES	Futures	1215.34	1215.84	1214.58	1214.83	2602.0
2011-12-14 00:00:00	NQ	Futures	2624.6	2625.18	2622.87	2624.89	149.0
2011-12-14 01:00:00	NQ	Futures	2624.6	2626.62	2622.29	2623.44	265.0
2011-12-14 02:00:00	NQ	Futures	2622.58	2627.49	2622.0	2623.16	523.0
2011-12-14 03:00:00	NQ	Futures	2623.16	2629.8	2619.69	2625.47	2168.0
2011-12-14 04:00:00	NQ	Futures	2625.47	2626.62	2620.27	2623.16	2186.0
2011-12-14 05:00:00	NQ	Futures	2623.16	2624.31	2615.36	2617.09	2647.0
2011-12-14 06:00:00	NQ	Futures	2616.8	2617.96	2607.27	2608.43	2865.0
2011-12-14 07:00:00	NQ	Futures	2608.14	2613.34	2605.25	2611.6	2934.0
2011-12-14 08:00:00	NQ	Futures	2611.31	2616.22	2606.41	2608.72	8153.0
2011-12-14 09:00:00	NQ	Futures	2608.43	2609.29	2585.9	2598.32	40078.0
2011-12-14 10:00:00	NQ	Futures	2598.61	2598.61	2575.79	2576.37	56136.0
2011-12-14 11:00:00	NQ	Futures	2576.37	2579.55	2559.91	2566.26	47428.0
2011-12-14 12:00:00	NQ	Futures	2565.97	2578.68	2564.53	2576.08	26955.0
2011-12-14 13:00:00	NQ	Futures	2576.08	2587.06	2572.9	2577.81	21215.0
2011-12-14 14:00:00	NQ	Futures	2577.81	2580.99	2566.84	2569.73	23724.0
2011-12-14 15:00:00	NQ	Futures	2569.73	2582.15	2565.97	2574.64	36508.0
2011-12-14 16:00:00	NQ	Futures	2574.35	2576.37	2572.04	2572.9	7005.0
2011-12-14 17:00:00	NQ	Futures	2573.77	2574.93	2570.02	2572.33	83.0
2011-12-14 18:00:00	NQ	Futures	2572.33	2573.48	2569.15	2573.19	255.0
2011-12-14 19:00:00	NQ	Futures	2572.62	2576.66	2572.62	2572.62	511.0
2011-12-14 20:00:00	NQ	Futures	2572.62	2576.08	2571.46	2572.33	318.0
2011-12-14 21:00:00	NQ	Futures	2572.04	2573.19	2565.97	2570.88	707.0
2011-12-14 22:00:00	NQ	Futures	2571.46	2573.48	2570.31	2572.9	348.0
2011-12-14 23:00:00	NQ	Futures	2572.9	2573.19	2570.31	2571.46	178.0
2011-12-14 00:00:00	YM	Futures	11814.3	11818.3	11806.4	11817.3	150.0
2011-12-14 01:00:00	YM	Futures	11816.3	11826.2	11806.4	11807.4	371.0

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

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