PREVIEW / futures_daily / 2017-10-10

all futures daily files

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

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-10	ES	Futures	2766.28	2777.15	2765.73	2771.99	1149236.0
2017-10-10	NQ	Futures	7120.79	7151.62	7093.48	7124.31	238961.0
2017-10-10	YM	Futures	23978.5	24075.6	23977.4	24059.8	86327.0
2017-10-10	CL	Futures	50.21	51.74	50.2	51.6	664839.0
2017-10-10	GC	Futures	1637.3	1649.9	1634.5	1646.2	316581.0
2017-10-10	ZN	Futures	123.378124	123.670818	123.254885	123.501364	1217966.0
2017-10-10	A6	Futures	0.7972	0.80152	0.79679	0.80008	91677.0
2017-10-10	AD	Futures	0.81111	0.81539	0.81071	0.81366	53193.0
2017-10-10	B	Futures	39.39	40.19	39.36	39.98	290341.0
2017-10-10	B6	Futures	1.3728	1.3818	1.3719	1.3791	99799.0
2017-10-10	BR	Futures	0.23592	0.23592	0.23585	0.23585	2.0
2017-10-10	BZ	Futures	39.01	39.86	39.01	39.65	21094.0
2017-10-10	C	Futures	1502.0	1529.0	1498.0	1514.0	10223.0
2017-10-10	CB	Futures	298.588	299.438	298.588	299.438	16.0
2017-10-10	CC	Futures	1501.0	1531.0	1497.0	1518.0	25353.0
2017-10-10	CNH	Futures	6.807	6.807	6.7623	6.7623	67.0
2017-10-10	CSC	Futures	3.462	3.474	3.458	3.458	14.0
2017-10-10	CT	Futures	81.04	82.08	80.59	80.99	12927.0
2017-10-10	DC	Futures	28.3	28.49	28.09	28.19	81.0
2017-10-10	DX	Futures	87.498	87.503	86.923	87.064	26866.0
2017-10-10	E1	Futures	1.2534	1.26135	1.25303	1.25927	23582.0
2017-10-10	E6	Futures	1.34448	1.35435	1.34437	1.35184	233749.0
2017-10-10	E7	Futures	1.3377	1.3472	1.3374	1.3448	3787.0
2017-10-10	EBM	Futures	176.4	176.67	175.59	175.86	12863.0
2017-10-10	ED	Futures	95.4842	95.4988	95.4842	95.4891	173900.0
2017-10-10	ER	Futures	98.337	98.342	98.337	98.337	11480.0
2017-10-10	EW	Futures	1929.6	1939.0	1929.0	1932.9	9346.0
2017-10-10	FBON	Futures	124.11	124.39	123.87	123.97	549.0
2017-10-10	FBTP	Futures	108.83	108.86	108.45	108.65	76004.0
2017-10-10	FBTS	Futures	103.246	103.274	103.21	103.237	48058.0
2017-10-10	FCE	Futures	4804.6	4816.3	4791.2	4802.9	63206.0
2017-10-10	FDAX	Futures	13618.7	13636.5	13557.2	13600.3	67415.0
2017-10-10	FDXM	Futures	13499.0	13520.9	13441.7	13485.5	20005.0
2017-10-10	FESX	Futures	2933.6	2941.7	2920.5	2927.0	755944.0
2017-10-10	FEU3	Futures	99.011	99.011	99.006	99.006	2.0
2017-10-10	FGBL	Futures	149.24	149.49	148.99	149.31	756280.0
2017-10-10	FGBM	Futures	129.57	129.69	129.48	129.61	589621.0
2017-10-10	FGBS	Futures	112.432	112.462	112.412	112.432	312553.0
2017-10-10	FGBX	Futures	167.07	167.71	166.58	167.34	38234.0
2017-10-10	FMWO	Futures	6702.6	6723.8	6702.6	6715.5	800.0
2017-10-10	FOAT	Futures	136.46	136.66	136.2	136.51	90301.0
2017-10-10	FTDX	Futures	2501.5	2507.4	2486.0	2491.5	43.0
2017-10-10	FTI	Futures	498.48	499.96	498.48	499.64	431.0
2017-10-10	FTUK	Futures	6476.4	6518.9	6471.2	6506.7	97171.0
2017-10-10	FVSA	Futures	380.27	393.04	378.85	387.37	23507.0
2017-10-10	FXXP	Futures	330.1	331.7	329.9	330.6	18832.0
2017-10-10	G	Futures	113.41	113.48	113.06	113.42	213249.0
2017-10-10	GF	Futures	335.616	338.31	334.376	336.532	7222.0
2017-10-10	GSCI	Futures	468.56	468.74	467.44	468.74	3279.0
2017-10-10	HE	Futures	90.402	92.063	90.402	90.882	18119.0

> showing 50 of 108 rows — these rows as CSV

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