PREVIEW / futures_daily / 2018-06-05

all futures daily files

  file:    by_date/futures_daily/2018/2018-06-05.parquet
  size:    10 KB
  rows:    115

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
2018-06-05	ES	Futures	2986.19	2994.07	2978.57	2992.17	1027609.0
2018-06-05	NQ	Futures	8365.67	8412.49	8353.97	8402.83	256212.0
2018-06-05	YM	Futures	26132.8	26187.6	26028.5	26147.5	140335.0
2018-06-05	CL	Futures	65.36	66.0	64.64	65.95	714674.0
2018-06-05	GC	Futures	1655.1	1665.8	1651.4	1662.5	271294.0
2018-06-05	ZN	Futures	118.88879	119.276505	118.88879	119.136928	40028.0
2018-06-05	A6	Futures	0.78661	0.78733	0.78095	0.78301	116493.0
2018-06-05	AD	Futures	0.78257	0.78358	0.77443	0.78009	101696.0
2018-06-05	B	Futures	55.21	55.46	54.05	55.2	400846.0
2018-06-05	B6	Futures	1.3797	1.3894	1.3784	1.3877	127635.0
2018-06-05	BR	Futures	0.20056	0.20056	0.19812	0.19904	46.0
2018-06-05	BTC	Futures	10679.8	10900.1	10459.5	10836.1	2069.0
2018-06-05	BZ	Futures	54.78	54.94	53.55	54.68	43436.0
2018-06-05	C	Futures	1529.0	1540.0	1485.0	1491.0	19187.0
2018-06-05	CB	Futures	292.342	292.342	290.843	290.843	16.0
2018-06-05	CC	Futures	1710.0	1738.0	1680.0	1689.0	33407.0
2018-06-05	CNH	Futures	6.4937	6.4997	6.4835	6.4841	22.0
2018-06-05	CSC	Futures	3.48	3.48	3.431	3.431	149.0
2018-06-05	CT	Futures	104.85	104.9	102.0	102.13	23560.0
2018-06-05	DC	Futures	28.09	28.09	27.49	27.54	440.0
2018-06-05	DX	Futures	88.64	88.933	88.423	88.533	20633.0
2018-06-05	E1	Futures	1.22008	1.22634	1.21851	1.22429	19757.0
2018-06-05	E6	Futures	1.31872	1.32278	1.31382	1.32075	278736.0
2018-06-05	E7	Futures	1.3118	1.3157	1.3067	1.3137	5684.0
2018-06-05	EBM	Futures	188.57	191.45	188.57	190.93	13968.0
2018-06-05	ED	Futures	94.9792	94.9816	94.9719	94.9743	220745.0
2018-06-05	ER	Futures	98.337	98.342	98.332	98.337	147174.0
2018-06-05	EW	Futures	2084.0	2092.5	2080.3	2090.3	11889.0
2018-06-05	FBON	Futures	128.88	128.88	128.37	128.45	1898.0
2018-06-05	FBTP	Futures	108.2	108.46	105.95	106.89	250488.0
2018-06-05	FBTS	Futures	102.364	102.364	101.399	101.826	107919.0
2018-06-05	FCE	Futures	4896.3	4942.6	4889.1	4895.9	75432.0
2018-06-05	FDAX	Futures	13263.9	13430.2	13244.7	13289.4	112691.0
2018-06-05	FDXM	Futures	13141.7	13309.6	13127.3	13171.1	37150.0
2018-06-05	FESX	Futures	2883.9	2909.7	2870.6	2878.1	1194543.0
2018-06-05	FEU3	Futures	99.016	99.021	99.016	99.021	500.0
2018-06-05	FGBL	Futures	151.4	152.33	151.4	152.13	1476604.0
2018-06-05	FGBM	Futures	130.55	130.91	130.52	130.83	1265990.0
2018-06-05	FGBS	Futures	112.673	112.749	112.668	112.718	863845.0
2018-06-05	FGBX	Futures	174.09	175.71	174.09	175.27	136102.0
2018-06-05	FMWO	Futures	7062.4	7069.4	7041.4	7043.7	522.0
2018-06-05	FOAT	Futures	139.43	139.87	139.34	139.74	323564.0
2018-06-05	FTDX	Futures	2796.8	2832.4	2796.8	2808.1	337.0
2018-06-05	FTI	Futures	518.8	522.96	518.29	520.0	26141.0
2018-06-05	FTUK	Futures	6823.8	6832.2	6765.5	6784.5	96985.0
2018-06-05	FVSA	Futures	312.53	320.05	297.5	312.53	32174.0
2018-06-05	FXXP	Futures	335.1	336.8	333.2	334.2	66851.0
2018-06-05	G	Futures	115.21	115.34	114.87	115.25	187275.0
2018-06-05	GF	Futures	301.051	304.417	298.979	302.708	6851.0
2018-06-05	GSCI	Futures	526.14	529.5	525.57	529.45	71.0

> showing 50 of 115 rows — these rows as CSV

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