PREVIEW / futures_daily / 2022-07-27

all futures daily files

  file:    by_date/futures_daily/2022/2022-07-27.parquet
  size:    10 KB
  rows:    127

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
2022-07-27	ES	Futures	4419.08	4535.19	4418.52	4514.71	1740431.0
2022-07-27	NQ	Futures	13921.61	14490.26	13921.33	14409.19	634889.0
2022-07-27	YM	Futures	34727.4	35332.0	34726.3	35175.7	210158.0
2022-07-27	CL	Futures	81.05	83.59	79.95	82.46	321903.0
2022-07-27	GC	Futures	1983.4	2012.1	1976.4	1988.4	116708.0
2022-07-27	ZN	Futures	123.097713	123.884947	122.985251	123.820683	1309166.0
2022-07-27	A6	Futures	0.71111	0.71895	0.70855	0.717	101481.0
2022-07-27	AD	Futures	0.78724	0.79181	0.78547	0.79003	90754.0
2022-07-27	ALI	Futures	2744.66	2744.66	2678.85	2724.69	1957.0
2022-07-27	B	Futures	84.64	87.23	83.81	86.2	254560.0
2022-07-27	B6	Futures	1.2223	1.238	1.2211	1.2356	103542.0
2022-07-27	BR	Futures	0.16078	0.1643	0.16035	0.16378	19933.0
2022-07-27	BTC	Futures	29014.9	31964.8	29014.9	31515.8	6806.0
2022-07-27	BZ	Futures	82.76	85.29	81.98	84.34	20757.0
2022-07-27	C	Futures	1326.0	1326.0	1297.0	1305.0	7234.0
2022-07-27	CB	Futures	225.218	228.421	225.218	225.843	38.0
2022-07-27	CC	Futures	1433.0	1441.0	1398.0	1408.0	24579.0
2022-07-27	CNH	Futures	6.3811	6.3818	6.3545	6.3581	446.0
2022-07-27	CSC	Futures	2.85	2.85	2.741	2.751	157.0
2022-07-27	CT	Futures	126.58	128.68	125.45	126.56	36.0
2022-07-27	DC	Futures	26.95	27.04	26.02	26.18	385.0
2022-07-27	DX	Futures	103.238	103.508	102.379	102.573	48129.0
2022-07-27	E1	Futures	1.15284	1.15942	1.14942	1.15765	31908.0
2022-07-27	E6	Futures	1.0683	1.07903	1.06599	1.07661	236999.0
2022-07-27	E7	Futures	1.062	1.0725	1.0596	1.0702	8369.0
2022-07-27	EBM	Futures	485.84	493.2	473.22	476.72	13480.0
2022-07-27	ED	Futures	94.9464	95.0152	94.9267	95.0004	177868.0
2022-07-27	ER	Futures	98.198	98.203	98.139	98.193	109840.0
2022-07-27	ESG	Futures	384.14	391.0	382.64	389.74	532.0
2022-07-27	EW	Futures	2609.5	2671.1	2609.5	2660.7	9831.0
2022-07-27	FBON	Futures	132.42	132.71	132.2	132.71	146.0
2022-07-27	FBTP	Futures	115.4	115.46	114.43	115.11	123833.0
2022-07-27	FBTS	Futures	107.04	107.05	106.823	106.931	53219.0
2022-07-27	FCE	Futures	6807.5	6918.9	6804.2	6868.4	47807.0
2022-07-27	FDAX	Futures	14156.7	14261.1	14077.1	14165.3	51632.0
2022-07-27	FDIV	Futures	155.7	156.04	155.7	156.04	1.0
2022-07-27	FDXM	Futures	14231.3	14348.2	14162.0	14251.9	31010.0
2022-07-27	FDXS	Futures	14091.7	14231.3	14047.7	14135.8	29145.0
2022-07-27	FESX	Futures	3553.8	3604.3	3543.8	3576.6	675029.0
2022-07-27	FGBL	Futures	153.76	154.19	153.33	154.12	645606.0
2022-07-27	FGBM	Futures	128.94	129.07	128.61	128.99	449165.0
2022-07-27	FGBS	Futures	111.745	111.771	111.522	111.684	502274.0
2022-07-27	FGBX	Futures	183.41	184.46	182.33	184.21	47956.0
2022-07-27	FMWO	Futures	9460.7	9642.2	9450.1	9494.6	6009.0
2022-07-27	FOAT	Futures	140.72	141.11	140.26	140.93	135702.0
2022-07-27	FSMX	Futures	27925.4	28334.9	27867.7	28286.8	203.0
2022-07-27	FTDX	Futures	3211.6	3253.3	3200.3	3248.0	45.0
2022-07-27	FTI	Futures	716.09	724.96	715.13	718.95	15881.0
2022-07-27	FTUK	Futures	7355.0	7439.6	7353.0	7404.2	76146.0
2022-07-27	FVSA	Futures	76.7	76.7	73.76	74.04	15780.0

> showing 50 of 127 rows — these rows as CSV

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