PREVIEW / futures_daily / 2016-08-26

all futures daily files

  file:    by_date/futures_daily/2016/2016-08-26.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-08-26	ES	Futures	2347.25	2361.01	2329.43	2341.31	2535682.0
2016-08-26	NQ	Futures	5638.48	5678.56	5607.54	5641.13	281261.0
2016-08-26	YM	Futures	19272.4	19380.0	19126.2	19198.2	193964.0
2016-08-26	CL	Futures	52.65	53.86	52.17	52.95	558344.0
2016-08-26	GC	Futures	1699.7	1726.9	1695.1	1701.1	300050.0
2016-08-26	ZN	Futures	127.531844	127.909113	126.867852	126.882943	2759059.0
2016-08-26	A6	Futures	0.77477	0.7822	0.76785	0.76805	158260.0
2016-08-26	AD	Futures	0.79214	0.79772	0.78651	0.78672	82467.0
2016-08-26	ALI	Futures	2128.35	2128.35	2126.78	2126.78	2.0
2016-08-26	B	Futures	39.24	40.09	38.82	39.43	187835.0
2016-08-26	B6	Futures	1.3907	1.4005	1.3839	1.3843	104456.0
2016-08-26	BR	Futures	0.2054	0.2054	0.20342	0.20342	3230.0
2016-08-26	BZ	Futures	39.06	39.91	38.69	39.26	23961.0
2016-08-26	C	Futures	2582.0	2601.0	2564.0	2586.0	8791.0
2016-08-26	CB	Futures	260.387	260.387	258.527	258.527	14.0
2016-08-26	CC	Futures	2240.0	2257.0	2204.0	2230.0	13968.0
2016-08-26	CNH	Futures	7.2207	7.2461	7.2193	7.2458	6.0
2016-08-26	CSC	Futures	3.905	3.905	3.829	3.829	103.0
2016-08-26	CT	Futures	76.88	77.54	76.7	76.7	13.0
2016-08-26	DC	Futures	31.04	31.04	30.41	30.49	233.0
2016-08-26	DX	Futures	88.053	88.9	87.611	88.86	41256.0
2016-08-26	E1	Futures	1.29545	1.30159	1.28005	1.28043	48807.0
2016-08-26	E6	Futures	1.31495	1.32158	1.30267	1.30348	261824.0
2016-08-26	E7	Futures	1.3079	1.3144	1.2958	1.2966	4085.0
2016-08-26	EBM	Futures	192.16	192.46	190.36	190.66	6048.0
2016-08-26	ED	Futures	95.6267	95.634	95.5906	95.593	388124.0
2016-08-26	ER	Futures	98.298	98.303	98.298	98.298	30278.0
2016-08-26	EW	Futures	1659.2	1670.1	1643.6	1651.3	19022.0
2016-08-26	FBON	Futures	125.05	125.1	124.81	125.07	330.0
2016-08-26	FBTP	Futures	110.67	110.89	110.51	110.87	57016.0
2016-08-26	FBTS	Futures	101.356	101.365	101.338	101.356	7441.0
2016-08-26	FCE	Futures	3842.7	3893.4	3830.1	3879.9	76171.0
2016-08-26	FDAX	Futures	11180.9	11296.9	11122.9	11268.7	88847.0
2016-08-26	FDXM	Futures	10893.2	11010.4	10843.4	10984.0	27202.0
2016-08-26	FESX	Futures	2333.7	2362.7	2327.5	2359.6	857779.0
2016-08-26	FGBL	Futures	150.71	150.95	150.15	150.9	478784.0
2016-08-26	FGBM	Futures	128.84	128.94	128.69	128.93	326931.0
2016-08-26	FGBS	Futures	111.847	111.872	111.842	111.872	125484.0
2016-08-26	FGBX	Futures	188.51	189.74	186.62	189.1	24279.0
2016-08-26	FMWO	Futures	5775.6	5807.2	5774.4	5803.6	1073.0
2016-08-26	FOAT	Futures	138.52	138.72	138.21	138.67	69220.0
2016-08-26	FTDX	Futures	1655.4	1664.0	1648.1	1662.1	55.0
2016-08-26	FTI	Futures	404.87	409.61	404.2	408.71	26577.0
2016-08-26	FTUK	Futures	5687.8	5722.1	5647.4	5709.5	84539.0
2016-08-26	FVSA	Futures	1925.55	1955.84	1864.97	1869.3	10457.0
2016-08-26	FXXP	Futures	276.0	278.6	275.2	278.4	12522.0
2016-08-26	G	Futures	116.94	117.38	116.79	117.34	201603.0
2016-08-26	GF	Futures	284.732	286.945	280.255	281.563	2884.0
2016-08-26	GSCI	Futures	517.67	517.67	514.9	514.9	53.0
2016-08-26	HE	Futures	82.08	85.366	82.08	84.847	16597.0

> showing 50 of 108 rows — these rows as CSV

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