PREVIEW / futures_daily / 2019-07-09

all futures daily files

  file:    by_date/futures_daily/2019/2019-07-09.parquet
  size:    10 KB
  rows:    119

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
2019-07-09	ES	Futures	3213.16	3222.33	3197.78	3217.75	956650.0
2019-07-09	NQ	Futures	8982.92	9047.97	8914.71	9032.43	346314.0
2019-07-09	YM	Futures	28134.4	28148.0	27990.5	28118.6	150793.0
2019-07-09	CL	Futures	58.88	60.46	58.6	59.16	551872.0
2019-07-09	GC	Futures	1739.9	1745.5	1726.9	1743.1	287176.0
2019-07-09	ZN	Futures	126.802681	126.911551	126.569388	126.709364	1234559.0
2019-07-09	A6	Futures	0.7189	0.71921	0.71345	0.71437	82781.0
2019-07-09	AD	Futures	0.77058	0.77068	0.76801	0.76897	51490.0
2019-07-09	ALI	Futures	2226.63	2245.87	2226.63	2245.87	19.0
2019-07-09	B	Futures	47.97	48.68	47.93	48.23	263889.0
2019-07-09	B6	Futures	1.2815	1.282	1.2739	1.2766	77996.0
2019-07-09	BR	Futures	0.20719	0.21106	0.20719	0.2099	2172.0
2019-07-09	BTC	Futures	17540.6	18359.5	17260.6	17862.6	6427.0
2019-07-09	BZ	Futures	47.45	48.26	47.31	47.63	28731.0
2019-07-09	C	Futures	1810.0	1820.0	1777.0	1786.0	2293.0
2019-07-09	CB	Futures	282.701	285.298	282.701	285.064	34.0
2019-07-09	CC	Futures	1710.0	1715.0	1675.0	1680.0	19919.0
2019-07-09	CNH	Futures	6.8896	6.8997	6.885	6.8942	840.0
2019-07-09	CSC	Futures	3.157	3.162	3.139	3.152	95.0
2019-07-09	CT	Futures	64.31	64.31	62.02	62.24	53.0
2019-07-09	DC	Futures	26.43	26.45	26.21	26.36	153.0
2019-07-09	DX	Futures	93.373	93.58	93.364	93.484	9711.0
2019-07-09	E1	Futures	1.1742	1.17594	1.17269	1.17466	16131.0
2019-07-09	E6	Futures	1.23007	1.23062	1.22784	1.22942	112359.0
2019-07-09	E7	Futures	1.2239	1.2242	1.2214	1.223	2304.0
2019-07-09	EBM	Futures	202.09	202.09	199.22	199.22	30061.0
2019-07-09	ED	Futures	95.3087	95.3184	95.2843	95.2941	257554.0
2019-07-09	ER	Futures	98.509	98.514	98.499	98.504	118608.0
2019-07-09	EW	Futures	2046.8	2050.3	2037.1	2049.2	15092.0
2019-07-09	FBON	Futures	142.84	143.18	142.65	142.98	328.0
2019-07-09	FBTP	Futures	123.28	123.95	123.28	123.71	114489.0
2019-07-09	FBTS	Futures	107.187	107.37	107.187	107.302	48063.0
2019-07-09	FCE	Futures	5098.4	5102.1	5065.5	5091.1	71506.0
2019-07-09	FDAX	Futures	13141.3	13153.9	13007.5	13084.9	114416.0
2019-07-09	FDIV	Futures	146.88	147.85	146.6	147.85	55.0
2019-07-09	FDXM	Futures	12980.4	12989.8	12847.3	12923.7	46237.0
2019-07-09	FESX	Futures	3066.7	3066.7	3042.2	3057.1	770836.0
2019-07-09	FGBL	Futures	164.83	164.94	164.54	164.7	565770.0
2019-07-09	FGBM	Futures	134.5	134.54	134.42	134.47	337137.0
2019-07-09	FGBS	Futures	113.081	113.086	113.046	113.061	244660.0
2019-07-09	FGBX	Futures	210.39	210.78	209.42	209.86	43497.0
2019-07-09	FMWO	Futures	7375.2	7397.1	7347.5	7378.7	4899.0
2019-07-09	FOAT	Futures	152.17	152.24	151.87	151.98	115300.0
2019-07-09	FTDX	Futures	2866.1	2882.4	2849.8	2882.4	71.0
2019-07-09	FTI	Futures	534.62	535.05	531.37	533.07	23406.0
2019-07-09	FTUK	Futures	6914.5	6916.4	6881.7	6901.1	70645.0
2019-07-09	FVSA	Futures	184.82	192.43	181.36	182.74	34071.0
2019-07-09	FXXP	Futures	347.3	347.3	345.0	346.3	57794.0
2019-07-09	G	Futures	121.11	121.23	120.83	121.11	205026.0
2019-07-09	GF	Futures	273.558	281.212	273.215	280.378	11168.0

> showing 50 of 119 rows — these rows as CSV

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