PREVIEW / futures_daily / 2023-09-01

all futures daily files

  file:    by_date/futures_daily/2023/2023-09-01.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-01	ES	Futures	4891.42	4924.99	4881.13	4896.56	1416762.0
2023-09-01	NQ	Futures	16996.87	17136.1	16909.33	16977.45	572689.0
2023-09-01	YM	Futures	36991.5	37225.3	36942.6	37071.2	144441.0
2023-09-01	CL	Futures	73.1	75.22	72.95	74.77	420461.0
2023-09-01	GC	Futures	2117.2	2132.1	2111.1	2117.9	160725.0
2023-09-01	ZN	Futures	112.43615	112.929151	111.895438	112.118084	33863.0
2023-09-01	A6	Futures	0.65729	0.66103	0.65253	0.65384	127812.0
2023-09-01	AD	Futures	0.74799	0.74925	0.74238	0.74314	97897.0
2023-09-01	ALI	Futures	2423.77	2481.11	2420.46	2448.31	4930.0
2023-09-01	B	Futures	77.38	79.32	77.31	78.92	380759.0
2023-09-01	B6	Futures	1.2696	1.2737	1.26	1.2616	98569.0
2023-09-01	BFX	Futures	4042.7	4042.7	4042.7	4042.7	0.0
2023-09-01	BR	Futures	0.18851	0.18851	0.18851	0.18851	0.0
2023-09-01	BTC	Futures	34755.0	34961.7	33861.8	34261.8	6918.0
2023-09-01	BZ	Futures	77.2	79.1	77.13	78.74	33224.0
2023-09-01	C	Futures	2469.0	2476.0	2429.0	2433.0	2181.0
2023-09-01	CB	Futures	259.875	259.875	258.513	258.562	27.0
2023-09-01	CC	Futures	2122.0	2141.0	2094.0	2103.0	22949.0
2023-09-01	CNH	Futures	6.9949	6.9986	6.966	6.9959	468.0
2023-09-01	CSC	Futures	2.125	2.125	2.125	2.125	2.0
2023-09-01	CT	Futures	110.67	112.35	110.18	111.69	42.0
2023-09-01	DC	Futures	20.04	20.12	19.84	19.84	38.0
2023-09-01	DX	Futures	101.622	102.279	101.259	102.216	19162.0
2023-09-01	E1	Futures	1.20272	1.20797	1.19853	1.19997	17476.0
2023-09-01	E6	Futures	1.1104	1.11439	1.10308	1.1038	222120.0
2023-09-01	E7	Futures	1.1105	1.1144	1.1031	1.1038	4203.0
2023-09-01	EBM	Futures	328.4	329.87	323.65	324.01	5879.0
2023-09-01	ER	Futures	97.894	97.919	97.883	97.904	315229.0
2023-09-01	ESG	Futures	425.02	428.07	424.51	425.81	881.0
2023-09-01	EW	Futures	2800.9	2831.8	2799.8	2825.3	9552.0
2023-09-01	FBON	Futures	122.4	122.5	121.13	121.51	591.0
2023-09-01	FBTP	Futures	114.0	114.07	112.91	113.12	333130.0
2023-09-01	FBTS	Futures	106.34	106.34	106.047	106.189	201116.0
2023-09-01	FCE	Futures	7938.7	7972.2	7892.2	7904.6	51554.0
2023-09-01	FDAX	Futures	16920.7	16970.5	16774.7	16799.0	55213.0
2023-09-01	FDIV	Futures	182.86	182.86	182.86	182.86	0.0
2023-09-01	FDXM	Futures	16995.3	17040.0	16843.3	16867.8	39688.0
2023-09-01	FDXS	Futures	16893.8	16929.7	16735.4	16759.7	19914.0
2023-09-01	FESX	Futures	4360.0	4383.3	4337.8	4345.9	703025.0
2023-09-01	FEU3	Futures	97.899	97.899	97.899	97.899	0.0
2023-09-01	FGBL	Futures	134.74	135.01	133.84	134.04	1145922.0
2023-09-01	FGBM	Futures	118.77	118.92	118.44	118.53	1286475.0
2023-09-01	FGBS	Futures	107.555	107.606	107.468	107.509	1376243.0
2023-09-01	FGBX	Futures	136.68	137.05	134.4	134.81	172175.0
2023-09-01	FMWO	Futures	10413.6	10471.8	10385.7	10395.7	9474.0
2023-09-01	FOAT	Futures	126.01	126.3	125.13	125.35	258641.0
2023-09-01	FSMX	Futures	29156.4	29156.4	28799.6	28929.6	60.0
2023-09-01	FTDX	Futures	3326.5	3350.2	3326.5	3333.4	37.0
2023-09-01	FTI	Futures	778.17	783.38	776.03	779.22	14229.0
2023-09-01	FTUK	Futures	7572.2	7629.1	7564.1	7602.7	83678.0

> showing 50 of 130 rows — these rows as CSV

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