PREVIEW / futures_daily / 2019-11-08

all futures daily files

  file:    by_date/futures_daily/2019/2019-11-08.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-08	ES	Futures	3341.07	3347.84	3326.19	3345.67	1080147.0
2019-11-08	NQ	Futures	9484.42	9523.89	9438.33	9515.83	326871.0
2019-11-08	YM	Futures	29049.8	29097.1	28912.3	29006.8	125901.0
2019-11-08	CL	Futures	58.31	58.72	56.97	58.48	636941.0
2019-11-08	GC	Futures	1812.1	1818.1	1797.3	1804.6	447069.0
2019-11-08	ZN	Futures	127.266383	127.529618	126.956694	127.235414	1764060.0
2019-11-08	A6	Futures	0.70779	0.70933	0.70317	0.70399	100790.0
2019-11-08	AD	Futures	0.76474	0.76479	0.76101	0.76156	82410.0
2019-11-08	ALI	Futures	2214.93	2229.5	2214.93	2220.4	171.0
2019-11-08	B	Futures	49.68	50.01	48.38	49.86	287672.0
2019-11-08	B6	Futures	1.3042	1.3051	1.2996	1.3012	65396.0
2019-11-08	BFX	Futures	4646.4	4671.2	4646.4	4671.2	2.0
2019-11-08	BR	Futures	0.19675	0.19796	0.19344	0.19461	10475.0
2019-11-08	BTC	Futures	13372.0	13437.0	12534.5	12772.7	5487.0
2019-11-08	BZ	Futures	49.04	49.32	47.72	49.18	34325.0
2019-11-08	C	Futures	1660.0	1701.0	1660.0	1696.0	5268.0
2019-11-08	CB	Futures	245.887	246.684	245.887	246.684	5.0
2019-11-08	CC	Futures	1603.0	1640.0	1601.0	1634.0	32610.0
2019-11-08	CNH	Futures	6.9635	6.9948	6.9576	6.9814	1043.0
2019-11-08	CSC	Futures	3.412	3.444	3.388	3.44	144.0
2019-11-08	CT	Futures	62.64	63.33	61.92	63.0	35657.0
2019-11-08	DC	Futures	28.49	28.68	28.16	28.65	710.0
2019-11-08	DX	Futures	94.715	94.956	94.666	94.914	10511.0
2019-11-08	E1	Futures	1.15898	1.15979	1.15553	1.15599	21942.0
2019-11-08	E6	Futures	1.20044	1.20103	1.19681	1.19751	132856.0
2019-11-08	E7	Futures	1.1942	1.1947	1.1905	1.1914	2174.0
2019-11-08	EBM	Futures	194.82	195.91	194.27	195.36	18436.0
2019-11-08	ED	Futures	95.3229	95.3277	95.3132	95.318	205158.0
2019-11-08	ER	Futures	98.382	98.391	98.382	98.382	64158.0
2019-11-08	EW	Futures	2093.5	2101.0	2084.5	2099.2	8736.0
2019-11-08	FBON	Futures	143.69	143.86	142.85	143.51	440.0
2019-11-08	FBTP	Futures	129.4	129.68	127.96	129.03	171289.0
2019-11-08	FBTS	Futures	108.24	108.307	107.989	108.153	72886.0
2019-11-08	FCE	Futures	5323.4	5358.4	5320.7	5346.6	69007.0
2019-11-08	FDAX	Futures	14017.7	14018.8	13918.0	13948.1	78036.0
2019-11-08	FDIV	Futures	162.65	162.65	162.37	162.37	40.0
2019-11-08	FDXM	Futures	13831.6	13831.6	13735.8	13766.0	31419.0
2019-11-08	FESX	Futures	3243.0	3247.4	3227.2	3235.1	818240.0
2019-11-08	FGBL	Futures	163.64	164.12	163.37	163.92	693755.0
2019-11-08	FGBM	Futures	133.47	133.63	133.43	133.58	421102.0
2019-11-08	FGBS	Futures	112.639	112.679	112.639	112.664	242536.0
2019-11-08	FGBX	Futures	210.31	211.62	209.07	211.08	49799.0
2019-11-08	FMWO	Futures	7541.7	7558.7	7523.5	7539.4	1318.0
2019-11-08	FOAT	Futures	151.45	151.78	150.91	151.61	157575.0
2019-11-08	FTDX	Futures	2878.4	2879.9	2867.6	2879.4	86.0
2019-11-08	FTI	Futures	566.77	569.92	566.49	568.17	21900.0
2019-11-08	FTUK	Futures	6841.7	6841.7	6792.6	6804.2	74510.0
2019-11-08	FVSA	Futures	146.01	150.25	144.41	147.07	25544.0
2019-11-08	FXXP	Futures	365.7	367.2	365.4	365.8	49601.0
2019-11-08	G	Futures	120.27	120.31	119.58	120.02	209125.0

> showing 50 of 121 rows — these rows as CSV

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