PREVIEW / futures_1hour / 2011-09-25

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-09-25.parquet
  size:    15 KB
  rows:    274

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-09-25 18:00:00	ES	Futures	1125.4	1147.97	1125.4	1144.21	52854.0
2011-09-25 19:00:00	ES	Futures	1144.46	1147.97	1142.96	1146.22	16216.0
2011-09-25 20:00:00	ES	Futures	1146.47	1147.47	1138.69	1139.7	26165.0
2011-09-25 21:00:00	ES	Futures	1139.7	1141.45	1135.18	1139.44	20586.0
2011-09-25 22:00:00	ES	Futures	1139.19	1140.95	1135.93	1138.44	11739.0
2011-09-25 23:00:00	ES	Futures	1138.69	1140.45	1133.68	1133.93	10148.0
2011-09-25 18:00:00	NQ	Futures	2526.28	2568.38	2522.53	2561.17	2301.0
2011-09-25 19:00:00	NQ	Futures	2560.59	2566.65	2558.57	2563.76	1447.0
2011-09-25 20:00:00	NQ	Futures	2564.05	2566.07	2544.16	2545.89	2675.0
2011-09-25 21:00:00	NQ	Futures	2547.62	2549.64	2537.81	2546.18	1842.0
2011-09-25 22:00:00	NQ	Futures	2545.89	2549.64	2539.26	2543.87	1157.0
2011-09-25 23:00:00	NQ	Futures	2544.16	2548.48	2534.35	2534.64	885.0
2011-09-25 18:00:00	YM	Futures	10475.7	10655.9	10459.0	10616.5	1376.0
2011-09-25 19:00:00	YM	Futures	10613.6	10647.0	10610.6	10640.1	489.0
2011-09-25 20:00:00	YM	Futures	10639.2	10642.1	10565.3	10573.2	1159.0
2011-09-25 21:00:00	YM	Futures	10578.1	10589.9	10541.7	10573.2	975.0
2011-09-25 22:00:00	YM	Futures	10568.3	10588.0	10543.7	10563.3	733.0
2011-09-25 23:00:00	YM	Futures	10563.3	10581.1	10526.9	10527.9	739.0
2011-09-25 18:00:00	CL	Futures	134.81	136.86	134.74	136.66	3056.0
2011-09-25 19:00:00	CL	Futures	136.59	136.72	136.4	136.55	913.0
2011-09-25 20:00:00	CL	Futures	136.52	136.6	135.5	135.78	2099.0
2011-09-25 21:00:00	CL	Futures	135.79	135.94	135.06	135.27	2762.0
2011-09-25 22:00:00	CL	Futures	135.27	135.57	135.12	135.39	2078.0
2011-09-25 23:00:00	CL	Futures	135.37	135.59	134.76	134.84	1075.0
2011-09-25 18:00:00	GC	Futures	2311.7	2311.7	2273.0	2290.1	6098.0
2011-09-25 19:00:00	GC	Futures	2289.8	2308.2	2286.2	2301.7	2443.0
2011-09-25 20:00:00	GC	Futures	2302.2	2320.5	2299.2	2311.4	7107.0
2011-09-25 21:00:00	GC	Futures	2311.4	2315.6	2289.0	2295.3	8301.0
2011-09-25 22:00:00	GC	Futures	2295.3	2296.4	2280.0	2283.9	4862.0
2011-09-25 23:00:00	GC	Futures	2283.9	2288.6	2273.0	2274.0	8180.0
2011-09-25 18:00:00	ZN	Futures	113.305718	113.359931	113.183738	113.197291	8062.0
2011-09-25 19:00:00	ZN	Futures	113.197291	113.305718	113.197291	113.278611	6060.0
2011-09-25 20:00:00	ZN	Futures	113.265058	113.441251	113.251505	113.427698	13903.0
2011-09-25 21:00:00	ZN	Futures	113.427698	113.576784	113.387038	113.481911	12685.0
2011-09-25 22:00:00	ZN	Futures	113.481911	113.522571	113.427698	113.468358	5802.0
2011-09-25 23:00:00	ZN	Futures	113.468358	113.563231	113.454804	113.536124	4405.0

> showing 36 of 274 rows — these rows as CSV

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