PREVIEW / futures_daily / 2017-09-22

all futures daily files

  file:    by_date/futures_daily/2017/2017-09-22.parquet
  size:    9 KB
  rows:    109

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-09-22	ES	Futures	2720.05	2720.32	2710.53	2718.69	1024727.0
2017-09-22	NQ	Futures	6982.18	6983.65	6943.13	6972.2	272649.0
2017-09-22	YM	Futures	23576.1	23584.6	23504.3	23547.6	112069.0
2017-09-22	CL	Futures	51.41	51.46	50.96	51.33	473795.0
2017-09-22	GC	Futures	1646.6	1656.6	1646.6	1651.0	264470.0
2017-09-22	ZN	Futures	123.824867	124.163776	123.809462	123.963512	1231862.0
2017-09-22	A6	Futures	0.8151	0.82087	0.81274	0.8186	105371.0
2017-09-22	AD	Futures	0.82597	0.8307	0.82419	0.82521	79105.0
2017-09-22	B	Futures	39.62	39.91	39.42	39.87	208360.0
2017-09-22	B6	Futures	1.4195	1.4211	1.406	1.4141	201270.0
2017-09-22	BZ	Futures	39.28	39.56	39.09	39.53	18348.0
2017-09-22	C	Futures	1463.0	1475.0	1435.0	1440.0	9155.0
2017-09-22	CB	Futures	313.673	313.673	311.154	311.28	74.0
2017-09-22	CC	Futures	1504.0	1520.0	1463.0	1472.0	24750.0
2017-09-22	CNH	Futures	6.778	6.7931	6.7767	6.7825	13.0
2017-09-22	CSC	Futures	3.427	3.468	3.427	3.468	44.0
2017-09-22	CT	Futures	80.66	80.88	80.3	80.63	25.0
2017-09-22	DC	Futures	27.98	28.48	27.98	28.48	268.0
2017-09-22	DX	Futures	85.983	86.039	85.637	86.004	24072.0
2017-09-22	E1	Futures	1.266	1.27138	1.26587	1.26722	28827.0
2017-09-22	E6	Futures	1.36867	1.37603	1.36822	1.36896	214218.0
2017-09-22	E7	Futures	1.3612	1.3688	1.3612	1.3618	4710.0
2017-09-22	EBM	Futures	177.75	178.28	177.21	177.75	15795.0
2017-09-22	ED	Futures	95.4988	95.5133	95.4988	95.5085	242231.0
2017-09-22	ER	Futures	98.337	98.342	98.337	98.337	30226.0
2017-09-22	EW	Futures	1875.1	1881.4	1868.0	1879.8	10106.0
2017-09-22	FBON	Futures	124.88	124.88	124.6	124.6	1013.0
2017-09-22	FBTP	Futures	108.76	108.93	108.65	108.73	61641.0
2017-09-22	FBTS	Futures	103.219	103.246	103.21	103.219	20708.0
2017-09-22	FCE	Futures	4706.1	4735.7	4703.4	4721.8	61698.0
2017-09-22	FDAX	Futures	13190.9	13281.8	13183.5	13228.7	56812.0
2017-09-22	FDIV	Futures	147.04	147.84	147.04	147.84	6.0
2017-09-22	FDXM	Futures	13079.0	13169.7	13072.8	13117.1	18310.0
2017-09-22	FESX	Futures	2870.8	2887.9	2869.1	2878.1	536955.0
2017-09-22	FEU3	Futures	99.011	99.011	99.006	99.006	150.0
2017-09-22	FGBL	Futures	149.04	149.11	148.75	148.98	511402.0
2017-09-22	FGBM	Futures	129.45	129.49	129.33	129.4	358993.0
2017-09-22	FGBS	Futures	112.392	112.392	112.362	112.372	258028.0
2017-09-22	FGBX	Futures	167.11	167.34	166.52	167.01	31919.0
2017-09-22	FMWO	Futures	6612.8	6625.8	6612.8	6622.3	8.0
2017-09-22	FOAT	Futures	136.22	136.37	136.04	136.2	69515.0
2017-09-22	FTDX	Futures	2378.2	2404.1	2378.2	2395.2	455.0
2017-09-22	FTI	Futures	485.67	487.29	484.98	486.04	17837.0
2017-09-22	FTUK	Futures	6260.7	6317.1	6239.9	6304.1	89812.0
2017-09-22	FVSA	Futures	420.0	421.42	410.07	417.16	14897.0
2017-09-22	FXXP	Futures	323.5	324.8	323.2	324.2	23240.0
2017-09-22	G	Futures	113.29	113.59	113.18	113.32	141750.0
2017-09-22	GF	Futures	340.581	342.0	337.907	340.69	6146.0
2017-09-22	GSCI	Futures	475.02	475.8	474.72	475.8	11.0
2017-09-22	HE	Futures	84.201	84.902	83.426	83.61	16710.0

> showing 50 of 109 rows — these rows as CSV

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