PREVIEW / futures_daily / 2019-07-12

all futures daily files

  file:    by_date/futures_daily/2019/2019-07-12.parquet
  size:    10 KB
  rows:    118

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-07-12	ES	Futures	3240.41	3256.59	3239.6	3253.9	969956.0
2019-07-12	NQ	Futures	9115.33	9173.18	9108.99	9164.54	299817.0
2019-07-12	YM	Futures	28426.3	28697.2	28424.2	28675.2	146908.0
2019-07-12	CL	Futures	61.85	62.13	61.3	61.59	469029.0
2019-07-12	GC	Futures	1750.2	1766.0	1748.1	1757.7	284967.0
2019-07-12	ZN	Futures	126.273883	126.553835	126.196119	126.522729	1148508.0
2019-07-12	A6	Futures	0.7188	0.72415	0.71859	0.72415	76420.0
2019-07-12	AD	Futures	0.77224	0.77527	0.77214	0.77436	55395.0
2019-07-12	ALI	Futures	2272.13	2272.13	2272.13	2272.13	0.0
2019-07-12	B	Futures	50.24	50.59	50.0	50.16	244702.0
2019-07-12	B6	Futures	1.2823	1.2879	1.2818	1.2869	56517.0
2019-07-12	BR	Futures	0.2121	0.2131	0.21194	0.2127	1586.0
2019-07-12	BTC	Futures	15965.7	16805.7	15671.8	16420.7	3357.0
2019-07-12	BZ	Futures	49.57	49.93	49.37	49.53	31996.0
2019-07-12	C	Futures	1754.0	1773.0	1742.0	1761.0	14915.0
2019-07-12	CB	Futures	283.576	286.931	283.576	286.202	102.0
2019-07-12	CC	Futures	1663.0	1679.0	1647.0	1667.0	10716.0
2019-07-12	CNH	Futures	6.8791	6.8873	6.873	6.8814	608.0
2019-07-12	CSC	Futures	3.137	3.137	3.099	3.107	150.0
2019-07-12	CT	Futures	62.43	62.43	61.58	61.58	25.0
2019-07-12	DC	Futures	26.26	26.27	25.96	26.01	318.0
2019-07-12	DX	Futures	93.137	93.137	92.82	92.838	10287.0
2019-07-12	E1	Futures	1.17838	1.18591	1.17722	1.18487	25477.0
2019-07-12	E6	Futures	1.23389	1.23623	1.2322	1.23585	141380.0
2019-07-12	E7	Futures	1.2277	1.2297	1.2258	1.2294	4111.0
2019-07-12	EBM	Futures	204.4	206.41	203.82	205.26	19522.0
2019-07-12	ED	Futures	95.3428	95.3574	95.3282	95.3525	285719.0
2019-07-12	ER	Futures	98.509	98.514	98.504	98.509	35388.0
2019-07-12	EW	Futures	2040.7	2066.2	2040.4	2064.0	12141.0
2019-07-12	FBON	Futures	142.46	142.46	141.26	141.45	803.0
2019-07-12	FBTP	Futures	124.01	124.18	123.39	123.69	89001.0
2019-07-12	FBTS	Futures	107.427	107.485	107.312	107.398	38501.0
2019-07-12	FCE	Futures	5072.8	5087.9	5059.2	5075.1	3175.0
2019-07-12	FDAX	Futures	12985.4	13032.8	12942.8	12958.0	94059.0
2019-07-12	FDIV	Futures	146.32	146.32	145.81	145.86	27.0
2019-07-12	FDXM	Futures	12832.7	12873.3	12783.9	12798.4	28427.0
2019-07-12	FESX	Futures	3051.8	3060.6	3042.2	3046.6	553455.0
2019-07-12	FGBL	Futures	163.12	163.43	162.83	163.24	769756.0
2019-07-12	FGBM	Futures	134.09	134.24	134.05	134.15	456664.0
2019-07-12	FGBS	Futures	113.046	113.056	113.026	113.041	218590.0
2019-07-12	FGBX	Futures	204.56	204.87	202.85	204.46	53385.0
2019-07-12	FMWO	Futures	7436.4	7458.3	7431.8	7441.0	1426.0
2019-07-12	FOAT	Futures	150.78	150.97	150.23	150.56	186296.0
2019-07-12	FTDX	Futures	2825.6	2830.0	2817.2	2819.7	117.0
2019-07-12	FTI	Futures	536.39	536.58	534.49	535.11	841.0
2019-07-12	FTUK	Futures	6897.0	6906.7	6858.6	6867.0	62516.0
2019-07-12	FVSA	Futures	173.74	176.22	173.12	174.36	25850.0
2019-07-12	FXXP	Futures	346.4	346.4	344.9	345.4	28725.0
2019-07-12	G	Futures	119.75	120.04	119.67	119.92	167791.0
2019-07-12	GF	Futures	280.083	280.23	275.619	277.875	6962.0

> showing 50 of 118 rows — these rows as CSV

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