PREVIEW / futures_1hour / 2011-02-07

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-02-07.parquet
  size:    47 KB
  rows:    1,442

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-07 00:00:00	ES	Futures	1294.79	1295.03	1293.8	1294.29	2750.0
2011-02-07 01:00:00	ES	Futures	1294.29	1295.28	1293.3	1294.29	4572.0
2011-02-07 02:00:00	ES	Futures	1294.29	1294.79	1292.81	1293.3	7461.0
2011-02-07 03:00:00	ES	Futures	1293.3	1299.24	1292.56	1298.99	34859.0
2011-02-07 04:00:00	ES	Futures	1298.99	1300.23	1298.0	1299.73	19661.0
2011-02-07 05:00:00	ES	Futures	1299.73	1300.23	1298.25	1298.25	14673.0
2011-02-07 06:00:00	ES	Futures	1298.25	1298.5	1297.01	1297.76	11799.0
2011-02-07 07:00:00	ES	Futures	1298.0	1298.0	1296.77	1297.51	21197.0
2011-02-07 08:00:00	ES	Futures	1297.26	1298.99	1296.77	1297.26	27339.0
2011-02-07 09:00:00	ES	Futures	1297.01	1300.97	1296.52	1299.73	189603.0
2011-02-07 10:00:00	ES	Futures	1299.73	1305.43	1299.73	1304.68	290833.0
2011-02-07 11:00:00	ES	Futures	1304.44	1306.41	1303.69	1304.68	196299.0
2011-02-07 12:00:00	ES	Futures	1304.68	1305.18	1303.2	1303.69	129051.0
2011-02-07 13:00:00	ES	Futures	1303.94	1304.93	1303.69	1304.44	83350.0
2011-02-07 14:00:00	ES	Futures	1304.68	1304.93	1300.97	1302.21	123480.0
2011-02-07 15:00:00	ES	Futures	1301.96	1303.45	1299.73	1301.96	242148.0
2011-02-07 16:00:00	ES	Futures	1301.96	1303.69	1300.48	1300.97	88774.0
2011-02-07 17:00:00	ES	Futures	1300.72	1301.22	1300.72	1301.22	1622.0
2011-02-07 18:00:00	ES	Futures	1301.22	1302.46	1300.97	1302.21	2789.0
2011-02-07 19:00:00	ES	Futures	1302.46	1302.46	1300.97	1301.96	4812.0
2011-02-07 20:00:00	ES	Futures	1301.96	1302.21	1300.97	1301.47	2653.0
2011-02-07 21:00:00	ES	Futures	1301.47	1301.71	1300.97	1301.47	2343.0
2011-02-07 22:00:00	ES	Futures	1301.47	1301.96	1301.22	1301.96	740.0
2011-02-07 23:00:00	ES	Futures	1301.96	1303.2	1301.47	1302.7	2985.0
2011-02-07 00:00:00	NQ	Futures	2683.47	2684.04	2682.61	2682.89	91.0
2011-02-07 01:00:00	NQ	Futures	2682.89	2686.91	2680.88	2685.19	687.0
2011-02-07 02:00:00	NQ	Futures	2685.48	2686.05	2681.46	2682.61	861.0
2011-02-07 03:00:00	NQ	Futures	2682.89	2692.36	2681.46	2691.79	2131.0
2011-02-07 04:00:00	NQ	Futures	2692.08	2694.66	2690.36	2693.23	1626.0
2011-02-07 05:00:00	NQ	Futures	2693.51	2693.8	2690.93	2691.5	908.0
2011-02-07 06:00:00	NQ	Futures	2691.22	2691.5	2688.92	2689.78	594.0
2011-02-07 07:00:00	NQ	Futures	2689.49	2690.36	2685.76	2686.91	2030.0
2011-02-07 08:00:00	NQ	Futures	2686.62	2690.07	2684.9	2686.62	4312.0
2011-02-07 09:00:00	NQ	Futures	2686.91	2692.94	2682.89	2689.78	38183.0
2011-02-07 10:00:00	NQ	Futures	2689.78	2700.98	2689.78	2699.83	49326.0
2011-02-07 11:00:00	NQ	Futures	2699.83	2708.44	2699.83	2703.85	33848.0
2011-02-07 12:00:00	NQ	Futures	2704.13	2709.3	2702.7	2705.57	16424.0
2011-02-07 13:00:00	NQ	Futures	2705.57	2708.44	2702.12	2704.42	17570.0
2011-02-07 14:00:00	NQ	Futures	2704.71	2705.28	2690.36	2694.09	29720.0
2011-02-07 15:00:00	NQ	Futures	2693.8	2698.97	2690.07	2694.37	31372.0
2011-02-07 16:00:00	NQ	Futures	2694.37	2697.24	2688.63	2688.92	12247.0
2011-02-07 17:00:00	NQ	Futures	2688.92	2690.07	2688.06	2689.78	105.0
2011-02-07 18:00:00	NQ	Futures	2689.49	2692.65	2689.49	2692.65	186.0
2011-02-07 19:00:00	NQ	Futures	2692.65	2692.65	2690.64	2692.36	173.0
2011-02-07 20:00:00	NQ	Futures	2692.65	2692.94	2690.07	2690.93	267.0
2011-02-07 21:00:00	NQ	Futures	2691.22	2691.79	2689.78	2691.5	149.0
2011-02-07 22:00:00	NQ	Futures	2691.5	2692.94	2691.22	2692.65	61.0
2011-02-07 23:00:00	NQ	Futures	2692.65	2694.09	2691.22	2693.23	199.0
2011-02-07 00:00:00	YM	Futures	11544.2	11546.1	11537.4	11539.4	116.0
2011-02-07 01:00:00	YM	Futures	11538.4	11548.9	11533.6	11543.2	406.0

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

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