PREVIEW / futures_1hour / 2011-04-13

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-04-13.parquet
  size:    49 KB
  rows:    1,497

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-04-13 00:00:00	ES	Futures	1303.76	1305.01	1303.52	1304.76	4324.0
2011-04-13 01:00:00	ES	Futures	1305.01	1305.5	1304.01	1305.01	7413.0
2011-04-13 02:00:00	ES	Futures	1305.25	1305.75	1304.01	1304.51	7081.0
2011-04-13 03:00:00	ES	Futures	1304.76	1305.75	1303.52	1304.26	20143.0
2011-04-13 04:00:00	ES	Futures	1304.51	1306.5	1303.76	1305.25	18121.0
2011-04-13 05:00:00	ES	Futures	1305.25	1307.49	1304.76	1307.49	12201.0
2011-04-13 06:00:00	ES	Futures	1307.24	1308.24	1306.74	1308.24	21139.0
2011-04-13 07:00:00	ES	Futures	1308.24	1310.22	1306.25	1308.98	44407.0
2011-04-13 08:00:00	ES	Futures	1308.98	1310.47	1307.99	1309.48	49456.0
2011-04-13 09:00:00	ES	Futures	1309.23	1309.23	1304.76	1305.01	233839.0
2011-04-13 10:00:00	ES	Futures	1305.01	1307.99	1302.52	1306.99	308627.0
2011-04-13 11:00:00	ES	Futures	1306.99	1307.24	1299.79	1300.04	239743.0
2011-04-13 12:00:00	ES	Futures	1300.04	1302.27	1296.81	1299.04	220759.0
2011-04-13 13:00:00	ES	Futures	1299.04	1301.28	1297.8	1298.79	111401.0
2011-04-13 14:00:00	ES	Futures	1298.79	1304.01	1297.8	1303.02	180766.0
2011-04-13 15:00:00	ES	Futures	1303.27	1305.5	1301.78	1301.78	287741.0
2011-04-13 16:00:00	ES	Futures	1301.78	1302.27	1300.04	1300.29	87494.0
2011-04-13 17:00:00	ES	Futures	1300.29	1300.78	1299.54	1300.04	3948.0
2011-04-13 18:00:00	ES	Futures	1299.79	1300.53	1297.8	1298.3	6552.0
2011-04-13 19:00:00	ES	Futures	1298.3	1299.54	1297.55	1299.29	6117.0
2011-04-13 20:00:00	ES	Futures	1299.04	1300.78	1298.79	1299.79	9424.0
2011-04-13 21:00:00	ES	Futures	1299.79	1300.53	1297.3	1298.3	10888.0
2011-04-13 22:00:00	ES	Futures	1298.55	1300.29	1298.3	1299.79	4006.0
2011-04-13 23:00:00	ES	Futures	1300.04	1301.28	1299.04	1300.78	3691.0
2011-04-13 00:00:00	NQ	Futures	2642.72	2646.17	2642.72	2645.59	451.0
2011-04-13 01:00:00	NQ	Futures	2645.02	2647.32	2643.87	2646.46	340.0
2011-04-13 02:00:00	NQ	Futures	2646.46	2647.03	2644.16	2645.02	553.0
2011-04-13 03:00:00	NQ	Futures	2644.73	2647.32	2642.15	2643.3	2576.0
2011-04-13 04:00:00	NQ	Futures	2643.3	2647.89	2642.43	2646.46	1238.0
2011-04-13 05:00:00	NQ	Futures	2646.46	2650.77	2645.59	2650.77	939.0
2011-04-13 06:00:00	NQ	Futures	2650.77	2653.64	2648.47	2653.06	1698.0
2011-04-13 07:00:00	NQ	Futures	2653.06	2660.25	2649.33	2656.23	4334.0
2011-04-13 08:00:00	NQ	Futures	2656.23	2658.52	2653.93	2655.65	3745.0
2011-04-13 09:00:00	NQ	Futures	2655.36	2657.37	2650.19	2651.63	39162.0
2011-04-13 10:00:00	NQ	Futures	2651.63	2665.71	2645.88	2664.27	55715.0
2011-04-13 11:00:00	NQ	Futures	2664.27	2664.56	2645.59	2646.17	34834.0
2011-04-13 12:00:00	NQ	Futures	2646.17	2652.49	2636.98	2643.58	38964.0
2011-04-13 13:00:00	NQ	Futures	2643.3	2648.47	2639.85	2642.43	21495.0
2011-04-13 14:00:00	NQ	Futures	2642.72	2657.95	2642.43	2655.94	27829.0
2011-04-13 15:00:00	NQ	Futures	2656.23	2661.4	2654.5	2657.37	38151.0
2011-04-13 16:00:00	NQ	Futures	2657.66	2658.52	2651.92	2652.78	10139.0
2011-04-13 17:00:00	NQ	Futures	2652.49	2653.35	2651.05	2651.92	169.0
2011-04-13 18:00:00	NQ	Futures	2650.77	2653.35	2649.62	2650.19	518.0
2011-04-13 19:00:00	NQ	Futures	2650.19	2651.63	2648.18	2651.63	233.0
2011-04-13 20:00:00	NQ	Futures	2651.63	2652.2	2649.04	2650.48	950.0
2011-04-13 21:00:00	NQ	Futures	2651.05	2651.92	2646.17	2647.89	856.0
2011-04-13 22:00:00	NQ	Futures	2648.47	2651.63	2647.89	2650.77	215.0
2011-04-13 23:00:00	NQ	Futures	2651.05	2653.35	2649.33	2652.78	228.0
2011-04-13 00:00:00	YM	Futures	11779.8	11799.1	11776.9	11791.3	782.0
2011-04-13 01:00:00	YM	Futures	11788.5	11799.1	11785.6	11792.3	627.0

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

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