PREVIEW / futures_daily / 2019-11-27

all futures daily files

  file:    by_date/futures_daily/2019/2019-11-27.parquet
  size:    10 KB
  rows:    121

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-11-27	ES	Futures	3403.32	3415.5	3401.16	3414.15	928792.0
2019-11-27	NQ	Futures	9683.5	9748.04	9676.88	9743.43	240866.0
2019-11-27	YM	Futures	29522.2	29575.8	29455.0	29549.5	99873.0
2019-11-27	CL	Futures	59.5	59.92	58.72	59.34	454256.0
2019-11-27	GC	Futures	1806.4	1807.4	1795.1	1797.2	232122.0
2019-11-27	ZN	Futures	128.505135	128.52062	128.13351	128.210932	1306006.0
2019-11-27	A6	Futures	0.6964	0.69722	0.69517	0.69578	63208.0
2019-11-27	AD	Futures	0.75894	0.7597	0.75804	0.75844	59302.0
2019-11-27	ALI	Futures	2187.63	2187.63	2166.37	2166.37	90.0
2019-11-27	B	Futures	50.78	51.28	50.38	50.82	267113.0
2019-11-27	B6	Futures	1.3086	1.3149	1.3048	1.3139	106518.0
2019-11-27	BR	Futures	0.19072	0.19072	0.18991	0.18991	3532.0
2019-11-27	BTC	Futures	10788.1	11653.3	10299.1	11472.7	2970.0
2019-11-27	BZ	Futures	50.18	50.59	49.7	50.14	23868.0
2019-11-27	C	Futures	1812.0	1817.0	1774.0	1784.0	4506.0
2019-11-27	CB	Futures	250.754	250.754	249.369	249.369	42.0
2019-11-27	CC	Futures	1734.0	1748.0	1682.0	1699.0	21297.0
2019-11-27	CNH	Futures	7.0065	7.0154	7.0021	7.0045	610.0
2019-11-27	CSC	Futures	3.431	3.431	3.422	3.422	19.0
2019-11-27	CT	Futures	62.7	62.87	62.08	62.6	10627.0
2019-11-27	DC	Futures	28.66	28.85	28.57	28.67	147.0
2019-11-27	DX	Futures	94.937	95.077	94.918	94.998	10948.0
2019-11-27	E1	Futures	1.1545	1.15496	1.15162	1.15242	28064.0
2019-11-27	E6	Futures	1.19605	1.19626	1.19274	1.19415	141835.0
2019-11-27	E7	Futures	1.1898	1.19	1.1865	1.188	2582.0
2019-11-27	EBM	Futures	199.47	200.56	198.86	198.92	10241.0
2019-11-27	ED	Futures	95.3277	95.3302	95.3229	95.3253	210769.0
2019-11-27	ER	Futures	98.401	98.401	98.396	98.396	38807.0
2019-11-27	ESG	Futures	279.94	280.69	279.84	280.69	136.0
2019-11-27	EW	Futures	2121.7	2134.6	2121.0	2133.5	9099.0
2019-11-27	FBON	Futures	143.51	143.58	143.31	143.32	375.0
2019-11-27	FBTP	Futures	129.21	129.43	128.52	128.55	87437.0
2019-11-27	FBTS	Futures	108.163	108.269	108.144	108.153	82846.0
2019-11-27	FCE	Futures	5373.3	5380.1	5353.4	5358.4	47327.0
2019-11-27	FDAX	Futures	13997.2	14049.9	13942.8	14011.4	79268.0
2019-11-27	FDIV	Futures	162.05	162.14	162.05	162.05	40.0
2019-11-27	FDXM	Futures	13806.6	13867.0	13760.8	13828.5	31031.0
2019-11-27	FESX	Futures	3253.5	3260.6	3244.8	3250.0	779891.0
2019-11-27	FEU3	Futures	99.104	99.104	99.1	99.1	396.0
2019-11-27	FGBL	Futures	165.48	165.69	165.31	165.53	639286.0
2019-11-27	FGBM	Futures	133.96	134.0	133.88	133.95	378487.0
2019-11-27	FGBS	Futures	112.689	112.699	112.679	112.694	374606.0
2019-11-27	FGBX	Futures	215.98	216.83	215.8	216.63	43617.0
2019-11-27	FMWO	Futures	7662.2	7679.3	7647.4	7661.1	3133.0
2019-11-27	FOAT	Futures	152.86	153.02	152.7	152.8	114450.0
2019-11-27	FTDX	Futures	3016.6	3027.5	3011.7	3023.5	94.0
2019-11-27	FTI	Futures	572.87	574.25	571.72	572.73	16896.0
2019-11-27	FTUK	Futures	6867.2	6897.3	6862.1	6876.9	86340.0
2019-11-27	FVSA	Futures	130.25	131.77	128.73	129.23	25648.0
2019-11-27	FXXP	Futures	370.0	371.1	369.2	370.4	36925.0

> showing 50 of 121 rows — these rows as CSV

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