PREVIEW / futures_daily / 2017-10-17

all futures daily files

  file:    by_date/futures_daily/2017/2017-10-17.parquet
  size:    9 KB
  rows:    112

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
2017-10-17	ES	Futures	2779.6	2782.05	2776.07	2781.23	738739.0
2017-10-17	NQ	Futures	7188.33	7195.08	7171.0	7193.03	154430.0
2017-10-17	YM	Futures	24177.0	24259.4	24167.5	24236.1	77237.0
2017-10-17	CL	Futures	52.64	52.95	51.91	52.55	503671.0
2017-10-17	GC	Futures	1650.6	1652.1	1632.8	1636.6	342411.0
2017-10-17	ZN	Futures	123.686223	123.747843	123.455149	123.670818	1087579.0
2017-10-17	A6	Futures	0.80739	0.80821	0.80379	0.80667	88515.0
2017-10-17	AD	Futures	0.81315	0.8134	0.80837	0.81157	65961.0
2017-10-17	ALI	Futures	2700.15	2700.15	2700.15	2700.15	0.0
2017-10-17	B	Futures	40.81	41.21	40.38	40.88	405217.0
2017-10-17	B6	Futures	1.384	1.3879	1.3739	1.3777	136538.0
2017-10-17	BFX	Futures	4832.8	4833.4	4832.8	4833.4	37.0
2017-10-17	BR	Futures	0.23615	0.2372	0.236	0.23653	31.0
2017-10-17	BZ	Futures	40.51	40.87	40.05	40.54	31599.0
2017-10-17	C	Futures	1504.0	1524.0	1502.0	1522.0	8200.0
2017-10-17	CB	Futures	308.288	309.926	308.288	308.54	19.0
2017-10-17	CC	Futures	1517.0	1540.0	1506.0	1532.0	21098.0
2017-10-17	CNH	Futures	6.796	6.819	6.796	6.8083	39.0
2017-10-17	CSC	Futures	3.427	3.48	3.427	3.451	37.0
2017-10-17	CT	Futures	79.37	80.58	79.22	79.6	14237.0
2017-10-17	DC	Futures	27.77	28.53	27.73	28.17	195.0
2017-10-17	DX	Futures	87.101	87.522	87.096	87.297	16907.0
2017-10-17	E1	Futures	1.25866	1.25927	1.25132	1.25499	24175.0
2017-10-17	E6	Futures	1.35047	1.35053	1.34346	1.34745	181596.0
2017-10-17	E7	Futures	1.3433	1.3433	1.3365	1.3404	3271.0
2017-10-17	EBM	Futures	175.05	175.86	175.05	175.32	9511.0
2017-10-17	ED	Futures	95.4988	95.5036	95.4891	95.4939	241161.0
2017-10-17	ER	Futures	98.342	98.347	98.337	98.342	90447.0
2017-10-17	EW	Futures	1933.6	1936.3	1928.6	1930.4	7873.0
2017-10-17	FBON	Futures	125.28	125.48	125.18	125.46	358.0
2017-10-17	FBTP	Futures	110.19	110.65	110.18	110.55	84993.0
2017-10-17	FBTS	Futures	103.393	103.457	103.384	103.448	47627.0
2017-10-17	FCE	Futures	4810.5	4815.8	4789.4	4801.5	207785.0
2017-10-17	FDAX	Futures	13655.4	13690.6	13619.7	13675.9	57837.0
2017-10-17	FDIV	Futures	152.68	152.68	152.34	152.34	5.0
2017-10-17	FDXM	Futures	13540.7	13576.1	13504.2	13560.5	15968.0
2017-10-17	FESX	Futures	2938.5	2946.6	2927.9	2941.7	619037.0
2017-10-17	FEU3	Futures	99.011	99.011	99.006	99.006	69.0
2017-10-17	FGBL	Futures	150.16	150.51	150.11	150.36	667772.0
2017-10-17	FGBM	Futures	129.97	130.08	129.95	130.0	516521.0
2017-10-17	FGBS	Futures	112.502	112.522	112.492	112.507	247381.0
2017-10-17	FGBX	Futures	168.97	169.83	168.93	169.5	39947.0
2017-10-17	FMWO	Futures	6749.8	6749.8	6738.0	6742.7	370.0
2017-10-17	FOAT	Futures	137.56	137.88	137.51	137.75	90838.0
2017-10-17	FTDX	Futures	2526.4	2528.4	2507.9	2508.9	171.0
2017-10-17	FTI	Futures	505.66	505.8	504.41	504.78	29987.0
2017-10-17	FTUK	Futures	6509.8	6525.4	6485.5	6508.0	75149.0
2017-10-17	FVSA	Futures	358.11	359.39	349.16	354.27	31511.0
2017-10-17	FXXP	Futures	332.2	332.3	330.8	331.5	36726.0
2017-10-17	G	Futures	113.56	114.38	113.52	114.23	243121.0

> showing 50 of 112 rows — these rows as CSV

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