PREVIEW / futures_1hour / 2012-11-16

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-11-16.parquet
  size:    41 KB
  rows:    1,201

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
2012-11-16 00:00:00	ES	Futures	1378.74	1379.25	1377.97	1378.23	2822.0
2012-11-16 01:00:00	ES	Futures	1377.97	1379.25	1377.72	1378.99	4272.0
2012-11-16 02:00:00	ES	Futures	1378.99	1380.53	1378.48	1379.76	9859.0
2012-11-16 03:00:00	ES	Futures	1380.01	1382.57	1379.5	1380.53	26278.0
2012-11-16 04:00:00	ES	Futures	1380.78	1380.78	1374.91	1375.67	41734.0
2012-11-16 05:00:00	ES	Futures	1375.93	1377.46	1373.88	1376.44	34732.0
2012-11-16 06:00:00	ES	Futures	1376.69	1380.01	1375.67	1380.01	23960.0
2012-11-16 07:00:00	ES	Futures	1379.76	1381.29	1376.95	1381.04	46939.0
2012-11-16 08:00:00	ES	Futures	1381.04	1386.66	1379.5	1384.61	102491.0
2012-11-16 09:00:00	ES	Futures	1384.61	1385.89	1374.91	1376.44	300186.0
2012-11-16 10:00:00	ES	Futures	1376.18	1378.99	1371.33	1375.16	374458.0
2012-11-16 11:00:00	ES	Futures	1375.16	1385.12	1369.54	1385.12	516696.0
2012-11-16 12:00:00	ES	Futures	1384.87	1388.7	1382.31	1384.87	290912.0
2012-11-16 13:00:00	ES	Futures	1384.87	1386.4	1381.55	1385.38	140960.0
2012-11-16 14:00:00	ES	Futures	1385.12	1385.89	1377.46	1383.08	174220.0
2012-11-16 15:00:00	ES	Futures	1383.08	1389.47	1381.04	1386.66	338062.0
2012-11-16 16:00:00	ES	Futures	1386.4	1390.23	1385.38	1390.23	109565.0
2012-11-16 00:00:00	NQ	Futures	2930.17	2931.63	2929.01	2929.01	288.0
2012-11-16 01:00:00	NQ	Futures	2929.3	2931.63	2929.3	2931.04	270.0
2012-11-16 02:00:00	NQ	Futures	2930.75	2933.95	2930.75	2932.5	544.0
2012-11-16 03:00:00	NQ	Futures	2932.5	2935.98	2929.88	2930.46	2037.0
2012-11-16 04:00:00	NQ	Futures	2930.75	2930.75	2920.87	2923.78	3420.0
2012-11-16 05:00:00	NQ	Futures	2924.07	2927.56	2920.87	2924.94	2577.0
2012-11-16 06:00:00	NQ	Futures	2925.23	2930.17	2922.91	2929.88	1636.0
2012-11-16 07:00:00	NQ	Futures	2929.88	2932.21	2923.2	2932.21	4658.0
2012-11-16 08:00:00	NQ	Futures	2931.92	2945.86	2930.17	2940.92	12669.0
2012-11-16 09:00:00	NQ	Futures	2940.63	2942.38	2912.16	2918.26	49174.0
2012-11-16 10:00:00	NQ	Futures	2917.97	2924.94	2908.09	2918.26	48432.0
2012-11-16 11:00:00	NQ	Futures	2918.26	2933.08	2896.47	2932.79	60471.0
2012-11-16 12:00:00	NQ	Futures	2933.08	2951.09	2929.59	2942.38	52225.0
2012-11-16 13:00:00	NQ	Futures	2942.09	2945.57	2933.95	2944.12	22641.0
2012-11-16 14:00:00	NQ	Futures	2943.83	2945.28	2924.65	2937.15	28380.0
2012-11-16 15:00:00	NQ	Futures	2937.44	2951.38	2930.75	2941.8	39542.0
2012-11-16 16:00:00	NQ	Futures	2942.09	2947.03	2939.76	2946.15	9044.0
2012-11-16 00:00:00	YM	Futures	12511.4	12516.4	12505.4	12505.4	384.0
2012-11-16 01:00:00	YM	Futures	12505.4	12513.4	12504.4	12512.4	312.0
2012-11-16 02:00:00	YM	Futures	12511.4	12525.4	12510.4	12522.4	609.0
2012-11-16 03:00:00	YM	Futures	12521.4	12539.5	12519.4	12523.4	1746.0
2012-11-16 04:00:00	YM	Futures	12523.4	12524.4	12477.4	12485.4	2361.0
2012-11-16 05:00:00	YM	Futures	12485.4	12496.4	12470.4	12491.4	2267.0
2012-11-16 06:00:00	YM	Futures	12491.4	12520.4	12481.4	12519.4	1457.0
2012-11-16 07:00:00	YM	Futures	12518.4	12525.4	12493.4	12516.4	3264.0
2012-11-16 08:00:00	YM	Futures	12516.4	12554.5	12510.4	12543.5	6716.0
2012-11-16 09:00:00	YM	Futures	12543.5	12553.5	12473.4	12484.4	20763.0
2012-11-16 10:00:00	YM	Futures	12484.4	12507.4	12440.4	12486.4	23451.0
2012-11-16 11:00:00	YM	Futures	12487.4	12555.5	12441.4	12552.5	33779.0
2012-11-16 12:00:00	YM	Futures	12553.5	12571.5	12526.4	12537.5	21331.0
2012-11-16 13:00:00	YM	Futures	12534.5	12556.5	12513.4	12546.5	9674.0
2012-11-16 14:00:00	YM	Futures	12546.5	12551.5	12482.4	12529.4	12185.0
2012-11-16 15:00:00	YM	Futures	12529.4	12574.5	12514.4	12557.5	20709.0

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

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