PREVIEW / futures_daily / 2012-11-19

all futures daily files

  file:    by_date/futures_daily/2012/2012-11-19.parquet
  size:    9 KB
  rows:    100

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-11-19	ES	Futures	1384.95	1410.39	1384.44	1407.09	1741462.0
2012-11-19	NQ	Futures	2916.8	2984.97	2916.23	2974.91	271966.0
2012-11-19	YM	Futures	12283.3	12463.9	12277.4	12438.5	126099.0
2012-11-19	CL	Futures	156.32	160.79	155.98	159.86	247078.0
2012-11-19	GC	Futures	2289.0	2317.1	2287.6	2315.7	125525.0
2012-11-19	ZN	Futures	117.892541	117.906275	117.590393	117.700265	585943.0
2012-11-19	A6	Futures	0.93853	0.94462	0.93816	0.94389	108010.0
2012-11-19	AD	Futures	1.00208	1.0077	1.00128	1.0067	64958.0
2012-11-19	B	Futures	100.84	103.61	100.83	103.15	232659.0
2012-11-19	B6	Futures	1.6597	1.6629	1.659	1.6607	73103.0
2012-11-19	BFX	Futures	2817.8	2847.8	2817.8	2845.3	54.0
2012-11-19	BR	Futures	0.23386	0.23405	0.23233	0.23316	358.0
2012-11-19	BZ	Futures	104.27	106.8	104.27	106.36	782.0
2012-11-19	C	Futures	1581.0	1589.0	1571.0	1581.0	1221.0
2012-11-19	CB	Futures	90.722	90.722	90.722	90.722	1.0
2012-11-19	CC	Futures	1811.0	1833.0	1805.0	1827.0	11254.0
2012-11-19	CSC	Futures	3.922	3.939	3.922	3.939	13.0
2012-11-19	CT	Futures	93.66	94.54	92.86	92.97	5969.0
2012-11-19	DC	Futures	29.15	29.46	29.08	29.46	150.0
2012-11-19	DX	Futures	78.7	78.729	78.298	78.382	17494.0
2012-11-19	E1	Futures	1.36167	1.37055	1.36167	1.36952	28583.0
2012-11-19	E6	Futures	1.50094	1.51013	1.50059	1.5086	215057.0
2012-11-19	E7	Futures	1.4916	1.501	1.4916	1.4996	2751.0
2012-11-19	ED	Futures	95.2229	95.2277	95.2205	95.2229	98378.0
2012-11-19	ER	Futures	97.881	97.886	97.862	97.881	41478.0
2012-11-19	EW	Futures	972.2	989.3	971.6	987.4	18874.0
2012-11-19	FBTP	Futures	73.06	73.09	72.76	72.8	13015.0
2012-11-19	FBTS	Futures	89.969	89.969	89.91	89.943	941.0
2012-11-19	FCE	Futures	2539.5	2593.0	2535.7	2588.5	111040.0
2012-11-19	FDAX	Futures	7682.0	7812.4	7675.4	7805.8	113355.0
2012-11-19	FESX	Futures	1667.5	1699.4	1662.7	1698.1	893407.0
2012-11-19	FGBL	Futures	119.61	119.67	119.4	119.51	406537.0
2012-11-19	FGBM	Futures	117.1	117.15	117.02	117.05	224565.0
2012-11-19	FGBS	Futures	110.532	110.542	110.512	110.517	157222.0
2012-11-19	FGBX	Futures	126.54	126.71	126.21	126.48	6498.0
2012-11-19	FOAT	Futures	105.02	105.2	104.99	105.08	14360.0
2012-11-19	FTDX	Futures	749.1	757.5	746.2	756.6	157.0
2012-11-19	FTI	Futures	276.52	278.84	275.11	278.58	25337.0
2012-11-19	FTUK	Futures	4128.6	4195.9	4124.6	4193.0	88768.0
2012-11-19	FVSA	Futures	4863.82	4886.82	4622.36	4645.35	21193.0
2012-11-19	FXXP	Futures	190.9	193.7	190.9	193.6	3930.0
2012-11-19	G	Futures	99.41	99.46	99.08	99.14	92455.0
2012-11-19	GF	Futures	276.709	278.18	276.092	277.041	1977.0
2012-11-19	GSCI	Futures	1046.26	1053.04	1044.0	1051.02	147.0
2012-11-19	HE	Futures	99.843	100.847	99.671	100.331	14845.0
2012-11-19	HG	Futures	4.4355	4.5588	4.4355	4.5414	15263.0
2012-11-19	HH	Futures	43.27	43.27	43.27	43.27	972.0
2012-11-19	HO	Futures	2.4209	2.4858	2.4209	2.4772	13231.0
2012-11-19	HRC	Futures	2458.3	2458.3	2458.3	2458.3	0.0
2012-11-19	J1	Futures	0.0153835	0.0154436	0.0153497	0.0153923	83803.0

> showing 50 of 100 rows — these rows as CSV

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