PREVIEW / futures_daily / 2017-11-06

all futures daily files

  file:    by_date/futures_daily/2017/2017-11-06.parquet
  size:    9 KB
  rows:    111

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-11-06	ES	Futures	2806.25	2817.13	2801.36	2815.77	848119.0
2017-11-06	NQ	Futures	7382.73	7420.61	7362.47	7415.91	218392.0
2017-11-06	YM	Futures	24756.7	24823.3	24717.7	24802.1	90269.0
2017-11-06	CL	Futures	56.44	58.09	56.13	57.83	861713.0
2017-11-06	GC	Futures	1616.9	1633.6	1611.4	1630.7	354770.0
2017-11-06	ZN	Futures	123.470554	123.655413	123.347314	123.593793	954051.0
2017-11-06	A6	Futures	0.78712	0.79123	0.78558	0.79072	67352.0
2017-11-06	AD	Futures	0.79748	0.80124	0.79616	0.80018	49502.0
2017-11-06	ALI	Futures	2718.01	2718.01	2718.01	2718.01	0.0
2017-11-06	B	Futures	44.04	45.58	43.91	45.46	356994.0
2017-11-06	B6	Futures	1.3654	1.3752	1.363	1.3749	95085.0
2017-11-06	BFX	Futures	4914.4	4914.4	4894.2	4894.2	49.0
2017-11-06	BR	Futures	0.22706	0.23147	0.22706	0.23026	4321.0
2017-11-06	BZ	Futures	43.56	45.17	43.56	45.06	32269.0
2017-11-06	C	Futures	1520.0	1554.0	1514.0	1551.0	15929.0
2017-11-06	CB	Futures	285.329	285.329	281.235	282.18	54.0
2017-11-06	CC	Futures	1530.0	1577.0	1529.0	1574.0	25199.0
2017-11-06	CNH	Futures	6.828	6.8291	6.815	6.815	14.0
2017-11-06	CSC	Futures	3.447	3.447	3.416	3.433	19.0
2017-11-06	CT	Futures	80.88	81.19	80.14	80.87	23635.0
2017-11-06	DC	Futures	27.86	27.86	27.55	27.64	157.0
2017-11-06	DX	Futures	88.677	88.84	88.471	88.519	17711.0
2017-11-06	E1	Futures	1.22528	1.22931	1.22234	1.22846	18545.0
2017-11-06	E6	Futures	1.32811	1.32925	1.32423	1.32731	172355.0
2017-11-06	E7	Futures	1.3204	1.3219	1.3174	1.3204	3278.0
2017-11-06	EBM	Futures	175.59	175.86	174.78	175.59	12478.0
2017-11-06	ED	Futures	95.4842	95.4891	95.4794	95.4794	121926.0
2017-11-06	ER	Futures	98.347	98.347	98.342	98.347	16007.0
2017-11-06	EW	Futures	1947.7	1961.3	1944.3	1958.2	8702.0
2017-11-06	FBON	Futures	126.52	126.54	126.36	126.43	354.0
2017-11-06	FBTP	Futures	112.77	113.01	112.72	112.81	74584.0
2017-11-06	FBTS	Futures	103.668	103.686	103.649	103.668	24449.0
2017-11-06	FCE	Futures	4940.0	4942.2	4920.7	4934.1	45052.0
2017-11-06	FDAX	Futures	14162.6	14168.3	14123.1	14152.6	52166.0
2017-11-06	FDXM	Futures	14037.8	14048.2	14003.4	14033.1	16708.0
2017-11-06	FESX	Futures	3002.9	3004.5	2989.0	3001.3	583587.0
2017-11-06	FEU3	Futures	99.011	99.016	99.011	99.016	8.0
2017-11-06	FGBL	Futures	150.56	150.94	150.52	150.84	560879.0
2017-11-06	FGBM	Futures	130.14	130.27	130.11	130.24	296667.0
2017-11-06	FGBS	Futures	112.557	112.587	112.552	112.577	199090.0
2017-11-06	FGBX	Futures	169.32	170.36	169.22	169.85	36792.0
2017-11-06	FMWO	Futures	6789.9	6815.9	6789.9	6806.5	646.0
2017-11-06	FOAT	Futures	138.22	138.59	138.2	138.51	73025.0
2017-11-06	FTDX	Futures	2584.8	2585.8	2576.3	2583.8	85.0
2017-11-06	FTI	Futures	513.49	514.7	511.92	513.45	16577.0
2017-11-06	FTUK	Futures	6541.5	6546.2	6504.6	6540.2	59678.0
2017-11-06	FVSA	Futures	324.86	328.69	315.9	318.46	20663.0
2017-11-06	FXXP	Futures	335.7	336.8	335.3	336.6	25493.0
2017-11-06	G	Futures	114.64	114.8	114.5	114.59	152743.0
2017-11-06	GF	Futures	346.715	347.2	342.674	345.152	1676.0

> showing 50 of 111 rows — these rows as CSV

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