PREVIEW / futures_daily / 2018-03-27

all futures daily files

  file:    by_date/futures_daily/2018/2018-03-27.parquet
  size:    10 KB
  rows:    112

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
2018-03-27	ES	Futures	2892.12	2914.14	2823.07	2844.54	2448450.0
2018-03-27	NQ	Futures	7930.56	8016.59	7596.11	7679.51	731553.0
2018-03-27	YM	Futures	25493.4	25739.9	24956.1	25133.1	380198.0
2018-03-27	CL	Futures	65.83	66.69	64.81	65.53	670811.0
2018-03-27	GC	Futures	1735.4	1739.6	1717.6	1720.8	296478.0
2018-03-27	ZN	Futures	119.478117	120.144986	119.447099	120.005408	1842010.0
2018-03-27	A6	Futures	0.79689	0.79792	0.78938	0.79062	86810.0
2018-03-27	AD	Futures	0.78864	0.79067	0.7852	0.78687	76069.0
2018-03-27	B	Futures	50.59	51.17	50.0	50.49	299889.0
2018-03-27	B6	Futures	1.4788	1.4802	1.4616	1.4707	138937.0
2018-03-27	BR	Futures	0.22768	0.22837	0.22742	0.22757	919.0
2018-03-27	BTC	Futures	11673.7	11695.0	11063.0	11240.6	626.0
2018-03-27	BZ	Futures	49.91	50.5	49.35	49.84	22766.0
2018-03-27	C	Futures	1699.0	1699.0	1641.0	1653.0	13059.0
2018-03-27	CB	Futures	278.251	278.282	278.251	278.282	4.0
2018-03-27	CC	Futures	1925.0	1925.0	1859.0	1874.0	20383.0
2018-03-27	CNH	Futures	6.3626	6.3882	6.3567	6.381	52.0
2018-03-27	CSC	Futures	3.327	3.335	3.319	3.335	37.0
2018-03-27	CT	Futures	94.12	95.14	93.93	94.28	13131.0
2018-03-27	DC	Futures	26.44	26.46	26.28	26.46	64.0
2018-03-27	DX	Futures	83.585	84.175	83.496	83.923	24993.0
2018-03-27	E1	Futures	1.28331	1.2856	1.27536	1.28054	22868.0
2018-03-27	E6	Futures	1.41093	1.4142	1.40231	1.40564	238935.0
2018-03-27	E7	Futures	1.4031	1.4067	1.3949	1.3982	3864.0
2018-03-27	EBM	Futures	175.05	175.86	175.05	175.59	13344.0
2018-03-27	ED	Futures	94.9889	95.0473	94.9889	95.0375	686285.0
2018-03-27	ER	Futures	98.337	98.337	98.332	98.337	57860.0
2018-03-27	EW	Futures	1992.3	2004.1	1952.8	1961.2	23672.0
2018-03-27	FBON	Futures	129.73	130.08	129.66	129.99	151.0
2018-03-27	FBTP	Futures	114.39	114.74	114.31	114.7	94056.0
2018-03-27	FBTS	Futures	104.084	104.149	104.084	104.139	42613.0
2018-03-27	FCE	Futures	4515.1	4531.0	4433.1	4501.0	84077.0
2018-03-27	FDAX	Futures	12459.7	12517.9	12266.4	12446.2	105611.0
2018-03-27	FDXM	Futures	12334.3	12405.4	12157.2	12335.4	41667.0
2018-03-27	FESX	Futures	2696.5	2706.5	2649.0	2689.8	1148112.0
2018-03-27	FEU3	Futures	99.016	99.026	99.016	99.021	5.0
2018-03-27	FGBL	Futures	149.41	150.02	149.37	149.84	733467.0
2018-03-27	FGBM	Futures	129.5	129.74	129.49	129.68	369593.0
2018-03-27	FGBS	Futures	112.553	112.583	112.547	112.568	190541.0
2018-03-27	FGBX	Futures	170.45	171.84	170.26	171.38	47735.0
2018-03-27	FMWO	Futures	6923.4	6925.8	6772.8	6884.9	1917.0
2018-03-27	FOAT	Futures	138.62	139.05	138.57	139.04	142537.0
2018-03-27	FTDX	Futures	2536.5	2536.5	2498.9	2523.2	173.0
2018-03-27	FTI	Futures	479.69	483.22	474.04	481.02	29553.0
2018-03-27	FTUK	Futures	6065.6	6147.8	6032.5	6102.7	139116.0
2018-03-27	FVSA	Futures	455.41	478.0	437.58	443.52	38076.0
2018-03-27	FXXP	Futures	312.1	312.7	307.3	311.4	53484.0
2018-03-27	G	Futures	113.34	113.71	113.3	113.68	252015.0
2018-03-27	GF	Futures	292.943	298.17	292.943	294.794	2774.0
2018-03-27	GSCI	Futures	521.71	521.71	517.94	517.94	80.0

> showing 50 of 112 rows — these rows as CSV

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