PREVIEW / futures_daily / 2019-12-20

all futures daily files

  file:    by_date/futures_daily/2019/2019-12-20.parquet
  size:    10 KB
  rows:    121

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-12-20	ES	Futures	3470.62	3487.9	3465.22	3483.85	1320006.0
2019-12-20	NQ	Futures	9955.55	10007.46	9939.21	9991.4	307870.0
2019-12-20	YM	Futures	29841.6	29958.1	29801.7	29911.9	146964.0
2019-12-20	CL	Futures	62.65	62.74	61.53	61.96	552517.0
2019-12-20	GC	Futures	1824.1	1826.7	1820.2	1821.9	140768.0
2019-12-20	ZN	Futures	127.065003	127.126948	126.832708	127.111461	806749.0
2019-12-20	A6	Futures	0.70717	0.70952	0.70706	0.70911	63101.0
2019-12-20	AD	Futures	0.76816	0.76826	0.76489	0.7663	70114.0
2019-12-20	ALI	Futures	2191.33	2202.49	2177.46	2188.92	226.0
2019-12-20	B	Futures	53.68	53.81	52.99	53.34	217977.0
2019-12-20	B6	Futures	1.3229	1.3301	1.3198	1.3236	86033.0
2019-12-20	BR	Futures	0.19859	0.19859	0.19778	0.19778	105.0
2019-12-20	BTC	Futures	10773.1	10885.9	10660.2	10878.4	2478.0
2019-12-20	BZ	Futures	52.93	53.09	52.31	52.63	33986.0
2019-12-20	C	Futures	1669.0	1678.0	1659.0	1663.0	10959.0
2019-12-20	CB	Futures	247.365	248.249	247.365	248.219	27.0
2019-12-20	CC	Futures	1592.0	1596.0	1573.0	1581.0	23317.0
2019-12-20	CNH	Futures	6.9779	6.9908	6.9779	6.9797	133.0
2019-12-20	CSC	Futures	3.35	3.381	3.346	3.37	123.0
2019-12-20	CT	Futures	64.28	64.98	63.84	64.64	18094.0
2019-12-20	DC	Futures	27.94	28.22	27.57	28.14	201.0
2019-12-20	DX	Futures	94.143	94.487	94.123	94.414	11728.0
2019-12-20	E1	Futures	1.17524	1.17559	1.16919	1.1701	23277.0
2019-12-20	E6	Futures	1.20517	1.20539	1.19909	1.20011	142684.0
2019-12-20	E7	Futures	1.199	1.199	1.1929	1.1938	2296.0
2019-12-20	EBM	Futures	204.13	204.95	203.85	204.68	10409.0
2019-12-20	ED	Futures	95.2938	95.2986	95.2792	95.2889	172421.0
2019-12-20	ER	Futures	98.377	98.377	98.367	98.367	60087.0
2019-12-20	ESG	Futures	287.33	287.4	287.01	287.01	35.0
2019-12-20	EW	Futures	2167.2	2183.7	2164.6	2176.9	12864.0
2019-12-20	FBON	Futures	142.88	143.0	142.7	142.93	70.0
2019-12-20	FBTP	Futures	127.95	128.13	127.26	127.73	54551.0
2019-12-20	FBTS	Futures	108.134	108.153	107.97	108.066	30314.0
2019-12-20	FCE	Futures	5404.1	5450.3	5395.1	5444.4	99468.0
2019-12-20	FDAX	Futures	14002.6	14092.5	13953.5	14075.6	110113.0
2019-12-20	FDIV	Futures	160.84	161.22	160.84	161.22	60.0
2019-12-20	FDXM	Futures	13819.6	13915.6	13778.8	13898.9	50590.0
2019-12-20	FESX	Futures	3288.9	3318.9	3281.9	3312.7	1218488.0
2019-12-20	FEU3	Futures	99.06	99.075	99.06	99.075	4.0
2019-12-20	FGBL	Futures	163.58	163.93	163.39	163.85	314511.0
2019-12-20	FGBM	Futures	133.47	133.59	133.42	133.56	198072.0
2019-12-20	FGBS	Futures	112.679	112.689	112.659	112.684	125051.0
2019-12-20	FGBX	Futures	210.29	211.16	209.64	210.77	27866.0
2019-12-20	FMWO	Futures	7813.4	7853.1	7813.4	7847.4	2271.0
2019-12-20	FOAT	Futures	151.2	151.43	151.0	151.39	52327.0
2019-12-20	FTDX	Futures	3065.0	3076.5	3061.9	3068.5	203.0
2019-12-20	FTI	Futures	581.17	584.62	579.49	584.01	31637.0
2019-12-20	FTUK	Futures	7065.3	7086.4	7040.9	7055.0	125308.0
2019-12-20	FVSA	Futures	125.51	127.85	123.64	124.11	20411.0
2019-12-20	FXXP	Futures	376.9	380.4	376.8	379.9	64818.0

> showing 50 of 121 rows — these rows as CSV

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