PREVIEW / futures_daily / 2023-06-20

all futures daily files

  file:    by_date/futures_daily/2023/2023-06-20.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-06-20	ES	Futures	4827.79	4832.13	4776.35	4802.62	1540416.0
2023-06-20	NQ	Futures	16744.39	16765.45	16550.99	16693.23	652883.0
2023-06-20	YM	Futures	36793.8	36823.5	36343.2	36512.2	189093.0
2023-06-20	CL	Futures	62.22	62.81	60.54	61.78	430492.0
2023-06-20	GC	Futures	2166.5	2167.7	2133.6	2141.2	250140.0
2023-06-20	ZN	Futures	115.091996	115.553191	114.726221	115.330546	1531542.0
2023-06-20	A6	Futures	0.69862	0.69882	0.68575	0.68915	147662.0
2023-06-20	AD	Futures	0.76679	0.7678	0.76249	0.76482	109146.0
2023-06-20	ALI	Futures	2489.51	2498.94	2464.0	2472.6	2851.0
2023-06-20	B	Futures	67.37	68.28	65.94	67.17	276378.0
2023-06-20	B6	Futures	1.2863	1.2873	1.2748	1.2794	135026.0
2023-06-20	BFX	Futures	3969.7	3969.7	3969.7	3969.7	0.0
2023-06-20	BR	Futures	0.19282	0.19427	0.19208	0.19236	104.0
2023-06-20	BTC	Futures	35312.0	37925.2	35078.7	37571.9	17218.0
2023-06-20	BZ	Futures	67.12	67.93	65.61	66.83	34421.0
2023-06-20	C	Futures	1973.0	1993.0	1953.0	1958.0	3304.0
2023-06-20	CB	Futures	229.402	229.402	229.402	229.402	4.0
2023-06-20	CC	Futures	1878.0	1878.0	1857.0	1862.0	32658.0
2023-06-20	CNH	Futures	6.7932	6.8743	6.7932	6.8706	843.0
2023-06-20	CSC	Futures	1.958	1.97	1.956	1.969	115.0
2023-06-20	CT	Futures	103.45	103.61	102.0	102.19	6751.0
2023-06-20	DC	Futures	17.86	18.15	17.86	18.11	149.0
2023-06-20	DX	Futures	100.141	100.435	99.989	100.19	13516.0
2023-06-20	E1	Futures	1.19774	1.19843	1.18936	1.19233	21599.0
2023-06-20	E6	Futures	1.12498	1.12539	1.11986	1.12242	200660.0
2023-06-20	E7	Futures	1.1252	1.1254	1.12	1.1225	5201.0
2023-06-20	EBM	Futures	349.27	353.3	345.25	350.01	29330.0
2023-06-20	ER	Futures	97.751	97.766	97.736	97.756	127615.0
2023-06-20	ESG	Futures	418.16	418.62	414.81	417.05	1805.0
2023-06-20	EW	Futures	2759.5	2761.6	2718.8	2734.0	9726.0
2023-06-20	FBON	Futures	122.46	123.16	122.46	123.1	29.0
2023-06-20	FBTP	Futures	114.02	114.84	113.95	114.71	156388.0
2023-06-20	FBTS	Futures	106.007	106.098	105.977	106.078	130267.0
2023-06-20	FCE	Futures	7955.4	7981.6	7935.3	7950.0	42738.0
2023-06-20	FDAX	Futures	17296.5	17311.3	17153.6	17199.1	50136.0
2023-06-20	FDIV	Futures	185.31	185.46	185.31	185.46	30.0
2023-06-20	FDXM	Futures	17373.7	17381.2	17224.9	17269.6	30489.0
2023-06-20	FDXS	Futures	17237.1	17270.9	17114.6	17158.9	17941.0
2023-06-20	FESX	Futures	4446.2	4449.2	4420.8	4423.9	572097.0
2023-06-20	FEU3	Futures	97.746	97.746	97.746	97.746	0.0
2023-06-20	FGBL	Futures	134.24	135.56	134.2	135.45	710538.0
2023-06-20	FGBM	Futures	118.21	118.75	118.19	118.7	504186.0
2023-06-20	FGBS	Futures	107.381	107.489	107.346	107.473	447375.0
2023-06-20	FGBX	Futures	137.64	141.09	137.5	140.72	78308.0
2023-06-20	FMWO	Futures	10334.2	10360.0	10270.5	10281.7	2484.0
2023-06-20	FOAT	Futures	125.7	126.93	125.67	126.81	180633.0
2023-06-20	FSMX	Futures	28203.5	28226.4	28021.5	28024.6	290.0
2023-06-20	FTDX	Futures	3379.7	3380.3	3362.3	3366.0	152.0
2023-06-20	FTI	Futures	808.49	808.49	802.87	803.62	11674.0
2023-06-20	FTUK	Futures	7731.2	7744.9	7697.2	7701.2	81733.0

> showing 50 of 130 rows — these rows as CSV

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