PREVIEW / futures_1hour / 2012-07-01

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-07-01.parquet
  size:    15 KB
  rows:    278

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-07-01 18:00:00	ES	Futures	1382.03	1383.05	1381.27	1382.28	10663.0
2012-07-01 19:00:00	ES	Futures	1382.28	1383.3	1381.01	1381.52	6153.0
2012-07-01 20:00:00	ES	Futures	1381.27	1381.78	1376.44	1377.96	14545.0
2012-07-01 21:00:00	ES	Futures	1377.96	1377.96	1376.69	1377.45	4824.0
2012-07-01 22:00:00	ES	Futures	1377.2	1377.71	1375.93	1377.2	4503.0
2012-07-01 23:00:00	ES	Futures	1377.45	1378.72	1377.2	1377.96	2754.0
2012-07-01 18:00:00	NQ	Futures	3028.72	3032.78	3027.85	3030.17	971.0
2012-07-01 19:00:00	NQ	Futures	3029.88	3032.2	3025.53	3028.14	744.0
2012-07-01 20:00:00	NQ	Futures	3027.56	3027.85	3016.83	3018.86	920.0
2012-07-01 21:00:00	NQ	Futures	3019.15	3019.73	3016.83	3018.28	753.0
2012-07-01 22:00:00	NQ	Futures	3018.28	3019.73	3015.96	3018.86	482.0
2012-07-01 23:00:00	NQ	Futures	3019.15	3021.76	3018.86	3019.73	408.0
2012-07-01 18:00:00	YM	Futures	12755.2	12758.2	12744.3	12750.2	345.0
2012-07-01 19:00:00	YM	Futures	12752.2	12761.2	12741.3	12743.3	193.0
2012-07-01 20:00:00	YM	Futures	12744.3	12745.3	12704.5	12721.4	1312.0
2012-07-01 21:00:00	YM	Futures	12720.4	12721.4	12710.5	12712.4	314.0
2012-07-01 22:00:00	YM	Futures	12712.4	12714.4	12699.5	12711.4	502.0
2012-07-01 23:00:00	YM	Futures	12711.4	12720.4	12710.5	12713.4	362.0
2012-07-01 18:00:00	CL	Futures	139.71	140.37	139.1	139.76	2629.0
2012-07-01 19:00:00	CL	Futures	139.73	139.94	139.47	139.55	1147.0
2012-07-01 20:00:00	CL	Futures	139.56	139.56	138.89	138.92	1809.0
2012-07-01 21:00:00	CL	Futures	138.92	138.92	138.38	138.51	2513.0
2012-07-01 22:00:00	CL	Futures	138.49	138.84	138.08	138.82	3082.0
2012-07-01 23:00:00	CL	Futures	138.84	138.84	138.49	138.74	921.0
2012-07-01 18:00:00	GC	Futures	2213.5	2214.6	2210.5	2214.0	631.0
2012-07-01 19:00:00	GC	Futures	2213.7	2213.9	2211.1	2213.2	605.0
2012-07-01 20:00:00	GC	Futures	2213.5	2213.5	2203.2	2205.6	2775.0
2012-07-01 21:00:00	GC	Futures	2205.6	2205.6	2199.2	2201.0	3111.0
2012-07-01 22:00:00	GC	Futures	2201.0	2205.1	2200.6	2203.9	1493.0
2012-07-01 23:00:00	GC	Futures	2203.8	2206.5	2203.2	2206.3	878.0
2012-07-01 18:00:00	ZN	Futures	117.470714	117.484467	117.333176	117.401945	5170.0
2012-07-01 19:00:00	ZN	Futures	117.401945	117.45696	117.374437	117.415699	4502.0
2012-07-01 20:00:00	ZN	Futures	117.415699	117.511975	117.401945	117.415699	5653.0
2012-07-01 21:00:00	ZN	Futures	117.415699	117.470714	117.415699	117.45696	3102.0
2012-07-01 22:00:00	ZN	Futures	117.443206	117.525729	117.443206	117.484467	4014.0
2012-07-01 23:00:00	ZN	Futures	117.470714	117.498221	117.429452	117.470714	3446.0

> showing 36 of 278 rows — these rows as CSV

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