PREVIEW / futures_1hour / 2011-03-29

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-03-29.parquet
  size:    49 KB
  rows:    1,478

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-03-29 00:00:00	ES	Futures	1295.57	1297.3	1295.32	1297.06	9967.0
2011-03-29 01:00:00	ES	Futures	1297.06	1298.3	1296.81	1298.3	9398.0
2011-03-29 02:00:00	ES	Futures	1298.55	1299.79	1298.3	1299.29	12838.0
2011-03-29 03:00:00	ES	Futures	1299.29	1300.04	1295.81	1296.81	33911.0
2011-03-29 04:00:00	ES	Futures	1296.81	1299.29	1296.31	1298.55	15274.0
2011-03-29 05:00:00	ES	Futures	1298.79	1299.04	1294.82	1296.06	19576.0
2011-03-29 06:00:00	ES	Futures	1296.31	1297.3	1294.82	1294.82	14120.0
2011-03-29 07:00:00	ES	Futures	1294.82	1297.8	1294.82	1297.55	32514.0
2011-03-29 08:00:00	ES	Futures	1297.3	1298.05	1295.81	1296.31	29555.0
2011-03-29 09:00:00	ES	Futures	1296.56	1297.55	1292.09	1293.83	224176.0
2011-03-29 10:00:00	ES	Futures	1293.58	1300.29	1292.83	1299.54	289613.0
2011-03-29 11:00:00	ES	Futures	1299.54	1303.27	1299.04	1302.52	228270.0
2011-03-29 12:00:00	ES	Futures	1302.27	1303.27	1301.28	1302.52	119624.0
2011-03-29 13:00:00	ES	Futures	1302.52	1303.52	1301.78	1302.77	54395.0
2011-03-29 14:00:00	ES	Futures	1302.77	1306.0	1302.52	1305.5	107794.0
2011-03-29 15:00:00	ES	Futures	1305.5	1306.74	1304.01	1306.0	185017.0
2011-03-29 16:00:00	ES	Futures	1306.25	1310.22	1306.0	1308.98	134885.0
2011-03-29 17:00:00	ES	Futures	1308.73	1309.48	1308.48	1308.98	2651.0
2011-03-29 18:00:00	ES	Futures	1308.73	1308.98	1306.5	1306.99	13376.0
2011-03-29 19:00:00	ES	Futures	1307.24	1307.49	1306.5	1307.24	5025.0
2011-03-29 20:00:00	ES	Futures	1307.49	1308.98	1306.74	1308.48	5270.0
2011-03-29 21:00:00	ES	Futures	1308.48	1310.22	1307.99	1309.97	5005.0
2011-03-29 22:00:00	ES	Futures	1309.73	1309.97	1307.99	1309.23	4499.0
2011-03-29 23:00:00	ES	Futures	1309.23	1311.22	1308.98	1310.97	5029.0
2011-03-29 00:00:00	NQ	Futures	2638.99	2642.43	2638.99	2642.43	435.0
2011-03-29 01:00:00	NQ	Futures	2642.43	2645.88	2642.43	2645.02	422.0
2011-03-29 02:00:00	NQ	Futures	2645.59	2653.64	2645.31	2652.49	1451.0
2011-03-29 03:00:00	NQ	Futures	2652.2	2653.06	2643.58	2645.02	3122.0
2011-03-29 04:00:00	NQ	Futures	2645.31	2651.92	2644.45	2649.62	1387.0
2011-03-29 05:00:00	NQ	Futures	2650.19	2651.63	2642.43	2644.73	2232.0
2011-03-29 06:00:00	NQ	Futures	2644.73	2647.32	2642.43	2642.72	1005.0
2011-03-29 07:00:00	NQ	Futures	2642.43	2647.03	2641.57	2646.46	3110.0
2011-03-29 08:00:00	NQ	Futures	2645.88	2645.88	2637.84	2639.56	4957.0
2011-03-29 09:00:00	NQ	Futures	2639.56	2644.73	2631.23	2641.57	40452.0
2011-03-29 10:00:00	NQ	Futures	2641.57	2659.1	2640.14	2657.37	43586.0
2011-03-29 11:00:00	NQ	Futures	2657.66	2666.86	2657.37	2665.42	33368.0
2011-03-29 12:00:00	NQ	Futures	2665.71	2666.57	2659.67	2663.12	17391.0
2011-03-29 13:00:00	NQ	Futures	2662.83	2663.7	2657.66	2661.11	10858.0
2011-03-29 14:00:00	NQ	Futures	2661.11	2667.14	2660.53	2665.71	17187.0
2011-03-29 15:00:00	NQ	Futures	2665.71	2670.02	2663.12	2669.44	26342.0
2011-03-29 16:00:00	NQ	Futures	2669.44	2674.61	2665.13	2670.88	11084.0
2011-03-29 17:00:00	NQ	Futures	2671.17	2672.89	2671.17	2671.74	170.0
2011-03-29 18:00:00	NQ	Futures	2671.45	2671.74	2666.86	2668.01	590.0
2011-03-29 19:00:00	NQ	Futures	2668.29	2668.87	2666.57	2668.87	268.0
2011-03-29 20:00:00	NQ	Futures	2669.15	2672.31	2668.01	2670.3	398.0
2011-03-29 21:00:00	NQ	Futures	2670.59	2674.33	2669.73	2674.33	632.0
2011-03-29 22:00:00	NQ	Futures	2674.04	2674.04	2669.44	2672.6	550.0
2011-03-29 23:00:00	NQ	Futures	2672.31	2677.77	2671.74	2676.62	589.0
2011-03-29 00:00:00	YM	Futures	11678.7	11690.2	11678.7	11690.2	269.0
2011-03-29 01:00:00	YM	Futures	11690.2	11700.8	11689.2	11700.8	299.0

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

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