PREVIEW / futures_daily / 2024-04-01

all futures daily files

  file:    by_date/futures_daily/2024/2024-04-01.parquet
  size:    9 KB
  rows:    95

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
2024-04-01	ES	Futures	5551.93	5572.04	5518.5	5532.08	1125234.0
2024-04-01	NQ	Futures	19431.19	19545.65	19338.25	19425.15	572133.0
2024-04-01	YM	Futures	41333.1	41538.9	40870.9	41061.3	122809.0
2024-04-01	CL	Futures	74.5	75.71	74.02	75.01	321059.0
2024-04-01	GC	Futures	2362.0	2390.4	2351.4	2359.8	220767.0
2024-04-01	ZN	Futures	111.583256	111.693408	110.639102	110.702046	1439886.0
2024-04-01	A6	Futures	0.65511	0.65737	0.65145	0.6517	75246.0
2024-04-01	AD	Futures	0.74359	0.7449	0.74088	0.74108	74162.0
2024-04-01	ALI	Futures	2552.58	2586.64	2551.48	2553.4	49.0
2024-04-01	B	Futures	81.68	82.62	81.13	82.09	274955.0
2024-04-01	B6	Futures	1.2632	1.2644	1.2539	1.2542	84099.0
2024-04-01	BR	Futures	0.19059	0.19059	0.18982	0.18991	82.0
2024-04-01	BTC	Futures	83757.2	84612.3	80348.3	82445.2	8077.0
2024-04-01	BZ	Futures	80.48	81.46	79.99	80.93	29598.0
2024-04-01	CB	Futures	293.002	293.002	291.108	291.856	15.0
2024-04-01	CC	Futures	5695.0	6046.0	5644.0	5929.0	11594.0
2024-04-01	CNH	Futures	7.0927	7.102	7.0868	7.1001	448.0
2024-04-01	CSC	Futures	1.605	1.605	1.588	1.592	90.0
2024-04-01	CT	Futures	110.03	111.6	109.99	111.46	12909.0
2024-04-01	DC	Futures	15.48	15.48	15.25	15.35	368.0
2024-04-01	DX	Futures	103.494	104.045	103.38	104.004	15078.0
2024-04-01	E1	Futures	1.15052	1.15165	1.14507	1.14558	18987.0
2024-04-01	E6	Futures	1.09146	1.09358	1.08666	1.08727	151887.0
2024-04-01	E7	Futures	1.0918	1.0931	1.0865	1.0871	2041.0
2024-04-01	ESG	Futures	469.62	469.62	466.88	467.58	195.0
2024-04-01	EW	Futures	3163.4	3171.8	3124.9	3128.1	9851.0
2024-04-01	GF	Futures	245.662	248.028	238.117	239.486	3482.0
2024-04-01	GSCI	Futures	612.21	614.62	611.95	611.95	15.0
2024-04-01	HE	Futures	80.733	83.196	80.513	82.493	835.0
2024-04-01	HG	Futures	4.2977	4.3478	4.2913	4.3164	81605.0
2024-04-01	HH	Futures	2.605	2.753	2.537	2.733	2356.0
2024-04-01	HO	Futures	2.546	2.5638	2.5086	2.5527	31155.0
2024-04-01	HRC	Futures	1064.3	1074.2	1064.3	1064.3	7.0
2024-04-01	J1	Futures	0.006907	0.0069127	0.0068848	0.0068925	116267.0
2024-04-01	J7	Futures	0.006923	0.006934	0.006902	0.006909	658.0
2024-04-01	JB	Futures	140.74	140.75	140.47	140.68	482.0
2024-04-01	KC	Futures	165.56	169.7	165.3	168.91	19146.0
2024-04-01	KE	Futures	677.85	680.75	653.53	666.56	26031.0
2024-04-01	KRW	Futures	0.0007365	0.0007365	0.0007306	0.0007311	22.0
2024-04-01	LBS	Futures	774.7	786.5	770.0	785.9	915.0
2024-04-01	LE	Futures	183.865	184.989	177.865	179.065	41728.0
2024-04-01	M2K	Futures	2222.9	2240.4	2191.3	2194.9	69302.0
2024-04-01	MBT	Futures	76776.4	77592.4	73614.5	75563.2	34338.0
2024-04-01	MCL	Futures	83.76	84.87	83.25	84.22	3661.0
2024-04-01	MES	Futures	5487.92	5509.1	5456.42	5469.85	659117.0
2024-04-01	MET	Futures	4096.7	4163.6	3864.3	3948.5	15911.0
2024-04-01	MFS	Futures	2387.1	2400.8	2370.6	2375.9	30703.0
2024-04-01	MGC	Futures	2342.9	2373.3	2334.5	2342.8	118301.0
2024-04-01	MME	Futures	1065.6	1073.9	1062.6	1065.7	78108.0
2024-04-01	MNQ	Futures	19224.6	19340.73	19135.75	19221.75	1215598.0

> showing 50 of 95 rows — these rows as CSV

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