PREVIEW / futures_daily / 2017-12-08

all futures daily files

  file:    by_date/futures_daily/2017/2017-12-08.parquet
  size:    10 KB
  rows:    111

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
2017-12-08	ES	Futures	2870.97	2885.11	2869.06	2883.48	1154864.0
2017-12-08	NQ	Futures	7426.19	7492.85	7424.13	7447.04	180084.0
2017-12-08	YM	Futures	25591.0	25696.6	25574.1	25679.7	102292.0
2017-12-08	CL	Futures	56.71	57.85	56.6	57.42	681599.0
2017-12-08	GC	Futures	1584.1	1590.3	1577.6	1582.7	277056.0
2017-12-08	ZN	Futures	122.761927	122.900763	122.576812	122.684796	1158177.0
2017-12-08	A6	Futures	0.77282	0.77508	0.77179	0.7722	96281.0
2017-12-08	AD	Futures	0.79158	0.79463	0.78995	0.79087	72106.0
2017-12-08	B	Futures	44.1	45.21	44.05	45.04	362429.0
2017-12-08	B6	Futures	1.4059	1.41	1.3927	1.3972	202988.0
2017-12-08	BR	Futures	0.22861	0.22861	0.22812	0.22816	9.0
2017-12-08	BZ	Futures	43.67	44.86	43.67	44.7	28508.0
2017-12-08	C	Futures	1295.0	1321.0	1291.0	1307.0	5129.0
2017-12-08	CB	Futures	279.239	281.062	279.239	279.301	40.0
2017-12-08	CC	Futures	1401.0	1430.0	1388.0	1408.0	29687.0
2017-12-08	CNH	Futures	6.7916	6.8033	6.7916	6.7963	16.0
2017-12-08	CSC	Futures	3.378	3.381	3.366	3.376	66.0
2017-12-08	CT	Futures	86.55	86.76	85.99	86.1	21103.0
2017-12-08	DC	Futures	26.92	26.96	26.72	26.85	165.0
2017-12-08	DX	Futures	87.718	87.975	87.704	87.787	19750.0
2017-12-08	E1	Futures	1.23017	1.23286	1.22601	1.23225	36148.0
2017-12-08	E6	Futures	1.34425	1.34437	1.33895	1.34323	257159.0
2017-12-08	E7	Futures	1.3373	1.3373	1.3317	1.3362	3137.0
2017-12-08	EBM	Futures	173.43	174.51	173.16	174.24	14113.0
2017-12-08	ED	Futures	95.4236	95.4261	95.4018	95.4091	330773.0
2017-12-08	ER	Futures	98.342	98.347	98.337	98.337	62881.0
2017-12-08	EW	Futures	2003.4	2014.8	2002.9	2009.0	31931.0
2017-12-08	FBON	Futures	127.05	127.37	126.99	127.28	65.0
2017-12-08	FBTP	Futures	114.37	114.8	114.21	114.75	73483.0
2017-12-08	FBTS	Futures	104.015	104.052	103.997	104.043	26151.0
2017-12-08	FCE	Futures	4846.3	4863.8	4834.2	4839.6	59812.0
2017-12-08	FDAX	Futures	13814.7	13919.8	13806.8	13837.8	94007.0
2017-12-08	FDXM	Futures	13693.9	13801.3	13689.7	13721.0	28567.0
2017-12-08	FESX	Futures	2929.5	2946.6	2926.2	2931.9	1290154.0
2017-12-08	FEU3	Futures	99.011	99.011	99.011	99.011	100.0
2017-12-08	FGBL	Futures	151.45	151.58	151.22	151.51	525023.0
2017-12-08	FGBM	Futures	130.44	130.45	130.28	130.34	408944.0
2017-12-08	FGBS	Futures	112.633	112.638	112.572	112.597	323342.0
2017-12-08	FGBX	Futures	171.85	172.43	171.07	172.28	48681.0
2017-12-08	FMWO	Futures	6893.9	6902.1	6883.2	6891.5	3054.0
2017-12-08	FOAT	Futures	140.08	140.21	139.91	140.14	76190.0
2017-12-08	FTDX	Futures	2498.5	2515.4	2497.5	2512.9	222.0
2017-12-08	FTI	Futures	507.19	509.69	507.19	508.11	27324.0
2017-12-08	FTUK	Futures	6354.0	6432.6	6340.6	6418.2	206875.0
2017-12-08	FVSA	Futures	306.36	307.53	299.32	304.01	21982.0
2017-12-08	FXXP	Futures	330.5	332.7	330.3	331.2	58013.0
2017-12-08	G	Futures	114.32	114.57	114.01	114.49	183190.0
2017-12-08	GF	Futures	317.274	317.814	313.382	313.977	6264.0
2017-12-08	GSCI	Futures	489.89	491.41	489.89	489.95	2635.0
2017-12-08	HE	Futures	91.276	91.943	90.509	91.843	14655.0

> showing 50 of 111 rows — these rows as CSV

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