PREVIEW / futures_1hour / 2012-08-26

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-08-26.parquet
  size:    14 KB
  rows:    261

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
2012-08-26 18:00:00	ES	Futures	1434.16	1437.21	1433.9	1436.45	7339.0
2012-08-26 19:00:00	ES	Futures	1436.45	1437.46	1434.67	1434.92	4003.0
2012-08-26 20:00:00	ES	Futures	1434.92	1436.7	1434.41	1436.45	5407.0
2012-08-26 21:00:00	ES	Futures	1436.19	1436.96	1434.67	1435.18	7562.0
2012-08-26 22:00:00	ES	Futures	1435.43	1436.19	1434.41	1435.94	3748.0
2012-08-26 23:00:00	ES	Futures	1435.94	1436.19	1435.18	1435.94	2323.0
2012-08-26 18:00:00	NQ	Futures	3228.16	3231.64	3225.55	3231.35	1631.0
2012-08-26 19:00:00	NQ	Futures	3231.35	3233.38	3229.32	3229.61	725.0
2012-08-26 20:00:00	NQ	Futures	3229.32	3232.8	3229.03	3232.8	652.0
2012-08-26 21:00:00	NQ	Futures	3232.51	3233.96	3229.03	3229.03	1074.0
2012-08-26 22:00:00	NQ	Futures	3229.03	3229.61	3226.71	3229.61	1107.0
2012-08-26 23:00:00	NQ	Futures	3229.61	3230.19	3227.58	3229.32	402.0
2012-08-26 18:00:00	YM	Futures	13085.3	13102.2	13082.4	13101.3	642.0
2012-08-26 19:00:00	YM	Futures	13101.3	13107.2	13083.4	13084.4	282.0
2012-08-26 20:00:00	YM	Futures	13085.3	13100.3	13083.4	13100.3	484.0
2012-08-26 21:00:00	YM	Futures	13100.3	13101.3	13084.4	13086.3	786.0
2012-08-26 22:00:00	YM	Futures	13086.3	13091.3	13079.4	13091.3	371.0
2012-08-26 23:00:00	YM	Futures	13091.3	13092.3	13084.4	13088.3	340.0
2012-08-26 18:00:00	CL	Futures	158.24	158.89	157.88	158.53	3341.0
2012-08-26 19:00:00	CL	Futures	158.53	158.66	158.37	158.4	519.0
2012-08-26 20:00:00	CL	Futures	158.37	159.32	158.37	159.3	2128.0
2012-08-26 21:00:00	CL	Futures	159.28	159.96	159.2	159.66	3113.0
2012-08-26 22:00:00	CL	Futures	159.66	159.78	159.33	159.6	1315.0
2012-08-26 23:00:00	CL	Futures	159.58	159.64	159.43	159.43	503.0
2012-08-26 18:00:00	GC	Futures	2308.2	2312.4	2308.2	2312.2	1367.0
2012-08-26 19:00:00	GC	Futures	2312.4	2314.0	2311.7	2312.7	1338.0
2012-08-26 20:00:00	GC	Futures	2312.8	2313.9	2310.2	2312.5	1682.0
2012-08-26 21:00:00	GC	Futures	2312.5	2316.7	2312.5	2315.3	3648.0
2012-08-26 22:00:00	GC	Futures	2315.4	2316.2	2313.9	2315.5	1431.0
2012-08-26 23:00:00	GC	Futures	2315.5	2315.8	2313.2	2314.7	999.0
2012-08-26 18:00:00	ZN	Futures	117.539482	117.56699	117.470714	117.511975	3655.0
2012-08-26 19:00:00	ZN	Futures	117.511975	117.553236	117.484467	117.539482	3190.0
2012-08-26 20:00:00	ZN	Futures	117.539482	117.56699	117.511975	117.525729	3615.0
2012-08-26 21:00:00	ZN	Futures	117.525729	117.56699	117.511975	117.553236	2740.0
2012-08-26 22:00:00	ZN	Futures	117.56699	117.608251	117.553236	117.608251	3117.0
2012-08-26 23:00:00	ZN	Futures	117.594497	117.608251	117.580743	117.580743	714.0

> showing 36 of 261 rows — these rows as CSV

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