PREVIEW / futures_daily / 2017-10-20

all futures daily files

  file:    by_date/futures_daily/2017/2017-10-20.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
2017-10-20	ES	Futures	2785.58	2800.27	2783.95	2799.72	1254054.0
2017-10-20	NQ	Futures	7162.49	7199.78	7153.97	7178.05	222217.0
2017-10-20	YM	Futures	24409.3	24586.7	24399.8	24580.4	121588.0
2017-10-20	CL	Futures	52.02	52.53	51.3	52.28	674142.0
2017-10-20	GC	Futures	1644.0	1645.1	1627.8	1629.3	314805.0
2017-10-20	ZN	Futures	123.578388	123.655413	123.023811	123.070025	1715638.0
2017-10-20	A6	Futures	0.81006	0.81047	0.80286	0.80348	119130.0
2017-10-20	AD	Futures	0.81508	0.81579	0.80582	0.80608	110971.0
2017-10-20	ALI	Futures	2718.01	2718.01	2718.01	2718.01	0.0
2017-10-20	B	Futures	40.48	40.92	39.97	40.78	369888.0
2017-10-20	B6	Futures	1.3735	1.3786	1.3666	1.3776	124629.0
2017-10-20	BR	Futures	0.23517	0.23551	0.23438	0.23551	38.0
2017-10-20	BZ	Futures	40.13	40.56	39.64	40.45	28185.0
2017-10-20	C	Futures	1565.0	1580.0	1552.0	1558.0	16112.0
2017-10-20	CB	Futures	301.769	303.627	301.422	303.595	16.0
2017-10-20	CC	Futures	1600.0	1604.0	1576.0	1587.0	29412.0
2017-10-20	CNH	Futures	6.8133	6.8222	6.8133	6.8206	18.0
2017-10-20	CSC	Futures	3.443	3.443	3.4	3.404	38.0
2017-10-20	CT	Futures	79.05	79.38	78.51	78.55	16514.0
2017-10-20	DC	Futures	27.78	27.82	27.36	27.41	195.0
2017-10-20	DX	Futures	87.012	87.601	86.965	87.511	27274.0
2017-10-20	E1	Futures	1.2567	1.25768	1.24545	1.24594	33472.0
2017-10-20	E6	Futures	1.35589	1.35709	1.34614	1.34808	207750.0
2017-10-20	E7	Futures	1.3489	1.35	1.3388	1.3411	3449.0
2017-10-20	EBM	Futures	174.24	174.78	173.7	173.97	10612.0
2017-10-20	ED	Futures	95.5085	95.5085	95.4939	95.4939	346903.0
2017-10-20	ER	Futures	98.342	98.342	98.337	98.342	20323.0
2017-10-20	EW	Futures	1939.1	1949.9	1938.7	1948.9	9879.0
2017-10-20	FBON	Futures	124.47	124.66	124.46	124.53	213.0
2017-10-20	FBTP	Futures	110.2	110.28	109.92	110.12	86670.0
2017-10-20	FBTS	Futures	103.457	103.475	103.448	103.457	26738.0
2017-10-20	FCE	Futures	4818.1	4831.1	4807.3	4811.8	67493.0
2017-10-20	FDAX	Futures	13686.4	13724.8	13608.1	13641.2	68188.0
2017-10-20	FDXM	Futures	13573.0	13609.5	13493.8	13526.1	20789.0
2017-10-20	FESX	Futures	2939.3	2945.0	2930.3	2935.2	731812.0
2017-10-20	FGBL	Futures	149.81	149.83	149.19	149.27	858352.0
2017-10-20	FGBM	Futures	129.8	129.82	129.59	129.65	545019.0
2017-10-20	FGBS	Futures	112.487	112.492	112.457	112.472	216024.0
2017-10-20	FGBX	Futures	168.48	168.48	166.48	166.75	61967.0
2017-10-20	FMWO	Futures	6766.3	6768.7	6760.4	6762.8	1985.0
2017-10-20	FOAT	Futures	137.15	137.17	136.65	136.74	122802.0
2017-10-20	FTDX	Futures	2499.5	2508.9	2478.0	2481.5	227.0
2017-10-20	FTI	Futures	502.97	504.83	502.37	503.11	24883.0
2017-10-20	FTUK	Futures	6512.4	6533.2	6495.0	6497.6	86902.0
2017-10-20	FVSA	Futures	345.32	355.55	338.93	349.16	28679.0
2017-10-20	FXXP	Futures	330.2	331.2	330.0	330.6	31763.0
2017-10-20	G	Futures	114.1	114.19	113.7	113.85	183458.0
2017-10-20	GF	Futures	330.066	331.198	327.534	329.904	3130.0
2017-10-20	GSCI	Futures	472.69	474.1	471.92	473.92	5.0
2017-10-20	HE	Futures	94.906	95.866	94.352	95.755	19473.0

> showing 50 of 108 rows — these rows as CSV

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