PREVIEW / futures_1hour / 2011-02-08

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-02-08.parquet
  size:    49 KB
  rows:    1,492

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-02-08 00:00:00	ES	Futures	1302.46	1302.7	1301.71	1302.21	1452.0
2011-02-08 01:00:00	ES	Futures	1301.96	1303.45	1301.71	1303.2	2322.0
2011-02-08 02:00:00	ES	Futures	1303.2	1304.19	1301.96	1302.46	7941.0
2011-02-08 03:00:00	ES	Futures	1302.46	1304.19	1301.71	1303.69	20491.0
2011-02-08 04:00:00	ES	Futures	1303.69	1304.93	1303.2	1304.19	9237.0
2011-02-08 05:00:00	ES	Futures	1304.44	1306.17	1302.21	1302.46	28991.0
2011-02-08 06:00:00	ES	Futures	1302.46	1303.69	1301.47	1302.95	15672.0
2011-02-08 07:00:00	ES	Futures	1303.2	1303.2	1300.48	1302.21	28374.0
2011-02-08 08:00:00	ES	Futures	1302.46	1303.69	1300.97	1301.96	45302.0
2011-02-08 09:00:00	ES	Futures	1301.71	1303.45	1299.49	1302.95	223475.0
2011-02-08 10:00:00	ES	Futures	1302.95	1305.67	1302.7	1303.94	274091.0
2011-02-08 11:00:00	ES	Futures	1303.94	1305.92	1301.96	1305.43	205150.0
2011-02-08 12:00:00	ES	Futures	1305.43	1306.91	1304.44	1305.67	105987.0
2011-02-08 13:00:00	ES	Futures	1305.43	1305.67	1303.45	1304.44	80267.0
2011-02-08 14:00:00	ES	Futures	1304.44	1307.16	1304.19	1305.67	102687.0
2011-02-08 15:00:00	ES	Futures	1305.67	1308.64	1305.18	1307.9	193714.0
2011-02-08 16:00:00	ES	Futures	1307.9	1308.39	1307.4	1307.9	82028.0
2011-02-08 17:00:00	ES	Futures	1307.65	1308.15	1307.65	1308.15	1588.0
2011-02-08 18:00:00	ES	Futures	1307.9	1308.15	1307.65	1307.9	1913.0
2011-02-08 19:00:00	ES	Futures	1308.15	1308.39	1306.91	1306.91	5721.0
2011-02-08 20:00:00	ES	Futures	1307.16	1307.4	1306.17	1306.66	5221.0
2011-02-08 21:00:00	ES	Futures	1306.66	1307.16	1305.67	1306.17	4494.0
2011-02-08 22:00:00	ES	Futures	1305.92	1306.66	1305.18	1305.43	11429.0
2011-02-08 23:00:00	ES	Futures	1305.67	1305.92	1304.68	1304.93	6777.0
2011-02-08 00:00:00	NQ	Futures	2692.65	2693.23	2691.79	2692.36	69.0
2011-02-08 01:00:00	NQ	Futures	2692.94	2695.23	2692.08	2694.95	134.0
2011-02-08 02:00:00	NQ	Futures	2694.66	2696.96	2692.36	2692.65	292.0
2011-02-08 03:00:00	NQ	Futures	2692.94	2696.38	2691.79	2695.52	1013.0
2011-02-08 04:00:00	NQ	Futures	2695.81	2698.1	2694.95	2697.24	568.0
2011-02-08 05:00:00	NQ	Futures	2697.24	2702.12	2693.51	2694.66	3278.0
2011-02-08 06:00:00	NQ	Futures	2694.37	2695.81	2692.08	2693.8	1862.0
2011-02-08 07:00:00	NQ	Futures	2694.09	2694.09	2688.35	2692.08	3257.0
2011-02-08 08:00:00	NQ	Futures	2692.08	2695.52	2689.78	2690.93	10567.0
2011-02-08 09:00:00	NQ	Futures	2690.93	2701.26	2690.36	2700.69	31861.0
2011-02-08 10:00:00	NQ	Futures	2700.98	2705.57	2699.25	2699.54	31732.0
2011-02-08 11:00:00	NQ	Futures	2699.54	2703.56	2694.37	2703.56	16365.0
2011-02-08 12:00:00	NQ	Futures	2703.56	2706.43	2702.41	2704.42	11143.0
2011-02-08 13:00:00	NQ	Futures	2704.13	2704.71	2700.4	2702.12	12290.0
2011-02-08 14:00:00	NQ	Futures	2702.12	2709.3	2701.55	2706.43	20389.0
2011-02-08 15:00:00	NQ	Futures	2706.14	2714.18	2705.57	2713.6	32514.0
2011-02-08 16:00:00	NQ	Futures	2713.32	2714.18	2711.02	2712.46	7233.0
2011-02-08 17:00:00	NQ	Futures	2712.46	2713.32	2712.17	2713.32	222.0
2011-02-08 18:00:00	NQ	Futures	2713.03	2713.32	2712.46	2713.32	88.0
2011-02-08 19:00:00	NQ	Futures	2713.03	2713.32	2711.88	2712.17	622.0
2011-02-08 20:00:00	NQ	Futures	2712.17	2712.74	2710.16	2711.02	431.0
2011-02-08 21:00:00	NQ	Futures	2711.02	2711.88	2709.59	2710.16	250.0
2011-02-08 22:00:00	NQ	Futures	2710.16	2711.02	2708.15	2708.73	455.0
2011-02-08 23:00:00	NQ	Futures	2709.3	2709.59	2707.29	2707.86	329.0
2011-02-08 00:00:00	YM	Futures	11603.5	11605.4	11598.7	11599.7	44.0
2011-02-08 01:00:00	YM	Futures	11598.7	11609.3	11598.7	11609.3	63.0

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

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