PREVIEW / futures_daily / 2013-09-27

all futures daily files

  file:    by_date/futures_daily/2013/2013-09-27.parquet
  size:    9 KB
  rows:    102

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
2013-09-27	ES	Futures	1740.63	1741.66	1725.74	1732.42	1432245.0
2013-09-27	NQ	Futures	3709.45	3713.76	3678.73	3701.7	193112.0
2013-09-27	YM	Futures	15219.5	15222.4	15058.3	15119.0	132108.0
2013-09-27	CL	Futures	182.19	183.71	181.22	182.12	232299.0
2013-09-27	GC	Futures	1750.7	1779.1	1745.8	1771.2	133967.0
2013-09-27	ZN	Futures	114.215442	114.640298	114.116309	114.512841	869080.0
2013-09-27	A6	Futures	0.87999	0.88103	0.87366	0.87574	56843.0
2013-09-27	AD	Futures	0.97814	0.97935	0.97612	0.97905	31444.0
2013-09-27	B	Futures	107.82	108.32	106.82	107.35	148196.0
2013-09-27	B6	Futures	1.6826	1.694	1.6817	1.6926	87743.0
2013-09-27	BR	Futures	0.22242	0.22311	0.22171	0.22222	73.0
2013-09-27	BZ	Futures	108.27	108.98	107.47	107.99	7953.0
2013-09-27	C	Futures	1822.0	1829.0	1810.0	1828.0	5495.0
2013-09-27	CB	Futures	73.495	73.495	73.495	73.495	6.0
2013-09-27	CC	Futures	1941.0	1970.0	1939.0	1967.0	12842.0
2013-09-27	CNH	Futures	7.0684	7.0684	7.067	7.067	11.0
2013-09-27	CSC	Futures	3.277	3.28	3.277	3.277	6.0
2013-09-27	CT	Futures	100.28	102.04	100.28	101.63	16608.0
2013-09-27	DC	Futures	24.89	25.0	24.89	24.97	52.0
2013-09-27	DX	Futures	76.843	76.891	76.419	76.583	17030.0
2013-09-27	E1	Futures	1.41282	1.42554	1.41141	1.41963	27994.0
2013-09-27	E6	Futures	1.59197	1.60106	1.59044	1.59563	149897.0
2013-09-27	E7	Futures	1.5818	1.5909	1.5803	1.5853	2302.0
2013-09-27	ED	Futures	95.3303	95.3351	95.3255	95.3303	99519.0
2013-09-27	ER	Futures	97.837	97.847	97.832	97.842	50621.0
2013-09-27	EW	Futures	1271.7	1272.9	1261.6	1266.6	17710.0
2013-09-27	FBTP	Futures	78.46	78.46	77.9	78.01	55066.0
2013-09-27	FBTS	Futures	93.748	93.748	93.558	93.566	11131.0
2013-09-27	FCE	Futures	3237.4	3244.3	3214.2	3232.4	103001.0
2013-09-27	FDAX	Futures	9620.9	9650.3	9560.4	9614.2	84915.0
2013-09-27	FESX	Futures	2043.9	2050.9	2029.1	2039.0	752715.0
2013-09-27	FGBL	Futures	119.06	119.67	118.99	119.59	588725.0
2013-09-27	FGBM	Futures	117.44	117.69	117.42	117.66	348108.0
2013-09-27	FGBS	Futures	110.388	110.438	110.368	110.433	260880.0
2013-09-27	FGBX	Futures	120.6	121.81	120.6	121.63	13378.0
2013-09-27	FMWO	Futures	5102.9	5102.9	5102.9	5102.9	0.0
2013-09-27	FOAT	Futures	106.6	106.88	106.44	106.8	36973.0
2013-09-27	FTDX	Futures	1018.1	1023.3	1017.7	1023.3	128.0
2013-09-27	FTI	Futures	327.34	327.99	323.96	325.43	23427.0
2013-09-27	FTUK	Futures	4910.3	4911.4	4843.2	4860.8	86794.0
2013-09-27	FVSA	Futures	2334.43	2393.12	2321.39	2380.08	4755.0
2013-09-27	FXXP	Futures	228.5	228.7	226.5	227.4	2051.0
2013-09-27	G	Futures	92.18	92.65	92.09	92.58	110973.0
2013-09-27	GF	Futures	267.316	268.824	267.03	267.56	1458.0
2013-09-27	GSCI	Futures	1065.48	1071.26	1062.8	1064.06	94.0
2013-09-27	HE	Futures	111.446	111.984	110.908	111.541	17415.0
2013-09-27	HG	Futures	4.1785	4.2177	4.1677	4.2158	35962.0
2013-09-27	HH	Futures	37.694	38.378	37.598	38.314	3368.0
2013-09-27	HO	Futures	2.3949	2.411	2.3752	2.3861	20080.0
2013-09-27	HRC	Futures	2277.5	2277.5	2277.5	2277.5	0.0

> showing 50 of 102 rows — these rows as CSV

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