PREVIEW / futures_daily / 2021-10-04

all futures daily files

  file:    by_date/futures_daily/2021/2021-10-04.parquet
  size:    10 KB
  rows:    124

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
2021-10-04	ES	Futures	4892.15	4906.78	4800.48	4827.19	2135338.0
2021-10-04	NQ	Futures	17049.26	17106.91	16568.11	16677.08	802849.0
2021-10-04	YM	Futures	37243.4	37311.9	36646.0	36851.7	240260.0
2021-10-04	CL	Futures	55.89	57.72	55.46	57.16	458006.0
2021-10-04	GC	Futures	2056.3	2066.7	2039.0	2062.2	166180.0
2021-10-04	ZN	Futures	134.432928	134.51238	134.099229	134.321695	1471686.0
2021-10-04	A6	Futures	0.74465	0.74901	0.74347	0.74757	84377.0
2021-10-04	AD	Futures	0.80298	0.80841	0.80217	0.80689	80149.0
2021-10-04	ALI	Futures	3277.34	3336.77	3277.34	3319.03	1655.0
2021-10-04	B	Futures	53.85	55.55	53.35	55.05	362369.0
2021-10-04	B6	Futures	1.3751	1.3847	1.3737	1.382	110790.0
2021-10-04	BR	Futures	0.14987	0.14987	0.14739	0.14776	54.0
2021-10-04	BTC	Futures	63915.4	66481.6	62732.0	66288.8	5865.0
2021-10-04	BZ	Futures	52.51	54.26	52.12	53.77	43286.0
2021-10-04	C	Futures	1629.0	1660.0	1628.0	1641.0	10965.0
2021-10-04	CB	Futures	139.475	139.475	138.687	138.707	50.0
2021-10-04	CC	Futures	1741.0	1793.0	1737.0	1767.0	25174.0
2021-10-04	CNH	Futures	6.1894	6.2133	6.1894	6.2075	137.0
2021-10-04	CSC	Futures	2.505	2.506	2.505	2.506	20.0
2021-10-04	CT	Futures	97.55	99.74	96.67	97.93	15950.0
2021-10-04	DC	Futures	23.06	23.25	23.06	23.22	176.0
2021-10-04	DX	Futures	90.912	90.931	90.516	90.612	24714.0
2021-10-04	E1	Futures	1.20656	1.21552	1.20488	1.2134	25676.0
2021-10-04	E6	Futures	1.23348	1.23842	1.23284	1.23672	142002.0
2021-10-04	E7	Futures	1.2261	1.2317	1.2261	1.2299	3171.0
2021-10-04	EBM	Futures	389.44	391.64	386.87	389.81	28405.0
2021-10-04	ED	Futures	96.5586	96.5634	96.5537	96.5634	121220.0
2021-10-04	ER	Futures	98.48	98.48	98.475	98.48	24778.0
2021-10-04	ESG	Futures	400.52	403.23	396.64	398.55	1298.0
2021-10-04	EW	Futures	2888.2	2894.9	2851.8	2863.3	15014.0
2021-10-04	FBON	Futures	149.24	149.31	148.97	149.1	1283.0
2021-10-04	FBTP	Futures	138.93	138.94	138.43	138.69	107205.0
2021-10-04	FBTS	Futures	110.429	110.429	110.371	110.4	41327.0
2021-10-04	FCE	Futures	6520.4	6554.5	6463.8	6489.9	59741.0
2021-10-04	FDAX	Futures	16299.9	16299.9	16027.3	16059.4	84205.0
2021-10-04	FDIV	Futures	180.93	181.81	180.78	181.37	62.0
2021-10-04	FDXM	Futures	16340.9	16345.2	16071.9	16105.1	60250.0
2021-10-04	FDXS	Futures	16182.8	16182.8	15929.0	15955.6	22999.0
2021-10-04	FESX	Futures	3871.2	3876.0	3807.6	3814.7	719336.0
2021-10-04	FGBL	Futures	167.93	168.03	167.41	167.6	604568.0
2021-10-04	FGBM	Futures	134.9	134.91	134.72	134.78	340655.0
2021-10-04	FGBS	Futures	112.669	112.674	112.644	112.669	181449.0
2021-10-04	FGBX	Futures	220.71	221.08	219.07	219.77	59038.0
2021-10-04	FMWO	Futures	10668.3	10734.3	10570.4	10591.6	4253.0
2021-10-04	FOAT	Futures	155.44	155.59	154.98	155.12	140493.0
2021-10-04	FTDX	Futures	3757.4	3761.0	3709.6	3714.3	81.0
2021-10-04	FTI	Futures	730.38	731.19	721.88	722.7	21138.0
2021-10-04	FTUK	Futures	6974.1	6974.1	6885.3	6900.6	91462.0
2021-10-04	FVSA	Futures	85.47	92.42	85.28	90.54	38353.0
2021-10-04	FXXP	Futures	432.9	432.9	427.4	428.5	63509.0

> showing 50 of 124 rows — these rows as CSV

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