PREVIEW / futures_1hour / 2011-02-10

all futures 1-hour files

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

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-10 00:00:00	ES	Futures	1305.67	1306.17	1303.2	1304.68	12813.0
2011-02-10 01:00:00	ES	Futures	1304.68	1305.18	1303.45	1303.94	5383.0
2011-02-10 02:00:00	ES	Futures	1303.94	1304.19	1301.96	1302.46	13830.0
2011-02-10 03:00:00	ES	Futures	1302.21	1302.7	1298.74	1299.73	33655.0
2011-02-10 04:00:00	ES	Futures	1299.73	1299.98	1296.52	1296.77	39340.0
2011-02-10 05:00:00	ES	Futures	1297.01	1299.73	1296.52	1299.49	25008.0
2011-02-10 06:00:00	ES	Futures	1299.24	1299.49	1297.01	1297.51	18597.0
2011-02-10 07:00:00	ES	Futures	1297.51	1299.49	1297.51	1298.5	20982.0
2011-02-10 08:00:00	ES	Futures	1298.5	1300.23	1297.01	1297.76	64013.0
2011-02-10 09:00:00	ES	Futures	1297.76	1300.72	1295.28	1297.76	274629.0
2011-02-10 10:00:00	ES	Futures	1297.51	1303.69	1295.03	1300.72	413904.0
2011-02-10 11:00:00	ES	Futures	1300.72	1305.67	1300.48	1304.19	204896.0
2011-02-10 12:00:00	ES	Futures	1304.19	1305.18	1302.46	1302.7	128670.0
2011-02-10 13:00:00	ES	Futures	1302.7	1303.69	1300.97	1302.21	140464.0
2011-02-10 14:00:00	ES	Futures	1302.46	1304.93	1301.47	1302.21	125234.0
2011-02-10 15:00:00	ES	Futures	1302.46	1306.91	1301.71	1305.67	398793.0
2011-02-10 16:00:00	ES	Futures	1305.92	1305.92	1300.72	1300.97	111536.0
2011-02-10 17:00:00	ES	Futures	1301.22	1301.22	1299.98	1300.72	5492.0
2011-02-10 18:00:00	ES	Futures	1301.22	1301.71	1300.23	1301.47	7083.0
2011-02-10 19:00:00	ES	Futures	1301.47	1302.46	1300.72	1300.97	5534.0
2011-02-10 20:00:00	ES	Futures	1301.22	1301.22	1298.99	1300.48	5524.0
2011-02-10 21:00:00	ES	Futures	1300.23	1302.46	1299.49	1301.71	5423.0
2011-02-10 22:00:00	ES	Futures	1301.96	1302.21	1300.97	1301.22	2692.0
2011-02-10 23:00:00	ES	Futures	1301.47	1301.71	1299.98	1300.97	4221.0
2011-02-10 00:00:00	NQ	Futures	2700.98	2701.55	2697.24	2698.68	552.0
2011-02-10 01:00:00	NQ	Futures	2698.97	2699.83	2697.24	2698.39	390.0
2011-02-10 02:00:00	NQ	Futures	2698.39	2698.39	2696.1	2696.38	853.0
2011-02-10 03:00:00	NQ	Futures	2696.67	2698.1	2690.07	2690.64	2812.0
2011-02-10 04:00:00	NQ	Futures	2690.64	2690.93	2684.61	2685.19	2432.0
2011-02-10 05:00:00	NQ	Futures	2685.19	2690.07	2684.61	2688.92	1910.0
2011-02-10 06:00:00	NQ	Futures	2688.63	2689.49	2686.34	2689.21	2946.0
2011-02-10 07:00:00	NQ	Futures	2689.21	2692.36	2688.63	2689.49	4079.0
2011-02-10 08:00:00	NQ	Futures	2689.49	2694.09	2687.2	2687.77	6394.0
2011-02-10 09:00:00	NQ	Futures	2688.06	2694.66	2686.62	2690.36	46002.0
2011-02-10 10:00:00	NQ	Futures	2690.36	2709.87	2686.62	2705.57	56117.0
2011-02-10 11:00:00	NQ	Futures	2705.57	2715.04	2704.13	2713.32	30649.0
2011-02-10 12:00:00	NQ	Futures	2713.32	2715.33	2708.73	2710.73	20070.0
2011-02-10 13:00:00	NQ	Futures	2710.73	2712.46	2697.53	2704.71	47199.0
2011-02-10 14:00:00	NQ	Futures	2704.71	2713.32	2701.84	2706.14	23244.0
2011-02-10 15:00:00	NQ	Futures	2706.43	2714.47	2702.98	2712.74	70171.0
2011-02-10 16:00:00	NQ	Futures	2712.74	2712.74	2703.56	2703.85	11732.0
2011-02-10 17:00:00	NQ	Futures	2703.85	2704.71	2702.12	2704.42	494.0
2011-02-10 18:00:00	NQ	Futures	2704.42	2705.57	2703.56	2705.28	557.0
2011-02-10 19:00:00	NQ	Futures	2705.57	2707.0	2703.85	2704.99	311.0
2011-02-10 20:00:00	NQ	Futures	2704.71	2704.99	2700.4	2703.56	411.0
2011-02-10 21:00:00	NQ	Futures	2703.56	2708.44	2701.84	2707.0	550.0
2011-02-10 22:00:00	NQ	Futures	2707.0	2707.58	2704.71	2705.28	112.0
2011-02-10 23:00:00	NQ	Futures	2704.71	2706.72	2703.56	2704.71	267.0
2011-02-10 00:00:00	YM	Futures	11692.6	11693.6	11675.4	11684.9	505.0
2011-02-10 01:00:00	YM	Futures	11684.0	11687.8	11679.2	11681.1	234.0

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

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