PREVIEW / futures_daily / 2019-08-12

all futures daily files

  file:    by_date/futures_daily/2019/2019-08-12.parquet
  size:    10 KB
  rows:    119

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-12	ES	Futures	3149.5	3162.72	3099.59	3107.95	1710875.0
2019-08-12	NQ	Futures	8812.82	8876.71	8674.94	8711.79	552715.0
2019-08-12	YM	Futures	27576.8	27671.3	27093.8	27161.0	215254.0
2019-08-12	CL	Futures	55.43	56.31	54.63	56.05	611027.0
2019-08-12	GC	Futures	1861.7	1889.2	1848.6	1871.5	355101.0
2019-08-12	ZN	Futures	129.073402	129.851047	129.011191	129.773282	1147618.0
2019-08-12	A6	Futures	0.69853	0.70007	0.69473	0.69565	70985.0
2019-08-12	AD	Futures	0.76353	0.76393	0.76116	0.76161	46994.0
2019-08-12	ALI	Futures	2200.06	2204.64	2175.93	2178.68	240.0
2019-08-12	B	Futures	43.98	44.42	43.66	44.18	221349.0
2019-08-12	B6	Futures	1.231	1.2377	1.2282	1.2348	86722.0
2019-08-12	BR	Futures	0.20215	0.20215	0.19868	0.2002	9519.0
2019-08-12	BTC	Futures	16074.5	16102.0	15613.2	15916.1	1834.0
2019-08-12	BZ	Futures	43.46	43.84	43.1	43.61	30960.0
2019-08-12	C	Futures	1633.0	1644.0	1616.0	1618.0	6549.0
2019-08-12	CB	Futures	275.699	275.699	275.699	275.699	3.0
2019-08-12	CC	Futures	1479.0	1496.0	1471.0	1473.0	25927.0
2019-08-12	CNH	Futures	7.102	7.1168	7.0949	7.1078	638.0
2019-08-12	CSC	Futures	3.12	3.127	3.099	3.102	47.0
2019-08-12	CT	Futures	58.19	58.19	57.04	57.31	52.0
2019-08-12	DC	Futures	26.27	26.36	25.98	26.1	352.0
2019-08-12	DX	Futures	93.749	93.922	93.518	93.583	13129.0
2019-08-12	E1	Futures	1.19589	1.20169	1.19264	1.20087	22661.0
2019-08-12	E6	Futures	1.22505	1.22844	1.22091	1.2274	134930.0
2019-08-12	E7	Futures	1.2188	1.222	1.2145	1.221	3290.0
2019-08-12	EBM	Futures	195.76	196.91	192.02	192.59	22527.0
2019-08-12	ED	Futures	95.4061	95.4304	95.3963	95.4255	191604.0
2019-08-12	ER	Futures	98.553	98.553	98.543	98.548	73993.0
2019-08-12	EW	Futures	1996.0	2005.3	1962.8	1966.8	10138.0
2019-08-12	FBON	Futures	145.08	145.23	145.05	145.11	170.0
2019-08-12	FBTP	Futures	123.73	124.25	123.38	123.94	91838.0
2019-08-12	FBTS	Futures	107.053	107.149	106.823	106.938	80042.0
2019-08-12	FCE	Futures	4852.4	4877.3	4785.3	4807.5	98739.0
2019-08-12	FDAX	Futures	12336.3	12456.8	12222.5	12299.4	95311.0
2019-08-12	FDIV	Futures	140.85	140.85	140.52	140.62	31.0
2019-08-12	FDXM	Futures	12174.4	12303.4	12070.4	12147.9	48195.0
2019-08-12	FESX	Futures	2912.1	2940.9	2885.9	2903.4	780487.0
2019-08-12	FGBL	Futures	168.44	168.95	168.33	168.72	340323.0
2019-08-12	FGBM	Futures	135.68	135.8	135.66	135.74	217648.0
2019-08-12	FGBS	Futures	113.313	113.348	113.303	113.333	254999.0
2019-08-12	FGBX	Futures	223.73	226.37	223.44	225.19	32772.0
2019-08-12	FMWO	Futures	7202.1	7213.7	7111.0	7132.9	1005.0
2019-08-12	FOAT	Futures	154.62	154.88	154.58	154.77	77862.0
2019-08-12	FTDX	Futures	2776.7	2776.7	2715.0	2719.5	136.0
2019-08-12	FTI	Futures	513.64	517.05	509.57	511.38	8470.0
2019-08-12	FTUK	Futures	6690.1	6710.9	6614.4	6647.7	83358.0
2019-08-12	FVSA	Futures	220.73	233.27	215.72	227.0	22498.0
2019-08-12	FXXP	Futures	333.5	335.7	328.4	331.4	49710.0
2019-08-12	G	Futures	123.45	123.64	123.3	123.53	119275.0
2019-08-12	GF	Futures	272.577	272.577	272.577	272.577	2381.0

> showing 50 of 119 rows — these rows as CSV

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