PREVIEW / futures_daily / 2023-07-27

all futures daily files

  file:    by_date/futures_daily/2023/2023-07-27.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-07-27	ES	Futures	4975.89	5018.93	4931.49	4942.86	1924565.0
2023-07-27	NQ	Futures	17111.48	17401.71	16971.98	17037.35	846437.0
2023-07-27	YM	Futures	37871.4	38092.5	37564.3	37654.6	188130.0
2023-07-27	CL	Futures	68.36	69.83	68.33	69.39	374358.0
2023-07-27	GC	Futures	2166.9	2177.2	2133.1	2137.4	189848.0
2023-07-27	ZN	Futures	113.946961	114.217316	112.929151	112.992764	2217996.0
2023-07-27	A6	Futures	0.68585	0.69218	0.67967	0.68023	114687.0
2023-07-27	AD	Futures	0.76578	0.76845	0.7635	0.76421	75305.0
2023-07-27	ALI	Futures	2472.01	2497.16	2445.74	2452.45	681.0
2023-07-27	B	Futures	73.26	74.42	73.09	74.15	354644.0
2023-07-27	B6	Futures	1.297	1.3022	1.2809	1.2827	130099.0
2023-07-27	BFX	Futures	4192.7	4192.7	4192.7	4192.7	0.0
2023-07-27	BR	Futures	0.19581	0.19669	0.19464	0.19511	23183.0
2023-07-27	BTC	Futures	39381.4	39527.1	38646.2	38825.1	7289.0
2023-07-27	BZ	Futures	72.95	74.2	72.87	73.92	25814.0
2023-07-27	C	Futures	2241.0	2270.0	2239.0	2246.0	11541.0
2023-07-27	CB	Futures	254.309	256.952	254.309	256.761	120.0
2023-07-27	CC	Futures	2076.0	2088.0	2030.0	2046.0	23786.0
2023-07-27	CNH	Futures	6.8445	6.8793	6.8215	6.8725	1129.0
2023-07-27	CSC	Futures	1.981	1.983	1.953	1.964	142.0
2023-07-27	CT	Futures	111.87	111.87	107.47	107.96	69.0
2023-07-27	DC	Futures	18.24	18.28	17.96	18.06	404.0
2023-07-27	DX	Futures	98.934	99.689	98.419	99.62	24611.0
2023-07-27	E1	Futures	1.23932	1.24706	1.22606	1.22675	27401.0
2023-07-27	E6	Futures	1.13757	1.14381	1.12498	1.1257	330420.0
2023-07-27	E7	Futures	1.1376	1.1439	1.125	1.1257	8969.0
2023-07-27	EBM	Futures	377.46	378.93	366.85	368.31	19144.0
2023-07-27	ER	Futures	97.838	97.899	97.838	97.863	251595.0
2023-07-27	ESG	Futures	434.18	435.62	428.1	428.82	518.0
2023-07-27	EW	Futures	2894.7	2926.0	2857.1	2864.5	14245.0
2023-07-27	FBON	Futures	122.27	122.58	122.17	122.17	13.0
2023-07-27	FBTP	Futures	114.41	114.85	113.83	114.18	198546.0
2023-07-27	FBTS	Futures	106.148	106.27	105.987	106.159	124854.0
2023-07-27	FCE	Futures	7973.3	8122.1	7957.6	8096.1	73817.0
2023-07-27	FDAX	Futures	17167.4	17500.8	17163.1	17456.4	75782.0
2023-07-27	FDIV	Futures	189.24	190.77	189.24	190.77	40.0
2023-07-27	FDXM	Futures	17244.0	17571.4	17233.4	17527.8	52256.0
2023-07-27	FDXS	Futures	17129.3	17459.9	17123.0	17415.5	24792.0
2023-07-27	FESX	Futures	4429.9	4539.4	4429.9	4527.2	1185120.0
2023-07-27	FEU3	Futures	97.863	97.863	97.863	97.863	0.0
2023-07-27	FGBL	Futures	134.81	135.6	134.0	134.66	898756.0
2023-07-27	FGBM	Futures	118.35	118.83	118.17	118.4	673747.0
2023-07-27	FGBS	Futures	107.32	107.514	107.299	107.371	780264.0
2023-07-27	FGBX	Futures	139.35	141.07	136.99	138.57	99101.0
2023-07-27	FMWO	Futures	10687.6	10748.0	10566.8	10698.8	7842.0
2023-07-27	FOAT	Futures	125.94	126.76	125.05	125.88	145470.0
2023-07-27	FSMX	Futures	29737.8	30170.5	29737.8	30045.7	176.0
2023-07-27	FTDX	Futures	3433.4	3535.6	3433.4	3510.3	91.0
2023-07-27	FTI	Futures	813.84	831.83	813.84	830.37	21649.0
2023-07-27	FTUK	Futures	7790.2	7823.7	7768.3	7817.1	95546.0

> showing 50 of 130 rows — these rows as CSV

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