PREVIEW / futures_1hour / 2012-02-09

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-02-09.parquet
  size:    49 KB
  rows:    1,500

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-02-09 00:00:00	ES	Futures	1356.45	1357.46	1355.95	1356.2	4992.0
2012-02-09 01:00:00	ES	Futures	1356.45	1357.96	1356.2	1356.2	4604.0
2012-02-09 02:00:00	ES	Futures	1356.2	1358.22	1354.94	1355.44	10757.0
2012-02-09 03:00:00	ES	Futures	1355.7	1358.22	1352.67	1357.46	31571.0
2012-02-09 04:00:00	ES	Futures	1357.21	1359.98	1356.45	1356.7	32989.0
2012-02-09 05:00:00	ES	Futures	1356.7	1357.46	1354.44	1355.19	22327.0
2012-02-09 06:00:00	ES	Futures	1355.19	1356.45	1353.68	1354.44	16722.0
2012-02-09 07:00:00	ES	Futures	1354.44	1356.7	1353.68	1356.2	23060.0
2012-02-09 08:00:00	ES	Futures	1356.2	1363.51	1355.44	1358.97	128292.0
2012-02-09 09:00:00	ES	Futures	1359.22	1360.99	1356.7	1358.97	218572.0
2012-02-09 10:00:00	ES	Futures	1359.22	1359.98	1351.66	1355.95	412694.0
2012-02-09 11:00:00	ES	Futures	1355.95	1358.97	1354.18	1358.97	249350.0
2012-02-09 12:00:00	ES	Futures	1358.72	1360.74	1358.22	1360.48	115833.0
2012-02-09 13:00:00	ES	Futures	1360.23	1362.0	1359.22	1360.99	126181.0
2012-02-09 14:00:00	ES	Futures	1360.99	1362.0	1360.23	1360.48	75238.0
2012-02-09 15:00:00	ES	Futures	1360.23	1361.74	1358.72	1359.48	153378.0
2012-02-09 16:00:00	ES	Futures	1359.48	1360.48	1357.96	1358.22	61518.0
2012-02-09 17:00:00	ES	Futures	1358.47	1358.47	1357.21	1357.96	3423.0
2012-02-09 18:00:00	ES	Futures	1357.46	1357.96	1356.7	1357.21	4247.0
2012-02-09 19:00:00	ES	Futures	1357.46	1357.71	1356.2	1356.96	4388.0
2012-02-09 20:00:00	ES	Futures	1356.96	1356.96	1354.94	1354.94	6286.0
2012-02-09 21:00:00	ES	Futures	1354.94	1355.44	1354.18	1354.44	4829.0
2012-02-09 22:00:00	ES	Futures	1354.44	1354.94	1353.18	1353.93	4979.0
2012-02-09 23:00:00	ES	Futures	1353.93	1354.18	1352.67	1352.92	3794.0
2012-02-09 00:00:00	NQ	Futures	2939.1	2939.97	2937.95	2938.23	236.0
2012-02-09 01:00:00	NQ	Futures	2938.23	2941.12	2938.23	2938.23	309.0
2012-02-09 02:00:00	NQ	Futures	2938.52	2940.83	2935.92	2937.37	723.0
2012-02-09 03:00:00	NQ	Futures	2937.08	2941.12	2931.01	2940.26	2807.0
2012-02-09 04:00:00	NQ	Futures	2940.26	2944.3	2937.08	2937.08	2648.0
2012-02-09 05:00:00	NQ	Futures	2937.37	2938.52	2933.32	2934.48	1390.0
2012-02-09 06:00:00	NQ	Futures	2934.77	2937.08	2931.59	2933.9	1026.0
2012-02-09 07:00:00	NQ	Futures	2933.9	2937.95	2931.88	2936.79	2328.0
2012-02-09 08:00:00	NQ	Futures	2936.79	2949.21	2935.06	2943.43	13030.0
2012-02-09 09:00:00	NQ	Futures	2943.72	2951.23	2938.23	2945.17	43391.0
2012-02-09 10:00:00	NQ	Futures	2945.17	2948.92	2931.88	2946.03	53418.0
2012-02-09 11:00:00	NQ	Futures	2946.32	2954.7	2944.88	2953.83	30565.0
2012-02-09 12:00:00	NQ	Futures	2953.83	2960.18	2953.54	2958.16	21771.0
2012-02-09 13:00:00	NQ	Futures	2958.45	2962.2	2954.41	2959.03	18342.0
2012-02-09 14:00:00	NQ	Futures	2959.03	2962.2	2957.01	2959.61	11707.0
2012-02-09 15:00:00	NQ	Futures	2959.61	2963.07	2956.72	2959.89	26917.0
2012-02-09 16:00:00	NQ	Futures	2959.61	2961.63	2957.3	2957.58	5959.0
2012-02-09 17:00:00	NQ	Futures	2957.3	2957.87	2956.43	2956.72	122.0
2012-02-09 18:00:00	NQ	Futures	2957.01	2958.16	2955.85	2957.58	361.0
2012-02-09 19:00:00	NQ	Futures	2957.3	2957.87	2954.98	2956.43	317.0
2012-02-09 20:00:00	NQ	Futures	2956.14	2956.72	2952.96	2953.25	541.0
2012-02-09 21:00:00	NQ	Futures	2952.96	2953.83	2951.81	2952.39	449.0
2012-02-09 22:00:00	NQ	Futures	2952.39	2952.96	2950.36	2951.23	470.0
2012-02-09 23:00:00	NQ	Futures	2951.23	2951.52	2949.21	2949.5	217.0
2012-02-09 00:00:00	YM	Futures	12720.2	12725.2	12714.3	12718.2	227.0
2012-02-09 01:00:00	YM	Futures	12718.2	12731.1	12715.3	12717.3	240.0

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

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