PREVIEW / futures_daily / 2011-09-27

all futures daily files

  file:    by_date/futures_daily/2011/2011-09-27.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-27	ES	Futures	1155.47	1187.91	1152.97	1167.45	3258954.0
2011-09-27	NQ	Futures	2541.45	2608.51	2535.46	2572.84	351571.0
2011-09-27	YM	Futures	10537.5	10844.9	10514.4	10682.5	152969.0
2011-09-27	CL	Futures	153.64	159.84	152.58	159.24	313568.0
2011-09-27	GC	Futures	2199.7	2267.2	2182.9	2231.1	228887.0
2011-09-27	ZN	Futures	111.844569	111.978643	111.160791	111.174198	1026823.0
2011-09-27	A6	Futures	0.85669	0.86953	0.85124	0.86759	155505.0
2011-09-27	AD	Futures	0.97464	0.98444	0.97134	0.98194	116191.0
2011-09-27	B	Futures	90.34	92.67	90.09	92.38	177588.0
2011-09-27	B6	Futures	1.6223	1.6379	1.6191	1.6328	123908.0
2011-09-27	BFX	Futures	2532.7	2596.5	2532.7	2596.5	5.0
2011-09-27	BR	Futures	0.24708	0.24844	0.24708	0.24844	406.0
2011-09-27	BZ	Futures	96.06	97.79	96.06	97.63	960.0
2011-09-27	C	Futures	1851.0	1874.0	1835.0	1862.0	5818.0
2011-09-27	CB	Futures	93.697	93.697	93.697	93.697	16.0
2011-09-27	CC	Futures	2095.0	2146.0	2078.0	2134.0	10771.0
2011-09-27	CSC	Futures	4.142	4.142	4.098	4.105	130.0
2011-09-27	CT	Futures	128.52	131.73	128.28	129.12	6630.0
2011-09-27	DC	Futures	28.81	28.87	28.12	28.29	386.0
2011-09-27	DX	Futures	77.379	77.551	76.505	76.601	31768.0
2011-09-27	E1	Futures	1.45792	1.47249	1.4511	1.46829	18739.0
2011-09-27	E6	Futures	1.61593	1.6329	1.61043	1.63015	370514.0
2011-09-27	E7	Futures	1.6021	1.6189	1.5967	1.6162	6853.0
2011-09-27	ED	Futures	95.008	95.0127	94.9889	94.9984	114955.0
2011-09-27	ER	Futures	97.504	97.504	97.371	97.401	296768.0
2011-09-27	EW	Futures	808.9	842.2	807.8	826.1	34765.0
2011-09-27	FBTP	Futures	61.88	62.14	61.71	62.01	7544.0
2011-09-27	FBTS	Futures	81.799	81.871	81.727	81.823	1865.0
2011-09-27	FCE	Futures	2082.8	2168.1	2082.8	2160.6	156896.0
2011-09-27	FDAX	Futures	5948.6	6171.2	5948.1	6103.9	214940.0
2011-09-27	FESX	Futures	1410.8	1460.7	1408.1	1448.0	1836219.0
2011-09-27	FEU3	Futures	98.014	98.014	97.95	97.96	166.0
2011-09-27	FGBL	Futures	110.64	110.64	109.65	109.94	1160682.0
2011-09-27	FGBM	Futures	110.74	110.81	110.3	110.44	524170.0
2011-09-27	FGBS	Futures	109.123	109.133	108.94	109.004	760629.0
2011-09-27	FGBX	Futures	114.21	114.47	111.89	112.2	5442.0
2011-09-27	FTDX	Futures	614.6	642.2	614.6	631.1	274.0
2011-09-27	FTI	Futures	228.44	235.04	227.65	234.29	56134.0
2011-09-27	FTUK	Futures	3677.1	3797.3	3677.1	3771.5	146858.0
2011-09-27	FVSA	Futures	18046.8	18258.12	17581.89	17581.89	3156.0
2011-09-27	FXXP	Futures	156.6	159.9	156.1	159.5	5617.0
2011-09-27	G	Futures	91.98	92.0	91.01	91.3	214889.0
2011-09-27	GF	Futures	312.907	318.341	312.511	315.907	3651.0
2011-09-27	GSCI	Futures	967.53	984.32	967.53	981.39	352.0
2011-09-27	HE	Futures	106.719	108.615	106.687	107.298	15289.0
2011-09-27	HG	Futures	4.4165	4.6097	4.3642	4.5514	66499.0
2011-09-27	HO	Futures	2.2728	2.3271	2.2699	2.3212	34705.0
2011-09-27	HRC	Futures	2747.5	2747.5	2747.5	2747.5	0.0
2011-09-27	J1	Futures	0.0164718	0.0164906	0.0163461	0.0163838	92507.0
2011-09-27	J7	Futures	0.016352	0.016389	0.016253	0.016284	487.0

> showing 50 of 98 rows — these rows as CSV

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