PREVIEW / futures_1hour / 2011-03-07

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-03-07.parquet
  size:    47 KB
  rows:    1,395

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-07 00:00:00	ES	Futures	1300.97	1301.96	1300.23	1301.47	3549.0
2011-03-07 01:00:00	ES	Futures	1301.47	1302.21	1300.72	1301.47	4178.0
2011-03-07 02:00:00	ES	Futures	1301.22	1302.7	1300.48	1302.7	8654.0
2011-03-07 03:00:00	ES	Futures	1302.46	1308.15	1301.96	1307.4	36513.0
2011-03-07 04:00:00	ES	Futures	1307.65	1309.88	1306.66	1309.63	21902.0
2011-03-07 05:00:00	ES	Futures	1309.38	1309.63	1305.92	1307.16	26011.0
2011-03-07 06:00:00	ES	Futures	1307.4	1311.86	1306.17	1311.12	43171.0
2011-03-07 07:00:00	ES	Futures	1311.12	1312.35	1305.43	1305.67	58004.0
2011-03-07 08:00:00	ES	Futures	1305.43	1308.89	1304.44	1308.64	52429.0
2011-03-07 09:00:00	ES	Futures	1308.89	1313.59	1308.64	1312.35	292013.0
2011-03-07 10:00:00	ES	Futures	1312.35	1313.34	1301.47	1302.21	432838.0
2011-03-07 11:00:00	ES	Futures	1302.21	1302.46	1293.8	1295.28	496421.0
2011-03-07 12:00:00	ES	Futures	1295.28	1297.51	1291.07	1291.57	245751.0
2011-03-07 13:00:00	ES	Futures	1291.57	1293.8	1289.34	1292.06	228788.0
2011-03-07 14:00:00	ES	Futures	1292.06	1296.27	1290.83	1294.29	187505.0
2011-03-07 15:00:00	ES	Futures	1294.54	1300.23	1293.05	1296.27	364974.0
2011-03-07 16:00:00	ES	Futures	1296.27	1296.77	1294.54	1296.27	100058.0
2011-03-07 17:00:00	ES	Futures	1296.02	1296.77	1295.78	1296.02	3096.0
2011-03-07 18:00:00	ES	Futures	1296.52	1298.74	1296.27	1298.5	6726.0
2011-03-07 19:00:00	ES	Futures	1298.5	1298.99	1296.77	1297.01	6773.0
2011-03-07 20:00:00	ES	Futures	1296.77	1298.99	1296.77	1298.74	5871.0
2011-03-07 21:00:00	ES	Futures	1298.74	1299.73	1297.26	1299.49	3571.0
2011-03-07 22:00:00	ES	Futures	1299.49	1300.72	1298.74	1300.48	6805.0
2011-03-07 23:00:00	ES	Futures	1300.48	1300.97	1299.73	1300.72	2457.0
2011-03-07 00:00:00	NQ	Futures	2697.53	2698.68	2695.52	2698.1	166.0
2011-03-07 01:00:00	NQ	Futures	2698.1	2700.11	2696.1	2698.1	539.0
2011-03-07 02:00:00	NQ	Futures	2698.39	2701.26	2695.81	2700.69	628.0
2011-03-07 03:00:00	NQ	Futures	2700.69	2713.89	2698.68	2712.46	2780.0
2011-03-07 04:00:00	NQ	Futures	2712.17	2718.48	2710.16	2717.34	1656.0
2011-03-07 05:00:00	NQ	Futures	2717.34	2718.2	2711.31	2713.89	1897.0
2011-03-07 06:00:00	NQ	Futures	2713.89	2723.08	2712.46	2722.22	2850.0
2011-03-07 07:00:00	NQ	Futures	2722.22	2725.95	2709.59	2710.73	6262.0
2011-03-07 08:00:00	NQ	Futures	2711.02	2719.35	2708.73	2718.77	8030.0
2011-03-07 09:00:00	NQ	Futures	2718.77	2722.5	2708.15	2713.32	43051.0
2011-03-07 10:00:00	NQ	Futures	2713.32	2714.47	2682.32	2684.61	66483.0
2011-03-07 11:00:00	NQ	Futures	2684.9	2685.19	2657.92	2662.51	91477.0
2011-03-07 12:00:00	NQ	Futures	2662.51	2669.69	2654.76	2656.2	38791.0
2011-03-07 13:00:00	NQ	Futures	2656.2	2659.36	2647.87	2655.05	39873.0
2011-03-07 14:00:00	NQ	Futures	2655.05	2667.39	2653.61	2665.38	29610.0
2011-03-07 15:00:00	NQ	Futures	2665.1	2680.88	2662.51	2672.85	52302.0
2011-03-07 16:00:00	NQ	Futures	2672.85	2672.85	2667.11	2669.69	11302.0
2011-03-07 17:00:00	NQ	Futures	2669.69	2670.84	2668.83	2669.69	172.0
2011-03-07 18:00:00	NQ	Futures	2669.98	2674.28	2668.54	2674.28	320.0
2011-03-07 19:00:00	NQ	Futures	2674.28	2674.86	2670.84	2670.84	386.0
2011-03-07 20:00:00	NQ	Futures	2671.41	2675.43	2671.41	2674.57	389.0
2011-03-07 21:00:00	NQ	Futures	2674.57	2677.15	2671.99	2676.58	237.0
2011-03-07 22:00:00	NQ	Futures	2676.29	2678.3	2674.28	2678.3	254.0
2011-03-07 23:00:00	NQ	Futures	2678.01	2678.59	2676.86	2678.59	172.0
2011-03-07 00:00:00	YM	Futures	11600.7	11605.4	11593.0	11598.7	187.0
2011-03-07 01:00:00	YM	Futures	11599.7	11608.3	11596.8	11599.7	271.0

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

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