PREVIEW / futures_daily / 2019-08-21

all futures daily files

  file:    by_date/futures_daily/2019/2019-08-21.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-21	ES	Futures	3121.98	3164.33	3121.71	3160.83	1180368.0
2019-08-21	NQ	Futures	8813.39	8940.9	8810.22	8923.05	344352.0
2019-08-21	YM	Futures	27177.8	27578.9	27166.3	27538.0	139879.0
2019-08-21	CL	Futures	57.57	58.68	57.05	57.19	704035.0
2019-08-21	GC	Futures	1873.0	1873.0	1858.3	1869.7	245896.0
2019-08-21	ZN	Futures	130.146552	130.19321	129.726624	129.928811	1479712.0
2019-08-21	A6	Futures	0.6975	0.70007	0.6973	0.69812	46987.0
2019-08-21	AD	Futures	0.75728	0.76085	0.75697	0.75839	62329.0
2019-08-21	ALI	Futures	2178.43	2180.55	2173.87	2176.91	90.0
2019-08-21	B	Futures	45.35	46.33	45.32	45.49	269681.0
2019-08-21	B6	Futures	1.2431	1.2442	1.2377	1.2389	80236.0
2019-08-21	BR	Futures	0.1976	0.1988	0.19724	0.19812	4043.0
2019-08-21	BTC	Futures	14890.4	14993.7	13561.8	13926.6	5034.0
2019-08-21	BZ	Futures	44.72	45.73	44.72	44.9	33717.0
2019-08-21	C	Futures	1528.0	1561.0	1528.0	1557.0	2337.0
2019-08-21	CB	Futures	274.824	274.824	272.578	272.782	57.0
2019-08-21	CC	Futures	1429.0	1453.0	1427.0	1448.0	24116.0
2019-08-21	CNH	Futures	7.0769	7.0804	7.0678	7.0777	469.0
2019-08-21	CSC	Futures	3.078	3.08	3.05	3.053	144.0
2019-08-21	CT	Futures	58.26	59.12	57.92	59.12	34.0
2019-08-21	DC	Futures	25.89	25.95	25.7	25.76	567.0
2019-08-21	DX	Futures	94.427	94.572	94.355	94.528	8810.0
2019-08-21	E1	Futures	1.18823	1.1887	1.18232	1.18336	14153.0
2019-08-21	E6	Futures	1.21284	1.21404	1.21104	1.21169	107256.0
2019-08-21	E7	Futures	1.2069	1.2076	1.2045	1.2054	1792.0
2019-08-21	EBM	Futures	190.58	190.87	189.14	190.0	10471.0
2019-08-21	ED	Futures	95.4134	95.4134	95.3744	95.3817	270557.0
2019-08-21	ER	Futures	98.548	98.548	98.533	98.543	50949.0
2019-08-21	EW	Futures	1965.8	1989.8	1963.8	1981.9	10000.0
2019-08-21	FBON	Futures	146.49	146.66	146.18	146.59	470.0
2019-08-21	FBTP	Futures	127.42	128.21	127.37	127.9	84616.0
2019-08-21	FBTS	Futures	107.485	107.724	107.456	107.686	47928.0
2019-08-21	FCE	Futures	4842.9	4928.0	4842.0	4922.2	67251.0
2019-08-21	FDAX	Futures	12224.1	12445.2	12224.1	12410.5	89191.0
2019-08-21	FDIV	Futures	140.94	141.78	140.94	141.78	20.0
2019-08-21	FDXM	Futures	12068.3	12291.9	12068.3	12257.6	35415.0
2019-08-21	FESX	Futures	2914.7	2967.1	2914.7	2959.3	796809.0
2019-08-21	FGBL	Futures	169.98	170.04	169.43	169.9	545223.0
2019-08-21	FGBM	Futures	136.15	136.15	135.95	136.01	318257.0
2019-08-21	FGBS	Futures	113.408	113.408	113.338	113.358	210483.0
2019-08-21	FGBX	Futures	228.45	229.64	226.45	228.98	70895.0
2019-08-21	FMWO	Futures	7142.2	7198.7	7138.7	7191.8	2063.0
2019-08-21	FOAT	Futures	156.17	156.38	155.82	156.27	122015.0
2019-08-21	FTDX	Futures	2707.6	2740.7	2707.6	2738.7	135.0
2019-08-21	FTI	Futures	515.82	521.27	515.63	520.48	18110.0
2019-08-21	FTUK	Futures	6541.5	6652.3	6535.0	6636.1	74862.0
2019-08-21	FVSA	Futures	215.09	215.72	206.94	208.82	34853.0
2019-08-21	FXXP	Futures	332.9	336.9	332.5	336.2	57664.0
2019-08-21	G	Futures	123.72	123.92	123.45	123.83	160186.0
2019-08-21	GF	Futures	273.137	276.545	272.272	275.324	4099.0

> showing 50 of 120 rows — these rows as CSV

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