PREVIEW / futures_daily / 2017-07-17

all futures daily files

  file:    by_date/futures_daily/2017/2017-07-17.parquet
  size:    9 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-07-17	ES	Futures	2670.32	2674.13	2667.06	2671.95	862469.0
2017-07-17	NQ	Futures	6869.27	6893.08	6854.87	6882.79	217890.0
2017-07-17	YM	Futures	22829.3	22855.7	22792.3	22813.5	77044.0
2017-07-17	CL	Futures	48.23	48.43	47.42	47.55	397385.0
2017-07-17	GC	Futures	1568.5	1577.1	1567.0	1574.9	174904.0
2017-07-17	ZN	Futures	123.688333	123.934571	123.672943	123.857621	788340.0
2017-07-17	A6	Futures	0.803	0.80455	0.79982	0.80064	93299.0
2017-07-17	AD	Futures	0.80507	0.80619	0.80162	0.80223	63700.0
2017-07-17	ALI	Futures	2534.37	2534.37	2534.37	2534.37	0.0
2017-07-17	B	Futures	34.74	34.83	34.16	34.23	227420.0
2017-07-17	B6	Futures	1.3728	1.3732	1.3661	1.3673	82123.0
2017-07-17	BFX	Futures	4678.3	4707.3	4671.1	4707.3	31.0
2017-07-17	BR	Futures	0.23147	0.23154	0.23095	0.23125	930.0
2017-07-17	BZ	Futures	34.46	34.6	33.94	34.02	17905.0
2017-07-17	C	Futures	1518.0	1526.0	1499.0	1519.0	5313.0
2017-07-17	CB	Futures	323.539	324.786	323.539	323.569	15.0
2017-07-17	CC	Futures	1453.0	1456.0	1432.0	1450.0	16866.0
2017-07-17	CNH	Futures	7.0144	7.0221	7.0124	7.0131	68.0
2017-07-17	CSC	Futures	3.52	3.53	3.499	3.522	78.0
2017-07-17	CT	Futures	78.81	80.12	78.26	80.03	14.0
2017-07-17	DC	Futures	29.69	29.72	29.3	29.58	245.0
2017-07-17	DX	Futures	88.6	88.82	88.521	88.618	12280.0
2017-07-17	E1	Futures	1.27948	1.28525	1.27641	1.28169	24266.0
2017-07-17	E6	Futures	1.31879	1.32045	1.3145	1.31965	140478.0
2017-07-17	E7	Futures	1.3112	1.3135	1.3076	1.3127	2442.0
2017-07-17	EBM	Futures	192.63	194.02	191.79	192.07	11396.0
2017-07-17	ED	Futures	95.5983	95.6032	95.5935	95.5983	78102.0
2017-07-17	ER	Futures	98.332	98.337	98.332	98.332	24707.0
2017-07-17	EW	Futures	1876.4	1880.7	1868.0	1877.7	10044.0
2017-07-17	FBON	Futures	122.74	123.39	122.74	123.33	192.0
2017-07-17	FBTP	Futures	106.4	107.02	106.4	106.98	56500.0
2017-07-17	FBTS	Futures	102.681	102.726	102.681	102.726	17721.0
2017-07-17	FCE	Futures	4710.2	4711.5	4680.1	4694.4	48053.0
2017-07-17	FDAX	Futures	13315.7	13338.3	13194.1	13253.0	65591.0
2017-07-17	FDXM	Futures	13226.9	13252.0	13114.9	13171.4	16851.0
2017-07-17	FESX	Futures	2878.1	2882.2	2855.3	2867.5	609799.0
2017-07-17	FEU3	Futures	99.011	99.011	99.006	99.006	5.0
2017-07-17	FGBL	Futures	146.33	146.74	146.31	146.51	369064.0
2017-07-17	FGBM	Futures	128.25	128.42	128.25	128.35	288012.0
2017-07-17	FGBS	Futures	112.101	112.146	112.101	112.136	142132.0
2017-07-17	FGBX	Futures	162.73	163.78	162.73	163.11	24985.0
2017-07-17	FMWO	Futures	6503.1	6512.6	6499.5	6512.6	992.0
2017-07-17	FOAT	Futures	134.26	134.63	134.26	134.48	60652.0
2017-07-17	FTDX	Futures	2289.2	2312.7	2289.2	2308.2	107.0
2017-07-17	FTI	Futures	480.06	480.57	478.49	478.86	9170.0
2017-07-17	FTUK	Futures	6326.0	6366.2	6324.7	6351.5	64482.0
2017-07-17	FVSA	Futures	465.75	477.61	450.92	453.88	25056.0
2017-07-17	FXXP	Futures	329.2	329.2	327.6	328.6	26213.0
2017-07-17	G	Futures	113.52	114.06	113.52	113.91	115682.0
2017-07-17	GF	Futures	337.016	341.516	337.016	338.991	5747.0

> showing 50 of 110 rows — these rows as CSV

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