PREVIEW / futures_1hour / 2011-03-08

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-03-08.parquet
  size:    48 KB
  rows:    1,455

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
2011-03-08 00:00:00	ES	Futures	1300.72	1300.72	1299.49	1299.73	2973.0
2011-03-08 01:00:00	ES	Futures	1299.98	1303.94	1299.49	1302.95	13878.0
2011-03-08 02:00:00	ES	Futures	1302.95	1304.44	1302.21	1303.69	15771.0
2011-03-08 03:00:00	ES	Futures	1303.69	1304.93	1299.49	1303.2	33044.0
2011-03-08 04:00:00	ES	Futures	1303.2	1304.93	1300.72	1301.47	20750.0
2011-03-08 05:00:00	ES	Futures	1301.47	1301.96	1298.5	1300.97	23213.0
2011-03-08 06:00:00	ES	Futures	1301.22	1302.21	1299.24	1300.23	14269.0
2011-03-08 07:00:00	ES	Futures	1300.23	1300.48	1296.27	1297.76	46860.0
2011-03-08 08:00:00	ES	Futures	1297.76	1298.99	1294.54	1296.52	88059.0
2011-03-08 09:00:00	ES	Futures	1296.52	1299.49	1292.56	1297.76	315323.0
2011-03-08 10:00:00	ES	Futures	1298.0	1305.43	1297.76	1304.19	457560.0
2011-03-08 11:00:00	ES	Futures	1304.44	1311.36	1302.46	1311.12	326476.0
2011-03-08 12:00:00	ES	Futures	1311.36	1312.11	1308.15	1308.89	156657.0
2011-03-08 13:00:00	ES	Futures	1308.89	1310.37	1308.39	1309.63	74257.0
2011-03-08 14:00:00	ES	Futures	1309.63	1310.37	1305.67	1309.88	167755.0
2011-03-08 15:00:00	ES	Futures	1309.63	1311.12	1307.4	1307.9	196537.0
2011-03-08 16:00:00	ES	Futures	1307.9	1308.39	1305.18	1306.66	109868.0
2011-03-08 17:00:00	ES	Futures	1306.66	1307.16	1306.17	1306.41	2963.0
2011-03-08 18:00:00	ES	Futures	1306.66	1307.9	1305.67	1307.65	5533.0
2011-03-08 19:00:00	ES	Futures	1307.4	1307.65	1305.92	1306.41	5517.0
2011-03-08 20:00:00	ES	Futures	1306.17	1307.9	1305.43	1307.4	6318.0
2011-03-08 21:00:00	ES	Futures	1307.65	1307.65	1306.17	1306.41	2435.0
2011-03-08 22:00:00	ES	Futures	1306.66	1306.66	1305.43	1305.67	3140.0
2011-03-08 23:00:00	ES	Futures	1305.92	1305.92	1303.69	1303.94	6684.0
2011-03-08 00:00:00	NQ	Futures	2678.3	2678.3	2674.57	2675.43	730.0
2011-03-08 01:00:00	NQ	Futures	2675.72	2681.74	2674.28	2680.6	1727.0
2011-03-08 02:00:00	NQ	Futures	2680.6	2682.61	2677.44	2681.74	1760.0
2011-03-08 03:00:00	NQ	Futures	2681.74	2684.33	2671.7	2679.16	3688.0
2011-03-08 04:00:00	NQ	Futures	2678.87	2686.62	2673.71	2675.14	2497.0
2011-03-08 05:00:00	NQ	Futures	2675.14	2676.58	2669.4	2674.86	1216.0
2011-03-08 06:00:00	NQ	Futures	2674.86	2679.45	2671.99	2673.42	2415.0
2011-03-08 07:00:00	NQ	Futures	2673.71	2673.99	2664.52	2668.54	6535.0
2011-03-08 08:00:00	NQ	Futures	2668.54	2670.55	2659.36	2664.81	11724.0
2011-03-08 09:00:00	NQ	Futures	2664.81	2671.41	2652.75	2666.82	48295.0
2011-03-08 10:00:00	NQ	Futures	2666.82	2686.05	2666.82	2682.03	82036.0
2011-03-08 11:00:00	NQ	Futures	2682.32	2694.66	2677.44	2693.8	50900.0
2011-03-08 12:00:00	NQ	Futures	2693.8	2695.81	2691.5	2692.36	41608.0
2011-03-08 13:00:00	NQ	Futures	2692.65	2694.66	2690.93	2692.65	17123.0
2011-03-08 14:00:00	NQ	Futures	2692.36	2693.23	2678.59	2689.78	44022.0
2011-03-08 15:00:00	NQ	Futures	2689.78	2693.23	2682.89	2683.18	31622.0
2011-03-08 16:00:00	NQ	Futures	2683.47	2683.47	2676.29	2678.3	11918.0
2011-03-08 17:00:00	NQ	Futures	2678.01	2679.73	2677.44	2678.87	496.0
2011-03-08 18:00:00	NQ	Futures	2678.59	2680.31	2676.58	2679.45	662.0
2011-03-08 19:00:00	NQ	Futures	2679.45	2679.73	2676.58	2678.59	409.0
2011-03-08 20:00:00	NQ	Futures	2678.3	2680.6	2677.15	2679.45	794.0
2011-03-08 21:00:00	NQ	Futures	2679.45	2680.02	2677.44	2677.44	101.0
2011-03-08 22:00:00	NQ	Futures	2677.44	2678.01	2674.28	2675.43	370.0
2011-03-08 23:00:00	NQ	Futures	2676.0	2676.0	2671.12	2672.56	291.0
2011-03-08 00:00:00	YM	Futures	11605.4	11607.4	11594.9	11597.8	144.0
2011-03-08 01:00:00	YM	Futures	11598.7	11627.5	11594.0	11621.7	635.0

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

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