PREVIEW / futures_1hour / 2012-07-26

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-07-26.parquet
  size:    50 KB
  rows:    1,489

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-07-26 00:00:00	ES	Futures	1355.59	1357.11	1355.33	1356.86	2138.0
2012-07-26 01:00:00	ES	Futures	1356.86	1358.13	1356.09	1357.37	5142.0
2012-07-26 02:00:00	ES	Futures	1357.37	1359.4	1356.6	1358.89	10253.0
2012-07-26 03:00:00	ES	Futures	1358.89	1358.89	1355.84	1357.37	32558.0
2012-07-26 04:00:00	ES	Futures	1357.37	1358.13	1352.53	1353.3	29903.0
2012-07-26 05:00:00	ES	Futures	1353.3	1353.81	1350.5	1352.03	29280.0
2012-07-26 06:00:00	ES	Futures	1352.03	1367.79	1351.77	1366.52	120716.0
2012-07-26 07:00:00	ES	Futures	1366.52	1377.71	1366.52	1372.62	144254.0
2012-07-26 08:00:00	ES	Futures	1372.62	1377.2	1372.11	1374.91	116350.0
2012-07-26 09:00:00	ES	Futures	1374.91	1380.0	1373.13	1376.94	332431.0
2012-07-26 10:00:00	ES	Futures	1376.94	1380.25	1372.37	1374.4	430419.0
2012-07-26 11:00:00	ES	Futures	1374.4	1374.66	1369.82	1371.1	262453.0
2012-07-26 12:00:00	ES	Futures	1370.84	1374.91	1369.57	1374.4	106232.0
2012-07-26 13:00:00	ES	Futures	1374.66	1377.96	1373.89	1374.91	118214.0
2012-07-26 14:00:00	ES	Futures	1375.16	1378.47	1374.4	1377.45	113355.0
2012-07-26 15:00:00	ES	Futures	1377.2	1382.03	1376.44	1378.22	284756.0
2012-07-26 16:00:00	ES	Futures	1378.47	1380.76	1376.69	1378.22	114327.0
2012-07-26 17:00:00	ES	Futures	1377.96	1380.0	1377.96	1379.49	1716.0
2012-07-26 18:00:00	ES	Futures	1379.23	1379.23	1377.45	1378.72	3081.0
2012-07-26 19:00:00	ES	Futures	1378.47	1378.72	1377.45	1377.96	1893.0
2012-07-26 20:00:00	ES	Futures	1377.96	1378.22	1376.44	1377.2	4378.0
2012-07-26 21:00:00	ES	Futures	1377.2	1378.72	1376.94	1378.22	3380.0
2012-07-26 22:00:00	ES	Futures	1378.47	1381.52	1378.22	1381.27	5254.0
2012-07-26 23:00:00	ES	Futures	1381.27	1382.28	1380.25	1381.52	4399.0
2012-07-26 00:00:00	NQ	Futures	2946.39	2950.74	2946.39	2949.87	482.0
2012-07-26 01:00:00	NQ	Futures	2949.58	2952.77	2948.42	2949.87	722.0
2012-07-26 02:00:00	NQ	Futures	2950.16	2953.64	2948.71	2952.19	1478.0
2012-07-26 03:00:00	NQ	Futures	2951.9	2951.9	2944.65	2947.84	3738.0
2012-07-26 04:00:00	NQ	Futures	2947.84	2949.87	2936.82	2938.27	4263.0
2012-07-26 05:00:00	NQ	Futures	2938.56	2940.59	2933.35	2936.24	3536.0
2012-07-26 06:00:00	NQ	Futures	2936.24	2973.35	2934.8	2968.13	14114.0
2012-07-26 07:00:00	NQ	Futures	2968.42	2993.35	2968.42	2985.53	11392.0
2012-07-26 08:00:00	NQ	Futures	2985.24	2993.35	2984.37	2986.97	12168.0
2012-07-26 09:00:00	NQ	Futures	2986.97	3007.27	2983.5	2994.22	52410.0
2012-07-26 10:00:00	NQ	Futures	2993.64	3005.53	2980.31	2986.97	57315.0
2012-07-26 11:00:00	NQ	Futures	2986.97	2989.29	2971.03	2975.09	31939.0
2012-07-26 12:00:00	NQ	Futures	2974.8	2984.37	2970.74	2982.92	16737.0
2012-07-26 13:00:00	NQ	Futures	2982.92	2992.48	2981.18	2981.47	15863.0
2012-07-26 14:00:00	NQ	Futures	2981.76	2992.19	2980.89	2988.71	14513.0
2012-07-26 15:00:00	NQ	Futures	2988.42	3000.6	2986.1	2989.0	32041.0
2012-07-26 16:00:00	NQ	Futures	2989.0	2990.74	2981.76	2986.1	13455.0
2012-07-26 17:00:00	NQ	Futures	2986.1	2989.0	2985.53	2988.42	145.0
2012-07-26 18:00:00	NQ	Futures	2988.42	2988.42	2985.82	2986.97	264.0
2012-07-26 19:00:00	NQ	Futures	2986.97	2987.55	2985.82	2986.39	202.0
2012-07-26 20:00:00	NQ	Futures	2986.68	2987.26	2983.21	2985.24	541.0
2012-07-26 21:00:00	NQ	Futures	2985.24	2988.71	2984.66	2987.84	477.0
2012-07-26 22:00:00	NQ	Futures	2988.13	2995.38	2988.13	2994.8	897.0
2012-07-26 23:00:00	NQ	Futures	2994.51	2995.38	2991.9	2993.35	653.0
2012-07-26 00:00:00	YM	Futures	12551.4	12566.3	12551.4	12564.3	199.0
2012-07-26 01:00:00	YM	Futures	12563.3	12579.2	12559.3	12568.3	703.0

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

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