PREVIEW / futures_daily / 2017-07-28

all futures daily files

  file:    by_date/futures_daily/2017/2017-07-28.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-07-28	ES	Futures	2686.63	2686.63	2675.21	2684.72	1156784.0
2017-07-28	NQ	Futures	6946.27	6957.15	6876.92	6947.74	338476.0
2017-07-28	YM	Futures	22981.5	23028.0	22922.3	23018.5	106336.0
2017-07-28	CL	Futures	50.58	51.24	50.26	51.13	771225.0
2017-07-28	GC	Futures	1609.6	1624.9	1607.3	1622.7	250893.0
2017-07-28	ZN	Futures	123.919181	124.088469	123.657553	124.05769	1232783.0
2017-07-28	A6	Futures	0.81759	0.82211	0.81482	0.82067	95750.0
2017-07-28	AD	Futures	0.81036	0.81952	0.80985	0.81865	97792.0
2017-07-28	ALI	Futures	2526.76	2526.76	2526.76	2526.76	0.0
2017-07-28	B	Futures	36.08	36.62	35.91	36.53	410846.0
2017-07-28	B6	Futures	1.3675	1.3768	1.3673	1.3763	87174.0
2017-07-28	BR	Futures	0.23217	0.23555	0.23217	0.23526	3804.0
2017-07-28	BZ	Futures	35.8	36.27	35.61	36.22	29634.0
2017-07-28	C	Futures	1574.0	1610.0	1570.0	1607.0	12626.0
2017-07-28	CB	Futures	327.553	333.696	327.553	333.696	53.0
2017-07-28	CC	Futures	1528.0	1570.0	1524.0	1564.0	30801.0
2017-07-28	CSC	Futures	3.513	3.59	3.513	3.59	140.0
2017-07-28	CT	Futures	81.49	82.49	81.49	81.95	5.0
2017-07-28	DC	Futures	29.22	29.93	29.22	29.88	583.0
2017-07-28	DX	Futures	87.471	87.583	86.934	86.947	24440.0
2017-07-28	E1	Futures	1.27616	1.27898	1.26646	1.2726	52662.0
2017-07-28	E6	Futures	1.34131	1.35133	1.34062	1.35099	229652.0
2017-07-28	E7	Futures	1.3345	1.3443	1.3335	1.3439	4516.0
2017-07-28	EBM	Futures	188.17	189.84	187.9	189.57	10320.0
2017-07-28	ED	Futures	95.5935	95.5935	95.5838	95.5935	136507.0
2017-07-28	ER	Futures	98.337	98.342	98.337	98.342	29089.0
2017-07-28	EW	Futures	1879.1	1880.7	1866.9	1871.8	8956.0
2017-07-28	FBON	Futures	124.36	124.41	123.71	124.07	615.0
2017-07-28	FBTP	Futures	108.39	108.58	107.6	108.05	93044.0
2017-07-28	FBTS	Futures	102.954	102.963	102.881	102.927	41067.0
2017-07-28	FCE	Futures	4626.6	4632.9	4581.7	4605.5	102795.0
2017-07-28	FDAX	Futures	12786.6	12821.3	12727.6	12781.3	75166.0
2017-07-28	FDXM	Futures	12707.9	12742.4	12649.3	12702.6	22956.0
2017-07-28	FESX	Futures	2829.2	2832.4	2810.4	2821.0	851925.0
2017-07-28	FGBL	Futures	147.34	147.51	146.6	147.15	723941.0
2017-07-28	FGBM	Futures	128.85	128.91	128.64	128.87	419310.0
2017-07-28	FGBS	Futures	112.257	112.277	112.217	112.272	259055.0
2017-07-28	FGBX	Futures	163.8	164.2	161.9	163.23	39194.0
2017-07-28	FMWO	Futures	6541.2	6541.2	6532.9	6537.6	789.0
2017-07-28	FOAT	Futures	135.13	135.21	134.42	135.01	132307.0
2017-07-28	FTDX	Futures	2277.2	2277.2	2249.1	2258.1	193.0
2017-07-28	FTI	Futures	484.64	485.38	481.45	482.7	28452.0
2017-07-28	FTUK	Futures	6357.6	6360.6	6286.7	6307.9	119344.0
2017-07-28	FVSA	Futures	428.67	442.02	421.25	433.12	36297.0
2017-07-28	FXXP	Futures	322.6	322.8	320.3	320.8	23399.0
2017-07-28	G	Futures	114.75	114.85	114.33	114.54	137682.0
2017-07-28	GF	Futures	324.887	325.052	318.466	320.607	6715.0
2017-07-28	GSCI	Futures	469.84	470.08	469.42	470.08	953.0
2017-07-28	HE	Futures	94.852	94.852	93.186	93.502	6902.0
2017-07-28	HG	Futures	3.488	3.5075	3.4558	3.4972	74746.0

> showing 50 of 108 rows — these rows as CSV

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