PREVIEW / futures_daily / 2018-04-27

all futures daily files

  file:    by_date/futures_daily/2018/2018-04-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-04-27	ES	Futures	2909.52	2910.34	2890.22	2905.17	1142350.0
2018-04-27	NQ	Futures	7894.28	7926.17	7751.78	7806.5	481734.0
2018-04-27	YM	Futures	25609.2	25615.6	25436.5	25579.7	173850.0
2018-04-27	CL	Futures	68.46	68.61	67.89	68.35	542549.0
2018-04-27	GC	Futures	1682.7	1693.4	1679.9	1689.6	241653.0
2018-04-27	ZN	Futures	118.439042	118.656162	118.392516	118.609636	1291016.0
2018-04-27	A6	Futures	0.77663	0.77992	0.77447	0.77941	109599.0
2018-04-27	AD	Futures	0.78682	0.78965	0.78505	0.78915	56714.0
2018-04-27	B	Futures	54.12	54.33	53.83	54.08	308157.0
2018-04-27	B6	Futures	1.444	1.4461	1.4268	1.4311	156933.0
2018-04-27	BR	Futures	0.21679	0.22052	0.21679	0.22052	6933.0
2018-04-27	BTC	Futures	12828.1	13228.3	12554.3	12750.9	2190.0
2018-04-27	BZ	Futures	53.55	53.77	53.29	53.52	27567.0
2018-04-27	C	Futures	1712.0	1718.0	1690.0	1715.0	4053.0
2018-04-27	CB	Futures	304.257	304.257	300.211	301.446	16.0
2018-04-27	CC	Futures	2043.0	2068.0	1990.0	2064.0	21072.0
2018-04-27	CNH	Futures	6.444	6.444	6.4209	6.4209	38.0
2018-04-27	CSC	Futures	3.425	3.444	3.425	3.434	38.0
2018-04-27	CT	Futures	95.83	96.37	95.44	96.07	9427.0
2018-04-27	DC	Futures	27.69	27.92	27.66	27.84	138.0
2018-04-27	DX	Futures	86.188	86.57	86.099	86.149	30518.0
2018-04-27	E1	Futures	1.22176	1.22477	1.21839	1.22393	34392.0
2018-04-27	E6	Futures	1.36829	1.37201	1.36283	1.37032	265280.0
2018-04-27	E7	Futures	1.361	1.3646	1.3556	1.363	3672.0
2018-04-27	EBM	Futures	178.54	179.62	178.28	178.54	22317.0
2018-04-27	ED	Futures	94.95	94.9597	94.9403	94.95	239933.0
2018-04-27	ER	Futures	98.337	98.347	98.337	98.342	78815.0
2018-04-27	EW	Futures	2007.4	2010.6	1993.4	2004.4	12501.0
2018-04-27	FBON	Futures	129.64	129.92	129.51	129.74	421.0
2018-04-27	FBTP	Futures	116.13	116.44	115.91	116.25	121019.0
2018-04-27	FBTS	Futures	104.306	104.315	104.25	104.297	59039.0
2018-04-27	FCE	Futures	4828.9	4850.7	4820.9	4847.2	55024.0
2018-04-27	FDAX	Futures	13071.7	13134.1	13016.6	13089.4	92895.0
2018-04-27	FDXM	Futures	12951.2	13018.2	12900.8	12972.8	28352.0
2018-04-27	FESX	Futures	2875.6	2883.1	2865.6	2878.1	784515.0
2018-04-27	FEU3	Futures	99.021	99.026	99.021	99.026	198.0
2018-04-27	FGBL	Futures	149.04	149.42	149.04	149.31	648004.0
2018-04-27	FGBM	Futures	129.38	129.53	129.37	129.5	365834.0
2018-04-27	FGBS	Futures	112.482	112.512	112.477	112.512	235594.0
2018-04-27	FGBX	Futures	168.92	169.79	168.9	169.4	44618.0
2018-04-27	FMWO	Futures	6956.1	6964.3	6937.4	6962.0	1423.0
2018-04-27	FOAT	Futures	138.27	138.64	138.26	138.54	94493.0
2018-04-27	FTDX	Futures	2597.4	2608.8	2589.5	2593.9	137.0
2018-04-27	FTI	Futures	510.07	510.53	507.76	509.47	20831.0
2018-04-27	FTUK	Futures	6543.2	6602.0	6516.7	6590.5	109984.0
2018-04-27	FVSA	Futures	338.68	343.27	331.79	332.94	18956.0
2018-04-27	FXXP	Futures	328.3	329.3	327.5	328.8	28446.0
2018-04-27	G	Futures	113.13	113.66	113.08	113.48	246800.0
2018-04-27	GF	Futures	301.388	306.391	300.688	305.638	3103.0
2018-04-27	GSCI	Futures	531.81	533.27	531.81	532.71	44.0

> showing 50 of 112 rows — these rows as CSV

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