PREVIEW / futures_daily / 2019-09-23

all futures daily files

  file:    by_date/futures_daily/2019/2019-09-23.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-09-23	ES	Futures	3243.1	3256.63	3228.22	3244.45	1044218.0
2019-09-23	NQ	Futures	9034.11	9101.24	8997.81	9047.08	348180.0
2019-09-23	YM	Futures	28263.5	28391.6	28137.5	28305.5	147365.0
2019-09-23	CL	Futures	60.83	60.97	58.9	60.2	526785.0
2019-09-23	GC	Futures	1876.8	1892.8	1872.4	1889.2	359879.0
2019-09-23	ZN	Futures	128.598042	129.248387	128.412229	128.90773	1513971.0
2019-09-23	A6	Futures	0.69609	0.69753	0.69588	0.6965	71422.0
2019-09-23	AD	Futures	0.76005	0.76086	0.75794	0.76056	57897.0
2019-09-23	ALI	Futures	2163.15	2174.02	2161.94	2174.02	131.0
2019-09-23	B	Futures	50.38	50.59	49.07	50.03	204777.0
2019-09-23	B6	Futures	1.2718	1.2738	1.266	1.2683	92150.0
2019-09-23	BR	Futures	0.19303	0.19315	0.19223	0.19295	80.0
2019-09-23	BTC	Futures	14465.9	14465.9	13844.4	14008.7	4645.0
2019-09-23	BZ	Futures	49.7	49.7	48.35	49.29	25895.0
2019-09-23	C	Futures	1658.0	1662.0	1647.0	1656.0	10420.0
2019-09-23	CB	Futures	256.604	258.05	256.604	257.43	16.0
2019-09-23	CC	Futures	1627.0	1628.0	1607.0	1610.0	21031.0
2019-09-23	CNH	Futures	7.1078	7.1281	7.1023	7.1147	1116.0
2019-09-23	CSC	Futures	3.149	3.175	3.129	3.132	45.0
2019-09-23	CT	Futures	58.09	59.5	57.95	59.08	69.0
2019-09-23	DC	Futures	26.61	26.76	26.36	26.46	224.0
2019-09-23	DX	Futures	94.86	95.159	94.787	94.933	13354.0
2019-09-23	E1	Futures	1.16864	1.17106	1.16703	1.17014	25663.0
2019-09-23	E6	Futures	1.20147	1.20212	1.19567	1.19903	167595.0
2019-09-23	E7	Futures	1.1952	1.196	1.1894	1.1929	4006.0
2019-09-23	EBM	Futures	187.98	188.52	187.7	187.98	12422.0
2019-09-23	ED	Futures	95.2403	95.284	95.2306	95.2597	279316.0
2019-09-23	ER	Futures	98.431	98.45	98.431	98.445	148505.0
2019-09-23	EW	Futures	2050.8	2058.9	2034.7	2048.2	12205.0
2019-09-23	FBON	Futures	145.19	146.2	145.19	146.2	311.0
2019-09-23	FBTP	Futures	131.53	132.57	131.53	132.48	75551.0
2019-09-23	FBTS	Futures	108.336	108.51	108.336	108.471	45647.0
2019-09-23	FCE	Futures	5131.9	5137.8	5079.8	5089.8	71117.0
2019-09-23	FDAX	Futures	13115.1	13126.1	12924.1	13013.2	105918.0
2019-09-23	FDIV	Futures	148.46	148.64	148.04	148.64	160.0
2019-09-23	FDXM	Futures	12939.1	12955.8	12754.8	12843.3	38479.0
2019-09-23	FESX	Futures	3112.3	3114.1	3078.1	3090.4	928370.0
2019-09-23	FGBL	Futures	167.7	168.7	167.4	168.61	692581.0
2019-09-23	FGBM	Futures	134.82	135.11	134.7	135.08	419689.0
2019-09-23	FGBS	Futures	112.91	112.966	112.89	112.951	227343.0
2019-09-23	FGBX	Futures	223.98	227.46	222.42	227.11	49818.0
2019-09-23	FMWO	Futures	7342.6	7342.6	7281.2	7307.4	3341.0
2019-09-23	FOAT	Futures	154.43	155.44	154.16	155.34	126274.0
2019-09-23	FTDX	Futures	2830.0	2830.0	2774.3	2786.6	142.0
2019-09-23	FTI	Futures	546.32	547.03	542.34	544.93	23046.0
2019-09-23	FTUK	Futures	6780.1	6789.8	6715.2	6759.2	79502.0
2019-09-23	FVSA	Futures	179.64	190.3	178.52	184.69	17118.0
2019-09-23	FXXP	Futures	352.8	353.4	350.0	351.2	47082.0
2019-09-23	G	Futures	121.64	122.56	121.47	122.54	212399.0
2019-09-23	GF	Futures	293.209	296.191	292.947	295.668	4444.0

> showing 50 of 120 rows — these rows as CSV

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