PREVIEW / futures_daily / 2011-09-20

all futures daily files

  file:    by_date/futures_daily/2011/2011-09-20.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-20	ES	Futures	1194.65	1212.37	1183.17	1193.9	2614553.0
2011-09-20	NQ	Futures	2623.92	2662.45	2606.8	2621.35	325787.0
2011-09-20	YM	Futures	10872.7	11023.6	10778.6	10889.1	124364.0
2011-09-20	CL	Futures	162.18	165.33	160.75	163.9	264593.0
2011-09-20	GC	Futures	2404.5	2449.6	2392.5	2442.6	174850.0
2011-09-20	ZN	Futures	112.018865	112.179754	111.697087	111.951828	857655.0
2011-09-20	A6	Futures	0.88861	0.89723	0.88307	0.89398	123207.0
2011-09-20	AD	Futures	1.00876	1.01056	1.00366	1.00736	82202.0
2011-09-20	B	Futures	93.7	95.75	93.27	94.85	175068.0
2011-09-20	B6	Futures	1.6373	1.6423	1.6324	1.6403	97495.0
2011-09-20	BFX	Futures	2519.7	2570.4	2519.7	2570.4	84.0
2011-09-20	BR	Futures	0.24844	0.25128	0.24602	0.24839	1957.0
2011-09-20	BZ	Futures	97.04	99.13	96.82	98.25	762.0
2011-09-20	C	Futures	1872.0	1893.0	1865.0	1876.0	8861.0
2011-09-20	CB	Futures	95.341	95.341	94.245	94.245	22.0
2011-09-20	CC	Futures	2138.0	2159.0	2130.0	2141.0	7386.0
2011-09-20	CSC	Futures	4.227	4.227	4.202	4.207	19.0
2011-09-20	CT	Futures	132.95	136.46	132.95	134.72	16.0
2011-09-20	DC	Futures	29.29	29.45	28.87	29.27	186.0
2011-09-20	DX	Futures	76.407	76.535	75.911	76.11	24673.0
2011-09-20	E1	Futures	1.49204	1.49676	1.47446	1.47957	30647.0
2011-09-20	E6	Futures	1.63362	1.64198	1.62369	1.63481	307611.0
2011-09-20	E7	Futures	1.6193	1.6278	1.6099	1.6208	4262.0
2011-09-20	ED	Futures	95.0175	95.0414	94.9984	95.0318	330721.0
2011-09-20	ER	Futures	97.396	97.435	97.396	97.416	186812.0
2011-09-20	EW	Futures	853.8	866.1	842.4	843.2	28226.0
2011-09-20	FBTP	Futures	61.52	62.01	61.21	61.52	6469.0
2011-09-20	FBTS	Futures	81.43	81.679	81.269	81.631	883.0
2011-09-20	FCE	Futures	2088.5	2138.1	2078.5	2132.8	114475.0
2011-09-20	FDAX	Futures	5859.6	6068.6	5830.8	6055.6	174821.0
2011-09-20	FESX	Futures	1378.2	1418.8	1373.6	1415.5	1332848.0
2011-09-20	FEU3	Futures	97.965	97.975	97.965	97.975	400.0
2011-09-20	FGBL	Futures	111.47	111.77	111.01	111.2	807234.0
2011-09-20	FGBM	Futures	111.15	111.32	110.9	111.01	337921.0
2011-09-20	FGBS	Futures	109.218	109.278	109.133	109.188	404376.0
2011-09-20	FGBX	Futures	114.12	114.32	113.09	113.46	4063.0
2011-09-20	FTDX	Futures	629.3	641.2	624.7	637.6	215.0
2011-09-20	FTI	Futures	227.4	232.67	226.48	232.17	43830.0
2011-09-20	FTUK	Futures	3753.2	3841.8	3724.1	3832.8	111528.0
2011-09-20	FVSA	Futures	17687.55	17687.55	17116.99	17201.51	3955.0
2011-09-20	FXXP	Futures	155.8	159.5	155.8	159.1	6329.0
2011-09-20	G	Futures	92.71	92.71	92.08	92.27	102958.0
2011-09-20	GF	Futures	308.322	311.662	307.416	311.379	1927.0
2011-09-20	GSCI	Futures	1018.78	1027.33	1014.5	1018.62	144.0
2011-09-20	HE	Futures	105.338	106.784	105.241	106.655	17542.0
2011-09-20	HG	Futures	5.0219	5.0602	4.9028	4.9299	43969.0
2011-09-20	HO	Futures	2.3856	2.4136	2.3692	2.3925	13216.0
2011-09-20	HRC	Futures	2890.0	2890.0	2890.0	2890.0	0.0
2011-09-20	J1	Futures	0.0164215	0.0164755	0.0163888	0.016473	78983.0
2011-09-20	J7	Futures	0.016319	0.016376	0.016292	0.016373	425.0

> showing 50 of 98 rows — these rows as CSV

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