PREVIEW / futures_1hour / 2011-06-02

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-06-02.parquet
  size:    48 KB
  rows:    1,445

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-06-02 00:00:00	ES	Futures	1303.76	1304.01	1302.52	1304.01	2810.0
2011-06-02 01:00:00	ES	Futures	1304.01	1304.76	1302.77	1304.76	4273.0
2011-06-02 02:00:00	ES	Futures	1304.76	1306.99	1304.51	1306.99	16589.0
2011-06-02 03:00:00	ES	Futures	1306.74	1306.74	1303.52	1304.51	34211.0
2011-06-02 04:00:00	ES	Futures	1304.51	1306.25	1303.27	1304.76	32518.0
2011-06-02 05:00:00	ES	Futures	1305.01	1307.99	1304.51	1307.99	31280.0
2011-06-02 06:00:00	ES	Futures	1307.99	1309.48	1307.24	1307.99	27913.0
2011-06-02 07:00:00	ES	Futures	1307.99	1308.24	1304.51	1305.01	28093.0
2011-06-02 08:00:00	ES	Futures	1305.01	1307.49	1304.26	1306.25	49597.0
2011-06-02 09:00:00	ES	Futures	1306.5	1308.73	1300.04	1306.0	436627.0
2011-06-02 10:00:00	ES	Futures	1306.25	1308.73	1304.01	1305.25	342641.0
2011-06-02 11:00:00	ES	Futures	1305.25	1306.25	1296.06	1299.54	391322.0
2011-06-02 12:00:00	ES	Futures	1299.54	1303.76	1297.55	1302.77	208132.0
2011-06-02 13:00:00	ES	Futures	1302.77	1306.25	1301.78	1305.75	217114.0
2011-06-02 14:00:00	ES	Futures	1305.75	1307.99	1302.27	1307.49	208612.0
2011-06-02 15:00:00	ES	Futures	1307.24	1308.24	1302.27	1303.52	240441.0
2011-06-02 16:00:00	ES	Futures	1303.52	1305.01	1303.27	1304.76	71550.0
2011-06-02 17:00:00	ES	Futures	1304.76	1305.25	1303.76	1304.01	2568.0
2011-06-02 18:00:00	ES	Futures	1304.01	1304.26	1302.52	1302.77	3949.0
2011-06-02 19:00:00	ES	Futures	1302.77	1303.27	1302.27	1303.02	1876.0
2011-06-02 20:00:00	ES	Futures	1303.02	1304.51	1303.02	1303.52	5442.0
2011-06-02 21:00:00	ES	Futures	1303.27	1303.52	1300.78	1302.27	5571.0
2011-06-02 22:00:00	ES	Futures	1302.27	1302.27	1300.04	1300.78	5546.0
2011-06-02 23:00:00	ES	Futures	1300.78	1301.78	1300.53	1301.53	2730.0
2011-06-02 00:00:00	NQ	Futures	2663.41	2663.7	2661.11	2663.41	266.0
2011-06-02 01:00:00	NQ	Futures	2663.41	2665.99	2661.97	2665.99	518.0
2011-06-02 02:00:00	NQ	Futures	2665.71	2672.03	2665.42	2671.74	1822.0
2011-06-02 03:00:00	NQ	Futures	2671.45	2672.03	2666.86	2668.87	3005.0
2011-06-02 04:00:00	NQ	Futures	2668.58	2673.46	2666.57	2670.88	3034.0
2011-06-02 05:00:00	NQ	Futures	2670.88	2677.49	2670.3	2677.49	3473.0
2011-06-02 06:00:00	NQ	Futures	2677.2	2679.79	2675.76	2676.91	2692.0
2011-06-02 07:00:00	NQ	Futures	2676.91	2678.06	2670.88	2671.74	3020.0
2011-06-02 08:00:00	NQ	Futures	2671.74	2675.48	2670.88	2673.75	5828.0
2011-06-02 09:00:00	NQ	Futures	2673.46	2678.64	2664.56	2676.91	46940.0
2011-06-02 10:00:00	NQ	Futures	2676.91	2684.09	2673.75	2679.21	52979.0
2011-06-02 11:00:00	NQ	Futures	2679.21	2680.07	2659.96	2666.86	41903.0
2011-06-02 12:00:00	NQ	Futures	2666.86	2672.89	2663.41	2671.17	25244.0
2011-06-02 13:00:00	NQ	Futures	2671.45	2676.91	2669.15	2675.48	23641.0
2011-06-02 14:00:00	NQ	Futures	2675.48	2679.5	2670.02	2678.92	23338.0
2011-06-02 15:00:00	NQ	Futures	2678.92	2680.65	2671.45	2674.61	28097.0
2011-06-02 16:00:00	NQ	Futures	2674.61	2675.76	2672.6	2674.9	5053.0
2011-06-02 17:00:00	NQ	Futures	2674.9	2675.19	2673.75	2674.33	129.0
2011-06-02 18:00:00	NQ	Futures	2674.61	2674.61	2672.03	2672.03	198.0
2011-06-02 19:00:00	NQ	Futures	2671.74	2672.6	2671.45	2672.6	136.0
2011-06-02 20:00:00	NQ	Futures	2672.03	2674.9	2672.03	2673.46	276.0
2011-06-02 21:00:00	NQ	Futures	2673.18	2673.46	2668.01	2670.88	374.0
2011-06-02 22:00:00	NQ	Futures	2670.59	2670.59	2666.86	2667.72	301.0
2011-06-02 23:00:00	NQ	Futures	2667.43	2668.87	2666.86	2668.87	211.0
2011-06-02 00:00:00	YM	Futures	11817.4	11818.3	11808.7	11816.4	153.0
2011-06-02 01:00:00	YM	Futures	11817.4	11825.1	11809.6	11825.1	295.0

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

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