PREVIEW / futures_1hour / 2012-02-13

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-02-13.parquet
  size:    47 KB
  rows:    1,448

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-13 00:00:00	ES	Futures	1357.96	1358.72	1357.21	1357.21	2718.0
2012-02-13 01:00:00	ES	Futures	1357.21	1357.71	1356.7	1356.7	2983.0
2012-02-13 02:00:00	ES	Futures	1356.45	1359.73	1356.2	1357.71	14753.0
2012-02-13 03:00:00	ES	Futures	1357.71	1363.0	1357.46	1362.0	48768.0
2012-02-13 04:00:00	ES	Futures	1362.0	1362.5	1358.47	1359.48	29063.0
2012-02-13 05:00:00	ES	Futures	1359.48	1360.48	1357.96	1360.48	17952.0
2012-02-13 06:00:00	ES	Futures	1360.23	1360.74	1359.48	1359.48	12474.0
2012-02-13 07:00:00	ES	Futures	1359.73	1361.74	1359.48	1361.49	19333.0
2012-02-13 08:00:00	ES	Futures	1361.49	1361.74	1358.72	1359.48	37575.0
2012-02-13 09:00:00	ES	Futures	1359.48	1360.74	1356.45	1357.71	159161.0
2012-02-13 10:00:00	ES	Futures	1357.71	1358.97	1353.43	1356.2	257083.0
2012-02-13 11:00:00	ES	Futures	1356.45	1358.22	1355.7	1357.46	145682.0
2012-02-13 12:00:00	ES	Futures	1357.46	1358.22	1355.44	1357.71	67246.0
2012-02-13 13:00:00	ES	Futures	1357.71	1360.23	1357.71	1359.48	75187.0
2012-02-13 14:00:00	ES	Futures	1359.22	1361.49	1358.97	1360.48	64475.0
2012-02-13 15:00:00	ES	Futures	1360.23	1360.74	1358.22	1359.48	145009.0
2012-02-13 16:00:00	ES	Futures	1359.48	1360.48	1358.97	1359.73	77383.0
2012-02-13 17:00:00	ES	Futures	1359.98	1360.23	1359.73	1359.98	1958.0
2012-02-13 18:00:00	ES	Futures	1358.72	1358.72	1355.95	1356.7	12641.0
2012-02-13 19:00:00	ES	Futures	1356.96	1358.47	1356.45	1358.22	5063.0
2012-02-13 20:00:00	ES	Futures	1358.47	1358.47	1356.2	1356.7	4019.0
2012-02-13 21:00:00	ES	Futures	1356.45	1357.46	1355.44	1356.96	4302.0
2012-02-13 22:00:00	ES	Futures	1356.96	1357.46	1355.7	1357.46	3892.0
2012-02-13 23:00:00	ES	Futures	1357.46	1358.47	1355.95	1355.95	5205.0
2012-02-13 00:00:00	NQ	Futures	2959.03	2960.18	2957.3	2957.3	192.0
2012-02-13 01:00:00	NQ	Futures	2957.3	2958.16	2956.43	2956.72	227.0
2012-02-13 02:00:00	NQ	Futures	2956.43	2961.05	2955.85	2958.16	1052.0
2012-02-13 03:00:00	NQ	Futures	2958.16	2968.27	2957.87	2965.96	3082.0
2012-02-13 04:00:00	NQ	Futures	2966.54	2966.83	2960.76	2961.92	1549.0
2012-02-13 05:00:00	NQ	Futures	2961.63	2963.65	2959.03	2963.65	1074.0
2012-02-13 06:00:00	NQ	Futures	2963.94	2964.8	2961.34	2961.63	713.0
2012-02-13 07:00:00	NQ	Futures	2961.34	2966.25	2960.76	2965.67	1391.0
2012-02-13 08:00:00	NQ	Futures	2965.67	2965.96	2959.61	2961.63	3805.0
2012-02-13 09:00:00	NQ	Futures	2961.92	2964.23	2956.14	2962.49	28033.0
2012-02-13 10:00:00	NQ	Futures	2962.78	2965.67	2947.76	2953.83	35787.0
2012-02-13 11:00:00	NQ	Futures	2953.83	2963.36	2952.96	2960.18	22761.0
2012-02-13 12:00:00	NQ	Futures	2960.47	2963.36	2953.83	2959.03	13321.0
2012-02-13 13:00:00	NQ	Futures	2959.03	2964.8	2959.03	2963.07	11045.0
2012-02-13 14:00:00	NQ	Futures	2963.07	2970.29	2962.78	2967.11	13875.0
2012-02-13 15:00:00	NQ	Futures	2967.11	2967.98	2961.63	2965.67	17186.0
2012-02-13 16:00:00	NQ	Futures	2965.67	2968.56	2965.67	2967.4	6047.0
2012-02-13 17:00:00	NQ	Futures	2967.4	2967.4	2965.96	2966.83	191.0
2012-02-13 18:00:00	NQ	Futures	2965.67	2965.67	2961.34	2962.49	778.0
2012-02-13 19:00:00	NQ	Futures	2962.49	2965.67	2962.49	2965.09	409.0
2012-02-13 20:00:00	NQ	Futures	2965.09	2965.09	2961.63	2961.92	262.0
2012-02-13 21:00:00	NQ	Futures	2961.63	2963.07	2960.18	2962.78	346.0
2012-02-13 22:00:00	NQ	Futures	2962.78	2963.65	2960.76	2963.65	271.0
2012-02-13 23:00:00	NQ	Futures	2963.65	2965.96	2961.63	2961.92	343.0
2012-02-13 00:00:00	YM	Futures	12712.3	12717.3	12705.4	12705.4	204.0
2012-02-13 01:00:00	YM	Futures	12706.4	12708.3	12701.4	12701.4	206.0

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

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