PREVIEW / futures_daily / 2017-10-04

all futures daily files

  file:    by_date/futures_daily/2017/2017-10-04.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-04	ES	Futures	2755.13	2760.57	2750.78	2758.66	956590.0
2017-10-04	NQ	Futures	7046.49	7065.88	7023.59	7052.37	236714.0
2017-10-04	YM	Futures	23876.0	23898.2	23844.4	23872.9	73327.0
2017-10-04	CL	Futures	50.83	51.34	50.42	50.65	598836.0
2017-10-04	GC	Futures	1621.7	1635.0	1619.9	1624.6	273119.0
2017-10-04	ZN	Futures	123.624603	123.840272	123.424339	123.562983	1209896.0
2017-10-04	A6	Futures	0.80512	0.80955	0.80482	0.80811	95164.0
2017-10-04	AD	Futures	0.81488	0.81763	0.81437	0.8159	50230.0
2017-10-04	B	Futures	39.32	39.69	39.11	39.41	330854.0
2017-10-04	B6	Futures	1.3828	1.389	1.3828	1.3843	82473.0
2017-10-04	BR	Futures	0.23954	0.23954	0.23947	0.23947	41.0
2017-10-04	BZ	Futures	39.01	39.36	38.8	39.08	25898.0
2017-10-04	C	Futures	1517.0	1537.0	1515.0	1524.0	13369.0
2017-10-04	CB	Futures	298.557	301.076	298.431	301.076	54.0
2017-10-04	CC	Futures	1553.0	1561.0	1532.0	1543.0	32809.0
2017-10-04	CNH	Futures	6.8473	6.8487	6.8406	6.8475	5.0
2017-10-04	CSC	Futures	3.483	3.522	3.476	3.518	98.0
2017-10-04	CT	Futures	79.4	82.18	79.33	80.81	24271.0
2017-10-04	DC	Futures	28.49	28.9	28.42	28.85	117.0
2017-10-04	DX	Futures	87.358	87.363	87.049	87.235	17763.0
2017-10-04	E1	Futures	1.2611	1.26514	1.25841	1.26037	17113.0
2017-10-04	E6	Futures	1.34465	1.35042	1.34437	1.34762	178739.0
2017-10-04	E7	Futures	1.3377	1.3431	1.3374	1.3406	2415.0
2017-10-04	EBM	Futures	179.9	180.17	178.82	179.09	13191.0
2017-10-04	ED	Futures	95.5085	95.5133	95.4988	95.5036	221573.0
2017-10-04	ER	Futures	98.337	98.342	98.337	98.342	23116.0
2017-10-04	EW	Futures	1931.3	1932.3	1924.4	1929.0	11142.0
2017-10-04	FBON	Futures	123.81	123.84	123.16	123.37	1443.0
2017-10-04	FBTP	Futures	108.32	108.45	107.96	108.09	129604.0
2017-10-04	FBTS	Futures	103.255	103.274	103.219	103.228	55103.0
2017-10-04	FCE	Futures	4812.7	4813.6	4785.8	4802.4	68109.0
2017-10-04	FDAX	Futures	13615.0	13636.5	13540.9	13617.1	73372.0
2017-10-04	FDXM	Futures	13495.9	13520.9	13427.1	13502.2	22996.0
2017-10-04	FESX	Futures	2936.8	2937.6	2914.8	2923.0	668770.0
2017-10-04	FGBL	Futures	149.08	149.62	149.01	149.16	957944.0
2017-10-04	FGBM	Futures	129.63	129.83	129.58	129.62	763617.0
2017-10-04	FGBS	Futures	112.447	112.492	112.432	112.442	368497.0
2017-10-04	FGBX	Futures	166.66	168.11	166.6	166.99	53801.0
2017-10-04	FMWO	Futures	6682.5	6693.1	6676.6	6687.2	2947.0
2017-10-04	FOAT	Futures	136.13	136.55	136.03	136.15	125393.0
2017-10-04	FTDX	Futures	2483.5	2495.5	2477.5	2495.0	343.0
2017-10-04	FTI	Futures	499.91	499.91	497.51	498.8	20236.0
2017-10-04	FTUK	Futures	6444.3	6452.5	6432.1	6446.9	62894.0
2017-10-04	FVSA	Futures	376.02	393.04	376.02	390.2	23130.0
2017-10-04	FXXP	Futures	331.0	331.2	329.6	330.5	24700.0
2017-10-04	G	Futures	113.7	113.7	113.15	113.33	161689.0
2017-10-04	GF	Futures	334.252	334.852	331.742	331.96	1627.0
2017-10-04	GSCI	Futures	472.15	472.15	470.54	470.54	357.0
2017-10-04	HE	Futures	91.99	92.875	91.288	91.399	15553.0
2017-10-04	HG	Futures	3.5726	3.5901	3.5599	3.5744	45588.0

> showing 50 of 108 rows — these rows as CSV

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