PREVIEW / futures_daily / 2012-11-20

all futures daily files

  file:    by_date/futures_daily/2012/2012-11-20.parquet
  size:    9 KB
  rows:    101

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-20	ES	Futures	1404.54	1412.17	1398.43	1410.9	1548714.0
2012-11-20	NQ	Futures	2974.04	2987.85	2954.77	2984.11	227460.0
2012-11-20	YM	Futures	12433.7	12476.6	12368.2	12459.1	122895.0
2012-11-20	CL	Futures	159.63	159.7	154.29	155.33	322630.0
2012-11-20	GC	Futures	2311.8	2317.8	2298.8	2301.2	128071.0
2012-11-20	ZN	Futures	117.741467	117.796403	117.356915	117.439319	967574.0
2012-11-20	A6	Futures	0.94371	0.94534	0.93916	0.94053	103511.0
2012-11-20	AD	Futures	1.00619	1.0076	1.00399	1.00499	59488.0
2012-11-20	B	Futures	103.24	103.29	100.66	101.42	236766.0
2012-11-20	B6	Futures	1.6612	1.6642	1.6596	1.6621	82233.0
2012-11-20	BFX	Futures	2843.0	2852.4	2843.0	2850.1	27.0
2012-11-20	BR	Futures	0.23255	0.23296	0.23255	0.23296	251.0
2012-11-20	BZ	Futures	106.21	106.45	103.82	104.58	420.0
2012-11-20	C	Futures	1581.0	1607.0	1580.0	1601.0	3153.0
2012-11-20	CB	Futures	90.588	90.588	89.919	89.919	5.0
2012-11-20	CC	Futures	1827.0	1866.0	1827.0	1853.0	10887.0
2012-11-20	CSC	Futures	3.931	3.973	3.931	3.964	9.0
2012-11-20	CT	Futures	92.9	93.99	92.54	93.55	10167.0
2012-11-20	DC	Futures	29.43	29.67	29.32	29.61	312.0
2012-11-20	DX	Futures	78.482	78.53	78.307	78.458	13524.0
2012-11-20	E1	Futures	1.36746	1.37093	1.36553	1.36887	25130.0
2012-11-20	E6	Futures	1.50577	1.51107	1.50354	1.50836	238921.0
2012-11-20	E7	Futures	1.4968	1.502	1.4948	1.4993	2947.0
2012-11-20	ED	Futures	95.2229	95.2301	95.2205	95.2253	84561.0
2012-11-20	ER	Futures	97.881	97.886	97.876	97.881	55528.0
2012-11-20	EW	Futures	987.1	994.8	984.6	994.4	16337.0
2012-11-20	FBTP	Futures	72.73	73.13	72.58	72.93	16235.0
2012-11-20	FBTS	Futures	89.893	90.245	89.876	90.077	3000.0
2012-11-20	FCE	Futures	2580.2	2610.8	2570.4	2604.7	82572.0
2012-11-20	FDAX	Futures	7782.2	7874.8	7770.2	7860.0	119078.0
2012-11-20	FESX	Futures	1693.3	1711.0	1687.9	1706.9	760257.0
2012-11-20	FEU3	Futures	98.502	98.502	98.502	98.502	30.0
2012-11-20	FGBL	Futures	119.56	119.7	118.95	119.0	682734.0
2012-11-20	FGBM	Futures	117.09	117.14	116.79	116.83	308859.0
2012-11-20	FGBS	Futures	110.522	110.537	110.472	110.477	238626.0
2012-11-20	FGBX	Futures	126.71	126.93	125.45	125.55	6607.0
2012-11-20	FOAT	Futures	104.95	104.98	104.45	104.45	31338.0
2012-11-20	FTDX	Futures	756.1	762.2	755.2	762.2	22.0
2012-11-20	FTI	Futures	278.19	280.08	277.34	279.65	23049.0
2012-11-20	FTUK	Futures	4189.4	4210.2	4170.7	4201.8	72618.0
2012-11-20	FVSA	Futures	4691.35	4691.35	4541.87	4553.37	14760.0
2012-11-20	FXXP	Futures	192.8	194.5	192.8	194.3	2549.0
2012-11-20	G	Futures	99.29	99.3	98.57	98.62	153788.0
2012-11-20	GF	Futures	277.041	277.705	275.808	277.136	926.0
2012-11-20	GSCI	Futures	1050.94	1050.94	1032.55	1037.47	288.0
2012-11-20	HE	Futures	100.245	100.962	100.015	100.646	11500.0
2012-11-20	HG	Futures	4.5331	4.5504	4.5112	4.5286	10435.0
2012-11-20	HH	Futures	44.585	44.585	44.585	44.585	900.0
2012-11-20	HO	Futures	2.4764	2.4845	2.4336	2.4505	15512.0
2012-11-20	HRC	Futures	2458.3	2458.3	2458.3	2458.3	0.0

> showing 50 of 101 rows — these rows as CSV

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