PREVIEW / futures_daily / 2019-08-22

all futures daily files

  file:    by_date/futures_daily/2019/2019-08-22.parquet
  size:    10 KB
  rows:    120

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-08-22	ES	Futures	3162.98	3172.16	3133.85	3153.27	1470309.0
2019-08-22	NQ	Futures	8929.67	8959.9	8812.24	8878.15	487622.0
2019-08-22	YM	Futures	27556.9	27694.4	27391.0	27536.9	175622.0
2019-08-22	CL	Futures	57.45	57.99	56.33	56.85	621573.0
2019-08-22	GC	Futures	1865.6	1868.3	1852.9	1860.8	279405.0
2019-08-22	ZN	Futures	129.8666	130.130999	129.524436	129.695518	1941609.0
2019-08-22	A6	Futures	0.69843	0.69884	0.69503	0.69575	62837.0
2019-08-22	AD	Futures	0.75909	0.75959	0.75728	0.75818	58439.0
2019-08-22	ALI	Futures	2160.52	2169.32	2156.27	2159.91	118.0
2019-08-22	B	Futures	45.59	45.93	44.86	45.2	276113.0
2019-08-22	B6	Futures	1.2399	1.254	1.2371	1.2523	155680.0
2019-08-22	BR	Futures	0.19804	0.19872	0.19564	0.19628	4166.0
2019-08-22	BTC	Futures	13823.4	14119.4	13444.7	14023.0	3956.0
2019-08-22	BZ	Futures	44.99	45.34	44.28	44.62	33800.0
2019-08-22	C	Futures	1556.0	1575.0	1544.0	1552.0	2063.0
2019-08-22	CB	Futures	272.782	272.782	267.763	271.247	25.0
2019-08-22	CC	Futures	1449.0	1470.0	1443.0	1463.0	24022.0
2019-08-22	CNH	Futures	7.0777	7.1067	7.0759	7.0934	877.0
2019-08-22	CSC	Futures	3.043	3.043	2.995	3.001	201.0
2019-08-22	CT	Futures	59.28	59.32	58.14	58.14	8.0
2019-08-22	DC	Futures	25.69	25.73	25.22	25.29	830.0
2019-08-22	DX	Futures	94.504	94.634	94.322	94.417	13481.0
2019-08-22	E1	Futures	1.18359	1.18406	1.18035	1.18151	20820.0
2019-08-22	E6	Futures	1.2118	1.21447	1.20896	1.21142	202399.0
2019-08-22	E7	Futures	1.2054	1.208	1.2027	1.2051	3558.0
2019-08-22	EBM	Futures	190.0	190.87	189.43	190.87	10010.0
2019-08-22	ED	Futures	95.3769	95.3915	95.3549	95.3622	337410.0
2019-08-22	ER	Futures	98.533	98.538	98.524	98.529	104736.0
2019-08-22	EW	Futures	1987.5	1994.1	1971.2	1983.7	10810.0
2019-08-22	FBON	Futures	146.56	146.63	145.9	145.99	410.0
2019-08-22	FBTP	Futures	127.82	128.47	127.47	127.95	96861.0
2019-08-22	FBTS	Futures	107.619	107.858	107.619	107.667	44306.0
2019-08-22	FCE	Futures	4913.1	4926.7	4869.6	4879.6	80083.0
2019-08-22	FDAX	Futures	12428.9	12475.3	12324.7	12347.8	103555.0
2019-08-22	FDXM	Futures	12270.1	12321.1	12173.4	12195.7	43658.0
2019-08-22	FESX	Futures	2966.3	2971.5	2936.6	2939.2	1022350.0
2019-08-22	FEU3	Futures	99.164	99.164	99.159	99.159	297.0
2019-08-22	FGBL	Futures	169.95	170.15	168.92	169.29	886720.0
2019-08-22	FGBM	Futures	136.02	136.09	135.64	135.82	499264.0
2019-08-22	FGBS	Futures	113.343	113.363	113.237	113.293	441534.0
2019-08-22	FGBX	Futures	229.35	230.57	225.83	226.94	90261.0
2019-08-22	FMWO	Futures	7187.2	7207.9	7138.7	7152.5	1924.0
2019-08-22	FOAT	Futures	156.26	156.49	155.31	155.6	108546.0
2019-08-22	FTDX	Futures	2735.3	2747.1	2707.6	2712.1	115.0
2019-08-22	FTI	Futures	519.99	520.98	516.01	517.15	25213.0
2019-08-22	FTUK	Futures	6639.4	6646.8	6551.7	6562.3	115797.0
2019-08-22	FVSA	Futures	208.82	220.73	206.94	216.34	34785.0
2019-08-22	FXXP	Futures	335.8	337.4	334.4	334.7	57240.0
2019-08-22	G	Futures	123.87	123.88	123.02	123.23	340163.0
2019-08-22	GF	Futures	275.324	278.377	274.307	277.613	3684.0

> showing 50 of 120 rows — these rows as CSV

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