PREVIEW / futures_1hour / 2012-05-20

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-05-20.parquet
  size:    14 KB
  rows:    270

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-05-20 18:00:00	ES	Futures	1307.17	1308.94	1302.62	1303.63	20516.0
2012-05-20 19:00:00	ES	Futures	1303.63	1310.46	1303.38	1309.95	13635.0
2012-05-20 20:00:00	ES	Futures	1309.95	1313.24	1309.45	1310.71	16525.0
2012-05-20 21:00:00	ES	Futures	1310.96	1314.76	1309.7	1314.51	15809.0
2012-05-20 22:00:00	ES	Futures	1314.25	1314.76	1310.21	1312.48	8334.0
2012-05-20 23:00:00	ES	Futures	1312.23	1313.24	1311.22	1312.99	3723.0
2012-05-20 18:00:00	NQ	Futures	2860.19	2863.37	2851.52	2854.12	2273.0
2012-05-20 19:00:00	NQ	Futures	2853.25	2867.13	2851.81	2866.56	1043.0
2012-05-20 20:00:00	NQ	Futures	2866.56	2874.07	2865.69	2868.29	1576.0
2012-05-20 21:00:00	NQ	Futures	2868.58	2875.81	2865.69	2875.52	1616.0
2012-05-20 22:00:00	NQ	Futures	2875.52	2875.81	2865.98	2871.47	746.0
2012-05-20 23:00:00	NQ	Futures	2871.47	2874.65	2868.87	2874.07	624.0
2012-05-20 18:00:00	YM	Futures	12289.4	12309.3	12259.5	12269.4	1029.0
2012-05-20 19:00:00	YM	Futures	12266.4	12321.2	12266.4	12319.2	629.0
2012-05-20 20:00:00	YM	Futures	12318.2	12349.1	12317.3	12328.2	1186.0
2012-05-20 21:00:00	YM	Futures	12329.2	12360.1	12322.2	12357.1	1137.0
2012-05-20 22:00:00	YM	Futures	12357.1	12358.1	12322.2	12341.2	527.0
2012-05-20 23:00:00	YM	Futures	12340.2	12349.1	12334.2	12349.1	330.0
2012-05-20 18:00:00	CL	Futures	151.86	151.86	150.88	151.01	1445.0
2012-05-20 19:00:00	CL	Futures	151.0	151.64	150.95	151.63	801.0
2012-05-20 20:00:00	CL	Futures	151.63	152.5	151.61	152.11	2170.0
2012-05-20 21:00:00	CL	Futures	152.07	152.87	151.84	152.85	1704.0
2012-05-20 22:00:00	CL	Futures	152.85	152.92	152.34	152.74	922.0
2012-05-20 23:00:00	CL	Futures	152.75	152.77	152.49	152.69	529.0
2012-05-20 18:00:00	GC	Futures	2203.8	2208.8	2203.5	2205.5	1573.0
2012-05-20 19:00:00	GC	Futures	2205.6	2209.8	2205.2	2209.1	700.0
2012-05-20 20:00:00	GC	Futures	2209.5	2213.8	2206.0	2208.4	4840.0
2012-05-20 21:00:00	GC	Futures	2208.4	2212.7	2208.4	2212.3	3136.0
2012-05-20 22:00:00	GC	Futures	2212.1	2213.6	2209.5	2211.8	1568.0
2012-05-20 23:00:00	GC	Futures	2211.8	2216.0	2211.4	2214.3	1584.0
2012-05-20 18:00:00	ZN	Futures	116.897956	116.993651	116.884285	116.993651	3596.0
2012-05-20 19:00:00	ZN	Futures	116.993651	117.020992	116.911627	116.925297	2666.0
2012-05-20 20:00:00	ZN	Futures	116.925297	116.938968	116.843273	116.925297	9993.0
2012-05-20 21:00:00	ZN	Futures	116.938968	116.938968	116.788591	116.802261	9396.0
2012-05-20 22:00:00	ZN	Futures	116.788591	116.856944	116.788591	116.815932	5241.0
2012-05-20 23:00:00	ZN	Futures	116.815932	116.856944	116.802261	116.815932	3590.0

> showing 36 of 270 rows — these rows as CSV

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