PREVIEW / futures_daily / 2014-07-23

all futures daily files

  file:    by_date/futures_daily/2014/2014-07-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-07-23	ES	Futures	2049.55	2060.45	2049.29	2057.6	1149621.0
2014-07-23	NQ	Futures	4551.37	4595.79	4550.79	4586.85	209511.0
2014-07-23	YM	Futures	17174.9	17220.3	17144.7	17178.0	113533.0
2014-07-23	CL	Futures	187.7	190.24	187.39	189.84	260652.0
2014-07-23	GC	Futures	1723.4	1728.4	1717.5	1719.1	86756.0
2014-07-23	ZN	Futures	117.104702	117.221413	116.987991	117.104702	608591.0
2014-07-23	A6	Futures	0.90465	0.91103	0.9033	0.91007	86494.0
2014-07-23	AD	Futures	0.94475	0.94709	0.94384	0.94516	41070.0
2014-07-23	ALI	Futures	2952.83	2952.83	2926.13	2926.13	10.0
2014-07-23	B	Futures	112.4	113.86	112.4	113.62	207150.0
2014-07-23	B6	Futures	1.793	1.7964	1.7888	1.7894	95680.0
2014-07-23	BFX	Futures	3856.5	3856.5	3845.7	3845.7	1.0
2014-07-23	BR	Futures	0.23505	0.23526	0.23468	0.23487	314.0
2014-07-23	BZ	Futures	113.36	114.56	113.29	114.35	12856.0
2014-07-23	C	Futures	2056.0	2099.0	2055.0	2091.0	24284.0
2014-07-23	CB	Futures	130.934	131.912	130.934	131.912	16.0
2014-07-23	CC	Futures	2300.0	2354.0	2298.0	2340.0	40472.0
2014-07-23	CNH	Futures	7.1313	7.1313	7.1199	7.1199	2.0
2014-07-23	CSC	Futures	4.466	4.5	4.466	4.493	29.0
2014-07-23	CT	Futures	86.79	86.89	86.75	86.75	5.0
2014-07-23	DC	Futures	35.95	36.55	35.91	36.34	379.0
2014-07-23	DX	Futures	76.764	76.811	76.702	76.807	14119.0
2014-07-23	E1	Futures	1.42096	1.42224	1.41981	1.42071	29587.0
2014-07-23	E6	Futures	1.58913	1.59008	1.58772	1.58807	125308.0
2014-07-23	E7	Futures	1.5787	1.5797	1.5774	1.5777	1233.0
2014-07-23	ED	Futures	95.4162	95.4162	95.4115	95.4162	33537.0
2014-07-23	ER	Futures	97.867	97.881	97.867	97.876	52169.0
2014-07-23	EW	Futures	1463.8	1468.5	1459.9	1463.7	10181.0
2014-07-23	FBTP	Futures	91.98	92.36	91.91	92.29	43348.0
2014-07-23	FBTS	Futures	98.401	98.428	98.365	98.401	7853.0
2014-07-23	FCE	Futures	3465.4	3497.6	3463.8	3480.5	74788.0
2014-07-23	FDAX	Futures	10682.7	10799.4	10678.3	10750.4	75421.0
2014-07-23	FESX	Futures	2283.6	2308.8	2282.9	2295.8	771950.0
2014-07-23	FGBL	Futures	128.82	129.08	128.7	128.97	461465.0
2014-07-23	FGBM	Futures	121.68	121.79	121.63	121.75	300126.0
2014-07-23	FGBS	Futures	110.763	110.768	110.758	110.763	72816.0
2014-07-23	FGBX	Futures	135.7	136.11	135.52	135.97	12444.0
2014-07-23	FMWO	Futures	5812.9	5825.5	5812.9	5825.5	32.0
2014-07-23	FOAT	Futures	118.8	119.05	118.68	119.01	49482.0
2014-07-23	FTDX	Futures	1180.4	1184.6	1180.0	1183.2	327.0
2014-07-23	FTI	Futures	351.21	353.9	350.78	352.69	21913.0
2014-07-23	FTUK	Futures	5176.5	5213.5	5171.9	5191.9	64862.0
2014-07-23	FVSA	Futures	1379.67	1379.67	1354.2	1371.18	3732.0
2014-07-23	FXXP	Futures	257.1	258.6	256.9	257.8	4666.0
2014-07-23	G	Futures	94.68	95.04	94.62	94.92	131355.0
2014-07-23	GF	Futures	332.305	335.217	328.818	332.956	5347.0
2014-07-23	GSCI	Futures	1057.54	1060.55	1056.46	1060.55	165.0
2014-07-23	HE	Futures	133.328	133.669	130.731	130.731	11674.0
2014-07-23	HG	Futures	4.0973	4.1132	4.08	4.0992	30733.0
2014-07-23	HH	Futures	47.773	48.178	47.495	47.571	6953.0

> showing 50 of 104 rows — these rows as CSV

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