PREVIEW / futures_daily / 2011-07-27

all futures daily files

  file:    by_date/futures_daily/2011/2011-07-27.parquet
  size:    9 KB
  rows:    96

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-07-27	ES	Futures	1316.9	1319.38	1289.09	1290.08	2535676.0
2011-07-27	NQ	Futures	2760.92	2762.34	2684.91	2684.91	328563.0
2011-07-27	YM	Futures	11758.0	11777.9	11564.2	11575.5	139319.0
2011-07-27	CL	Futures	190.07	190.69	186.16	186.66	304524.0
2011-07-27	GC	Futures	2190.0	2202.4	2175.1	2183.6	170615.0
2011-07-27	ZN	Futures	106.027325	106.160375	105.614871	105.787836	1181279.0
2011-07-27	A6	Futures	0.94623	0.95728	0.94466	0.95136	117229.0
2011-07-27	AD	Futures	1.05625	1.05924	1.04846	1.04976	85501.0
2011-07-27	B	Futures	101.03	101.27	100.11	100.24	86314.0
2011-07-27	B6	Futures	1.7073	1.7123	1.696	1.6974	97492.0
2011-07-27	BFX	Futures	2989.8	2989.8	2958.5	2964.4	38.0
2011-07-27	BR	Futures	0.28397	0.28397	0.28196	0.28383	28.0
2011-07-27	BZ	Futures	103.72	103.72	103.53	103.53	859.0
2011-07-27	C	Futures	2019.0	2061.0	2018.0	2046.0	5466.0
2011-07-27	CB	Futures	113.422	113.422	113.422	113.422	2.0
2011-07-27	CC	Futures	2388.0	2422.0	2363.0	2407.0	12983.0
2011-07-27	CSC	Futures	4.929	4.956	4.929	4.956	31.0
2011-07-27	CT	Futures	132.19	135.82	131.1	134.77	61.0
2011-07-27	DC	Futures	33.68	34.31	33.51	34.14	448.0
2011-07-27	DX	Futures	72.979	73.672	72.875	73.556	32760.0
2011-07-27	E1	Futures	1.63311	1.63625	1.62566	1.63141	33695.0
2011-07-27	E6	Futures	1.72096	1.72381	1.70065	1.70457	333394.0
2011-07-27	E7	Futures	1.7087	1.7111	1.6883	1.6921	4873.0
2011-07-27	ED	Futures	94.9525	94.9573	94.9239	94.9334	297636.0
2011-07-27	ER	Futures	97.336	97.361	97.331	97.356	94678.0
2011-07-27	EW	Futures	965.8	968.1	938.7	939.0	25589.0
2011-07-27	FBTP	Futures	61.34	61.34	60.51	60.7	13051.0
2011-07-27	FCE	Futures	2667.6	2669.3	2604.1	2635.1	128657.0
2011-07-27	FDAX	Futures	7849.3	7866.4	7696.5	7768.1	151964.0
2011-07-27	FESX	Futures	1754.3	1755.5	1707.4	1728.6	1349200.0
2011-07-27	FEU3	Futures	97.89	97.895	97.885	97.895	31.0
2011-07-27	FGBL	Futures	102.99	103.87	102.93	103.78	909577.0
2011-07-27	FGBM	Futures	106.57	107.11	106.55	107.02	476937.0
2011-07-27	FGBS	Futures	107.512	107.696	107.512	107.671	552764.0
2011-07-27	FGBX	Futures	98.47	100.34	98.47	100.19	5592.0
2011-07-27	FTDX	Futures	749.3	757.4	746.2	751.1	299.0
2011-07-27	FTI	Futures	277.59	277.8	271.95	274.81	40640.0
2011-07-27	FTUK	Futures	4148.7	4159.3	4063.7	4109.2	108834.0
2011-07-27	FXXP	Futures	181.2	182.2	179.6	180.4	1828.0
2011-07-27	G	Futures	86.2	86.7	86.13	86.54	118822.0
2011-07-27	GF	Futures	316.997	316.997	313.22	314.615	2230.0
2011-07-27	GSCI	Futures	1117.99	1121.44	1110.31	1112.95	106.0
2011-07-27	HE	Futures	110.963	112.34	110.33	112.285	11349.0
2011-07-27	HG	Futures	5.9217	5.9336	5.8457	5.878	26990.0
2011-07-27	HO	Futures	2.524	2.5295	2.5024	2.5053	45155.0
2011-07-27	HRC	Futures	2954.7	2954.7	2954.7	2954.7	0.0
2011-07-27	J1	Futures	0.01613	0.0162092	0.0160847	0.0161124	87373.0
2011-07-27	J7	Futures	0.016023	0.0161	0.015978	0.016005	339.0
2011-07-27	JB	Futures	123.24	123.44	123.22	123.43	957.0
2011-07-27	KC	Futures	579.49	580.32	564.47	570.62	11033.0

> showing 50 of 96 rows — these rows as CSV

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