PREVIEW / futures_daily / 2023-12-26

all futures daily files

  file:    by_date/futures_daily/2023/2023-12-26.parquet
  size:    9 KB
  rows:    98

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-12-26	ES	Futures	5081.41	5117.67	5081.41	5107.61	688201.0
2023-12-26	NQ	Futures	18075.18	18231.53	18075.18	18201.97	292090.0
2023-12-26	YM	Futures	39271.5	39550.7	39270.4	39479.8	55134.0
2023-12-26	CL	Futures	65.27	67.59	64.88	67.05	208715.0
2023-12-26	GC	Futures	2202.4	2217.9	2201.5	2206.5	79573.0
2023-12-26	ZN	Futures	114.094069	114.173181	113.967492	114.141536	396317.0
2023-12-26	A6	Futures	0.68576	0.68842	0.68546	0.68807	27736.0
2023-12-26	AD	Futures	0.7601	0.76408	0.7601	0.76372	48946.0
2023-12-26	ALI	Futures	2544.96	2544.96	2512.87	2527.68	31.0
2023-12-26	B	Futures	72.26	74.75	71.93	74.2	184694.0
2023-12-26	B6	Futures	1.2702	1.2737	1.2692	1.2731	20650.0
2023-12-26	BR	Futures	0.19598	0.19713	0.19579	0.19579	45.0
2023-12-26	BTC	Futures	57368.1	57368.1	54522.2	55212.7	6492.0
2023-12-26	BZ	Futures	71.64	73.95	71.19	73.42	24285.0
2023-12-26	CB	Futures	261.058	261.058	257.703	261.058	10.0
2023-12-26	CC	Futures	2500.0	2513.0	2474.0	2478.0	9121.0
2023-12-26	CNH	Futures	6.9255	6.926	6.9109	6.9207	306.0
2023-12-26	CSC	Futures	1.717	1.725	1.717	1.725	91.0
2023-12-26	CT	Futures	95.9	96.79	95.73	96.25	6761.0
2023-12-26	DC	Futures	16.23	16.35	16.2	16.33	196.0
2023-12-26	DX	Futures	100.288	100.387	100.075	100.084	5097.0
2023-12-26	E1	Futures	1.22432	1.2278	1.22084	1.22739	8841.0
2023-12-26	E6	Futures	1.11976	1.12295	1.11921	1.12285	60568.0
2023-12-26	E7	Futures	1.1198	1.1227	1.1189	1.1226	1481.0
2023-12-26	ER	Futures	97.863	97.863	97.863	97.863	0.0
2023-12-26	ESG	Futures	431.27	432.73	431.27	432.22	208.0
2023-12-26	EW	Futures	2912.7	2944.4	2912.7	2935.2	4368.0
2023-12-26	FTUK	Futures	7760.3	7760.3	7760.3	7760.3	0.0
2023-12-26	G	Futures	103.73	103.73	103.73	103.73	0.0
2023-12-26	GF	Futures	224.774	228.29	224.086	227.806	1967.0
2023-12-26	GSCI	Futures	575.01	575.01	571.78	573.4	13.0
2023-12-26	HE	Futures	73.299	73.299	71.361	71.645	18647.0
2023-12-26	HG	Futures	4.1574	4.1984	4.1489	4.1542	38002.0
2023-12-26	HH	Futures	3.521	3.568	3.482	3.546	4424.0
2023-12-26	HO	Futures	2.3292	2.3969	2.3266	2.3504	19340.0
2023-12-26	HRC	Futures	1323.8	1342.6	1323.8	1332.0	56.0
2023-12-26	J1	Futures	0.0074585	0.0074726	0.0074427	0.0074511	61411.0
2023-12-26	J7	Futures	0.007477	0.007485	0.007461	0.007468	199.0
2023-12-26	JB	Futures	140.71	140.95	140.6	140.71	196.0
2023-12-26	KC	Futures	170.24	172.54	169.49	171.61	6725.0
2023-12-26	KE	Futures	717.23	746.03	714.63	740.56	18877.0
2023-12-26	KRW	Futures	0.0007718	0.0007718	0.0007717	0.0007717	2.0
2023-12-26	LBS	Futures	831.3	831.3	813.6	814.4	402.0
2023-12-26	LE	Futures	168.939	171.529	168.36	171.429	17965.0
2023-12-26	M2K	Futures	2149.8	2184.6	2147.6	2178.9	44934.0
2023-12-26	MBT	Futures	49539.6	49690.2	47169.7	47710.6	2071.0
2023-12-26	MCL	Futures	72.85	75.49	72.56	74.91	3051.0
2023-12-26	MES	Futures	5040.77	5076.21	5039.98	5066.23	325139.0
2023-12-26	MET	Futures	2713.5	2736.7	2580.7	2619.1	9276.0
2023-12-26	MFS	Futures	2251.0	2273.6	2251.0	2270.2	19389.0

> showing 50 of 98 rows — these rows as CSV

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