PREVIEW / futures_1hour / 2011-02-22

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-02-22.parquet
  size:    50 KB
  rows:    1,490

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-22 00:00:00	ES	Futures	1313.34	1314.83	1312.85	1313.1	4922.0
2011-02-22 01:00:00	ES	Futures	1313.1	1313.1	1311.86	1312.11	7263.0
2011-02-22 02:00:00	ES	Futures	1312.11	1312.35	1310.37	1310.87	23283.0
2011-02-22 03:00:00	ES	Futures	1310.87	1311.12	1306.66	1307.65	62246.0
2011-02-22 04:00:00	ES	Futures	1307.9	1310.37	1306.41	1309.14	37142.0
2011-02-22 05:00:00	ES	Futures	1309.38	1311.12	1307.16	1310.87	40320.0
2011-02-22 06:00:00	ES	Futures	1311.12	1312.11	1309.88	1310.62	27922.0
2011-02-22 07:00:00	ES	Futures	1310.62	1313.34	1310.37	1313.34	39436.0
2011-02-22 08:00:00	ES	Futures	1313.34	1314.33	1311.86	1313.59	61819.0
2011-02-22 09:00:00	ES	Futures	1313.84	1318.29	1309.63	1318.29	388188.0
2011-02-22 10:00:00	ES	Futures	1318.29	1320.77	1315.82	1317.3	408645.0
2011-02-22 11:00:00	ES	Futures	1317.55	1317.8	1308.89	1310.13	386215.0
2011-02-22 12:00:00	ES	Futures	1310.13	1310.62	1302.21	1303.2	358485.0
2011-02-22 13:00:00	ES	Futures	1303.2	1304.93	1299.24	1301.71	300102.0
2011-02-22 14:00:00	ES	Futures	1301.47	1303.94	1299.49	1300.97	204851.0
2011-02-22 15:00:00	ES	Futures	1301.22	1302.21	1296.77	1300.48	422935.0
2011-02-22 16:00:00	ES	Futures	1300.72	1301.96	1299.98	1300.48	161927.0
2011-02-22 17:00:00	ES	Futures	1300.72	1300.72	1298.99	1299.24	3770.0
2011-02-22 18:00:00	ES	Futures	1298.99	1302.21	1298.74	1301.96	10657.0
2011-02-22 19:00:00	ES	Futures	1301.96	1303.69	1301.71	1303.45	13720.0
2011-02-22 20:00:00	ES	Futures	1303.69	1304.44	1303.45	1303.94	8671.0
2011-02-22 21:00:00	ES	Futures	1304.19	1305.18	1303.2	1304.44	11490.0
2011-02-22 22:00:00	ES	Futures	1304.19	1305.43	1303.94	1305.18	5035.0
2011-02-22 23:00:00	ES	Futures	1305.43	1305.43	1304.19	1304.68	5565.0
2011-02-22 00:00:00	NQ	Futures	2712.17	2715.04	2711.6	2711.88	281.0
2011-02-22 01:00:00	NQ	Futures	2711.88	2711.88	2708.73	2709.59	437.0
2011-02-22 02:00:00	NQ	Futures	2709.59	2709.59	2703.85	2705.28	1441.0
2011-02-22 03:00:00	NQ	Futures	2705.28	2706.14	2699.83	2702.41	3382.0
2011-02-22 04:00:00	NQ	Futures	2702.41	2706.72	2700.4	2705.28	2187.0
2011-02-22 05:00:00	NQ	Futures	2705.57	2707.58	2701.26	2707.29	2092.0
2011-02-22 06:00:00	NQ	Futures	2707.29	2709.01	2702.12	2704.71	3837.0
2011-02-22 07:00:00	NQ	Futures	2704.42	2714.18	2704.42	2712.46	4618.0
2011-02-22 08:00:00	NQ	Futures	2713.03	2713.32	2707.0	2711.6	10732.0
2011-02-22 09:00:00	NQ	Futures	2711.88	2711.88	2688.06	2707.58	75175.0
2011-02-22 10:00:00	NQ	Futures	2707.86	2716.76	2700.11	2712.17	67421.0
2011-02-22 11:00:00	NQ	Futures	2712.17	2712.46	2692.08	2695.23	57869.0
2011-02-22 12:00:00	NQ	Futures	2695.23	2696.67	2672.85	2675.43	54561.0
2011-02-22 13:00:00	NQ	Futures	2675.14	2680.02	2667.97	2673.71	39150.0
2011-02-22 14:00:00	NQ	Futures	2673.71	2679.73	2668.83	2674.28	25113.0
2011-02-22 15:00:00	NQ	Futures	2673.99	2675.72	2661.08	2664.81	54595.0
2011-02-22 16:00:00	NQ	Futures	2664.81	2668.25	2658.49	2666.53	17294.0
2011-02-22 17:00:00	NQ	Futures	2666.82	2666.82	2662.23	2663.09	220.0
2011-02-22 18:00:00	NQ	Futures	2661.36	2666.82	2661.36	2666.24	798.0
2011-02-22 19:00:00	NQ	Futures	2666.53	2668.83	2665.96	2668.83	644.0
2011-02-22 20:00:00	NQ	Futures	2668.83	2669.69	2668.54	2669.69	312.0
2011-02-22 21:00:00	NQ	Futures	2669.4	2670.84	2668.25	2669.69	479.0
2011-02-22 22:00:00	NQ	Futures	2669.69	2671.99	2669.4	2671.7	365.0
2011-02-22 23:00:00	NQ	Futures	2671.7	2672.27	2670.26	2671.99	495.0
2011-02-22 00:00:00	YM	Futures	11763.5	11775.0	11762.5	11762.5	418.0
2011-02-22 01:00:00	YM	Futures	11762.5	11765.4	11754.9	11762.5	347.0

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

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