PREVIEW / futures_daily / 2017-11-21

all futures daily files

  file:    by_date/futures_daily/2017/2017-11-21.parquet
  size:    9 KB
  rows:    109

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-11-21	ES	Futures	2808.43	2828.55	2805.43	2823.93	1153787.0
2017-11-21	NQ	Futures	7418.55	7500.19	7413.27	7493.43	216030.0
2017-11-21	YM	Futures	24708.2	24906.7	24683.9	24861.3	113831.0
2017-11-21	CL	Futures	56.44	57.28	56.38	56.89	619066.0
2017-11-21	GC	Futures	1624.4	1634.4	1623.3	1630.8	330147.0
2017-11-21	ZN	Futures	122.946786	123.162455	122.838951	122.931381	1774516.0
2017-11-21	A6	Futures	0.77631	0.78074	0.77477	0.78002	92689.0
2017-11-21	AD	Futures	0.79443	0.79824	0.79285	0.79662	73302.0
2017-11-21	B	Futures	43.92	44.47	43.9	44.26	338157.0
2017-11-21	B6	Futures	1.3813	1.3843	1.3781	1.3809	97098.0
2017-11-21	BR	Futures	0.23128	0.23275	0.23087	0.23223	5561.0
2017-11-21	BZ	Futures	43.56	44.05	43.49	43.86	30389.0
2017-11-21	C	Futures	1511.0	1520.0	1500.0	1511.0	5294.0
2017-11-21	CB	Futures	283.44	283.44	283.162	283.162	7.0
2017-11-21	CC	Futures	1561.0	1579.0	1556.0	1574.0	13602.0
2017-11-21	CNH	Futures	6.8234	6.8239	6.8146	6.8146	10.0
2017-11-21	CSC	Futures	3.398	3.404	3.375	3.387	67.0
2017-11-21	CT	Futures	83.48	85.18	82.69	83.28	7045.0
2017-11-21	DC	Futures	27.31	27.43	27.02	27.2	414.0
2017-11-21	DX	Futures	87.854	87.984	87.713	87.79	11698.0
2017-11-21	E1	Futures	1.23274	1.23726	1.23115	1.23457	20843.0
2017-11-21	E6	Futures	1.34072	1.34346	1.33821	1.34174	181539.0
2017-11-21	E7	Futures	1.3337	1.3363	1.3312	1.3347	4140.0
2017-11-21	EBM	Futures	169.92	171.0	169.65	170.73	31890.0
2017-11-21	ED	Futures	95.4576	95.46	95.4503	95.4527	235849.0
2017-11-21	ER	Futures	98.342	98.347	98.342	98.347	11491.0
2017-11-21	EW	Futures	1963.6	1976.5	1962.4	1975.6	13653.0
2017-11-21	FBON	Futures	126.02	126.47	126.02	126.32	534.0
2017-11-21	FBTP	Futures	112.77	113.28	112.71	112.97	89009.0
2017-11-21	FBTS	Futures	103.86	103.906	103.851	103.869	45184.0
2017-11-21	FCE	Futures	4779.5	4823.5	4768.3	4804.6	90215.0
2017-11-21	FDAX	Futures	13719.0	13883.0	13684.9	13834.6	90167.0
2017-11-21	FDXM	Futures	13606.4	13764.8	13568.9	13717.9	30560.0
2017-11-21	FESX	Futures	2900.1	2927.9	2893.6	2917.3	1029531.0
2017-11-21	FGBL	Futures	150.65	150.96	150.59	150.79	663081.0
2017-11-21	FGBM	Futures	130.07	130.17	130.05	130.11	403359.0
2017-11-21	FGBS	Futures	112.527	112.547	112.517	112.532	139310.0
2017-11-21	FGBX	Futures	169.52	170.95	169.4	170.42	48225.0
2017-11-21	FMWO	Futures	6771.0	6821.8	6771.0	6818.3	1201.0
2017-11-21	FOAT	Futures	138.95	139.53	138.95	139.35	149347.0
2017-11-21	FTDX	Futures	2558.4	2583.3	2534.4	2576.8	329.0
2017-11-21	FTI	Futures	501.29	504.35	500.04	503.01	25468.0
2017-11-21	FTUK	Futures	6413.5	6435.2	6386.6	6425.2	86021.0
2017-11-21	FVSA	Futures	323.97	326.31	313.4	316.92	26685.0
2017-11-21	FXXP	Futures	328.1	330.4	327.0	329.4	31173.0
2017-11-21	G	Futures	114.33	114.71	114.27	114.48	174150.0
2017-11-21	GF	Futures	324.463	328.733	323.219	327.814	5908.0
2017-11-21	GSCI	Futures	494.44	496.6	494.44	495.49	46.0
2017-11-21	HE	Futures	91.342	92.443	89.108	89.308	16186.0
2017-11-21	HG	Futures	3.7234	3.7755	3.7133	3.7713	38155.0

> showing 50 of 109 rows — these rows as CSV

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