PREVIEW / futures_daily / 2011-09-19

all futures daily files

  file:    by_date/futures_daily/2011/2011-09-19.parquet
  size:    9 KB
  rows:    98

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
2011-09-19	ES	Futures	1197.15	1201.64	1179.43	1195.65	2446620.0
2011-09-19	NQ	Futures	2611.65	2641.9	2573.13	2626.49	317744.0
2011-09-19	YM	Futures	10904.4	10923.7	10736.3	10877.5	123756.0
2011-09-19	CL	Futures	165.56	165.56	160.09	161.8	283210.0
2011-09-19	GC	Futures	2457.3	2474.7	2391.1	2401.8	189056.0
2011-09-19	ZN	Futures	111.469161	112.126124	111.415532	112.018865	894252.0
2011-09-19	A6	Futures	0.89583	0.8975	0.88439	0.88545	118893.0
2011-09-19	AD	Futures	1.01786	1.01886	1.00626	1.00766	87100.0
2011-09-19	B	Futures	95.85	96.2	93.27	93.65	160085.0
2011-09-19	B6	Futures	1.6391	1.6429	1.63	1.6363	95022.0
2011-09-19	BFX	Futures	2542.9	2542.9	2527.3	2532.2	57.0
2011-09-19	BR	Futures	0.25657	0.25657	0.24844	0.24966	920.0
2011-09-19	BZ	Futures	99.41	99.55	96.69	97.01	850.0
2011-09-19	C	Futures	1904.0	1907.0	1861.0	1871.0	14115.0
2011-09-19	CB	Futures	95.888	95.888	95.341	95.341	7.0
2011-09-19	CC	Futures	2178.0	2185.0	2110.0	2130.0	15354.0
2011-09-19	CSC	Futures	4.276	4.276	4.215	4.234	124.0
2011-09-19	CT	Futures	141.1	141.1	135.07	135.07	32.0
2011-09-19	DC	Futures	30.14	30.14	29.17	29.34	451.0
2011-09-19	DX	Futures	76.142	76.633	75.99	76.219	34561.0
2011-09-19	E1	Futures	1.49046	1.49545	1.48102	1.4906	20200.0
2011-09-19	E6	Futures	1.63409	1.63875	1.62274	1.63242	318921.0
2011-09-19	E7	Futures	1.6231	1.6246	1.6088	1.6185	5303.0
2011-09-19	ED	Futures	94.9984	95.0223	94.9746	95.0127	255151.0
2011-09-19	ER	Futures	97.366	97.401	97.356	97.401	249133.0
2011-09-19	EW	Futures	859.1	860.8	840.6	854.4	29449.0
2011-09-19	FBTP	Futures	61.98	62.13	61.73	62.05	4384.0
2011-09-19	FBTS	Futures	81.55	81.751	81.55	81.751	1070.0
2011-09-19	FCE	Futures	2124.2	2129.6	2087.4	2102.8	92891.0
2011-09-19	FDAX	Futures	5957.9	5979.6	5830.8	5911.7	161656.0
2011-09-19	FESX	Futures	1399.5	1404.8	1374.9	1390.2	1331462.0
2011-09-19	FEU3	Futures	97.95	97.96	97.94	97.96	526.0
2011-09-19	FGBL	Futures	110.97	111.43	110.88	111.19	586437.0
2011-09-19	FGBM	Futures	110.95	111.14	110.89	111.01	297733.0
2011-09-19	FGBS	Futures	109.148	109.223	109.123	109.183	338577.0
2011-09-19	FGBX	Futures	112.55	113.77	111.87	113.39	3688.0
2011-09-19	FTDX	Futures	641.2	645.8	629.3	634.3	248.0
2011-09-19	FTI	Futures	231.22	231.22	227.23	228.31	35567.0
2011-09-19	FTUK	Futures	3817.7	3817.7	3732.0	3758.2	97138.0
2011-09-19	FVSA	Futures	17539.63	17856.61	17370.57	17603.02	1984.0
2011-09-19	FXXP	Futures	157.6	157.7	155.6	156.5	786.0
2011-09-19	G	Futures	92.13	92.53	91.96	92.31	90293.0
2011-09-19	GF	Futures	310.473	310.473	307.699	308.718	2158.0
2011-09-19	GSCI	Futures	1024.32	1024.32	1008.64	1009.91	220.0
2011-09-19	HE	Futures	106.687	106.687	104.309	105.177	20815.0
2011-09-19	HG	Futures	5.174	5.1807	4.9828	5.0053	47106.0
2011-09-19	HO	Futures	2.4177	2.426	2.3655	2.3783	17811.0
2011-09-19	HRC	Futures	2910.3	2910.3	2910.3	2910.3	0.0
2011-09-19	J1	Futures	0.0163549	0.0164843	0.0163373	0.0164454	71369.0
2011-09-19	J7	Futures	0.016252	0.016384	0.016239	0.016346	361.0

> showing 50 of 98 rows — these rows as CSV

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