PREVIEW / futures_1hour / 2011-02-09

all futures 1-hour files

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

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-09 00:00:00	ES	Futures	1304.93	1306.17	1304.44	1304.93	4238.0
2011-02-09 01:00:00	ES	Futures	1305.18	1305.67	1304.44	1305.43	2824.0
2011-02-09 02:00:00	ES	Futures	1305.67	1305.67	1303.94	1304.19	7777.0
2011-02-09 03:00:00	ES	Futures	1303.94	1306.91	1303.94	1304.93	23126.0
2011-02-09 04:00:00	ES	Futures	1304.93	1305.43	1303.45	1304.19	16478.0
2011-02-09 05:00:00	ES	Futures	1304.44	1305.67	1302.7	1302.95	18447.0
2011-02-09 06:00:00	ES	Futures	1302.7	1303.69	1302.46	1303.69	18526.0
2011-02-09 07:00:00	ES	Futures	1303.45	1304.93	1302.95	1303.69	17997.0
2011-02-09 08:00:00	ES	Futures	1303.69	1304.44	1302.46	1303.69	32707.0
2011-02-09 09:00:00	ES	Futures	1303.69	1305.92	1303.2	1305.43	169517.0
2011-02-09 10:00:00	ES	Futures	1305.67	1308.39	1304.93	1306.66	260511.0
2011-02-09 11:00:00	ES	Futures	1306.66	1307.16	1300.97	1301.22	331735.0
2011-02-09 12:00:00	ES	Futures	1301.22	1303.94	1300.48	1302.46	168760.0
2011-02-09 13:00:00	ES	Futures	1302.46	1305.18	1302.21	1302.95	115534.0
2011-02-09 14:00:00	ES	Futures	1303.2	1303.2	1298.25	1299.73	251209.0
2011-02-09 15:00:00	ES	Futures	1299.73	1305.18	1299.24	1305.18	241802.0
2011-02-09 16:00:00	ES	Futures	1305.18	1307.16	1304.19	1305.18	114366.0
2011-02-09 17:00:00	ES	Futures	1304.93	1305.18	1303.94	1303.94	4599.0
2011-02-09 18:00:00	ES	Futures	1303.94	1304.44	1303.69	1303.94	4293.0
2011-02-09 19:00:00	ES	Futures	1303.94	1303.94	1302.95	1303.2	6027.0
2011-02-09 20:00:00	ES	Futures	1303.45	1305.67	1303.2	1305.67	6554.0
2011-02-09 21:00:00	ES	Futures	1305.67	1306.41	1304.93	1306.41	6391.0
2011-02-09 22:00:00	ES	Futures	1306.17	1306.41	1305.92	1306.17	2944.0
2011-02-09 23:00:00	ES	Futures	1306.41	1306.66	1305.67	1305.67	2674.0
2011-02-09 00:00:00	NQ	Futures	2707.86	2709.59	2706.72	2707.29	253.0
2011-02-09 01:00:00	NQ	Futures	2707.86	2709.01	2706.72	2709.01	134.0
2011-02-09 02:00:00	NQ	Futures	2709.01	2709.3	2706.14	2706.43	408.0
2011-02-09 03:00:00	NQ	Futures	2706.43	2711.31	2705.57	2707.86	1036.0
2011-02-09 04:00:00	NQ	Futures	2708.15	2709.3	2704.99	2706.14	1066.0
2011-02-09 05:00:00	NQ	Futures	2706.14	2708.73	2702.98	2703.56	882.0
2011-02-09 06:00:00	NQ	Futures	2703.56	2704.99	2702.98	2704.99	1334.0
2011-02-09 07:00:00	NQ	Futures	2704.99	2706.72	2702.7	2704.42	1829.0
2011-02-09 08:00:00	NQ	Futures	2704.42	2706.72	2702.7	2704.99	4245.0
2011-02-09 09:00:00	NQ	Futures	2705.28	2712.74	2704.42	2711.02	23489.0
2011-02-09 10:00:00	NQ	Futures	2710.73	2715.9	2707.58	2713.32	32383.0
2011-02-09 11:00:00	NQ	Futures	2713.32	2714.75	2703.27	2705.28	33065.0
2011-02-09 12:00:00	NQ	Futures	2705.57	2712.46	2704.42	2708.73	18732.0
2011-02-09 13:00:00	NQ	Futures	2708.44	2714.18	2708.15	2710.45	12354.0
2011-02-09 14:00:00	NQ	Futures	2710.45	2710.45	2698.68	2701.84	31523.0
2011-02-09 15:00:00	NQ	Futures	2701.84	2709.01	2701.55	2707.86	22677.0
2011-02-09 16:00:00	NQ	Futures	2707.86	2713.89	2702.41	2704.71	13148.0
2011-02-09 17:00:00	NQ	Futures	2704.99	2704.99	2697.82	2698.68	2153.0
2011-02-09 18:00:00	NQ	Futures	2698.97	2700.98	2698.68	2700.4	551.0
2011-02-09 19:00:00	NQ	Futures	2700.69	2701.26	2699.25	2699.25	489.0
2011-02-09 20:00:00	NQ	Futures	2699.83	2702.98	2699.83	2701.84	727.0
2011-02-09 21:00:00	NQ	Futures	2701.84	2703.27	2700.69	2701.84	604.0
2011-02-09 22:00:00	NQ	Futures	2701.84	2702.12	2700.98	2701.55	385.0
2011-02-09 23:00:00	NQ	Futures	2702.12	2702.12	2700.98	2700.98	254.0
2011-02-09 00:00:00	YM	Futures	11663.9	11672.5	11661.0	11668.7	191.0
2011-02-09 01:00:00	YM	Futures	11666.7	11672.5	11662.9	11670.6	252.0

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

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