PREVIEW / futures_daily / 2020-04-13

all futures daily files

  file:    by_date/futures_daily/2020/2020-04-13.parquet
  size:    9 KB
  rows:    93

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
2020-04-13	ES	Futures	3110.33	3119.74	2999.68	3053.07	1571402.0
2020-04-13	NQ	Futures	9510.87	9559.88	9255.5	9546.69	385072.0
2020-04-13	YM	Futures	25437.5	25514.3	24508.1	24871.9	159039.0
2020-04-13	CL	Futures	22.56	22.76	21.04	21.78	399067.0
2020-04-13	GC	Futures	2112.9	2149.9	2091.0	2136.1	166890.0
2020-04-13	ZN	Futures	136.404603	136.667009	136.219375	136.404603	596558.0
2020-04-13	A6	Futures	0.65319	0.65874	0.6499	0.65781	48128.0
2020-04-13	AD	Futures	0.72749	0.7321	0.72435	0.73113	38264.0
2020-04-13	ALI	Futures	1796.17	1796.17	1796.17	1796.17	0.0
2020-04-13	B	Futures	26.04	26.04	23.46	24.31	223294.0
2020-04-13	B6	Futures	1.265	1.2734	1.2649	1.2726	33285.0
2020-04-13	BR	Futures	0.15972	0.16001	0.15702	0.15796	45.0
2020-04-13	BTC	Futures	10156.4	10156.4	9298.3	9660.0	5395.0
2020-04-13	BZ	Futures	24.52	24.69	22.77	23.59	28098.0
2020-04-13	CB	Futures	154.194	154.194	154.194	154.194	16.0
2020-04-13	CC	Futures	1510.0	1520.0	1476.0	1485.0	13852.0
2020-04-13	CNH	Futures	6.9858	6.9964	6.9847	6.9897	163.0
2020-04-13	CSC	Futures	2.541	2.549	2.422	2.422	81.0
2020-04-13	CT	Futures	52.31	52.52	50.4	50.8	16617.0
2020-04-13	DC	Futures	20.45	20.56	19.2	19.29	604.0
2020-04-13	DX	Futures	96.209	96.349	95.837	96.055	9026.0
2020-04-13	E1	Futures	1.18351	1.18522	1.17804	1.18123	10014.0
2020-04-13	E6	Futures	1.17757	1.18079	1.17279	1.17606	72771.0
2020-04-13	E7	Futures	1.1715	1.1746	1.1667	1.17	2831.0
2020-04-13	ED	Futures	96.1502	96.1889	96.1406	96.1793	147696.0
2020-04-13	ER	Futures	98.22	98.22	98.22	98.22	0.0
2020-04-13	ESG	Futures	247.84	249.39	246.01	248.69	57.0
2020-04-13	EW	Futures	1690.0	1690.0	1606.4	1624.9	11322.0
2020-04-13	GF	Futures	240.655	240.655	237.644	237.644	1614.0
2020-04-13	GSCI	Futures	362.4	362.4	305.75	305.75	1275.0
2020-04-13	HE	Futures	28.656	29.119	28.246	28.246	258.0
2020-04-13	HG	Futures	2.5969	2.6556	2.5551	2.5991	56786.0
2020-04-13	HH	Futures	10.218	10.322	9.876	9.969	730.0
2020-04-13	HO	Futures	0.7016	0.7066	0.6522	0.6871	33892.0
2020-04-13	HRC	Futures	1328.3	1336.0	1328.3	1330.8	25.0
2020-04-13	J1	Futures	0.0106923	0.0107837	0.0106808	0.0107826	57955.0
2020-04-13	J7	Futures	0.010655	0.010749	0.010647	0.010748	749.0
2020-04-13	JB	Futures	139.76	140.05	139.64	139.66	248.0
2020-04-13	KC	Futures	113.41	114.99	111.17	114.18	14231.0
2020-04-13	KE	Futures	680.21	689.14	673.35	678.16	30623.0
2020-04-13	KRW	Futures	0.000807	0.0008094	0.000807	0.0008092	10.0
2020-04-13	LBS	Futures	493.3	506.3	487.1	504.8	186.0
2020-04-13	LE	Futures	120.859	121.602	120.859	120.859	4458.0
2020-04-13	M2K	Futures	1376.7	1387.7	1307.2	1325.2	94288.0
2020-04-13	MES	Futures	3034.42	3049.01	2929.83	2982.8	800021.0
2020-04-13	MFS	Futures	1606.5	1620.3	1592.9	1606.5	23612.0
2020-04-13	MGC	Futures	2050.1	2086.8	2029.3	2073.4	75881.0
2020-04-13	MME	Futures	894.9	894.9	862.8	882.0	51300.0
2020-04-13	MNQ	Futures	9403.69	9473.86	9175.3	9461.93	442775.0
2020-04-13	MP	Futures	0.03231	0.03231	0.03147	0.03178	28775.0

> showing 50 of 93 rows — these rows as CSV

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