PREVIEW / futures_daily / 2012-12-31

all futures daily files

  file:    by_date/futures_daily/2012/2012-12-31.parquet
  size:    9 KB
  rows:    88

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-12-31	ES	Futures	1420.45	1458.82	1415.59	1452.94	1480199.0
2012-12-31	NQ	Futures	2987.7	3073.91	2975.87	3062.67	198763.0
2012-12-31	YM	Futures	12552.6	12824.2	12494.7	12774.2	129952.0
2012-12-31	CL	Futures	160.46	163.27	159.74	162.97	119525.0
2012-12-31	GC	Futures	2206.7	2240.1	2206.7	2233.2	85218.0
2012-12-31	ZN	Futures	117.272536	117.369011	116.707467	117.120932	327518.0
2012-12-31	A6	Futures	0.94447	0.94712	0.94319	0.94484	43990.0
2012-12-31	AD	Futures	1.0053	1.01102	1.0039	1.0064	39827.0
2012-12-31	B	Futures	102.39	103.27	101.45	103.08	47886.0
2012-12-31	B6	Futures	1.6889	1.7003	1.6857	1.6971	60151.0
2012-12-31	BFX	Futures	2972.4	2998.2	2972.4	2998.2	39.0
2012-12-31	BR	Futures	0.23814	0.23944	0.2378	0.2378	12.0
2012-12-31	BZ	Futures	105.48	105.48	105.37	105.37	565.0
2012-12-31	C	Futures	1543.0	1544.0	1532.0	1538.0	1473.0
2012-12-31	CB	Futures	84.055	84.055	83.924	83.924	2.0
2012-12-31	CC	Futures	1698.0	1704.0	1665.0	1687.0	7162.0
2012-12-31	CSC	Futures	3.852	3.852	3.83	3.83	75.0
2012-12-31	CT	Futures	94.02	95.41	93.95	94.56	8597.0
2012-12-31	DC	Futures	28.86	29.05	28.71	28.75	104.0
2012-12-31	DX	Futures	76.899	77.116	76.856	77.031	11779.0
2012-12-31	E1	Futures	1.41097	1.41328	1.40633	1.40929	15164.0
2012-12-31	E6	Futures	1.56	1.56212	1.55457	1.55776	103044.0
2012-12-31	E7	Futures	1.5484	1.5515	1.544	1.5471	2852.0
2012-12-31	EBM	Futures	277.56	277.56	275.34	276.73	2811.0
2012-12-31	ED	Futures	95.2151	95.2342	95.2103	95.2295	59148.0
2012-12-31	ER	Futures	97.842	97.847	97.837	97.842	4737.0
2012-12-31	EW	Futures	1013.7	1040.6	1013.7	1038.0	20007.0
2012-12-31	FCE	Futures	2718.0	2755.6	2701.4	2742.1	27621.0
2012-12-31	FTI	Futures	292.51	295.95	291.61	294.83	5705.0
2012-12-31	FTUK	Futures	4303.8	4326.6	4287.2	4301.5	20312.0
2012-12-31	G	Futures	98.61	98.9	98.61	98.8	16088.0
2012-12-31	GF	Futures	288.474	290.371	286.813	287.288	1140.0
2012-12-31	GSCI	Futures	1037.03	1044.2	1036.87	1043.88	164.0
2012-12-31	HE	Futures	98.15	98.781	97.375	98.38	16789.0
2012-12-31	HG	Futures	4.6076	4.6936	4.5992	4.6904	26440.0
2012-12-31	HH	Futures	39.799	39.799	39.295	39.341	21.0
2012-12-31	HO	Futures	2.4202	2.4396	2.3991	2.4338	16036.0
2012-12-31	HRC	Futures	2428.1	2428.1	2428.1	2428.1	0.0
2012-12-31	J1	Futures	0.0146055	0.0146105	0.0144439	0.0144727	64347.0
2012-12-31	J7	Futures	0.014525	0.014545	0.014372	0.014401	670.0
2012-12-31	JB	Futures	126.94	126.98	126.77	126.77	236.0
2012-12-31	KC	Futures	306.58	306.89	296.4	301.75	10468.0
2012-12-31	KE	Futures	2720.57	2740.33	2687.63	2737.04	6130.0
2012-12-31	L	Futures	98.901	98.911	98.891	98.911	11938.0
2012-12-31	LBS	Futures	674.9	674.9	663.1	663.6	986.0
2012-12-31	LE	Futures	169.594	170.006	168.069	168.101	21631.0
2012-12-31	MFS	Futures	1461.2	1482.2	1458.2	1475.7	5945.0
2012-12-31	MGC	Futures	2178.2	2209.4	2178.0	2202.9	600.0
2012-12-31	MME	Futures	971.3	992.4	970.7	988.2	12176.0
2012-12-31	MP	Futures	0.04463	0.04514	0.0444	0.04485	21175.0

> showing 50 of 88 rows — these rows as CSV

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