PREVIEW / futures_daily / 2019-09-03

all futures daily files

  file:    by_date/futures_daily/2019/2019-09-03.parquet
  size:    10 KB
  rows:    120

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-09-03	ES	Futures	3130.34	3157.86	3117.39	3135.74	1999829.0
2019-09-03	NQ	Futures	8782.59	8860.02	8727.9	8770.22	643037.0
2019-09-03	YM	Futures	27555.8	27691.3	27276.5	27428.8	286417.0
2019-09-03	CL	Futures	56.49	56.73	54.27	55.4	970804.0
2019-09-03	GC	Futures	1893.7	1923.0	1884.9	1919.3	554833.0
2019-09-03	ZN	Futures	130.644244	131.110831	130.255422	130.846432	79351.0
2019-09-03	A6	Futures	0.69195	0.69617	0.68824	0.69586	139030.0
2019-09-03	AD	Futures	0.75647	0.75733	0.75329	0.75652	113287.0
2019-09-03	ALI	Futures	2121.36	2137.44	2121.05	2132.59	149.0
2019-09-03	B	Futures	45.21	45.47	44.2	45.0	265120.0
2019-09-03	B6	Futures	1.2404	1.2434	1.2213	1.2341	237502.0
2019-09-03	BR	Futures	0.19441	0.19441	0.19223	0.19223	15.0
2019-09-03	BTC	Futures	13994.4	15608.9	13994.4	15430.3	7222.0
2019-09-03	BZ	Futures	44.95	45.09	43.54	44.33	51149.0
2019-09-03	C	Futures	1562.0	1581.0	1555.0	1576.0	1999.0
2019-09-03	CB	Futures	264.811	265.697	264.811	265.697	29.0
2019-09-03	CC	Futures	1450.0	1475.0	1435.0	1473.0	29472.0
2019-09-03	CNH	Futures	7.1676	7.1993	7.1676	7.1812	943.0
2019-09-03	CSC	Futures	3.022	3.022	2.998	3.0	36.0
2019-09-03	CT	Futures	58.47	58.47	57.28	57.58	35.0
2019-09-03	DC	Futures	25.88	25.88	25.44	25.49	43.0
2019-09-03	DX	Futures	95.328	95.636	95.188	95.269	21301.0
2019-09-03	E1	Futures	1.17327	1.1771	1.16933	1.17582	37670.0
2019-09-03	E6	Futures	1.20013	1.20094	1.19298	1.19756	296655.0
2019-09-03	E7	Futures	1.1934	1.1947	1.1869	1.1913	6998.0
2019-09-03	EBM	Futures	188.28	189.43	184.82	185.4	6665.0
2019-09-03	ED	Futures	95.3671	95.3988	95.3574	95.3817	349312.0
2019-09-03	ER	Futures	98.563	98.568	98.548	98.553	133306.0
2019-09-03	EW	Futures	1959.9	1976.4	1940.2	1950.6	17654.0
2019-09-03	FBON	Futures	146.28	146.81	146.25	146.53	1965.0
2019-09-03	FBTP	Futures	130.87	132.11	130.8	131.8	245898.0
2019-09-03	FBTS	Futures	108.299	108.529	108.299	108.443	182881.0
2019-09-03	FCE	Futures	4972.9	4982.9	4927.1	4951.2	85163.0
2019-09-03	FDAX	Futures	12567.9	12622.1	12490.5	12527.4	109956.0
2019-09-03	FDIV	Futures	143.54	143.54	143.12	143.12	13.0
2019-09-03	FDXM	Futures	12426.1	12465.6	12336.7	12373.1	45107.0
2019-09-03	FESX	Futures	2990.7	3002.9	2972.4	2981.1	1005168.0
2019-09-03	FGBL	Futures	170.1	170.84	170.02	170.51	1628643.0
2019-09-03	FGBM	Futures	136.2	136.41	136.09	136.19	1021469.0
2019-09-03	FGBS	Futures	113.388	113.419	113.343	113.358	945476.0
2019-09-03	FGBX	Futures	229.52	232.86	228.74	232.47	162492.0
2019-09-03	FMWO	Futures	7165.2	7167.5	7123.7	7142.2	2309.0
2019-09-03	FOAT	Futures	156.3	156.77	156.13	156.52	444884.0
2019-09-03	FTDX	Futures	2726.9	2735.8	2718.0	2729.4	31.0
2019-09-03	FTI	Futures	529.41	530.31	526.47	529.03	28621.0
2019-09-03	FTUK	Futures	6712.8	6749.7	6676.3	6696.6	135770.0
2019-09-03	FVSA	Futures	222.61	234.53	220.73	230.14	35875.0
2019-09-03	FXXP	Futures	341.2	341.5	338.8	339.9	44134.0
2019-09-03	G	Futures	123.99	124.54	123.66	123.9	239056.0
2019-09-03	GF	Futures	270.898	274.51	269.728	272.984	1447.0

> showing 50 of 120 rows — these rows as CSV

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