PREVIEW / futures_daily / 2014-11-06

all futures daily files

  file:    by_date/futures_daily/2014/2014-11-06.parquet
  size:    9 KB
  rows:    105

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
2014-11-06	ES	Futures	2108.5	2119.73	2100.4	2118.42	1434905.0
2014-11-06	NQ	Futures	4803.09	4829.45	4786.86	4824.53	233284.0
2014-11-06	YM	Futures	17667.9	17767.4	17619.2	17758.2	136570.0
2014-11-06	CL	Futures	151.43	151.64	148.07	149.59	292897.0
2014-11-06	GC	Futures	1496.3	1507.1	1491.6	1498.7	168560.0
2014-11-06	ZN	Futures	118.39295	118.524742	117.997575	118.14401	1163268.0
2014-11-06	A6	Futures	0.83089	0.83613	0.82894	0.83079	123050.0
2014-11-06	AD	Futures	0.89051	0.89183	0.88685	0.88837	53965.0
2014-11-06	ALI	Futures	3143.74	3143.74	3143.74	3143.74	0.0
2014-11-06	B	Futures	86.49	86.64	85.43	86.29	150897.0
2014-11-06	B6	Futures	1.6773	1.6815	1.6628	1.6643	104012.0
2014-11-06	BFX	Futures	3808.0	3865.9	3808.0	3827.8	40.0
2014-11-06	BR	Futures	0.21285	0.21288	0.2084	0.21013	1381.0
2014-11-06	BZ	Futures	87.31	87.52	86.27	87.17	13891.0
2014-11-06	C	Futures	2017.0	2042.0	2013.0	2039.0	4577.0
2014-11-06	CB	Futures	140.28	140.28	135.27	135.656	4.0
2014-11-06	CC	Futures	2116.0	2133.0	2107.0	2119.0	18224.0
2014-11-06	CNH	Futures	7.0365	7.0402	7.0362	7.0402	13.0
2014-11-06	CSC	Futures	5.095	5.14	4.98	4.98	67.0
2014-11-06	CT	Futures	79.59	80.27	79.22	80.07	11877.0
2014-11-06	DC	Futures	40.74	41.41	39.95	40.01	688.0
2014-11-06	DX	Futures	83.137	83.792	82.805	83.663	55058.0
2014-11-06	E1	Futures	1.32558	1.33185	1.31343	1.31586	64959.0
2014-11-06	E6	Futures	1.46903	1.47574	1.45573	1.45844	349767.0
2014-11-06	E7	Futures	1.4598	1.4663	1.4467	1.4493	6337.0
2014-11-06	ED	Futures	95.4422	95.4422	95.4374	95.4374	47171.0
2014-11-06	ER	Futures	97.999	98.009	97.999	98.004	54407.0
2014-11-06	EW	Futures	1477.3	1489.2	1472.8	1488.7	14481.0
2014-11-06	FBTP	Futures	94.87	95.51	94.72	95.32	106792.0
2014-11-06	FBTS	Futures	98.233	98.419	98.197	98.401	17474.0
2014-11-06	FCE	Futures	3386.0	3451.3	3370.7	3409.8	150287.0
2014-11-06	FDAX	Futures	10168.0	10372.8	10151.0	10274.2	153437.0
2014-11-06	FESX	Futures	2224.5	2273.1	2215.1	2241.2	1492370.0
2014-11-06	FGBL	Futures	133.25	133.33	132.82	133.14	715466.0
2014-11-06	FGBM	Futures	123.21	123.23	123.08	123.19	322735.0
2014-11-06	FGBS	Futures	110.943	110.953	110.918	110.928	175241.0
2014-11-06	FGBX	Futures	145.32	145.34	143.8	144.68	41248.0
2014-11-06	FMWO	Futures	5661.1	5676.1	5654.8	5669.9	606.0
2014-11-06	FOAT	Futures	122.62	122.73	122.34	122.61	108380.0
2014-11-06	FTDX	Futures	1186.6	1198.9	1180.4	1192.3	188.0
2014-11-06	FTI	Futures	357.58	363.45	356.97	361.04	42316.0
2014-11-06	FTUK	Futures	5037.7	5078.7	5018.8	5055.5	99546.0
2014-11-06	FVSA	Futures	1662.49	1687.49	1591.65	1645.82	29426.0
2014-11-06	FXXP	Futures	254.1	257.6	253.3	255.4	9727.0
2014-11-06	G	Futures	98.65	98.89	98.48	98.68	152918.0
2014-11-06	GF	Futures	369.099	370.977	368.942	370.234	1616.0
2014-11-06	GSCI	Futures	896.02	900.69	892.45	900.09	122.0
2014-11-06	HE	Futures	117.867	118.776	117.262	117.968	14773.0
2014-11-06	HG	Futures	3.8103	3.8344	3.7963	3.8274	36392.0
2014-11-06	HH	Futures	50.093	52.56	49.056	52.489	3547.0

> showing 50 of 105 rows — these rows as CSV

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