PREVIEW / futures_daily / 2012-06-27

all futures daily files

  file:    by_date/futures_daily/2012/2012-06-27.parquet
  size:    9 KB
  rows:    99

schema

  date         DATE
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

date	symbol	asset_type	open	high	low	close	volume
2012-06-27	ES	Futures	1332.49	1345.4	1328.69	1342.36	1615882.0
2012-06-27	NQ	Futures	2924.79	2951.47	2918.19	2935.69	184611.0
2012-06-27	YM	Futures	12112.6	12201.9	12085.5	12178.6	103948.0
2012-06-27	CL	Futures	144.93	147.57	143.49	146.28	253006.0
2012-06-27	GC	Futures	2102.2	2118.3	2089.5	2110.0	115527.0
2012-06-27	ZN	Futures	116.290848	116.427036	116.15466	116.399799	714579.0
2012-06-27	A6	Futures	0.89784	0.90053	0.89613	0.89901	101540.0
2012-06-27	AD	Futures	0.97704	0.97774	0.97463	0.97553	74853.0
2012-06-27	B	Futures	83.54	84.49	82.57	83.99	159004.0
2012-06-27	B6	Futures	1.6336	1.6343	1.6242	1.6256	84598.0
2012-06-27	BFX	Futures	2560.7	2562.1	2560.7	2562.1	7.0
2012-06-27	BR	Futures	0.22777	0.22777	0.22508	0.22508	703.0
2012-06-27	BZ	Futures	89.56	90.38	89.56	89.99	1396.0
2012-06-27	C	Futures	1513.0	1567.0	1512.0	1564.0	3548.0
2012-06-27	CB	Futures	84.367	84.367	84.367	84.367	2.0
2012-06-27	CC	Futures	1613.0	1698.0	1613.0	1682.0	17287.0
2012-06-27	CSC	Futures	3.814	3.823	3.806	3.821	22.0
2012-06-27	CT	Futures	90.23	91.03	89.05	89.33	106.0
2012-06-27	DC	Futures	27.93	28.09	27.83	27.98	116.0
2012-06-27	DX	Futures	80.158	80.469	80.047	80.377	19607.0
2012-06-27	E1	Futures	1.34629	1.34758	1.34074	1.34203	30983.0
2012-06-27	E6	Futures	1.47498	1.47675	1.4692	1.47073	197694.0
2012-06-27	E7	Futures	1.4659	1.4675	1.4601	1.4616	2570.0
2012-06-27	ED	Futures	95.1369	95.1417	95.1274	95.1322	155375.0
2012-06-27	ER	Futures	97.611	97.631	97.602	97.621	129267.0
2012-06-27	EW	Futures	915.1	924.9	913.1	923.1	21625.0
2012-06-27	FBTP	Futures	64.52	64.59	63.76	64.15	15592.0
2012-06-27	FBTS	Futures	83.161	83.368	82.979	83.235	2321.0
2012-06-27	FCE	Futures	2239.5	2273.9	2226.1	2264.6	89398.0
2012-06-27	FDAX	Futures	6730.3	6821.4	6697.5	6790.3	116556.0
2012-06-27	FESX	Futures	1444.6	1465.6	1435.8	1457.4	965031.0
2012-06-27	FEU3	Futures	98.191	98.206	98.191	98.201	650.0
2012-06-27	FGBL	Futures	116.93	117.06	116.45	116.55	550599.0
2012-06-27	FGBM	Futures	115.2	115.24	114.91	114.94	328135.0
2012-06-27	FGBS	Futures	110.193	110.198	110.138	110.158	231345.0
2012-06-27	FGBX	Futures	124.53	124.97	123.65	123.95	5278.0
2012-06-27	FOAT	Futures	98.45	98.62	98.13	98.33	12283.0
2012-06-27	FTDX	Futures	668.6	677.9	658.9	675.6	211.0
2012-06-27	FTI	Futures	251.87	254.16	249.49	253.52	28754.0
2012-06-27	FTUK	Futures	3948.5	4003.1	3937.2	3988.5	67472.0
2012-06-27	FVSA	Futures	8727.63	8803.0	8456.31	8486.45	2444.0
2012-06-27	FXXP	Futures	173.9	175.8	173.4	175.5	2518.0
2012-06-27	G	Futures	98.88	98.97	98.69	98.88	87079.0
2012-06-27	GF	Futures	291.993	295.595	287.306	293.77	7603.0
2012-06-27	GSCI	Futures	911.69	919.92	911.69	914.22	188.0
2012-06-27	HE	Futures	98.319	101.346	97.977	100.609	11315.0
2012-06-27	HG	Futures	4.2842	4.3286	4.2552	4.3241	32430.0
2012-06-27	HO	Futures	2.1071	2.1335	2.0886	2.1199	22312.0
2012-06-27	HRC	Futures	2429.9	2429.9	2429.9	2429.9	0.0
2012-06-27	J1	Futures	0.0157764	0.0158103	0.0157088	0.0157326	56694.0

> showing 50 of 99 rows — these rows as CSV

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