PREVIEW / futures_daily / 2019-09-27

all futures daily files

  file:    by_date/futures_daily/2019/2019-09-27.parquet
  size:    10 KB
  rows:    119

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
2019-09-27	ES	Futures	3225.78	3240.12	3189.51	3208.46	1673557.0
2019-09-27	NQ	Futures	8973.9	9014.23	8805.65	8875.08	598171.0
2019-09-27	YM	Futures	28235.2	28336.0	28017.9	28130.2	225720.0
2019-09-27	CL	Futures	58.02	58.27	56.21	57.4	712966.0
2019-09-27	GC	Futures	1864.9	1868.1	1842.1	1858.2	451928.0
2019-09-27	ZN	Futures	129.04709	129.232903	128.76837	129.217418	1325313.0
2019-09-27	A6	Futures	0.69404	0.69732	0.69363	0.69537	82615.0
2019-09-27	AD	Futures	0.76015	0.76322	0.75945	0.76136	71968.0
2019-09-27	ALI	Futures	2113.34	2113.95	2097.95	2110.93	132.0
2019-09-27	B	Futures	48.72	48.97	47.4	48.35	380302.0
2019-09-27	B6	Futures	1.2569	1.258	1.2512	1.2532	99946.0
2019-09-27	BR	Futures	0.1936	0.19437	0.19275	0.19384	185.0
2019-09-27	BTC	Futures	11693.1	11765.0	11376.7	11556.5	3497.0
2019-09-27	BZ	Futures	48.14	48.28	46.73	47.68	46591.0
2019-09-27	C	Futures	1712.0	1720.0	1699.0	1708.0	12689.0
2019-09-27	CB	Futures	255.984	256.456	255.659	255.895	32.0
2019-09-27	CC	Futures	1643.0	1650.0	1624.0	1634.0	21486.0
2019-09-27	CNH	Futures	7.124	7.146	7.1113	7.1453	1293.0
2019-09-27	CSC	Futures	3.098	3.144	3.095	3.115	58.0
2019-09-27	CT	Futures	58.4	59.38	57.99	59.28	13759.0
2019-09-27	DC	Futures	25.97	26.43	25.97	26.22	151.0
2019-09-27	DX	Futures	95.498	95.643	95.329	95.455	10394.0
2019-09-27	E1	Futures	1.16519	1.16945	1.16358	1.16876	28335.0
2019-09-27	E6	Futures	1.19009	1.19442	1.18857	1.19236	162479.0
2019-09-27	E7	Futures	1.184	1.1882	1.1824	1.1862	3332.0
2019-09-27	EBM	Futures	189.34	190.99	189.34	190.44	32846.0
2019-09-27	ED	Futures	95.25	95.2792	95.2403	95.2743	224867.0
2019-09-27	ER	Futures	98.455	98.46	98.45	98.455	55195.0
2019-09-27	EW	Futures	2037.5	2048.7	2013.3	2021.6	12525.0
2019-09-27	FBON	Futures	145.97	146.31	145.77	145.91	287.0
2019-09-27	FBTP	Futures	132.62	132.67	132.27	132.51	75480.0
2019-09-27	FBTS	Futures	108.577	108.625	108.5	108.577	44596.0
2019-09-27	FCE	Futures	5097.5	5109.7	5071.7	5105.2	60327.0
2019-09-27	FDAX	Futures	12995.3	13075.0	12944.1	13040.1	99859.0
2019-09-27	FDIV	Futures	148.46	149.01	148.46	148.55	41.0
2019-09-27	FDXM	Futures	12817.3	12904.8	12775.6	12869.9	33163.0
2019-09-27	FESX	Futures	3095.7	3105.3	3077.3	3095.7	836788.0
2019-09-27	FGBL	Futures	168.42	168.61	168.13	168.29	452243.0
2019-09-27	FGBM	Futures	135.09	135.23	135.05	135.15	329204.0
2019-09-27	FGBS	Futures	112.986	113.036	112.976	113.021	172308.0
2019-09-27	FGBX	Futures	227.63	228.54	225.91	226.45	35668.0
2019-09-27	FMWO	Futures	7277.8	7300.5	7239.1	7288.0	4096.0
2019-09-27	FOAT	Futures	155.17	155.42	154.9	155.11	75901.0
2019-09-27	FTDX	Futures	2769.8	2778.2	2760.5	2778.2	48.0
2019-09-27	FTI	Futures	548.69	550.12	544.24	548.41	24796.0
2019-09-27	FTUK	Futures	6800.0	6864.0	6785.2	6847.8	104925.0
2019-09-27	FVSA	Futures	186.37	197.04	184.13	186.37	15534.0
2019-09-27	FXXP	Futures	352.3	353.6	351.0	352.8	33044.0
2019-09-27	G	Futures	122.57	123.24	122.57	122.87	201721.0
2019-09-27	GF	Futures	300.169	302.942	298.86	302.105	4929.0

> showing 50 of 119 rows — these rows as CSV

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