PREVIEW / futures_daily / 2017-08-01

all futures daily files

  file:    by_date/futures_daily/2017/2017-08-01.parquet
  size:    10 KB
  rows:    110

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-08-01	ES	Futures	2682.28	2692.33	2680.38	2686.9	1043439.0
2017-08-01	NQ	Futures	6917.47	6972.43	6906.89	6923.06	229005.0
2017-08-01	YM	Futures	23105.2	23215.2	23097.8	23154.9	104872.0
2017-08-01	CL	Futures	51.65	51.87	49.76	50.57	1008583.0
2017-08-01	GC	Futures	1623.1	1629.1	1613.9	1627.9	213543.0
2017-08-01	ZN	Futures	123.949961	124.350097	123.780672	124.334707	1471383.0
2017-08-01	A6	Futures	0.82149	0.82571	0.81728	0.81821	123116.0
2017-08-01	AD	Futures	0.81504	0.81748	0.81072	0.81265	86461.0
2017-08-01	ALI	Futures	2516.61	2516.61	2516.61	2516.61	0.0
2017-08-01	B	Futures	36.86	37.02	35.59	36.22	392641.0
2017-08-01	B6	Futures	1.3825	1.3864	1.3807	1.3827	98928.0
2017-08-01	BFX	Futures	4751.3	4770.0	4751.3	4770.0	6.0
2017-08-01	BR	Futures	0.23611	0.23748	0.236	0.23674	2224.0
2017-08-01	BZ	Futures	36.53	36.71	35.29	35.91	33859.0
2017-08-01	C	Futures	1602.0	1619.0	1566.0	1573.0	11652.0
2017-08-01	CB	Futures	330.26	331.841	330.107	331.446	40.0
2017-08-01	CC	Futures	1580.0	1587.0	1515.0	1536.0	34313.0
2017-08-01	CNH	Futures	6.9624	6.9659	6.9624	6.9659	1.0
2017-08-01	CSC	Futures	3.61	3.655	3.594	3.651	151.0
2017-08-01	CT	Futures	82.55	83.06	82.29	83.06	19.0
2017-08-01	DC	Futures	30.05	30.52	29.93	30.43	651.0
2017-08-01	DX	Futures	86.658	86.812	86.504	86.748	18708.0
2017-08-01	E1	Futures	1.27395	1.27886	1.27211	1.27493	31087.0
2017-08-01	E6	Futures	1.35952	1.35981	1.35357	1.35557	213451.0
2017-08-01	E7	Futures	1.3521	1.3526	1.3465	1.3485	4157.0
2017-08-01	EBM	Futures	186.5	186.78	184.56	184.83	19117.0
2017-08-01	ED	Futures	95.5886	95.5983	95.5886	95.5935	121752.0
2017-08-01	ER	Futures	98.337	98.342	98.337	98.342	33837.0
2017-08-01	EW	Futures	1869.5	1877.6	1866.9	1873.8	12645.0
2017-08-01	FBON	Futures	124.33	124.97	124.25	124.73	432.0
2017-08-01	FBTP	Futures	108.4	109.41	108.3	109.08	71911.0
2017-08-01	FBTS	Futures	102.918	102.982	102.918	102.982	40486.0
2017-08-01	FCE	Futures	4580.4	4622.6	4565.6	4602.0	74338.0
2017-08-01	FDAX	Futures	12769.7	12947.1	12720.2	12899.2	93827.0
2017-08-01	FDXM	Futures	12691.1	12877.4	12642.0	12819.8	27462.0
2017-08-01	FESX	Futures	2817.7	2845.5	2808.7	2834.9	892030.0
2017-08-01	FEU3	Futures	99.011	99.016	99.011	99.016	10.0
2017-08-01	FGBL	Futures	147.06	148.02	147.0	147.89	683752.0
2017-08-01	FGBM	Futures	128.81	129.15	128.79	129.1	400306.0
2017-08-01	FGBS	Futures	112.262	112.327	112.262	112.312	331465.0
2017-08-01	FGBX	Futures	163.8	166.14	163.68	165.96	41472.0
2017-08-01	FMWO	Futures	6579.3	6587.7	6569.8	6569.8	568.0
2017-08-01	FOAT	Futures	135.07	135.78	134.99	135.69	111681.0
2017-08-01	FTDX	Futures	2266.2	2278.7	2263.6	2270.7	50.0
2017-08-01	FTI	Futures	482.75	486.12	482.05	484.5	24862.0
2017-08-01	FTUK	Futures	6322.6	6374.0	6322.6	6358.9	84301.0
2017-08-01	FVSA	Futures	430.15	430.15	415.32	419.77	15836.0
2017-08-01	FXXP	Futures	320.8	323.9	320.7	322.8	36016.0
2017-08-01	G	Futures	114.33	114.76	114.09	114.66	199036.0
2017-08-01	GF	Futures	322.473	328.455	321.54	327.467	3925.0

> showing 50 of 110 rows — these rows as CSV

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