PREVIEW / futures_daily / 2021-09-29

all futures daily files

  file:    by_date/futures_daily/2021/2021-09-29.parquet
  size:    10 KB
  rows:    123

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
2021-09-29	ES	Futures	4890.47	4925.62	4886.81	4893.0	1815726.0
2021-09-29	NQ	Futures	17031.09	17211.85	16963.92	16997.08	649554.0
2021-09-29	YM	Futures	37253.1	37483.8	37175.9	37281.4	212633.0
2021-09-29	CL	Futures	54.77	55.81	54.3	55.1	424193.0
2021-09-29	GC	Futures	2023.0	2037.0	2007.9	2010.0	177389.0
2021-09-29	ZN	Futures	133.670188	134.035667	133.543065	133.701969	2067859.0
2021-09-29	A6	Futures	0.74255	0.74491	0.73527	0.73665	110103.0
2021-09-29	AD	Futures	0.80029	0.8013	0.7946	0.79633	81718.0
2021-09-29	ALI	Futures	3340.44	3349.45	3305.23	3314.52	140.0
2021-09-29	B	Futures	52.51	53.34	52.01	52.9	371396.0
2021-09-29	B6	Futures	1.3742	1.3759	1.3614	1.3638	128044.0
2021-09-29	BR	Futures	0.14873	0.14889	0.14792	0.148	2690.0
2021-09-29	BTC	Futures	55698.3	56821.8	54229.0	54721.0	3694.0
2021-09-29	BZ	Futures	51.2	52.1	50.8	51.67	44034.0
2021-09-29	C	Futures	1552.0	1594.0	1552.0	1591.0	11023.0
2021-09-29	CB	Futures	139.672	139.672	139.475	139.672	2.0
2021-09-29	CC	Futures	1648.0	1671.0	1643.0	1662.0	16315.0
2021-09-29	CNH	Futures	6.2281	6.2368	6.2237	6.234	219.0
2021-09-29	CSC	Futures	2.438	2.459	2.438	2.459	63.0
2021-09-29	CT	Futures	93.09	97.09	92.89	95.14	32916.0
2021-09-29	DC	Futures	22.44	22.68	22.44	22.64	290.0
2021-09-29	DX	Futures	90.564	91.25	90.52	91.166	31449.0
2021-09-29	E1	Futures	1.2078	1.20914	1.19917	1.20063	25542.0
2021-09-29	E6	Futures	1.24309	1.24384	1.23305	1.23433	211960.0
2021-09-29	E7	Futures	1.2365	1.2369	1.2264	1.2276	4526.0
2021-09-29	EBM	Futures	373.27	378.79	371.81	376.21	26738.0
2021-09-29	ED	Futures	96.5489	96.5537	96.5441	96.5489	103881.0
2021-09-29	ER	Futures	98.475	98.475	98.47	98.475	29521.0
2021-09-29	ESG	Futures	405.66	405.84	402.97	403.52	368.0
2021-09-29	EW	Futures	2884.2	2896.8	2868.0	2879.6	10344.0
2021-09-29	FBON	Futures	148.94	149.38	148.89	149.1	730.0
2021-09-29	FBTP	Futures	138.41	139.06	138.35	138.86	145694.0
2021-09-29	FBTS	Futures	110.312	110.38	110.293	110.371	54950.0
2021-09-29	FCE	Futures	6549.0	6604.6	6541.5	6573.5	63716.0
2021-09-29	FDAX	Futures	16345.8	16466.6	16267.8	16395.0	70831.0
2021-09-29	FDIV	Futures	183.92	184.46	183.92	184.46	25.0
2021-09-29	FDXM	Futures	16381.6	16513.5	16315.2	16441.7	54296.0
2021-09-29	FDXS	Futures	16198.8	16359.1	16163.7	16289.0	19214.0
2021-09-29	FESX	Futures	3883.7	3917.7	3865.5	3890.9	780564.0
2021-09-29	FGBL	Futures	167.14	167.8	167.1	167.64	737214.0
2021-09-29	FGBM	Futures	134.55	134.76	134.54	134.71	435876.0
2021-09-29	FGBS	Futures	112.629	112.649	112.619	112.634	306127.0
2021-09-29	FGBX	Futures	219.55	221.4	219.4	220.78	77239.0
2021-09-29	FMWO	Futures	10803.9	10840.4	10743.7	10786.2	5664.0
2021-09-29	FOAT	Futures	154.68	155.28	154.66	155.15	159354.0
2021-09-29	FTDX	Futures	3859.5	3885.1	3820.5	3821.5	65.0
2021-09-29	FTI	Futures	740.59	746.7	736.96	739.12	23093.0
2021-09-29	FTUK	Futures	6916.4	6998.3	6890.2	6988.0	101470.0
2021-09-29	FVSA	Futures	87.35	90.35	85.28	87.91	35126.0
2021-09-29	FXXP	Futures	431.1	434.5	430.8	432.2	56880.0

> showing 50 of 123 rows — these rows as CSV

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