PREVIEW / futures_daily / 2014-07-22

all futures daily files

  file:    by_date/futures_daily/2014/2014-07-22.parquet
  size:    9 KB
  rows:    103

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-22	ES	Futures	2042.01	2057.34	2041.49	2051.62	1274851.0
2014-07-22	NQ	Futures	4528.0	4568.39	4527.14	4558.0	198837.0
2014-07-22	YM	Futures	17131.6	17222.4	17128.5	17186.0	118907.0
2014-07-22	CL	Futures	189.19	190.44	187.59	188.49	252395.0
2014-07-22	GC	Futures	1729.2	1735.0	1715.8	1721.2	127494.0
2014-07-22	ZN	Futures	117.00258	117.13388	116.769159	117.090113	1022281.0
2014-07-22	A6	Futures	0.90253	0.90726	0.90127	0.90436	100046.0
2014-07-22	AD	Futures	0.94465	0.94526	0.94272	0.94495	35507.0
2014-07-22	ALI	Futures	2955.62	2955.62	2955.62	2955.62	0.0
2014-07-22	B	Futures	113.38	114.01	112.36	112.89	183102.0
2014-07-22	B6	Futures	1.7941	1.7951	1.7906	1.7926	71338.0
2014-07-22	BR	Futures	0.23455	0.23597	0.23445	0.23566	1737.0
2014-07-22	BZ	Futures	113.98	114.72	113.23	113.61	8368.0
2014-07-22	C	Futures	2047.0	2060.0	2041.0	2059.0	8771.0
2014-07-22	CB	Futures	127.441	129.118	127.161	129.118	31.0
2014-07-22	CC	Futures	2289.0	2306.0	2289.0	2301.0	11609.0
2014-07-22	CSC	Futures	4.399	4.448	4.399	4.446	24.0
2014-07-22	CT	Futures	86.6	87.75	86.6	86.79	33.0
2014-07-22	DC	Futures	35.32	36.03	35.32	35.82	241.0
2014-07-22	DX	Futures	76.546	76.816	76.517	76.759	31958.0
2014-07-22	E1	Futures	1.42788	1.42827	1.42045	1.42109	45784.0
2014-07-22	E6	Futures	1.5961	1.59669	1.58831	1.58913	191543.0
2014-07-22	E7	Futures	1.5855	1.5862	1.578	1.5788	2234.0
2014-07-22	ED	Futures	95.4115	95.4162	95.4115	95.4162	53029.0
2014-07-22	ER	Futures	97.886	97.891	97.871	97.876	97717.0
2014-07-22	EW	Futures	1458.2	1471.4	1457.8	1463.9	12822.0
2014-07-22	FBTP	Futures	92.07	92.18	91.93	92.0	29364.0
2014-07-22	FBTS	Futures	98.356	98.428	98.339	98.392	9764.0
2014-07-22	FCE	Futures	3439.9	3479.7	3431.6	3476.1	83783.0
2014-07-22	FDAX	Futures	10643.0	10731.1	10626.0	10721.2	86656.0
2014-07-22	FESX	Futures	2267.0	2295.8	2264.9	2294.4	778721.0
2014-07-22	FEU3	Futures	98.507	98.507	98.497	98.497	500.0
2014-07-22	FGBL	Futures	128.95	128.98	128.62	128.69	638588.0
2014-07-22	FGBM	Futures	121.71	121.74	121.58	121.62	387466.0
2014-07-22	FGBS	Futures	110.768	110.768	110.748	110.758	158650.0
2014-07-22	FGBX	Futures	135.88	135.93	135.3	135.46	26101.0
2014-07-22	FMWO	Futures	5785.2	5817.9	5785.2	5817.9	32.0
2014-07-22	FOAT	Futures	118.82	118.84	118.62	118.67	67163.0
2014-07-22	FTDX	Futures	1160.8	1179.0	1158.0	1178.1	354.0
2014-07-22	FTI	Futures	349.78	352.51	349.78	352.25	26088.0
2014-07-22	FTUK	Futures	5148.5	5195.0	5146.2	5190.4	78404.0
2014-07-22	FVSA	Futures	1413.63	1413.63	1371.18	1375.42	7002.0
2014-07-22	FXXP	Futures	255.4	257.7	255.2	257.5	5171.0
2014-07-22	G	Futures	94.72	94.81	94.49	94.65	170526.0
2014-07-22	GF	Futures	326.673	331.079	326.634	331.079	3822.0
2014-07-22	GSCI	Futures	1062.39	1063.48	1055.03	1055.03	79.0
2014-07-22	HE	Futures	131.229	134.194	130.6	133.879	19240.0
2014-07-22	HG	Futures	4.0877	4.1363	4.0851	4.1005	42985.0
2014-07-22	HH	Futures	48.645	48.645	47.596	47.697	13396.0
2014-07-22	HO	Futures	2.2922	2.3068	2.2796	2.2865	43644.0

> showing 50 of 103 rows — these rows as CSV

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