PREVIEW / futures_daily / 2023-04-28

all futures daily files

  file:    by_date/futures_daily/2023/2023-04-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-04-28	ES	Futures	4542.11	4588.89	4520.78	4583.15	1753803.0
2023-04-28	NQ	Futures	14649.51	14783.64	14598.51	14766.18	671058.0
2023-04-28	YM	Futures	36284.3	36686.1	36167.5	36647.6	169860.0
2023-04-28	CL	Futures	65.31	67.06	64.46	66.94	328399.0
2023-04-28	GC	Futures	2216.0	2223.7	2201.8	2218.1	172445.0
2023-04-28	ZN	Futures	117.441861	118.161284	117.202053	117.873515	2075086.0
2023-04-28	A6	Futures	0.67518	0.6764	0.66893	0.67366	79243.0
2023-04-28	AD	Futures	0.74574	0.74903	0.74174	0.74898	94594.0
2023-04-28	ALI	Futures	2539.89	2602.45	2534.15	2586.33	648.0
2023-04-28	B	Futures	69.14	71.13	68.46	70.95	417058.0
2023-04-28	B6	Futures	1.2566	1.2653	1.2514	1.2633	124472.0
2023-04-28	BFX	Futures	4177.4	4177.4	4177.4	4177.4	0.0
2023-04-28	BR	Futures	0.18007	0.18056	0.17889	0.17989	6186.0
2023-04-28	BTC	Futures	40294.0	40294.0	39122.7	39681.4	6022.0
2023-04-28	BZ	Futures	68.78	70.68	68.04	70.53	26788.0
2023-04-28	C	Futures	1727.0	1727.0	1701.0	1708.0	9793.0
2023-04-28	CB	Futures	236.626	236.871	235.892	236.871	27.0
2023-04-28	CC	Futures	1692.0	1707.0	1680.0	1705.0	22683.0
2023-04-28	CNH	Futures	6.5968	6.6061	6.5878	6.5976	188.0
2023-04-28	CSC	Futures	2.14	2.147	2.132	2.146	62.0
2023-04-28	CT	Futures	101.9	103.46	101.1	102.37	15934.0
2023-04-28	DC	Futures	20.3	20.33	20.07	20.23	342.0
2023-04-28	DX	Futures	98.925	99.736	98.886	99.113	19700.0
2023-04-28	E1	Futures	1.20416	1.21064	1.20004	1.20491	25801.0
2023-04-28	E6	Futures	1.1371	1.1389	1.13037	1.13607	243211.0
2023-04-28	E7	Futures	1.1366	1.1384	1.1299	1.1356	8111.0
2023-04-28	EBM	Futures	353.69	356.28	349.62	352.95	12878.0
2023-04-28	ER	Futures	97.853	97.924	97.838	97.914	214892.0
2023-04-28	ESG	Futures	391.67	397.16	391.67	396.54	442.0
2023-04-28	EW	Futures	2641.3	2673.5	2624.2	2668.9	12292.0
2023-04-28	FBON	Futures	120.8	122.23	120.22	122.02	66.0
2023-04-28	FBTP	Futures	110.79	112.24	110.22	112.0	228876.0
2023-04-28	FBTS	Futures	106.108	106.482	105.906	106.401	121520.0
2023-04-28	FCE	Futures	8169.1	8173.5	8041.6	8138.6	52803.0
2023-04-28	FDAX	Futures	17036.3	17151.5	16852.9	17089.7	71502.0
2023-04-28	FDIV	Futures	187.57	188.46	187.57	188.46	75.0
2023-04-28	FDXM	Futures	17185.8	17294.5	16996.5	17235.3	42598.0
2023-04-28	FDXS	Futures	17065.1	17181.6	16882.4	17119.6	22126.0
2023-04-28	FESX	Futures	4428.3	4441.6	4361.9	4414.0	977497.0
2023-04-28	FEU3	Futures	97.924	97.924	97.924	97.924	0.0
2023-04-28	FGBL	Futures	134.61	136.41	134.36	136.29	971108.0
2023-04-28	FGBM	Futures	119.03	119.96	118.79	119.88	696672.0
2023-04-28	FGBS	Futures	108.021	108.308	107.939	108.272	687591.0
2023-04-28	FGBX	Futures	138.51	142.45	138.05	142.27	92633.0
2023-04-28	FMWO	Futures	9886.0	9970.8	9830.6	9927.8	5718.0
2023-04-28	FOAT	Futures	125.49	127.25	125.29	127.14	215291.0
2023-04-28	FSMX	Futures	29463.7	29652.6	29102.6	29547.1	368.0
2023-04-28	FTDX	Futures	3489.8	3509.6	3480.7	3509.6	9.0
2023-04-28	FTI	Futures	798.47	803.18	790.27	800.99	17171.0
2023-04-28	FTUK	Futures	8017.8	8031.6	7938.8	8016.8	96611.0

> showing 50 of 130 rows — these rows as CSV

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