PREVIEW / futures_1hour / 2011-11-02

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-11-02.parquet
  size:    49 KB
  rows:    1,472

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-11-02 00:00:00	ES	Futures	1229.97	1232.23	1229.47	1230.72	4156.0
2011-11-02 01:00:00	ES	Futures	1230.72	1233.23	1229.72	1232.98	5898.0
2011-11-02 02:00:00	ES	Futures	1232.98	1239.25	1232.48	1238.24	18315.0
2011-11-02 03:00:00	ES	Futures	1238.24	1240.5	1234.23	1237.49	20863.0
2011-11-02 04:00:00	ES	Futures	1237.49	1241.25	1234.48	1237.49	51006.0
2011-11-02 05:00:00	ES	Futures	1237.49	1239.5	1224.45	1226.21	55943.0
2011-11-02 06:00:00	ES	Futures	1226.46	1232.48	1225.71	1230.47	36447.0
2011-11-02 07:00:00	ES	Futures	1230.47	1234.48	1228.71	1232.23	35215.0
2011-11-02 08:00:00	ES	Futures	1232.23	1236.99	1231.97	1234.23	48065.0
2011-11-02 09:00:00	ES	Futures	1234.48	1238.49	1231.97	1233.48	213928.0
2011-11-02 10:00:00	ES	Futures	1233.73	1242.51	1230.97	1240.5	314290.0
2011-11-02 11:00:00	ES	Futures	1240.75	1242.51	1238.24	1239.0	220571.0
2011-11-02 12:00:00	ES	Futures	1239.0	1240.75	1232.23	1232.73	265929.0
2011-11-02 13:00:00	ES	Futures	1232.98	1233.23	1225.96	1228.97	234723.0
2011-11-02 14:00:00	ES	Futures	1228.97	1236.49	1225.96	1235.23	234690.0
2011-11-02 15:00:00	ES	Futures	1235.23	1240.5	1232.48	1237.99	346894.0
2011-11-02 16:00:00	ES	Futures	1237.99	1239.5	1236.99	1238.74	69776.0
2011-11-02 17:00:00	ES	Futures	1238.74	1241.25	1238.74	1240.5	2804.0
2011-11-02 18:00:00	ES	Futures	1240.5	1241.75	1233.48	1234.98	14984.0
2011-11-02 19:00:00	ES	Futures	1235.23	1236.49	1229.97	1230.47	13566.0
2011-11-02 20:00:00	ES	Futures	1230.47	1230.72	1226.71	1228.46	13503.0
2011-11-02 21:00:00	ES	Futures	1228.71	1228.97	1221.19	1222.19	18189.0
2011-11-02 22:00:00	ES	Futures	1222.19	1225.2	1220.44	1222.95	13341.0
2011-11-02 23:00:00	ES	Futures	1222.95	1226.71	1221.19	1226.71	7423.0
2011-11-02 00:00:00	NQ	Futures	2664.68	2668.42	2663.81	2665.25	262.0
2011-11-02 01:00:00	NQ	Futures	2665.25	2670.44	2664.1	2670.15	305.0
2011-11-02 02:00:00	NQ	Futures	2670.15	2682.26	2668.71	2680.82	1390.0
2011-11-02 03:00:00	NQ	Futures	2680.53	2684.86	2673.61	2679.09	1298.0
2011-11-02 04:00:00	NQ	Futures	2678.8	2686.88	2673.61	2678.23	3808.0
2011-11-02 05:00:00	NQ	Futures	2678.52	2681.69	2649.4	2651.7	5773.0
2011-11-02 06:00:00	NQ	Futures	2651.7	2664.1	2650.84	2659.2	3617.0
2011-11-02 07:00:00	NQ	Futures	2659.2	2667.56	2656.03	2663.52	2740.0
2011-11-02 08:00:00	NQ	Futures	2663.52	2671.31	2663.23	2667.56	4030.0
2011-11-02 09:00:00	NQ	Futures	2667.27	2676.5	2657.76	2660.06	33300.0
2011-11-02 10:00:00	NQ	Futures	2660.06	2679.38	2652.86	2676.79	41938.0
2011-11-02 11:00:00	NQ	Futures	2677.07	2681.4	2668.71	2670.15	31500.0
2011-11-02 12:00:00	NQ	Futures	2670.15	2673.04	2657.76	2658.62	34500.0
2011-11-02 13:00:00	NQ	Futures	2658.91	2660.35	2647.67	2650.55	29955.0
2011-11-02 14:00:00	NQ	Futures	2650.26	2666.12	2644.78	2663.52	31437.0
2011-11-02 15:00:00	NQ	Futures	2663.52	2673.61	2656.89	2668.71	47315.0
2011-11-02 16:00:00	NQ	Futures	2668.71	2676.21	2668.42	2675.34	7232.0
2011-11-02 17:00:00	NQ	Futures	2675.06	2679.96	2674.77	2678.52	288.0
2011-11-02 18:00:00	NQ	Futures	2678.23	2680.53	2665.83	2668.42	953.0
2011-11-02 19:00:00	NQ	Futures	2668.14	2670.73	2660.64	2662.08	1209.0
2011-11-02 20:00:00	NQ	Futures	2661.5	2662.66	2656.03	2658.91	1435.0
2011-11-02 21:00:00	NQ	Futures	2658.91	2658.91	2645.94	2647.95	1620.0
2011-11-02 22:00:00	NQ	Futures	2647.95	2652.57	2642.19	2647.38	1261.0
2011-11-02 23:00:00	NQ	Futures	2647.09	2654.58	2644.49	2654.58	569.0
2011-11-02 00:00:00	YM	Futures	11519.4	11537.1	11515.4	11522.3	278.0
2011-11-02 01:00:00	YM	Futures	11522.3	11544.0	11515.4	11543.0	412.0

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

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