PREVIEW / futures_1hour / 2012-11-14

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-11-14.parquet
  size:    48 KB
  rows:    1,496

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-14 00:00:00	ES	Futures	1405.82	1406.58	1404.79	1406.33	2482.0
2012-11-14 01:00:00	ES	Futures	1406.33	1407.09	1405.82	1407.09	4809.0
2012-11-14 02:00:00	ES	Futures	1407.09	1409.65	1405.56	1408.88	14485.0
2012-11-14 03:00:00	ES	Futures	1409.39	1409.65	1406.58	1407.61	31314.0
2012-11-14 04:00:00	ES	Futures	1407.86	1411.95	1407.61	1410.67	32033.0
2012-11-14 05:00:00	ES	Futures	1410.67	1410.93	1407.35	1407.86	20102.0
2012-11-14 06:00:00	ES	Futures	1407.86	1408.37	1405.56	1407.86	20903.0
2012-11-14 07:00:00	ES	Futures	1407.86	1408.37	1403.77	1404.54	37189.0
2012-11-14 08:00:00	ES	Futures	1404.54	1408.37	1403.52	1405.31	84516.0
2012-11-14 09:00:00	ES	Futures	1405.31	1407.86	1400.96	1401.98	241026.0
2012-11-14 10:00:00	ES	Futures	1402.24	1404.28	1392.28	1393.81	410904.0
2012-11-14 11:00:00	ES	Futures	1393.81	1398.66	1392.02	1398.41	295631.0
2012-11-14 12:00:00	ES	Futures	1398.15	1398.66	1392.79	1393.55	160633.0
2012-11-14 13:00:00	ES	Futures	1393.55	1397.64	1392.79	1396.36	164724.0
2012-11-14 14:00:00	ES	Futures	1396.36	1398.41	1389.72	1389.98	234994.0
2012-11-14 15:00:00	ES	Futures	1389.98	1390.74	1378.99	1382.31	531458.0
2012-11-14 16:00:00	ES	Futures	1382.31	1384.61	1381.8	1384.1	123268.0
2012-11-14 17:00:00	ES	Futures	1384.1	1384.1	1382.57	1382.83	4045.0
2012-11-14 18:00:00	ES	Futures	1383.08	1385.38	1383.08	1383.85	8527.0
2012-11-14 19:00:00	ES	Futures	1384.1	1384.36	1382.83	1383.08	9011.0
2012-11-14 20:00:00	ES	Futures	1383.08	1383.59	1380.78	1382.83	11623.0
2012-11-14 21:00:00	ES	Futures	1382.83	1384.87	1381.8	1384.87	5264.0
2012-11-14 22:00:00	ES	Futures	1384.87	1385.38	1383.59	1384.87	3999.0
2012-11-14 23:00:00	ES	Futures	1384.61	1385.38	1384.36	1384.61	2969.0
2012-11-14 00:00:00	NQ	Futures	2994.68	2997.3	2993.23	2996.42	402.0
2012-11-14 01:00:00	NQ	Futures	2996.42	2999.62	2995.55	2999.33	647.0
2012-11-14 02:00:00	NQ	Futures	2999.62	3001.65	2994.97	3000.78	1541.0
2012-11-14 03:00:00	NQ	Futures	3001.07	3001.07	2994.97	2997.0	2789.0
2012-11-14 04:00:00	NQ	Futures	2996.71	3005.43	2996.42	3002.24	3043.0
2012-11-14 05:00:00	NQ	Futures	3002.82	3003.11	2995.84	2997.0	2173.0
2012-11-14 06:00:00	NQ	Futures	2996.71	2998.17	2992.65	2996.13	2306.0
2012-11-14 07:00:00	NQ	Futures	2996.42	2997.0	2987.71	2987.71	4839.0
2012-11-14 08:00:00	NQ	Futures	2987.71	2995.84	2985.96	2990.03	8431.0
2012-11-14 09:00:00	NQ	Futures	2990.03	2994.68	2980.73	2984.22	50562.0
2012-11-14 10:00:00	NQ	Futures	2984.22	2989.16	2963.01	2966.49	80377.0
2012-11-14 11:00:00	NQ	Futures	2966.49	2979.86	2962.14	2977.83	51329.0
2012-11-14 12:00:00	NQ	Futures	2978.12	2978.7	2964.75	2965.91	27080.0
2012-11-14 13:00:00	NQ	Futures	2966.2	2974.34	2964.17	2971.14	20806.0
2012-11-14 14:00:00	NQ	Futures	2970.85	2974.34	2955.74	2956.91	33923.0
2012-11-14 15:00:00	NQ	Futures	2957.2	2958.07	2936.56	2941.21	60988.0
2012-11-14 16:00:00	NQ	Futures	2941.5	2944.41	2939.18	2943.25	7849.0
2012-11-14 17:00:00	NQ	Futures	2943.25	2943.25	2940.63	2941.21	152.0
2012-11-14 18:00:00	NQ	Futures	2941.8	2946.44	2941.5	2943.54	586.0
2012-11-14 19:00:00	NQ	Futures	2943.54	2943.83	2940.92	2941.8	711.0
2012-11-14 20:00:00	NQ	Futures	2941.8	2942.38	2936.86	2940.63	964.0
2012-11-14 21:00:00	NQ	Futures	2940.34	2945.28	2939.18	2944.99	670.0
2012-11-14 22:00:00	NQ	Futures	2944.99	2945.57	2942.38	2943.83	465.0
2012-11-14 23:00:00	NQ	Futures	2944.12	2945.28	2943.83	2944.41	157.0
2012-11-14 00:00:00	YM	Futures	12763.6	12770.6	12756.6	12770.6	365.0
2012-11-14 01:00:00	YM	Futures	12770.6	12774.6	12766.6	12773.6	407.0

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

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