PREVIEW / futures_1hour / 2011-04-12

all futures 1-hour files

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

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-12 00:00:00	ES	Futures	1304.76	1305.25	1303.52	1304.26	5710.0
2011-04-12 01:00:00	ES	Futures	1304.26	1305.75	1302.77	1305.01	9253.0
2011-04-12 02:00:00	ES	Futures	1305.01	1305.75	1304.01	1304.76	13401.0
2011-04-12 03:00:00	ES	Futures	1305.01	1306.5	1303.76	1305.75	34515.0
2011-04-12 04:00:00	ES	Futures	1306.0	1306.25	1303.27	1303.76	27328.0
2011-04-12 05:00:00	ES	Futures	1303.52	1305.75	1303.27	1305.25	18080.0
2011-04-12 06:00:00	ES	Futures	1305.25	1305.75	1304.01	1304.51	12582.0
2011-04-12 07:00:00	ES	Futures	1304.51	1304.76	1303.52	1304.51	27885.0
2011-04-12 08:00:00	ES	Futures	1304.26	1305.75	1302.02	1304.76	58407.0
2011-04-12 09:00:00	ES	Futures	1304.51	1307.24	1301.53	1303.02	284047.0
2011-04-12 10:00:00	ES	Futures	1302.77	1303.76	1297.06	1297.3	455588.0
2011-04-12 11:00:00	ES	Futures	1297.55	1301.03	1297.06	1299.79	248326.0
2011-04-12 12:00:00	ES	Futures	1299.54	1301.78	1298.3	1300.78	112376.0
2011-04-12 13:00:00	ES	Futures	1300.53	1304.01	1299.29	1302.52	132896.0
2011-04-12 14:00:00	ES	Futures	1302.52	1306.0	1302.02	1302.77	195206.0
2011-04-12 15:00:00	ES	Futures	1302.77	1303.52	1299.04	1302.02	268498.0
2011-04-12 16:00:00	ES	Futures	1302.02	1302.27	1299.29	1300.78	96353.0
2011-04-12 17:00:00	ES	Futures	1300.78	1301.53	1300.53	1301.53	1344.0
2011-04-12 18:00:00	ES	Futures	1301.03	1301.78	1300.04	1300.04	2504.0
2011-04-12 19:00:00	ES	Futures	1300.29	1303.76	1300.04	1303.52	6983.0
2011-04-12 20:00:00	ES	Futures	1303.52	1304.76	1303.02	1303.52	12879.0
2011-04-12 21:00:00	ES	Futures	1303.52	1304.01	1302.52	1303.02	5019.0
2011-04-12 22:00:00	ES	Futures	1302.77	1303.76	1302.02	1302.52	5521.0
2011-04-12 23:00:00	ES	Futures	1302.27	1304.26	1301.78	1303.76	4709.0
2011-04-12 00:00:00	NQ	Futures	2641.57	2643.87	2640.14	2641.86	726.0
2011-04-12 01:00:00	NQ	Futures	2642.15	2644.16	2638.12	2642.72	863.0
2011-04-12 02:00:00	NQ	Futures	2643.01	2643.58	2639.85	2640.71	1173.0
2011-04-12 03:00:00	NQ	Futures	2640.71	2643.58	2638.7	2643.01	1566.0
2011-04-12 04:00:00	NQ	Futures	2642.72	2643.58	2635.54	2636.11	1589.0
2011-04-12 05:00:00	NQ	Futures	2636.11	2642.15	2635.54	2640.14	1790.0
2011-04-12 06:00:00	NQ	Futures	2640.42	2641.86	2639.56	2641.28	2211.0
2011-04-12 07:00:00	NQ	Futures	2641.28	2641.86	2636.98	2638.99	3656.0
2011-04-12 08:00:00	NQ	Futures	2639.27	2642.72	2635.54	2641.57	7943.0
2011-04-12 09:00:00	NQ	Futures	2641.86	2648.76	2635.83	2637.55	48228.0
2011-04-12 10:00:00	NQ	Futures	2637.55	2640.14	2628.93	2629.79	64834.0
2011-04-12 11:00:00	NQ	Futures	2629.79	2634.96	2626.06	2631.52	29695.0
2011-04-12 12:00:00	NQ	Futures	2631.8	2638.12	2628.36	2634.96	20829.0
2011-04-12 13:00:00	NQ	Futures	2634.96	2639.27	2630.94	2636.69	28630.0
2011-04-12 14:00:00	NQ	Futures	2636.69	2641.86	2633.24	2634.68	28782.0
2011-04-12 15:00:00	NQ	Futures	2634.68	2637.55	2627.78	2636.98	33398.0
2011-04-12 16:00:00	NQ	Futures	2636.98	2637.26	2632.09	2636.69	7646.0
2011-04-12 17:00:00	NQ	Futures	2636.4	2637.26	2635.54	2637.26	162.0
2011-04-12 18:00:00	NQ	Futures	2637.26	2638.99	2635.83	2635.83	538.0
2011-04-12 19:00:00	NQ	Futures	2635.83	2642.15	2635.83	2641.86	393.0
2011-04-12 20:00:00	NQ	Futures	2641.86	2645.88	2641.57	2643.01	708.0
2011-04-12 21:00:00	NQ	Futures	2643.58	2644.45	2640.42	2641.57	398.0
2011-04-12 22:00:00	NQ	Futures	2641.57	2642.72	2638.7	2639.85	215.0
2011-04-12 23:00:00	NQ	Futures	2640.14	2644.16	2638.7	2642.72	174.0
2011-04-12 00:00:00	YM	Futures	11804.8	11808.7	11796.2	11801.0	431.0
2011-04-12 01:00:00	YM	Futures	11801.9	11813.5	11791.3	11809.6	468.0

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

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