PREVIEW / futures_daily / 2019-07-16

all futures daily files

  file:    by_date/futures_daily/2019/2019-07-16.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-16	ES	Futures	3255.78	3260.64	3242.03	3244.72	939814.0
2019-07-16	NQ	Futures	9190.74	9212.32	9123.1	9144.68	303702.0
2019-07-16	YM	Futures	28714.0	28766.5	28644.7	28695.1	134696.0
2019-07-16	CL	Futures	60.6	61.4	58.36	58.92	303563.0
2019-07-16	GC	Futures	1762.9	1767.4	1745.1	1756.4	334818.0
2019-07-16	ZN	Futures	126.616046	126.662705	126.133907	126.336095	1322335.0
2019-07-16	A6	Futures	0.72559	0.72621	0.7226	0.72291	74386.0
2019-07-16	AD	Futures	0.7735	0.77487	0.77078	0.77214	56258.0
2019-07-16	ALI	Futures	2272.13	2272.13	2272.13	2272.13	4.0
2019-07-16	B	Futures	49.85	50.44	47.98	48.38	356735.0
2019-07-16	B6	Futures	1.2814	1.2817	1.269	1.2701	101570.0
2019-07-16	BR	Futures	0.2119	0.21198	0.21142	0.21142	212.0
2019-07-16	BTC	Futures	15174.8	15615.8	13242.9	13620.9	8513.0
2019-07-16	BZ	Futures	49.09	49.79	47.4	47.77	41087.0
2019-07-16	C	Futures	1713.0	1741.0	1706.0	1727.0	8077.0
2019-07-16	CB	Futures	288.244	290.578	288.244	289.995	183.0
2019-07-16	CC	Futures	1605.0	1631.0	1593.0	1618.0	21173.0
2019-07-16	CNH	Futures	6.8759	6.8847	6.8731	6.8831	839.0
2019-07-16	CSC	Futures	3.072	3.109	3.065	3.095	112.0
2019-07-16	CT	Futures	62.45	62.59	61.47	61.55	29.0
2019-07-16	DC	Futures	25.76	26.05	25.54	26.01	343.0
2019-07-16	DX	Futures	92.978	93.469	92.95	93.432	21864.0
2019-07-16	E1	Futures	1.18487	1.18557	1.17872	1.17965	18673.0
2019-07-16	E6	Futures	1.23438	1.23471	1.22805	1.22854	150627.0
2019-07-16	E7	Futures	1.2281	1.2286	1.2216	1.2221	3061.0
2019-07-16	EBM	Futures	202.67	203.25	201.52	202.09	14587.0
2019-07-16	ED	Futures	95.3574	95.3671	95.3379	95.3476	283673.0
2019-07-16	ER	Futures	98.524	98.533	98.524	98.529	78451.0
2019-07-16	EW	Futures	2052.3	2060.3	2042.9	2052.9	10635.0
2019-07-16	FBON	Futures	141.87	142.61	141.87	142.36	213.0
2019-07-16	FBTP	Futures	124.6	125.15	124.41	124.85	76574.0
2019-07-16	FBTS	Futures	107.58	107.743	107.561	107.667	62875.0
2019-07-16	FCE	Futures	5076.5	5124.3	5073.3	5112.0	136283.0
2019-07-16	FDAX	Futures	13057.0	13114.4	13007.5	13072.3	98481.0
2019-07-16	FDIV	Futures	146.97	147.16	146.97	147.16	21.0
2019-07-16	FDXM	Futures	12895.1	12952.3	12847.3	12911.3	32114.0
2019-07-16	FESX	Futures	3055.3	3077.2	3047.5	3066.7	796312.0
2019-07-16	FGBL	Futures	163.86	164.19	163.7	163.87	580062.0
2019-07-16	FGBM	Futures	134.31	134.4	134.26	134.32	330955.0
2019-07-16	FGBS	Futures	113.051	113.071	113.041	113.056	144539.0
2019-07-16	FGBX	Futures	206.79	208.02	206.29	206.77	42021.0
2019-07-16	FMWO	Futures	7459.5	7459.5	7428.3	7446.8	3189.0
2019-07-16	FOAT	Futures	151.17	151.57	151.05	151.24	103537.0
2019-07-16	FTDX	Futures	2867.6	2867.6	2852.7	2853.2	63.0
2019-07-16	FTI	Futures	536.53	539.48	535.2	538.87	29477.0
2019-07-16	FTUK	Futures	6899.7	6948.2	6889.6	6934.8	77211.0
2019-07-16	FVSA	Futures	173.74	174.36	168.8	170.65	41471.0
2019-07-16	FXXP	Futures	346.3	348.1	345.7	347.4	39660.0
2019-07-16	G	Futures	120.26	120.53	120.02	120.06	196257.0
2019-07-16	GF	Futures	279.347	279.445	276.306	276.796	3633.0

> showing 50 of 118 rows — these rows as CSV

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