PREVIEW / futures_daily / 2012-03-27

all futures daily files

  file:    by_date/futures_daily/2012/2012-03-27.parquet
  size:    9 KB
  rows:    99

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
2012-03-27	ES	Futures	1425.92	1430.71	1416.85	1417.35	1251826.0
2012-03-27	NQ	Futures	3180.23	3195.99	3175.94	3180.23	179109.0
2012-03-27	YM	Futures	12833.9	12880.6	12761.0	12763.0	87238.0
2012-03-27	CL	Futures	197.41	198.59	196.36	197.85	209036.0
2012-03-27	GC	Futures	2262.3	2272.0	2247.8	2256.1	79720.0
2012-03-27	ZN	Futures	111.796643	112.378776	111.715415	112.28401	973085.0
2012-03-27	A6	Futures	0.93967	0.94111	0.93158	0.93455	102045.0
2012-03-27	AD	Futures	1.01336	1.01446	1.00873	1.01014	61916.0
2012-03-27	B	Futures	113.0	113.38	112.26	112.84	140935.0
2012-03-27	B6	Futures	1.6746	1.6787	1.6724	1.6744	85884.0
2012-03-27	BFX	Futures	2887.3	2887.3	2865.4	2865.4	8.0
2012-03-27	BR	Futures	0.25924	0.25979	0.25924	0.25979	17.0
2012-03-27	BZ	Futures	119.53	119.79	118.87	119.36	777.0
2012-03-27	C	Futures	1519.0	1540.0	1518.0	1528.0	6342.0
2012-03-27	CB	Futures	81.945	81.945	81.945	81.945	5.0
2012-03-27	CC	Futures	1772.0	1814.0	1766.0	1793.0	12020.0
2012-03-27	CSC	Futures	3.625	3.625	3.623	3.623	3.0
2012-03-27	CT	Futures	113.89	116.61	113.15	115.88	20018.0
2012-03-27	DC	Futures	25.6	25.99	25.35	25.38	86.0
2012-03-27	DX	Futures	76.663	76.876	76.474	76.757	20754.0
2012-03-27	E1	Futures	1.45131	1.45354	1.44765	1.44974	32617.0
2012-03-27	E6	Futures	1.59485	1.59855	1.58996	1.59259	182687.0
2012-03-27	E7	Futures	1.5793	1.5832	1.5747	1.5773	3158.0
2012-03-27	EBM	Futures	292.77	293.44	287.04	287.38	10261.0
2012-03-27	ED	Futures	95.0836	95.1027	95.0788	95.0979	150789.0
2012-03-27	ER	Futures	97.567	97.582	97.548	97.553	85569.0
2012-03-27	EW	Futures	1015.2	1020.3	1008.8	1009.7	14164.0
2012-03-27	FBTP	Futures	68.56	68.57	67.95	68.06	11433.0
2012-03-27	FBTS	Futures	86.055	86.063	85.827	85.876	1739.0
2012-03-27	FCE	Futures	2498.0	2507.9	2450.1	2460.4	88489.0
2012-03-27	FDAX	Futures	7896.7	7922.7	7821.0	7839.8	124398.0
2012-03-27	FESX	Futures	1716.5	1726.9	1689.6	1695.8	977333.0
2012-03-27	FEU3	Futures	98.127	98.127	98.127	98.127	61.0
2012-03-27	FGBL	Futures	112.21	112.79	112.03	112.59	729973.0
2012-03-27	FGBM	Futures	113.14	113.42	113.04	113.34	360583.0
2012-03-27	FGBS	Futures	109.859	109.909	109.824	109.884	300708.0
2012-03-27	FGBX	Futures	115.57	116.84	115.22	116.22	5093.0
2012-03-27	FTDX	Futures	755.1	757.9	749.9	750.8	210.0
2012-03-27	FTI	Futures	279.29	279.92	276.2	277.0	24074.0
2012-03-27	FTUK	Futures	4286.3	4300.5	4237.4	4251.6	91459.0
2012-03-27	FVSA	Futures	7431.35	7699.14	7230.5	7682.41	4150.0
2012-03-27	FXXP	Futures	191.7	192.5	189.7	190.1	1617.0
2012-03-27	G	Futures	92.91	93.28	92.67	93.22	121514.0
2012-03-27	GF	Futures	320.308	324.024	319.89	322.402	1564.0
2012-03-27	GSCI	Futures	1116.31	1120.75	1112.44	1114.02	238.0
2012-03-27	HE	Futures	103.119	103.972	102.844	103.972	376.0
2012-03-27	HG	Futures	5.1091	5.1183	5.0541	5.0868	43659.0
2012-03-27	HO	Futures	2.6765	2.6818	2.6552	2.6694	21182.0
2012-03-27	HRC	Futures	2699.8	2699.8	2699.8	2699.8	0.0
2012-03-27	J1	Futures	0.015142	0.0151833	0.0150467	0.0151043	99844.0

> showing 50 of 99 rows — these rows as CSV

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