PREVIEW / futures_daily / 2023-07-17

all futures daily files

  file:    by_date/futures_daily/2023/2023-07-17.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-17	ES	Futures	4912.26	4944.48	4903.6	4931.49	1057965.0
2023-07-17	NQ	Futures	17167.56	17378.46	17136.37	17332.5	522129.0
2023-07-17	YM	Futures	36821.4	37037.2	36750.2	36944.7	117302.0
2023-07-17	CL	Futures	64.87	65.84	63.92	64.18	248258.0
2023-07-17	GC	Futures	2153.1	2158.6	2142.6	2150.7	165833.0
2023-07-17	ZN	Futures	114.439962	114.932964	114.408156	114.726221	910140.0
2023-07-17	A6	Futures	0.69401	0.69426	0.68894	0.69254	65703.0
2023-07-17	AD	Futures	0.76471	0.76835	0.76421	0.76709	56325.0
2023-07-17	ALI	Futures	2511.69	2519.79	2497.72	2513.65	620.0
2023-07-17	B	Futures	69.53	70.65	68.55	68.77	341159.0
2023-07-17	B6	Futures	1.3121	1.3135	1.3077	1.3108	71593.0
2023-07-17	BFX	Futures	4067.3	4067.3	4067.3	4067.3	0.0
2023-07-17	BR	Futures	0.19222	0.19268	0.19063	0.19226	249.0
2023-07-17	BTC	Futures	40794.3	40901.6	39889.0	40224.3	6236.0
2023-07-17	BZ	Futures	69.48	70.51	68.44	68.65	29152.0
2023-07-17	C	Futures	2087.0	2111.0	2085.0	2105.0	6464.0
2023-07-17	CB	Futures	239.76	241.212	239.76	240.498	63.0
2023-07-17	CC	Futures	1943.0	1956.0	1927.0	1947.0	18464.0
2023-07-17	CNH	Futures	6.8531	6.8845	6.8461	6.8737	548.0
2023-07-17	CSC	Futures	1.801	1.839	1.791	1.815	102.0
2023-07-17	CT	Futures	102.54	104.06	102.54	104.06	3.0
2023-07-17	DC	Futures	16.49	16.95	16.49	16.77	164.0
2023-07-17	DX	Futures	97.776	97.972	97.565	97.643	14607.0
2023-07-17	E1	Futures	1.23879	1.24478	1.23731	1.24171	18889.0
2023-07-17	E6	Futures	1.15287	1.15481	1.15015	1.15414	145947.0
2023-07-17	E7	Futures	1.1526	1.1548	1.1503	1.1542	3473.0
2023-07-17	EBM	Futures	344.15	348.54	339.02	340.12	36055.0
2023-07-17	ER	Futures	97.792	97.792	97.782	97.792	54369.0
2023-07-17	ESG	Futures	425.76	428.5	425.38	427.61	315.0
2023-07-17	EW	Futures	2844.1	2870.9	2834.7	2864.4	7001.0
2023-07-17	FBON	Futures	121.89	122.52	121.85	121.85	46.0
2023-07-17	FBTP	Futures	113.57	113.74	113.21	113.34	94148.0
2023-07-17	FBTS	Futures	105.926	105.977	105.866	105.916	73066.0
2023-07-17	FCE	Futures	7961.9	7963.0	7889.5	7916.0	26524.0
2023-07-17	FDAX	Futures	17102.8	17160.0	17034.0	17118.7	42897.0
2023-07-17	FDIV	Futures	186.79	186.79	185.82	185.82	3.0
2023-07-17	FDXM	Futures	17173.9	17232.4	17103.7	17188.8	31861.0
2023-07-17	FDXS	Futures	17077.6	17120.9	16993.1	17078.7	14053.0
2023-07-17	FESX	Futures	4457.3	4462.4	4420.8	4435.0	607833.0
2023-07-17	FEU3	Futures	97.782	97.782	97.782	97.782	0.0
2023-07-17	FGBL	Futures	134.45	135.14	134.26	134.66	479419.0
2023-07-17	FGBM	Futures	118.14	118.47	118.08	118.27	384559.0
2023-07-17	FGBS	Futures	107.259	107.32	107.223	107.274	273514.0
2023-07-17	FGBX	Futures	139.0	140.7	138.63	139.47	53620.0
2023-07-17	FMWO	Futures	10523.2	10584.7	10519.9	10562.4	3848.0
2023-07-17	FOAT	Futures	125.66	126.24	125.48	125.79	106444.0
2023-07-17	FSMX	Futures	28900.5	29026.3	28900.5	29000.3	62.0
2023-07-17	FTDX	Futures	3388.1	3388.1	3388.1	3388.1	0.0
2023-07-17	FTI	Futures	811.0	815.89	809.64	811.4	3259.0
2023-07-17	FTUK	Futures	7526.5	7555.9	7509.7	7529.5	74915.0

> showing 50 of 130 rows — these rows as CSV

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