PREVIEW / futures_daily / 2016-11-01

all futures daily files

  file:    by_date/futures_daily/2016/2016-11-01.parquet
  size:    9 KB
  rows:    108

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
2016-11-01	ES	Futures	2296.77	2303.26	2261.62	2275.41	2257062.0
2016-11-01	NQ	Futures	5660.27	5677.07	5561.28	5606.65	307806.0
2016-11-01	YM	Futures	18984.9	19033.2	18749.6	18836.8	228082.0
2016-11-01	CL	Futures	51.04	51.67	50.41	50.93	834989.0
2016-11-01	GC	Futures	1639.4	1658.8	1637.5	1652.5	207256.0
2016-11-01	ZN	Futures	126.14687	126.374873	125.751663	126.268472	1469591.0
2016-11-01	A6	Futures	0.7751	0.78367	0.77438	0.77948	106726.0
2016-11-01	AD	Futures	0.76382	0.76731	0.76316	0.76546	78570.0
2016-11-01	ALI	Futures	2308.6	2308.6	2289.7	2289.7	12.0
2016-11-01	B	Futures	37.01	37.42	36.25	36.57	462804.0
2016-11-01	B6	Futures	1.2899	1.294	1.286	1.2905	104810.0
2016-11-01	BR	Futures	0.21332	0.21349	0.20903	0.20907	3188.0
2016-11-01	BZ	Futures	36.73	37.23	36.08	36.39	56065.0
2016-11-01	C	Futures	2411.0	2411.0	2372.0	2378.0	7059.0
2016-11-01	CB	Futures	237.448	238.068	237.448	238.068	21.0
2016-11-01	CC	Futures	2012.0	2022.0	1984.0	1994.0	18802.0
2016-11-01	CNH	Futures	7.3099	7.3136	7.2958	7.296	25.0
2016-11-01	CSC	Futures	3.866	3.932	3.843	3.882	173.0
2016-11-01	CT	Futures	77.03	77.21	76.29	76.4	20056.0
2016-11-01	DC	Futures	30.35	31.08	30.26	30.62	871.0
2016-11-01	DX	Futures	91.574	91.639	90.857	90.929	25446.0
2016-11-01	E1	Futures	1.26275	1.28381	1.26163	1.28194	36354.0
2016-11-01	E6	Futures	1.27481	1.28565	1.27301	1.28466	171880.0
2016-11-01	E7	Futures	1.2682	1.2786	1.2662	1.2777	2578.0
2016-11-01	EBM	Futures	195.06	195.94	191.23	191.82	16997.0
2016-11-01	ED	Futures	95.6297	95.6442	95.6249	95.6393	397905.0
2016-11-01	ER	Futures	98.274	98.274	98.269	98.269	50709.0
2016-11-01	EW	Futures	1604.3	1610.8	1577.0	1585.7	23793.0
2016-11-01	FBON	Futures	123.16	123.18	122.61	122.75	349.0
2016-11-01	FBTP	Futures	106.5	106.59	105.8	105.96	99770.0
2016-11-01	FBTS	Futures	100.943	100.961	100.889	100.898	26783.0
2016-11-01	FCE	Futures	4036.6	4041.0	3949.3	3978.2	109720.0
2016-11-01	FDAX	Futures	11328.3	11348.4	11044.0	11099.5	121627.0
2016-11-01	FDXM	Futures	11301.7	11322.8	11022.3	11075.6	27511.0
2016-11-01	FESX	Futures	2458.2	2461.4	2397.3	2411.8	1166873.0
2016-11-01	FGBL	Futures	147.86	148.24	147.48	147.77	751505.0
2016-11-01	FGBM	Futures	128.26	128.36	128.17	128.22	517351.0
2016-11-01	FGBS	Futures	111.823	111.842	111.803	111.823	235376.0
2016-11-01	FGBX	Futures	176.23	177.66	174.93	176.07	50560.0
2016-11-01	FMWO	Futures	5667.5	5667.5	5614.2	5614.2	48.0
2016-11-01	FOAT	Futures	135.38	135.44	134.96	135.06	134813.0
2016-11-01	FTDX	Futures	1691.6	1691.6	1660.2	1669.1	242.0
2016-11-01	FTI	Futures	416.19	420.01	409.67	412.29	38445.0
2016-11-01	FTUK	Futures	5826.7	5879.0	5782.8	5804.8	119638.0
2016-11-01	FVSA	Futures	1354.22	1484.08	1351.13	1453.16	30858.0
2016-11-01	FXXP	Futures	280.6	280.8	274.9	275.7	22044.0
2016-11-01	G	Futures	111.42	111.73	111.2	111.38	216548.0
2016-11-01	GF	Futures	262.265	271.338	262.158	270.963	3396.0
2016-11-01	GSCI	Futures	506.17	506.17	497.79	499.93	1316.0
2016-11-01	HE	Futures	73.222	73.875	70.766	71.304	21979.0

> showing 50 of 108 rows — these rows as CSV

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