PREVIEW / futures_daily / 2014-03-19

all futures daily files

  file:    by_date/futures_daily/2014/2014-03-19.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-03-19	ES	Futures	1928.56	1932.19	1905.8	1916.41	2004270.0
2014-03-19	NQ	Futures	4254.2	4265.13	4204.41	4229.45	350571.0
2014-03-19	YM	Futures	16330.7	16360.8	16114.8	16205.2	193215.0
2014-03-19	CL	Futures	175.96	177.14	175.48	176.97	276195.0
2014-03-19	GC	Futures	1787.6	1793.0	1750.3	1768.1	194615.0
2014-03-19	ZN	Futures	115.431775	115.518697	114.1859	114.475638	1710572.0
2014-03-19	A6	Futures	0.87147	0.87272	0.86128	0.86417	94324.0
2014-03-19	AD	Futures	0.90832	0.90974	0.89768	0.90051	98423.0
2014-03-19	B	Futures	109.67	109.95	108.75	108.9	188478.0
2014-03-19	B6	Futures	1.7431	1.7493	1.7338	1.7364	118619.0
2014-03-19	BFX	Futures	3729.9	3735.2	3724.9	3731.2	75.0
2014-03-19	BR	Futures	0.22146	0.22227	0.21985	0.22038	71.0
2014-03-19	BZ	Futures	111.86	112.14	110.94	111.08	8119.0
2014-03-19	C	Futures	1988.0	1995.0	1986.0	1991.0	3507.0
2014-03-19	CB	Futures	93.669	94.151	93.669	93.923	16.0
2014-03-19	CC	Futures	2243.0	2251.0	2236.0	2246.0	5273.0
2014-03-19	CNH	Futures	7.115	7.1246	7.1049	7.1134	71.0
2014-03-19	CSC	Futures	4.509	4.52	4.488	4.488	33.0
2014-03-19	CT	Futures	104.53	104.85	103.94	104.1	5480.0
2014-03-19	DC	Futures	35.74	36.14	35.55	35.81	194.0
2014-03-19	DX	Futures	75.546	76.24	75.518	76.129	25762.0
2014-03-19	E1	Futures	1.47049	1.47139	1.45445	1.45599	33809.0
2014-03-19	E6	Futures	1.64473	1.64485	1.63009	1.63245	186383.0
2014-03-19	E7	Futures	1.6337	1.6338	1.6192	1.6216	5288.0
2014-03-19	EBM	Futures	294.17	300.86	292.76	300.51	19227.0
2014-03-19	ED	Futures	95.3804	95.3899	95.3804	95.3851	201055.0
2014-03-19	ER	Futures	97.822	97.822	97.808	97.817	47023.0
2014-03-19	EW	Futures	1426.2	1430.0	1410.8	1417.3	29629.0
2014-03-19	FBTP	Futures	86.72	86.9	86.54	86.62	42282.0
2014-03-19	FBTS	Futures	97.082	97.135	97.012	97.056	10298.0
2014-03-19	FCE	Futures	3343.5	3360.6	3306.2	3344.7	108063.0
2014-03-19	FDAX	Futures	10246.9	10323.1	10152.5	10276.2	23443.0
2014-03-19	FDIV	Futures	138.61	139.0	138.61	139.0	2.0
2014-03-19	FESX	Futures	2157.2	2170.9	2132.1	2163.0	937733.0
2014-03-19	FGBL	Futures	123.63	123.64	122.81	123.37	712157.0
2014-03-19	FGBM	Futures	119.72	119.73	119.22	119.59	413052.0
2014-03-19	FGBS	Futures	110.533	110.533	110.433	110.503	245992.0
2014-03-19	FGBX	Futures	126.17	126.28	125.16	125.71	19071.0
2014-03-19	FMWO	Futures	5492.6	5502.7	5492.6	5492.6	107.0
2014-03-19	FOAT	Futures	112.24	112.3	111.79	111.92	41626.0
2014-03-19	FTDX	Futures	1176.1	1180.8	1172.3	1179.4	576.0
2014-03-19	FTI	Futures	332.5	333.23	329.26	331.86	27323.0
2014-03-19	FTUK	Futures	4992.1	4998.2	4927.7	4968.9	140288.0
2014-03-19	FVSA	Futures	1930.94	1930.94	1865.74	1880.79	9789.0
2014-03-19	FXXP	Futures	241.4	242.6	241.3	241.9	28597.0
2014-03-19	G	Futures	93.72	93.78	93.49	93.65	157630.0
2014-03-19	GF	Futures	283.198	283.758	281.957	282.797	1066.0
2014-03-19	GSCI	Futures	1058.52	1061.24	1055.79	1060.33	80.0
2014-03-19	HE	Futures	147.767	148.146	146.513	148.029	337.0
2014-03-19	HG	Futures	3.7398	3.7993	3.646	3.7854	107680.0

> showing 50 of 105 rows — these rows as CSV

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