PREVIEW / futures_daily / 2021-11-03

all futures daily files

  file:    by_date/futures_daily/2021/2021-11-03.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-11-03	ES	Futures	5198.41	5238.62	5189.13	5233.28	1074650.0
2021-11-03	NQ	Futures	18401.61	18618.4	18375.66	18599.95	448135.0
2021-11-03	YM	Futures	39083.2	39241.0	38920.0	39207.3	134646.0
2021-11-03	CL	Futures	61.55	61.56	59.05	59.91	546577.0
2021-11-03	GC	Futures	2087.4	2087.5	2051.6	2057.9	257427.0
2021-11-03	ZN	Futures	133.145804	133.400051	132.700872	132.9869	1821995.0
2021-11-03	A6	Futures	0.76192	0.76474	0.75998	0.76351	90051.0
2021-11-03	AD	Futures	0.81811	0.81998	0.81491	0.81922	74646.0
2021-11-03	ALI	Futures	3035.32	3058.67	2961.38	2974.17	800.0
2021-11-03	B	Futures	57.47	57.56	55.44	56.05	380105.0
2021-11-03	B6	Futures	1.3819	1.3897	1.3812	1.3885	82618.0
2021-11-03	BR	Futures	0.14126	0.14557	0.14126	0.14455	8429.0
2021-11-03	BTC	Futures	83756.3	84263.5	80285.2	83077.9	5495.0
2021-11-03	BZ	Futures	56.1	56.2	54.13	54.73	50062.0
2021-11-03	C	Futures	1428.0	1442.0	1421.0	1434.0	10923.0
2021-11-03	CB	Futures	152.674	152.871	152.674	152.674	12.0
2021-11-03	CC	Futures	1578.0	1593.0	1544.0	1557.0	28296.0
2021-11-03	CNH	Futures	6.1485	6.1526	6.1403	6.1414	251.0
2021-11-03	CSC	Futures	2.469	2.473	2.417	2.438	284.0
2021-11-03	CT	Futures	109.67	111.5	108.03	110.9	23911.0
2021-11-03	DC	Futures	23.53	23.56	23.07	23.17	526.0
2021-11-03	DX	Futures	90.921	91.032	90.632	90.683	22475.0
2021-11-03	E1	Futures	1.22594	1.23154	1.22516	1.23131	27444.0
2021-11-03	E6	Futures	1.23114	1.23512	1.22939	1.23459	161836.0
2021-11-03	E7	Futures	1.2245	1.2285	1.2227	1.2278	3268.0
2021-11-03	EBM	Futures	431.32	435.0	424.71	425.45	25652.0
2021-11-03	ED	Futures	96.515	96.5247	96.5054	96.5199	186110.0
2021-11-03	ER	Futures	98.484	98.499	98.484	98.494	81601.0
2021-11-03	ESG	Futures	433.62	437.44	433.43	437.0	236.0
2021-11-03	EW	Futures	3066.5	3116.2	3058.2	3104.9	14409.0
2021-11-03	FBON	Futures	147.78	148.38	147.78	148.06	588.0
2021-11-03	FBTP	Futures	136.55	137.25	136.53	136.88	156291.0
2021-11-03	FBTS	Futures	110.167	110.206	110.08	110.118	91834.0
2021-11-03	FCE	Futures	6999.8	7063.5	6990.7	7027.6	51426.0
2021-11-03	FDAX	Futures	17035.3	17124.0	17004.3	17043.8	51800.0
2021-11-03	FDIV	Futures	186.23	186.23	186.18	186.18	10.0
2021-11-03	FDXM	Futures	17076.2	17173.8	17053.7	17092.3	36707.0
2021-11-03	FDXS	Futures	16935.7	17013.3	16895.4	16933.6	13864.0
2021-11-03	FESX	Futures	4101.1	4141.3	4098.7	4118.3	526595.0
2021-11-03	FGBL	Futures	166.75	167.19	166.48	166.84	803099.0
2021-11-03	FGBM	Futures	134.15	134.41	134.03	134.16	498965.0
2021-11-03	FGBS	Futures	112.574	112.614	112.524	112.554	344426.0
2021-11-03	FGBX	Futures	224.81	227.21	223.91	225.72	101493.0
2021-11-03	FMWO	Futures	11340.4	11444.2	11334.5	11356.9	1693.0
2021-11-03	FOAT	Futures	154.41	154.9	154.25	154.56	155640.0
2021-11-03	FTDX	Futures	4007.8	4041.1	4004.7	4019.6	79.0
2021-11-03	FTI	Futures	774.65	782.21	773.89	778.49	11846.0
2021-11-03	FTUK	Futures	7158.8	7174.2	7125.8	7134.7	61544.0
2021-11-03	FVSA	Futures	64.11	64.11	58.94	62.38	21673.0
2021-11-03	FXXP	Futures	456.4	459.8	455.3	457.7	40490.0

> showing 50 of 122 rows — these rows as CSV

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