PREVIEW / futures_daily / 2019-05-09

all futures daily files

  file:    by_date/futures_daily/2019/2019-05-09.parquet
  size:    10 KB
  rows:    118

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-05-09	ES	Futures	3115.22	3116.85	3063.65	3103.07	2705412.0
2019-05-09	NQ	Futures	8802.56	8808.03	8619.64	8751.28	741216.0
2019-05-09	YM	Futures	27426.5	27438.1	26916.7	27250.3	364960.0
2019-05-09	CL	Futures	63.67	63.87	62.54	63.35	769583.0
2019-05-09	GC	Futures	1595.5	1604.6	1593.6	1599.6	306546.0
2019-05-09	ZN	Futures	123.057144	123.585486	123.057144	123.305775	2119854.0
2019-05-09	A6	Futures	0.72116	0.72199	0.71848	0.72168	104304.0
2019-05-09	AD	Futures	0.75079	0.7518	0.74928	0.7516	79672.0
2019-05-09	B	Futures	51.75	52.06	51.14	51.87	328735.0
2019-05-09	B6	Futures	1.335	1.3378	1.3308	1.3365	94068.0
2019-05-09	BR	Futures	0.20324	0.20364	0.20072	0.20236	3024.0
2019-05-09	BTC	Futures	9132.0	9464.5	9047.0	9379.5	6973.0
2019-05-09	BZ	Futures	51.61	51.91	51.0	51.73	46554.0
2019-05-09	C	Futures	1673.0	1675.0	1654.0	1672.0	8428.0
2019-05-09	CB	Futures	276.33	279.321	276.33	278.723	62.0
2019-05-09	CC	Futures	1550.0	1576.0	1534.0	1573.0	14176.0
2019-05-09	CNH	Futures	6.8192	6.8783	6.8125	6.846	1786.0
2019-05-09	CSC	Futures	2.998	3.006	2.992	2.998	12.0
2019-05-09	CT	Futures	75.58	75.72	72.9	73.51	34573.0
2019-05-09	DC	Futures	25.12	25.2	24.97	25.04	290.0
2019-05-09	DX	Futures	93.331	93.446	92.986	93.133	17593.0
2019-05-09	E1	Futures	1.14742	1.15664	1.14684	1.15384	34232.0
2019-05-09	E6	Futures	1.23256	1.23865	1.23003	1.23569	222222.0
2019-05-09	E7	Futures	1.2263	1.2325	1.224	1.2295	3995.0
2019-05-09	EBM	Futures	196.91	197.2	195.47	196.05	13113.0
2019-05-09	ED	Futures	95.1746	95.1892	95.1697	95.1843	230807.0
2019-05-09	ER	Futures	98.411	98.416	98.411	98.411	12292.0
2019-05-09	EW	Futures	2054.9	2055.9	2018.4	2046.5	13591.0
2019-05-09	FBON	Futures	136.81	136.92	136.46	136.5	932.0
2019-05-09	FBTP	Futures	115.35	115.39	114.66	114.93	103522.0
2019-05-09	FBTS	Futures	105.846	105.846	105.627	105.693	67790.0
2019-05-09	FCE	Futures	4845.3	4846.2	4774.1	4780.4	110347.0
2019-05-09	FDAX	Futures	12840.1	12846.4	12590.1	12595.3	154546.0
2019-05-09	FDIV	Futures	146.37	146.37	144.28	144.28	117.0
2019-05-09	FDXM	Futures	12729.8	12733.0	12481.5	12486.2	67909.0
2019-05-09	FESX	Futures	2940.9	2946.2	2892.0	2892.9	1410914.0
2019-05-09	FGBL	Futures	160.35	160.73	160.31	160.46	714157.0
2019-05-09	FGBM	Futures	133.25	133.42	133.25	133.33	476948.0
2019-05-09	FGBS	Futures	112.809	112.86	112.809	112.844	329043.0
2019-05-09	FGBX	Futures	195.06	196.15	194.88	195.23	49610.0
2019-05-09	FMWO	Futures	7127.0	7135.1	7047.2	7049.5	3262.0
2019-05-09	FOAT	Futures	147.2	147.36	146.95	147.04	159005.0
2019-05-09	FTDX	Futures	2789.6	2803.4	2746.1	2750.6	296.0
2019-05-09	FTI	Futures	525.75	526.18	518.07	519.19	33534.0
2019-05-09	FTUK	Futures	6620.2	6629.3	6558.7	6560.6	113095.0
2019-05-09	FVSA	Futures	236.7	255.56	231.81	250.67	69032.0
2019-05-09	FXXP	Futures	337.7	337.9	333.3	333.4	114428.0
2019-05-09	G	Futures	118.0	118.33	117.87	118.09	171259.0
2019-05-09	GF	Futures	282.884	284.185	279.969	283.665	1732.0
2019-05-09	GSCI	Futures	488.26	490.63	487.35	490.63	2992.0

> showing 50 of 118 rows — these rows as CSV

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