PREVIEW / futures_daily / 2023-07-28

all futures daily files

  file:    by_date/futures_daily/2023/2023-07-28.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-28	ES	Futures	4944.75	4999.44	4936.09	4988.61	1573973.0
2023-07-28	NQ	Futures	17047.2	17392.96	17010.27	17339.89	689386.0
2023-07-28	YM	Futures	37663.1	37949.0	37596.2	37825.7	144651.0
2023-07-28	CL	Futures	69.17	69.93	68.5	69.81	299547.0
2023-07-28	GC	Futures	2137.5	2155.5	2136.0	2153.3	159597.0
2023-07-28	ZN	Futures	113.056377	113.644798	112.770118	113.326733	1726479.0
2023-07-28	A6	Futures	0.68084	0.68119	0.67197	0.67491	116261.0
2023-07-28	AD	Futures	0.76461	0.76598	0.76259	0.76365	65546.0
2023-07-28	ALI	Futures	2453.57	2475.36	2450.49	2471.17	552.0
2023-07-28	B	Futures	73.7	74.78	73.32	74.7	353948.0
2023-07-28	B6	Futures	1.2825	1.2915	1.2787	1.2883	108240.0
2023-07-28	BFX	Futures	4190.0	4190.0	4174.6	4174.6	16.0
2023-07-28	BR	Futures	0.19487	0.19721	0.1946	0.19595	8245.0
2023-07-28	BTC	Futures	38851.5	39480.8	38778.7	39123.1	6829.0
2023-07-28	BZ	Futures	73.57	74.58	73.09	74.47	25541.0
2023-07-28	C	Futures	2261.0	2270.0	2246.0	2249.0	4597.0
2023-07-28	CB	Futures	256.19	256.214	252.404	252.88	33.0
2023-07-28	CC	Futures	2058.0	2065.0	2040.0	2044.0	14059.0
2023-07-28	CNH	Futures	6.8725	6.8793	6.849	6.8546	237.0
2023-07-28	CSC	Futures	1.969	2.004	1.954	2.003	130.0
2023-07-28	CT	Futures	109.46	109.49	105.97	106.02	65.0
2023-07-28	DC	Futures	18.11	18.5	17.93	18.42	613.0
2023-07-28	DX	Futures	99.557	99.895	99.179	99.477	19385.0
2023-07-28	E1	Futures	1.22691	1.23121	1.22049	1.22691	25270.0
2023-07-28	E6	Futures	1.12631	1.13332	1.12262	1.13086	251344.0
2023-07-28	E7	Futures	1.126	1.1333	1.1227	1.131	6350.0
2023-07-28	EBM	Futures	364.65	367.95	357.33	362.82	38556.0
2023-07-28	ER	Futures	97.873	97.929	97.868	97.899	301780.0
2023-07-28	ESG	Futures	432.29	434.01	431.74	433.29	465.0
2023-07-28	EW	Futures	2865.9	2897.8	2858.5	2887.4	11979.0
2023-07-28	FBON	Futures	121.31	122.43	121.2	121.94	38.0
2023-07-28	FBTP	Futures	113.77	114.41	113.21	114.05	131695.0
2023-07-28	FBTS	Futures	106.138	106.34	106.058	106.249	106449.0
2023-07-28	FCE	Futures	8091.8	8131.3	8040.9	8106.4	53213.0
2023-07-28	FDAX	Futures	17391.8	17546.3	17359.0	17530.5	53568.0
2023-07-28	FDIV	Futures	190.46	191.94	190.46	191.94	80.0
2023-07-28	FDXM	Futures	17449.2	17626.7	17431.1	17602.2	41843.0
2023-07-28	FDXS	Futures	17339.5	17505.3	17322.6	17489.5	21204.0
2023-07-28	FESX	Futures	4500.9	4556.6	4489.7	4553.5	861828.0
2023-07-28	FEU3	Futures	97.894	97.894	97.894	97.894	0.0
2023-07-28	FGBL	Futures	134.17	135.01	133.46	134.65	897454.0
2023-07-28	FGBM	Futures	118.27	118.68	117.97	118.49	581375.0
2023-07-28	FGBS	Futures	107.381	107.514	107.305	107.443	513595.0
2023-07-28	FGBX	Futures	137.28	139.28	135.27	137.99	91466.0
2023-07-28	FMWO	Futures	10599.3	10703.3	10599.3	10698.8	6288.0
2023-07-28	FOAT	Futures	125.2	126.15	124.6	125.74	200829.0
2023-07-28	FSMX	Futures	30001.0	30011.4	29672.3	30011.4	24.0
2023-07-28	FTDX	Futures	3481.4	3499.8	3476.6	3496.6	22.0
2023-07-28	FTI	Futures	828.78	833.41	825.78	832.51	13861.0
2023-07-28	FTUK	Futures	7775.4	7830.3	7758.7	7809.0	84372.0

> showing 50 of 130 rows — these rows as CSV

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