PREVIEW / futures_daily / 2020-09-17

all futures daily files

  file:    by_date/futures_daily/2020/2020-09-17.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
2020-09-17	ES	Futures	3799.05	3804.67	3719.0	3764.78	2676297.0
2020-09-17	NQ	Futures	13032.33	13068.8	12623.95	12821.92	818376.0
2020-09-17	YM	Futures	30101.2	30138.8	29526.3	29949.4	236969.0
2020-09-17	CL	Futures	29.01	29.78	28.48	29.6	270184.0
2020-09-17	GC	Futures	2323.8	2325.8	2289.0	2302.9	273140.0
2020-09-17	ZN	Futures	138.233712	138.605641	138.218215	138.311197	1045395.0
2020-09-17	A6	Futures	0.7498	0.75114	0.74488	0.75001	92180.0
2020-09-17	AD	Futures	0.76921	0.77078	0.76516	0.76921	74597.0
2020-09-17	ALI	Futures	2139.76	2139.76	2128.47	2129.36	271.0
2020-09-17	B	Futures	26.98	27.73	26.45	27.6	237399.0
2020-09-17	B6	Futures	1.3155	1.3188	1.305	1.3148	143830.0
2020-09-17	BFX	Futures	3484.4	3490.3	3484.4	3490.3	8.0
2020-09-17	BR	Futures	0.14895	0.14977	0.14895	0.14977	8.0
2020-09-17	BTC	Futures	14912.7	14953.2	14521.1	14784.4	7179.0
2020-09-17	BZ	Futures	26.35	27.13	25.89	27.0	27245.0
2020-09-17	C	Futures	1638.0	1688.0	1629.0	1649.0	10120.0
2020-09-17	CB	Futures	172.278	172.278	169.255	169.255	13.0
2020-09-17	CC	Futures	1707.0	1759.0	1692.0	1707.0	16424.0
2020-09-17	CNH	Futures	6.6489	6.6741	6.6423	6.6532	818.0
2020-09-17	CSC	Futures	3.3	3.335	3.3	3.326	48.0
2020-09-17	CT	Futures	65.71	65.71	65.08	65.08	49.0
2020-09-17	DC	Futures	26.52	27.22	26.41	27.06	146.0
2020-09-17	DX	Futures	90.018	90.443	89.714	89.805	31138.0
2020-09-17	E1	Futures	1.24839	1.2502	1.24205	1.24885	21102.0
2020-09-17	E6	Futures	1.26788	1.272	1.25963	1.27055	205750.0
2020-09-17	E7	Futures	1.2617	1.2656	1.2532	1.2641	9270.0
2020-09-17	EBM	Futures	227.24	231.76	226.94	231.16	46879.0
2020-09-17	ED	Futures	96.46	96.4697	96.4552	96.4648	73330.0
2020-09-17	ER	Futures	98.426	98.435	98.421	98.431	154608.0
2020-09-17	ESG	Futures	309.71	311.06	307.57	310.15	1763.0
2020-09-17	EW	Futures	2029.8	2029.8	1984.6	2012.2	12380.0
2020-09-17	FBON	Futures	147.68	147.92	147.39	147.92	539.0
2020-09-17	FBTP	Futures	134.0	134.46	133.84	134.43	113103.0
2020-09-17	FBTS	Futures	109.132	109.267	109.122	109.238	65306.0
2020-09-17	FCE	Futures	4858.3	4892.2	4832.1	4877.2	58107.0
2020-09-17	FDAX	Futures	14060.7	14104.9	13875.2	14079.3	43852.0
2020-09-17	FDIV	Futures	151.61	153.65	151.61	153.65	1050.0
2020-09-17	FDXM	Futures	13979.2	14033.3	13806.2	14008.3	6446.0
2020-09-17	FESX	Futures	3059.2	3063.8	3025.0	3058.3	822101.0
2020-09-17	FGBL	Futures	169.27	169.65	168.96	169.47	647265.0
2020-09-17	FGBM	Futures	134.96	135.1	134.83	135.06	400358.0
2020-09-17	FGBS	Futures	112.744	112.769	112.719	112.764	423093.0
2020-09-17	FGBX	Futures	229.36	231.55	228.71	230.74	58476.0
2020-09-17	FMWO	Futures	8309.9	8405.9	8309.9	8397.6	5943.0
2020-09-17	FOAT	Futures	157.41	157.77	157.1	157.61	152087.0
2020-09-17	FTDX	Futures	3158.4	3193.9	3154.3	3189.2	648.0
2020-09-17	FTI	Futures	513.94	515.99	510.54	514.56	19943.0
2020-09-17	FTUK	Futures	5782.4	5784.7	5702.5	5762.8	90418.0
2020-09-17	FVSA	Futures	199.1	203.19	189.44	192.04	20249.0
2020-09-17	FXXP	Futures	340.4	343.4	339.7	343.0	72249.0

> showing 50 of 120 rows — these rows as CSV

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