PREVIEW / futures_daily / 2013-05-20

all futures daily files

  file:    by_date/futures_daily/2013/2013-05-20.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-05-20	ES	Futures	1706.82	1715.29	1704.0	1708.87	1749840.0
2013-05-20	NQ	Futures	3489.81	3502.23	3476.82	3489.53	193256.0
2013-05-20	YM	Futures	15067.0	15132.0	15056.1	15084.7	105444.0
2013-05-20	CL	Futures	167.85	169.77	166.49	169.03	263796.0
2013-05-20	GC	Futures	1807.2	1855.7	1774.0	1837.4	258371.0
2013-05-20	ZN	Futures	117.448072	117.642868	117.225448	117.378502	1190631.0
2013-05-20	A6	Futures	0.89867	0.90531	0.89691	0.90439	120846.0
2013-05-20	AD	Futures	0.97673	0.98286	0.97522	0.98185	76064.0
2013-05-20	B	Futures	100.79	101.33	99.9	100.84	164956.0
2013-05-20	B6	Futures	1.5888	1.5988	1.5867	1.5975	110467.0
2013-05-20	BFX	Futures	3269.6	3278.9	3269.6	3278.9	1.0
2013-05-20	BR	Futures	0.24279	0.24299	0.24218	0.24223	177.0
2013-05-20	BZ	Futures	101.46	102.34	100.9	101.85	3976.0
2013-05-20	C	Futures	1664.0	1666.0	1648.0	1650.0	4544.0
2013-05-20	CB	Futures	82.362	82.362	81.105	81.352	22.0
2013-05-20	CC	Futures	1730.0	1735.0	1718.0	1725.0	9018.0
2013-05-20	CNH	Futures	7.1757	7.1757	7.1635	7.1635	36.0
2013-05-20	CSC	Futures	3.637	3.637	3.607	3.627	13.0
2013-05-20	CT	Futures	103.49	104.16	102.25	102.81	12672.0
2013-05-20	DC	Futures	27.86	27.93	27.52	27.78	271.0
2013-05-20	DX	Futures	80.961	81.115	80.539	80.579	34690.0
2013-05-20	E1	Futures	1.32667	1.33374	1.32384	1.33181	37166.0
2013-05-20	E6	Futures	1.51472	1.5212	1.51165	1.52073	196063.0
2013-05-20	E7	Futures	1.5048	1.5113	1.5019	1.5108	2314.0
2013-05-20	ED	Futures	95.2635	95.2707	95.2635	95.2683	123927.0
2013-05-20	ER	Futures	97.837	97.842	97.832	97.832	24647.0
2013-05-20	EW	Futures	1232.9	1240.0	1229.8	1235.4	13147.0
2013-05-20	FBTP	Futures	80.04	80.45	80.04	80.19	20859.0
2013-05-20	FBTS	Futures	93.22	93.305	93.194	93.22	3.0
2013-05-20	FCE	Futures	3090.2	3098.7	3068.9	3094.5	66935.0
2013-05-20	FDAX	Futures	9392.8	9408.4	9338.3	9391.7	65656.0
2013-05-20	FESX	Futures	1972.1	1974.2	1953.9	1968.6	616185.0
2013-05-20	FGBL	Futures	121.6	121.81	121.24	121.41	518659.0
2013-05-20	FGBM	Futures	118.2	118.25	118.02	118.07	367720.0
2013-05-20	FGBS	Futures	110.592	110.592	110.542	110.552	216281.0
2013-05-20	FGBX	Futures	127.37	127.76	126.57	126.93	3520.0
2013-05-20	FMWO	Futures	4979.0	4979.0	4979.0	4979.0	0.0
2013-05-20	FOAT	Futures	109.64	109.74	109.35	109.53	23786.0
2013-05-20	FTDX	Futures	917.9	918.4	917.9	917.9	5.0
2013-05-20	FTI	Futures	320.88	322.14	320.05	321.83	18379.0
2013-05-20	FTUK	Futures	4993.5	5004.6	4966.7	4998.3	71216.0
2013-05-20	FVSA	Futures	2838.05	2929.6	2838.05	2853.31	3413.0
2013-05-20	FXXP	Futures	226.9	227.3	226.2	227.0	795.0
2013-05-20	G	Futures	98.74	98.98	98.56	98.69	123824.0
2013-05-20	GF	Futures	241.318	244.856	239.802	243.424	3534.0
2013-05-20	GSCI	Futures	1023.81	1030.93	1020.65	1028.67	125.0
2013-05-20	HE	Futures	90.225	90.838	89.784	90.323	12624.0
2013-05-20	HG	Futures	4.2265	4.2965	4.1672	4.2806	60937.0
2013-05-20	HH	Futures	46.631	46.665	45.676	45.957	1363.0
2013-05-20	HO	Futures	2.3642	2.3759	2.348	2.3677	7784.0

> showing 50 of 102 rows — these rows as CSV

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