PREVIEW / futures_1hour / 2011-11-17

all futures 1-hour files

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

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-17 00:00:00	ES	Futures	1240.25	1243.01	1238.74	1242.26	8283.0
2011-11-17 01:00:00	ES	Futures	1242.26	1242.51	1238.74	1240.25	4427.0
2011-11-17 02:00:00	ES	Futures	1240.5	1243.76	1238.74	1241.5	17689.0
2011-11-17 03:00:00	ES	Futures	1241.5	1245.52	1235.74	1240.25	61369.0
2011-11-17 04:00:00	ES	Futures	1240.25	1242.51	1232.98	1236.49	51395.0
2011-11-17 05:00:00	ES	Futures	1236.49	1237.99	1231.47	1235.74	53244.0
2011-11-17 06:00:00	ES	Futures	1235.99	1237.99	1229.47	1230.47	45501.0
2011-11-17 07:00:00	ES	Futures	1230.47	1232.98	1223.95	1232.48	110182.0
2011-11-17 08:00:00	ES	Futures	1232.23	1237.49	1228.46	1234.23	111838.0
2011-11-17 09:00:00	ES	Futures	1234.23	1240.25	1227.46	1232.23	312238.0
2011-11-17 10:00:00	ES	Futures	1232.23	1239.75	1229.47	1235.48	419317.0
2011-11-17 11:00:00	ES	Futures	1235.48	1237.24	1230.22	1233.98	267475.0
2011-11-17 12:00:00	ES	Futures	1233.73	1234.73	1212.42	1219.44	455015.0
2011-11-17 13:00:00	ES	Futures	1219.19	1220.69	1210.41	1216.93	311454.0
2011-11-17 14:00:00	ES	Futures	1216.68	1217.93	1210.66	1215.68	248357.0
2011-11-17 15:00:00	ES	Futures	1215.93	1219.44	1210.16	1219.19	416097.0
2011-11-17 16:00:00	ES	Futures	1219.19	1220.44	1217.68	1219.44	121122.0
2011-11-17 17:00:00	ES	Futures	1219.44	1220.19	1218.68	1218.93	3554.0
2011-11-17 18:00:00	ES	Futures	1218.43	1219.19	1214.17	1214.42	12647.0
2011-11-17 19:00:00	ES	Futures	1214.42	1218.43	1212.67	1216.93	13772.0
2011-11-17 20:00:00	ES	Futures	1217.18	1218.68	1215.68	1217.93	6628.0
2011-11-17 21:00:00	ES	Futures	1218.18	1220.69	1216.93	1219.19	7852.0
2011-11-17 22:00:00	ES	Futures	1218.93	1220.69	1218.43	1219.69	4782.0
2011-11-17 23:00:00	ES	Futures	1219.69	1219.69	1216.93	1217.43	3938.0
2011-11-17 00:00:00	NQ	Futures	2682.26	2685.15	2679.67	2683.99	692.0
2011-11-17 01:00:00	NQ	Futures	2683.42	2683.71	2678.23	2680.53	316.0
2011-11-17 02:00:00	NQ	Futures	2681.11	2687.74	2678.23	2684.28	1105.0
2011-11-17 03:00:00	NQ	Futures	2683.99	2690.34	2670.73	2680.82	4910.0
2011-11-17 04:00:00	NQ	Futures	2680.82	2686.3	2666.69	2673.33	3170.0
2011-11-17 05:00:00	NQ	Futures	2672.75	2675.92	2663.52	2669.87	3715.0
2011-11-17 06:00:00	NQ	Futures	2669.87	2673.9	2658.33	2659.77	2355.0
2011-11-17 07:00:00	NQ	Futures	2659.77	2665.54	2650.26	2664.39	5555.0
2011-11-17 08:00:00	NQ	Futures	2664.39	2675.34	2657.47	2669.58	7479.0
2011-11-17 09:00:00	NQ	Futures	2669.58	2679.67	2652.86	2663.81	33551.0
2011-11-17 10:00:00	NQ	Futures	2662.95	2667.85	2653.43	2654.87	45571.0
2011-11-17 11:00:00	NQ	Futures	2654.58	2657.47	2641.32	2648.82	38459.0
2011-11-17 12:00:00	NQ	Futures	2648.82	2650.84	2602.11	2616.53	70092.0
2011-11-17 13:00:00	NQ	Futures	2616.53	2621.14	2601.82	2615.08	43119.0
2011-11-17 14:00:00	NQ	Futures	2614.8	2623.73	2605.57	2617.39	37321.0
2011-11-17 15:00:00	NQ	Futures	2617.39	2622.0	2606.15	2621.43	51015.0
2011-11-17 16:00:00	NQ	Futures	2621.72	2622.0	2615.95	2618.83	13415.0
2011-11-17 17:00:00	NQ	Futures	2618.54	2620.27	2617.39	2617.68	431.0
2011-11-17 18:00:00	NQ	Futures	2616.24	2617.39	2609.89	2610.18	668.0
2011-11-17 19:00:00	NQ	Futures	2610.47	2616.53	2607.3	2614.22	923.0
2011-11-17 20:00:00	NQ	Futures	2613.93	2617.97	2612.49	2615.95	551.0
2011-11-17 21:00:00	NQ	Futures	2616.24	2620.56	2614.8	2617.97	522.0
2011-11-17 22:00:00	NQ	Futures	2617.97	2622.0	2617.1	2618.54	534.0
2011-11-17 23:00:00	NQ	Futures	2618.54	2619.12	2613.07	2613.07	570.0
2011-11-17 00:00:00	YM	Futures	11715.3	11735.0	11704.5	11727.1	465.0
2011-11-17 01:00:00	YM	Futures	11728.1	11729.1	11700.5	11714.3	427.0

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

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