PREVIEW / futures_daily / 2023-01-27

all futures daily files

  file:    by_date/futures_daily/2023/2023-01-27.parquet
  size:    10 KB
  rows:    131

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-01-27	ES	Futures	4494.72	4543.65	4486.15	4516.01	1587936.0
2023-01-27	NQ	Futures	13522.89	13814.14	13485.86	13717.34	588072.0
2023-01-27	YM	Futures	36741.7	37004.3	36634.7	36793.5	141444.0
2023-01-27	CL	Futures	70.91	72.01	69.01	69.57	367588.0
2023-01-27	GC	Futures	2177.0	2184.0	2162.6	2176.7	144498.0
2023-01-27	ZN	Futures	117.939988	118.036318	117.522559	117.763383	1143961.0
2023-01-27	A6	Futures	0.72707	0.7285	0.72375	0.72666	62691.0
2023-01-27	AD	Futures	0.76194	0.76306	0.76032	0.76275	53464.0
2023-01-27	ALI	Futures	2952.74	2965.71	2916.3	2933.42	1462.0
2023-01-27	B	Futures	76.31	77.3	74.59	75.36	321656.0
2023-01-27	B6	Futures	1.2522	1.2532	1.2455	1.2504	55486.0
2023-01-27	BFX	Futures	4151.1	4151.1	4151.1	4151.1	0.0
2023-01-27	BR	Futures	0.17582	0.17587	0.17363	0.17399	11562.0
2023-01-27	BTC	Futures	31833.0	32489.7	31142.2	31901.4	7950.0
2023-01-27	BZ	Futures	75.9	77.07	74.36	75.12	22151.0
2023-01-27	C	Futures	1585.0	1602.0	1583.0	1593.0	6116.0
2023-01-27	CB	Futures	231.977	232.466	231.977	232.466	1.0
2023-01-27	CC	Futures	1528.0	1541.0	1524.0	1533.0	14661.0
2023-01-27	CNH	Futures	6.3727	6.4088	6.3661	6.4064	272.0
2023-01-27	CSC	Futures	2.396	2.403	2.372	2.377	120.0
2023-01-27	CT	Futures	114.54	114.82	112.92	113.94	10049.0
2023-01-27	DC	Futures	22.52	22.71	22.27	22.34	355.0
2023-01-27	DX	Futures	98.7	99.157	98.671	98.895	18244.0
2023-01-27	E1	Futures	1.18627	1.18763	1.18149	1.18508	12139.0
2023-01-27	E6	Futures	1.1307	1.13148	1.12496	1.12822	165243.0
2023-01-27	E7	Futures	1.1299	1.1308	1.1242	1.1275	5957.0
2023-01-27	EBM	Futures	426.56	427.3	422.12	422.86	23054.0
2023-01-27	ED	Futures	94.5216	94.5266	94.5117	94.5167	44646.0
2023-01-27	ER	Futures	97.68	97.691	97.675	97.691	92055.0
2023-01-27	ESG	Futures	384.54	388.66	384.54	386.7	311.0
2023-01-27	EW	Futures	2810.2	2835.7	2803.4	2825.4	7137.0
2023-01-27	FBON	Futures	123.4	123.47	122.84	123.27	96.0
2023-01-27	FBTP	Futures	112.01	112.14	111.25	111.67	142804.0
2023-01-27	FBTS	Futures	106.684	106.734	106.574	106.634	106306.0
2023-01-27	FCE	Futures	7722.3	7742.9	7682.1	7720.6	42504.0
2023-01-27	FDAX	Futures	16430.3	16470.3	16346.0	16422.7	53538.0
2023-01-27	FDIV	Futures	181.12	181.12	181.12	181.12	0.0
2023-01-27	FDXM	Futures	16331.3	16371.0	16247.5	16323.7	79508.0
2023-01-27	FDXS	Futures	16228.8	16271.5	16148.7	16224.5	15642.0
2023-01-27	FESX	Futures	4157.4	4169.4	4132.6	4155.5	793799.0
2023-01-27	FEU3	Futures	97.756	97.756	97.756	97.756	0.0
2023-01-27	FGBL	Futures	138.06	138.06	137.16	137.72	649626.0
2023-01-27	FGBM	Futures	120.41	120.46	120.03	120.29	491115.0
2023-01-27	FGBS	Futures	108.358	108.425	108.292	108.368	321161.0
2023-01-27	FGBX	Futures	149.37	149.43	147.38	148.84	54165.0
2023-01-27	FMWO	Futures	9817.0	9891.5	9796.4	9838.8	1557.0
2023-01-27	FOAT	Futures	129.21	129.27	128.37	128.88	131866.0
2023-01-27	FSMX	Futures	30665.2	30968.6	30648.2	30946.3	578.0
2023-01-27	FTDX	Futures	3424.3	3428.5	3411.5	3423.2	47.0
2023-01-27	FTI	Futures	776.75	778.66	773.22	777.24	14576.0

> showing 50 of 131 rows — these rows as CSV

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