PREVIEW / futures_1hour / 2011-03-09

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-03-09.parquet
  size:    48 KB
  rows:    1,429

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-09 00:00:00	ES	Futures	1304.19	1306.66	1303.94	1304.93	4819.0
2011-03-09 01:00:00	ES	Futures	1305.18	1306.41	1304.93	1305.18	2810.0
2011-03-09 02:00:00	ES	Futures	1305.18	1307.4	1304.93	1306.91	8277.0
2011-03-09 03:00:00	ES	Futures	1307.16	1307.16	1303.69	1304.19	23754.0
2011-03-09 04:00:00	ES	Futures	1304.44	1308.89	1303.94	1307.65	24088.0
2011-03-09 05:00:00	ES	Futures	1307.65	1308.64	1306.41	1308.15	14393.0
2011-03-09 06:00:00	ES	Futures	1308.39	1311.36	1308.15	1309.38	22985.0
2011-03-09 07:00:00	ES	Futures	1309.38	1310.62	1306.66	1309.38	47722.0
2011-03-09 08:00:00	ES	Futures	1309.14	1309.63	1305.18	1305.43	59950.0
2011-03-09 09:00:00	ES	Futures	1305.43	1306.17	1299.49	1302.21	298620.0
2011-03-09 10:00:00	ES	Futures	1302.46	1308.64	1298.99	1299.98	405174.0
2011-03-09 11:00:00	ES	Futures	1299.73	1307.16	1298.0	1306.17	279795.0
2011-03-09 12:00:00	ES	Futures	1306.41	1309.88	1304.68	1306.17	223346.0
2011-03-09 13:00:00	ES	Futures	1306.17	1307.9	1303.69	1304.93	124138.0
2011-03-09 14:00:00	ES	Futures	1305.18	1307.9	1302.95	1305.92	136170.0
2011-03-09 15:00:00	ES	Futures	1305.92	1307.9	1304.19	1305.67	167490.0
2011-03-09 16:00:00	ES	Futures	1305.92	1306.17	1301.47	1302.21	101671.0
2011-03-09 17:00:00	ES	Futures	1302.21	1302.7	1301.71	1302.21	1321.0
2011-03-09 18:00:00	ES	Futures	1301.96	1303.69	1301.22	1301.47	6482.0
2011-03-09 19:00:00	ES	Futures	1301.47	1302.46	1300.72	1301.71	5708.0
2011-03-09 20:00:00	ES	Futures	1301.71	1302.21	1297.51	1298.25	13173.0
2011-03-09 21:00:00	ES	Futures	1298.5	1298.99	1296.52	1297.26	10128.0
2011-03-09 22:00:00	ES	Futures	1297.26	1297.26	1293.3	1293.8	13808.0
2011-03-09 23:00:00	ES	Futures	1293.8	1295.28	1293.3	1294.54	8490.0
2011-03-09 00:00:00	NQ	Futures	2672.85	2676.29	2672.56	2672.85	430.0
2011-03-09 01:00:00	NQ	Futures	2672.85	2676.86	2672.85	2674.28	342.0
2011-03-09 02:00:00	NQ	Futures	2674.28	2679.45	2674.28	2679.45	1105.0
2011-03-09 03:00:00	NQ	Futures	2679.45	2679.73	2671.99	2673.71	2326.0
2011-03-09 04:00:00	NQ	Futures	2673.71	2682.32	2672.85	2678.01	3588.0
2011-03-09 05:00:00	NQ	Futures	2678.01	2679.73	2674.86	2678.59	1895.0
2011-03-09 06:00:00	NQ	Futures	2678.87	2687.2	2678.87	2683.18	3128.0
2011-03-09 07:00:00	NQ	Futures	2683.47	2685.48	2676.29	2683.18	17120.0
2011-03-09 08:00:00	NQ	Futures	2683.47	2684.04	2673.42	2675.43	9229.0
2011-03-09 09:00:00	NQ	Futures	2675.43	2676.29	2650.17	2661.94	62345.0
2011-03-09 10:00:00	NQ	Futures	2661.36	2676.0	2654.48	2656.49	61304.0
2011-03-09 11:00:00	NQ	Futures	2656.2	2670.55	2651.61	2668.25	44282.0
2011-03-09 12:00:00	NQ	Futures	2668.54	2674.57	2662.51	2665.38	30351.0
2011-03-09 13:00:00	NQ	Futures	2665.38	2668.25	2656.2	2659.36	24541.0
2011-03-09 14:00:00	NQ	Futures	2659.36	2671.12	2659.07	2668.54	27436.0
2011-03-09 15:00:00	NQ	Futures	2668.54	2672.27	2661.36	2664.52	34567.0
2011-03-09 16:00:00	NQ	Futures	2664.52	2665.38	2653.61	2655.34	14214.0
2011-03-09 17:00:00	NQ	Futures	2655.62	2656.77	2654.76	2655.62	229.0
2011-03-09 18:00:00	NQ	Futures	2654.48	2658.49	2653.33	2654.48	288.0
2011-03-09 19:00:00	NQ	Futures	2654.76	2655.91	2652.75	2654.76	201.0
2011-03-09 20:00:00	NQ	Futures	2654.48	2655.34	2638.98	2645.29	1873.0
2011-03-09 21:00:00	NQ	Futures	2645.29	2646.73	2641.27	2643.86	478.0
2011-03-09 22:00:00	NQ	Futures	2642.99	2644.43	2634.96	2637.54	1062.0
2011-03-09 23:00:00	NQ	Futures	2637.25	2640.99	2636.68	2638.4	474.0
2011-03-09 00:00:00	YM	Futures	11665.8	11684.0	11665.8	11673.5	162.0
2011-03-09 01:00:00	YM	Futures	11675.4	11686.9	11674.4	11675.4	198.0

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

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