PREVIEW / futures_daily / 2019-10-17

all futures daily files

  file:    by_date/futures_daily/2019/2019-10-17.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-10-17	ES	Futures	3239.31	3256.36	3231.73	3245.54	1121748.0
2019-10-17	NQ	Futures	9166.64	9213.32	9129.48	9164.91	368623.0
2019-10-17	YM	Futures	28274.0	28436.7	28214.2	28337.0	144360.0
2019-10-17	CL	Futures	54.23	55.43	53.87	55.2	316374.0
2019-10-17	GC	Futures	1843.2	1851.7	1834.3	1848.2	305666.0
2019-10-17	ZN	Futures	128.861277	129.016121	128.350291	128.737402	1463817.0
2019-10-17	A6	Futures	0.69424	0.70225	0.69414	0.70143	123787.0
2019-10-17	AD	Futures	0.76333	0.76756	0.76282	0.76715	96222.0
2019-10-17	ALI	Futures	2112.62	2113.84	2105.64	2107.46	85.0
2019-10-17	B	Futures	46.73	47.56	46.49	47.46	269842.0
2019-10-17	B6	Futures	1.306	1.3233	1.2987	1.3117	256939.0
2019-10-17	BFX	Futures	4556.5	4556.5	4548.0	4548.0	42.0
2019-10-17	BR	Futures	0.19372	0.19509	0.19303	0.19368	54.0
2019-10-17	BTC	Futures	11470.2	11721.9	11412.7	11592.4	2582.0
2019-10-17	BZ	Futures	46.16	46.89	45.8	46.8	44951.0
2019-10-17	C	Futures	1699.0	1713.0	1677.0	1681.0	11821.0
2019-10-17	CB	Futures	250.316	250.316	247.895	249.194	40.0
2019-10-17	CC	Futures	1654.0	1672.0	1629.0	1633.0	20738.0
2019-10-17	CNH	Futures	7.0986	7.1003	7.0628	7.0742	728.0
2019-10-17	CSC	Futures	3.241	3.246	3.229	3.233	42.0
2019-10-17	CT	Futures	62.78	63.41	62.48	63.26	17549.0
2019-10-17	DC	Futures	27.09	27.21	26.99	27.05	402.0
2019-10-17	DX	Futures	94.468	94.57	93.966	94.077	25715.0
2019-10-17	E1	Futures	1.16151	1.17095	1.16128	1.16945	50915.0
2019-10-17	E6	Futures	1.20504	1.21214	1.20401	1.21035	232895.0
2019-10-17	E7	Futures	1.1987	1.2058	1.1977	1.2041	6334.0
2019-10-17	EBM	Futures	197.55	198.92	197.28	198.37	35806.0
2019-10-17	ED	Futures	95.352	95.3569	95.3083	95.3277	406525.0
2019-10-17	ER	Futures	98.416	98.421	98.401	98.416	116705.0
2019-10-17	EW	Futures	2020.4	2039.7	2016.8	2036.5	17037.0
2019-10-17	FBON	Futures	144.93	145.35	144.54	145.16	548.0
2019-10-17	FBTP	Futures	131.41	131.96	131.32	131.83	77007.0
2019-10-17	FBTS	Futures	108.423	108.519	108.413	108.5	38998.0
2019-10-17	FCE	Futures	5160.9	5205.0	5131.9	5146.4	77474.0
2019-10-17	FDAX	Futures	13356.2	13515.0	13309.2	13378.9	120925.0
2019-10-17	FDIV	Futures	153.47	155.04	153.33	153.84	167.0
2019-10-17	FDXM	Futures	13181.8	13338.0	13134.9	13204.2	57616.0
2019-10-17	FESX	Futures	3141.3	3174.6	3126.4	3146.5	1280212.0
2019-10-17	FGBL	Futures	165.81	166.09	164.93	165.88	846195.0
2019-10-17	FGBM	Futures	134.3	134.33	133.96	134.22	489610.0
2019-10-17	FGBS	Futures	112.82	112.825	112.759	112.79	285042.0
2019-10-17	FGBX	Futures	216.36	217.71	213.59	217.21	47560.0
2019-10-17	FMWO	Futures	7307.4	7372.2	7306.2	7344.9	3432.0
2019-10-17	FOAT	Futures	153.48	153.53	152.59	153.34	157818.0
2019-10-17	FTDX	Futures	2754.5	2778.2	2754.5	2760.5	793.0
2019-10-17	FTI	Futures	546.83	551.31	545.78	547.84	21260.0
2019-10-17	FTUK	Futures	6620.2	6687.4	6612.3	6649.4	127205.0
2019-10-17	FVSA	Futures	169.9	169.9	163.0	166.71	30476.0
2019-10-17	FXXP	Futures	353.9	358.1	353.4	355.2	78030.0
2019-10-17	G	Futures	121.13	121.22	119.87	120.89	279271.0

> showing 50 of 121 rows — these rows as CSV

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