PREVIEW / futures_daily / 2021-09-27

all futures daily files

  file:    by_date/futures_daily/2021/2021-09-27.parquet
  size:    10 KB
  rows:    122

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-27	ES	Futures	5001.27	5030.52	4977.65	4986.65	1306188.0
2021-09-27	NQ	Futures	17665.03	17757.57	17394.05	17521.76	543381.0
2021-09-27	YM	Futures	37750.4	38009.3	37702.5	37801.5	147057.0
2021-09-27	CL	Futures	54.63	55.78	54.61	55.56	417829.0
2021-09-27	GC	Futures	2043.7	2054.4	2035.5	2044.0	137574.0
2021-09-27	ZN	Futures	134.321695	134.417037	133.844982	134.035667	1856758.0
2021-09-27	A6	Futures	0.74455	0.74798	0.74342	0.74716	82998.0
2021-09-27	AD	Futures	0.80196	0.80501	0.80105	0.8043	69322.0
2021-09-27	ALI	Futures	3300.72	3333.11	3283.26	3286.92	731.0
2021-09-27	B	Futures	52.58	53.55	52.4	53.33	366630.0
2021-09-27	B6	Futures	1.3874	1.3937	1.3865	1.3917	88947.0
2021-09-27	BFX	Futures	4255.5	4263.1	4255.5	4263.1	2.0
2021-09-27	BR	Futures	0.1506	0.1506	0.14906	0.14926	55.0
2021-09-27	BTC	Futures	58018.5	59275.0	56868.3	57373.6	5221.0
2021-09-27	BZ	Futures	51.23	52.3	51.23	52.09	36128.0
2021-09-27	C	Futures	1543.0	1551.0	1524.0	1528.0	10741.0
2021-09-27	CC	Futures	1658.0	1668.0	1632.0	1635.0	17756.0
2021-09-27	CNH	Futures	6.2282	6.2315	6.2202	6.2226	228.0
2021-09-27	CSC	Futures	2.415	2.432	2.415	2.427	32.0
2021-09-27	CT	Futures	89.62	93.2	89.62	91.51	40991.0
2021-09-27	DC	Futures	22.29	22.39	22.19	22.36	120.0
2021-09-27	DX	Futures	90.153	90.337	90.047	90.227	21078.0
2021-09-27	E1	Futures	1.21396	1.2144	1.20768	1.21183	23556.0
2021-09-27	E6	Futures	1.24681	1.24766	1.24314	1.2449	131415.0
2021-09-27	E7	Futures	1.2403	1.2408	1.2365	1.2381	2545.0
2021-09-27	EBM	Futures	372.17	372.91	369.6	372.17	16521.0
2021-09-27	ED	Futures	96.5441	96.5489	96.5441	96.5441	129847.0
2021-09-27	ER	Futures	98.47	98.475	98.47	98.47	49705.0
2021-09-27	ESG	Futures	411.41	412.37	410.7	411.56	425.0
2021-09-27	EW	Futures	2896.7	2939.5	2890.9	2922.9	12443.0
2021-09-27	FBON	Futures	149.69	149.69	148.94	149.29	431.0
2021-09-27	FBTP	Futures	139.37	139.58	138.72	139.16	127026.0
2021-09-27	FBTS	Futures	110.409	110.429	110.342	110.38	78790.0
2021-09-27	FCE	Futures	6693.8	6706.3	6645.7	6657.2	46038.0
2021-09-27	FDAX	Futures	16605.6	16779.8	16600.2	16634.4	57919.0
2021-09-27	FDIV	Futures	185.54	185.69	185.1	185.25	35.0
2021-09-27	FDXM	Futures	16659.3	16829.7	16647.5	16681.8	47028.0
2021-09-27	FDXS	Futures	16523.7	16670.3	16491.8	16526.9	14916.0
2021-09-27	FESX	Futures	3970.4	4002.9	3962.2	3971.3	527545.0
2021-09-27	FGBL	Futures	167.81	168.16	167.22	167.66	786122.0
2021-09-27	FGBM	Futures	134.75	134.82	134.56	134.68	446400.0
2021-09-27	FGBS	Futures	112.639	112.654	112.619	112.629	238463.0
2021-09-27	FGBX	Futures	220.84	221.4	218.84	220.35	77412.0
2021-09-27	FMWO	Futures	11057.4	11088.1	10964.3	10989.0	4272.0
2021-09-27	FOAT	Futures	155.42	155.72	154.84	155.29	206820.0
2021-09-27	FTDX	Futures	4021.6	4033.5	3941.1	3946.7	114.0
2021-09-27	FTI	Futures	758.4	761.26	749.56	751.24	18423.0
2021-09-27	FTUK	Futures	6956.4	7010.2	6924.3	6945.5	79915.0
2021-09-27	FVSA	Futures	77.77	80.59	76.27	79.08	18860.0
2021-09-27	FXXP	Futures	443.2	443.7	438.5	439.3	40920.0

> showing 50 of 122 rows — these rows as CSV

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