PREVIEW / futures_daily / 2022-07-18

all futures daily files

  file:    by_date/futures_daily/2022/2022-07-18.parquet
  size:    10 KB
  rows:    127

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
2022-07-18	ES	Futures	4350.93	4385.71	4285.58	4300.73	1439590.0
2022-07-18	NQ	Futures	13752.05	13915.33	13539.09	13596.18	553676.0
2022-07-18	YM	Futures	34220.1	34565.6	33836.3	33945.7	147514.0
2022-07-18	CL	Futures	79.99	84.46	78.75	84.29	291700.0
2022-07-18	GC	Futures	1971.9	1989.9	1969.6	1976.3	157535.0
2022-07-18	ZN	Futures	122.005225	122.278347	121.330453	121.812433	934835.0
2022-07-18	A6	Futures	0.6962	0.70276	0.69595	0.69851	75325.0
2022-07-18	AD	Futures	0.77857	0.78628	0.77857	0.78202	93893.0
2022-07-18	ALI	Futures	2660.86	2766.03	2660.86	2735.66	1188.0
2022-07-18	B	Futures	81.09	85.64	80.0	85.47	213498.0
2022-07-18	B6	Futures	1.2058	1.2226	1.2052	1.2144	95057.0
2022-07-18	BR	Futures	0.15896	0.16026	0.15804	0.15843	99.0
2022-07-18	BTC	Futures	29383.1	31759.6	28923.1	30135.7	10033.0
2022-07-18	BZ	Futures	79.26	83.62	78.13	83.46	20217.0
2022-07-18	C	Futures	1288.0	1294.0	1277.0	1284.0	4642.0
2022-07-18	CB	Futures	217.543	220.383	217.543	219.175	38.0
2022-07-18	CC	Futures	1396.0	1401.0	1373.0	1392.0	16540.0
2022-07-18	CNH	Futures	6.3762	6.3766	6.3512	6.371	812.0
2022-07-18	CSC	Futures	2.766	2.831	2.766	2.8	166.0
2022-07-18	CT	Futures	123.06	127.82	123.06	127.31	11.0
2022-07-18	DC	Futures	25.84	26.86	25.84	26.5	431.0
2022-07-18	DX	Futures	104.005	104.087	102.972	103.441	28183.0
2022-07-18	E1	Futures	1.13808	1.14145	1.13465	1.13675	21664.0
2022-07-18	E6	Futures	1.06594	1.07803	1.06504	1.07261	191913.0
2022-07-18	E7	Futures	1.0597	1.0714	1.0587	1.0662	7389.0
2022-07-18	EBM	Futures	462.7	477.43	456.04	470.06	21099.0
2022-07-18	ED	Futures	94.8972	94.9022	94.8481	94.8972	119508.0
2022-07-18	ER	Futures	98.203	98.218	98.188	98.198	65865.0
2022-07-18	ESG	Futures	378.54	379.0	370.68	371.99	321.0
2022-07-18	EW	Futures	2518.5	2546.6	2497.3	2503.3	9863.0
2022-07-18	FBON	Futures	129.11	129.13	128.4	128.84	38.0
2022-07-18	FBTP	Futures	113.94	115.24	113.56	114.99	115430.0
2022-07-18	FBTS	Futures	106.646	107.207	106.557	107.158	80995.0
2022-07-18	FCE	Futures	6669.2	6731.7	6613.2	6682.3	46956.0
2022-07-18	FDAX	Futures	13832.8	14048.0	13798.3	13907.0	54888.0
2022-07-18	FDIV	Futures	154.9	155.5	153.61	154.31	28.0
2022-07-18	FDXM	Futures	13932.4	14133.8	13882.6	13992.0	36274.0
2022-07-18	FDXS	Futures	13819.0	14019.8	13769.6	13878.0	20003.0
2022-07-18	FESX	Futures	3447.6	3499.2	3439.7	3472.4	779013.0
2022-07-18	FGBL	Futures	150.95	151.31	149.49	149.93	508831.0
2022-07-18	FGBM	Futures	127.76	127.94	127.12	127.34	286513.0
2022-07-18	FGBS	Futures	111.471	111.547	111.288	111.359	366169.0
2022-07-18	FGBX	Futures	177.47	178.11	173.43	174.19	42603.0
2022-07-18	FMWO	Futures	9256.9	9322.5	9151.6	9292.1	5474.0
2022-07-18	FOAT	Futures	138.2	138.43	137.01	137.47	156832.0
2022-07-18	FSMX	Futures	27584.4	27787.5	27467.8	27660.3	403.0
2022-07-18	FTDX	Futures	3189.6	3189.6	3121.7	3122.7	63.0
2022-07-18	FTI	Futures	681.54	688.79	678.35	686.12	17929.0
2022-07-18	FTUK	Futures	7226.7	7321.5	7206.0	7268.8	81067.0
2022-07-18	FVSA	Futures	81.72	84.1	79.91	82.14	34371.0

> showing 50 of 127 rows — these rows as CSV

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