PREVIEW / futures_daily / 2023-09-20

all futures daily files

  file:    by_date/futures_daily/2023/2023-09-20.parquet
  size:    10 KB
  rows:    130

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
2023-09-20	ES	Futures	4807.32	4825.25	4755.95	4759.96	1482206.0
2023-09-20	NQ	Futures	16593.28	16659.11	16325.36	16352.34	605256.0
2023-09-20	YM	Futures	36637.9	36919.9	36535.8	36547.4	178631.0
2023-09-20	CL	Futures	79.91	80.3	78.44	79.05	457854.0
2023-09-20	GC	Futures	2102.8	2119.9	2098.0	2117.9	220980.0
2023-09-20	ZN	Futures	110.705985	111.054516	110.246559	110.73767	1641379.0
2023-09-20	A6	Futures	0.65264	0.65834	0.65113	0.65431	120200.0
2023-09-20	AD	Futures	0.75055	0.75347	0.74888	0.7511	91090.0
2023-09-20	ALI	Futures	2447.2	2494.27	2441.97	2489.87	3037.0
2023-09-20	B	Futures	84.22	84.42	82.68	83.36	330592.0
2023-09-20	B6	Futures	1.2396	1.2429	1.2337	1.2367	153313.0
2023-09-20	BFX	Futures	4030.4	4030.4	4030.4	4030.4	0.0
2023-09-20	BR	Futures	0.19195	0.19265	0.19185	0.19185	22.0
2023-09-20	BTC	Futures	36294.8	36601.4	35788.2	35981.5	5569.0
2023-09-20	BZ	Futures	84.01	84.23	82.48	83.16	43515.0
2023-09-20	C	Futures	2539.0	2542.0	2458.0	2480.0	11102.0
2023-09-20	CB	Futures	263.49	263.986	262.005	262.005	39.0
2023-09-20	CC	Futures	2108.0	2115.0	2074.0	2083.0	25702.0
2023-09-20	CNH	Futures	7.0524	7.0639	7.0357	7.0466	496.0
2023-09-20	CSC	Futures	2.061	2.068	2.034	2.055	134.0
2023-09-20	CT	Futures	106.85	106.85	106.38	106.4	6.0
2023-09-20	DC	Futures	19.27	19.37	19.02	19.05	406.0
2023-09-20	DX	Futures	103.371	103.701	102.932	103.369	15432.0
2023-09-20	E1	Futures	1.17953	1.18552	1.17707	1.18064	25448.0
2023-09-20	E6	Futures	1.09042	1.09657	1.08762	1.09133	210334.0
2023-09-20	E7	Futures	1.0908	1.0968	1.0879	1.0916	4766.0
2023-09-20	EBM	Futures	328.31	331.05	325.57	327.28	50591.0
2023-09-20	ER	Futures	97.736	97.756	97.736	97.751	111714.0
2023-09-20	ESG	Futures	415.83	416.85	410.99	411.13	1089.0
2023-09-20	EW	Futures	2705.7	2729.8	2685.6	2688.0	10395.0
2023-09-20	FBON	Futures	119.19	119.59	119.16	119.53	502.0
2023-09-20	FBTP	Futures	110.75	111.28	110.66	111.18	128997.0
2023-09-20	FBTS	Futures	105.521	105.663	105.521	105.643	90668.0
2023-09-20	FCE	Futures	7860.6	7943.5	7854.1	7920.3	52247.0
2023-09-20	FDAX	Futures	16674.2	16817.4	16652.0	16781.6	52191.0
2023-09-20	FDIV	Futures	183.17	183.37	183.02	183.37	21.0
2023-09-20	FDXM	Futures	16670.8	16810.8	16645.5	16775.0	36088.0
2023-09-20	FDXS	Futures	16556.6	16701.0	16536.8	16665.5	18374.0
2023-09-20	FESX	Futures	4304.3	4349.6	4297.2	4337.5	654540.0
2023-09-20	FEU3	Futures	97.746	97.746	97.746	97.746	0.0
2023-09-20	FGBL	Futures	131.52	132.13	131.45	132.05	659883.0
2023-09-20	FGBM	Futures	117.04	117.33	117.0	117.28	509033.0
2023-09-20	FGBS	Futures	106.861	106.963	106.861	106.938	436396.0
2023-09-20	FGBX	Futures	129.01	130.41	128.93	130.02	69859.0
2023-09-20	FMWO	Futures	10248.9	10308.5	10178.3	10290.8	5153.0
2023-09-20	FOAT	Futures	122.77	123.47	122.73	123.38	148531.0
2023-09-20	FSMX	Futures	27985.3	28297.6	27985.3	28209.2	131.0
2023-09-20	FTDX	Futures	3182.8	3223.3	3182.8	3217.0	13.0
2023-09-20	FTI	Futures	764.39	771.35	764.39	768.79	11385.0
2023-09-20	FTUK	Futures	7781.0	7858.1	7751.8	7852.1	91789.0

> showing 50 of 130 rows — these rows as CSV

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