PREVIEW / futures_1hour / 2011-02-28

all futures 1-hour files

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

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-28 00:00:00	ES	Futures	1302.7	1303.94	1302.46	1303.94	5923.0
2011-02-28 01:00:00	ES	Futures	1303.94	1304.68	1303.45	1304.68	6489.0
2011-02-28 02:00:00	ES	Futures	1304.44	1305.43	1302.7	1302.95	13106.0
2011-02-28 03:00:00	ES	Futures	1302.95	1303.45	1300.48	1302.21	30893.0
2011-02-28 04:00:00	ES	Futures	1302.46	1304.44	1300.97	1301.47	17252.0
2011-02-28 05:00:00	ES	Futures	1301.47	1304.19	1300.97	1301.96	20079.0
2011-02-28 06:00:00	ES	Futures	1302.21	1305.18	1301.71	1304.93	22602.0
2011-02-28 07:00:00	ES	Futures	1304.93	1312.11	1304.44	1310.87	81609.0
2011-02-28 08:00:00	ES	Futures	1310.87	1312.6	1310.13	1310.87	73186.0
2011-02-28 09:00:00	ES	Futures	1311.12	1314.09	1309.14	1312.35	213438.0
2011-02-28 10:00:00	ES	Futures	1312.11	1315.32	1311.61	1313.84	257630.0
2011-02-28 11:00:00	ES	Futures	1314.09	1314.33	1310.13	1311.12	185793.0
2011-02-28 12:00:00	ES	Futures	1310.87	1312.35	1308.15	1308.89	131775.0
2011-02-28 13:00:00	ES	Futures	1308.64	1308.89	1305.92	1306.41	161622.0
2011-02-28 14:00:00	ES	Futures	1306.41	1310.62	1305.67	1310.62	122581.0
2011-02-28 15:00:00	ES	Futures	1310.62	1313.84	1308.64	1313.59	337014.0
2011-02-28 16:00:00	ES	Futures	1313.34	1315.32	1312.35	1312.85	193250.0
2011-02-28 17:00:00	ES	Futures	1312.85	1313.1	1312.6	1312.6	1603.0
2011-02-28 18:00:00	ES	Futures	1312.85	1314.58	1312.6	1314.33	4344.0
2011-02-28 19:00:00	ES	Futures	1314.58	1316.06	1314.33	1315.32	13400.0
2011-02-28 20:00:00	ES	Futures	1315.57	1315.82	1314.09	1314.09	5411.0
2011-02-28 21:00:00	ES	Futures	1314.33	1315.32	1314.09	1314.83	2151.0
2011-02-28 22:00:00	ES	Futures	1314.83	1315.82	1314.33	1315.07	2614.0
2011-02-28 23:00:00	ES	Futures	1315.07	1315.57	1314.58	1314.83	2122.0
2011-02-28 00:00:00	NQ	Futures	2687.77	2688.92	2686.62	2688.92	454.0
2011-02-28 01:00:00	NQ	Futures	2688.92	2690.64	2688.63	2690.07	282.0
2011-02-28 02:00:00	NQ	Futures	2690.64	2694.09	2688.63	2688.92	1604.0
2011-02-28 03:00:00	NQ	Futures	2688.63	2691.22	2685.19	2687.77	2856.0
2011-02-28 04:00:00	NQ	Futures	2688.06	2691.79	2686.91	2686.91	1409.0
2011-02-28 05:00:00	NQ	Futures	2687.2	2692.94	2686.62	2688.06	1493.0
2011-02-28 06:00:00	NQ	Futures	2688.35	2696.38	2687.77	2695.81	1244.0
2011-02-28 07:00:00	NQ	Futures	2695.52	2707.29	2695.23	2705.57	6372.0
2011-02-28 08:00:00	NQ	Futures	2705.28	2709.01	2702.98	2704.42	10589.0
2011-02-28 09:00:00	NQ	Futures	2704.42	2713.03	2702.12	2708.15	32764.0
2011-02-28 10:00:00	NQ	Futures	2707.86	2712.17	2704.13	2708.15	34435.0
2011-02-28 11:00:00	NQ	Futures	2708.15	2708.73	2696.67	2700.11	27167.0
2011-02-28 12:00:00	NQ	Futures	2700.11	2701.55	2689.21	2690.36	18439.0
2011-02-28 13:00:00	NQ	Futures	2690.36	2691.5	2684.9	2686.34	26589.0
2011-02-28 14:00:00	NQ	Futures	2686.34	2694.66	2684.04	2693.8	17219.0
2011-02-28 15:00:00	NQ	Futures	2693.51	2700.11	2689.21	2699.54	32383.0
2011-02-28 16:00:00	NQ	Futures	2699.54	2705.85	2698.1	2700.98	14414.0
2011-02-28 17:00:00	NQ	Futures	2700.98	2702.7	2700.69	2700.98	174.0
2011-02-28 18:00:00	NQ	Futures	2701.55	2703.85	2700.69	2703.85	306.0
2011-02-28 19:00:00	NQ	Futures	2703.85	2706.43	2703.56	2703.85	795.0
2011-02-28 20:00:00	NQ	Futures	2703.85	2704.13	2700.11	2700.11	410.0
2011-02-28 21:00:00	NQ	Futures	2700.98	2702.98	2700.4	2702.41	123.0
2011-02-28 22:00:00	NQ	Futures	2702.7	2704.42	2701.55	2703.27	145.0
2011-02-28 23:00:00	NQ	Futures	2703.56	2703.56	2702.41	2702.41	80.0
2011-02-28 00:00:00	YM	Futures	11582.5	11599.7	11581.5	11598.7	437.0
2011-02-28 01:00:00	YM	Futures	11599.7	11614.1	11593.0	11614.1	1549.0

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

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