PREVIEW / futures_daily / 2014-12-23

all futures daily files

  file:    by_date/futures_daily/2014/2014-12-23.parquet
  size:    9 KB
  rows:    104

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-12-23	ES	Futures	2172.77	2184.82	2171.2	2179.06	777814.0
2014-12-23	NQ	Futures	4980.84	5003.18	4959.96	4963.73	148403.0
2014-12-23	YM	Futures	18233.8	18351.9	18223.6	18308.1	70412.0
2014-12-23	CL	Futures	108.48	112.73	107.84	111.87	274003.0
2014-12-23	GC	Futures	1539.4	1550.9	1534.6	1541.9	105530.0
2014-12-23	ZN	Futures	119.393088	119.466697	118.627559	118.71589	547909.0
2014-12-23	A6	Futures	0.79102	0.79317	0.78768	0.78837	40103.0
2014-12-23	AD	Futures	0.87391	0.87666	0.87147	0.87524	35032.0
2014-12-23	ALI	Futures	2846.91	2846.91	2846.91	2846.91	7.0
2014-12-23	B	Futures	62.24	64.21	61.83	63.74	159862.0
2014-12-23	B6	Futures	1.6378	1.6402	1.6273	1.6308	62671.0
2014-12-23	BFX	Futures	3999.4	4015.8	3999.4	4015.8	8.0
2014-12-23	BR	Futures	0.20394	0.20394	0.20038	0.20049	10.0
2014-12-23	BZ	Futures	62.86	64.76	62.42	64.31	13242.0
2014-12-23	C	Futures	2171.0	2179.0	2165.0	2173.0	3268.0
2014-12-23	CB	Futures	135.549	135.549	135.138	135.138	20.0
2014-12-23	CC	Futures	2195.0	2203.0	2180.0	2189.0	7121.0
2014-12-23	CSC	Futures	4.557	4.557	4.438	4.455	81.0
2014-12-23	CT	Futures	79.24	80.26	78.62	78.96	14554.0
2014-12-23	DC	Futures	35.48	35.69	34.85	35.13	207.0
2014-12-23	DX	Futures	85.139	85.575	85.045	85.5	26083.0
2014-12-23	E1	Futures	1.29965	1.30156	1.29365	1.29505	21026.0
2014-12-23	E6	Futures	1.43938	1.44138	1.43185	1.43326	96628.0
2014-12-23	E7	Futures	1.4309	1.4328	1.4234	1.4247	3109.0
2014-12-23	EBM	Futures	324.01	328.47	323.2	327.66	11542.0
2014-12-23	ED	Futures	95.4354	95.445	95.4306	95.4402	144009.0
2014-12-23	ER	Futures	98.009	98.009	98.004	98.009	18629.0
2014-12-23	EW	Futures	1519.0	1530.4	1519.0	1525.1	14662.0
2014-12-23	FBTP	Futures	98.46	98.66	98.27	98.48	18199.0
2014-12-23	FBTS	Futures	98.606	98.677	98.562	98.668	10045.0
2014-12-23	FCE	Futures	3488.8	3537.8	3481.1	3526.8	63091.0
2014-12-23	FDAX	Futures	11022.5	11045.3	10952.0	11024.2	62290.0
2014-12-23	FESX	Futures	2284.0	2306.3	2271.0	2298.4	521449.0
2014-12-23	FGBL	Futures	135.82	135.98	135.64	135.86	204242.0
2014-12-23	FGBM	Futures	123.61	123.64	123.55	123.59	124249.0
2014-12-23	FGBS	Futures	110.963	110.988	110.963	110.973	86914.0
2014-12-23	FGBX	Futures	153.37	153.97	153.17	153.59	8236.0
2014-12-23	FMWO	Futures	5670.6	5683.0	5664.4	5680.5	1052.0
2014-12-23	FOAT	Futures	125.28	125.4	125.21	125.35	16866.0
2014-12-23	FTDX	Futures	1296.6	1296.6	1278.7	1292.3	54.0
2014-12-23	FTI	Futures	367.23	370.78	366.19	369.57	21058.0
2014-12-23	FTUK	Futures	5106.6	5126.1	5095.3	5097.6	55377.0
2014-12-23	FVSA	Futures	1738.01	1749.65	1718.62	1745.77	1655.0
2014-12-23	FXXP	Futures	258.9	260.1	258.1	259.5	5273.0
2014-12-23	G	Futures	102.49	102.62	102.14	102.16	48790.0
2014-12-23	GF	Futures	354.11	354.191	347.532	348.374	2994.0
2014-12-23	GSCI	Futures	744.65	752.91	737.91	752.57	80.0
2014-12-23	HE	Futures	107.861	110.377	107.593	109.538	11271.0
2014-12-23	HG	Futures	3.6489	3.6591	3.626	3.6406	20058.0
2014-12-23	HH	Futures	38.604	38.821	37.271	38.088	7486.0

> showing 50 of 104 rows — these rows as CSV

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