PREVIEW / futures_daily / 2012-09-21

all futures daily files

  file:    by_date/futures_daily/2012/2012-09-21.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-09-21	ES	Futures	1480.11	1488.25	1476.3	1477.82	1605312.0
2012-09-21	NQ	Futures	3284.13	3304.27	3281.83	3282.12	170166.0
2012-09-21	YM	Futures	13200.2	13268.6	13171.9	13182.6	93398.0
2012-09-21	CL	Futures	167.72	169.36	167.11	167.65	181036.0
2012-09-21	GC	Futures	2363.5	2389.9	2362.0	2373.9	185293.0
2012-09-21	ZN	Futures	116.40927	116.697684	116.244463	116.61528	740468.0
2012-09-21	A6	Futures	0.94116	0.94889	0.94071	0.94298	116638.0
2012-09-21	AD	Futures	1.02577	1.02948	1.02426	1.02536	66541.0
2012-09-21	B	Futures	100.76	101.85	100.37	101.6	161966.0
2012-09-21	B6	Futures	1.6932	1.7028	1.6928	1.6962	112399.0
2012-09-21	BFX	Futures	2944.8	2946.7	2939.8	2946.7	18.0
2012-09-21	BR	Futures	0.23789	0.23825	0.23789	0.23825	82.0
2012-09-21	BZ	Futures	106.08	106.71	105.73	106.48	1140.0
2012-09-21	C	Futures	1661.0	1661.0	1633.0	1648.0	7520.0
2012-09-21	CB	Futures	98.75	98.75	98.75	98.75	6.0
2012-09-21	CC	Futures	1910.0	1916.0	1886.0	1901.0	10037.0
2012-09-21	CSC	Futures	4.051	4.057	4.036	4.036	6.0
2012-09-21	CT	Futures	97.18	98.03	94.53	94.85	48.0
2012-09-21	DC	Futures	30.82	30.88	30.39	30.48	170.0
2012-09-21	DX	Futures	76.966	77.024	76.627	76.906	18660.0
2012-09-21	E1	Futures	1.38149	1.38818	1.37917	1.38239	34730.0
2012-09-21	E6	Futures	1.52815	1.5378	1.52685	1.53097	281069.0
2012-09-21	E7	Futures	1.5188	1.5285	1.5177	1.5218	5118.0
2012-09-21	ED	Futures	95.2062	95.2253	95.2062	95.2205	118093.0
2012-09-21	ER	Futures	97.896	97.911	97.886	97.906	97295.0
2012-09-21	EW	Futures	1023.8	1031.4	1021.8	1022.6	21364.0
2012-09-21	FBTP	Futures	71.59	71.67	71.02	71.11	17364.0
2012-09-21	FBTS	Futures	89.424	89.449	89.282	89.299	1814.0
2012-09-21	FCE	Futures	2637.3	2640.3	2611.8	2633.2	132628.0
2012-09-21	FDAX	Futures	8136.7	8198.6	8101.1	8169.0	153647.0
2012-09-21	FESX	Futures	1741.6	1749.1	1728.7	1743.7	1240419.0
2012-09-21	FGBL	Futures	116.86	117.18	116.67	117.01	682861.0
2012-09-21	FGBM	Futures	115.74	115.92	115.68	115.84	326377.0
2012-09-21	FGBS	Futures	110.308	110.353	110.293	110.353	338512.0
2012-09-21	FGBX	Futures	122.23	122.97	121.85	122.42	5546.0
2012-09-21	FOAT	Futures	102.13	102.29	101.99	102.25	19208.0
2012-09-21	FTDX	Futures	769.3	773.1	769.3	771.6	149.0
2012-09-21	FTI	Futures	286.77	286.81	284.42	285.11	30936.0
2012-09-21	FTUK	Futures	4275.0	4293.6	4248.3	4268.4	116237.0
2012-09-21	FVSA	Futures	5474.62	5474.62	5279.1	5315.76	8308.0
2012-09-21	FXXP	Futures	198.3	198.7	197.3	198.1	2387.0
2012-09-21	G	Futures	98.56	98.66	98.22	98.45	116928.0
2012-09-21	GF	Futures	286.274	287.004	285.495	286.615	2859.0
2012-09-21	GSCI	Futures	1068.65	1073.88	1068.08	1069.29	101.0
2012-09-21	HE	Futures	92.758	93.348	92.416	93.193	17644.0
2012-09-21	HG	Futures	4.8538	4.8955	4.8454	4.8692	46942.0
2012-09-21	HH	Futures	38.674	38.674	38.674	38.674	1181.0
2012-09-21	HO	Futures	2.5004	2.5276	2.4972	2.5188	26420.0
2012-09-21	HRC	Futures	2471.7	2471.7	2471.7	2471.7	0.0
2012-09-21	J1	Futures	0.0160145	0.0160408	0.0159857	0.0160333	63405.0

> showing 50 of 99 rows — these rows as CSV

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