PREVIEW / futures_daily / 2020-09-01

all futures daily files

  file:    by_date/futures_daily/2020/2020-09-01.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
2020-09-01	ES	Futures	3931.96	3973.32	3921.83	3969.95	1283622.0
2020-09-01	NQ	Futures	14055.05	14309.23	14035.61	14290.37	518997.0
2020-09-01	YM	Futures	30413.5	30708.2	30282.8	30673.9	165105.0
2020-09-01	CL	Futures	30.97	31.41	30.89	30.92	285146.0
2020-09-01	GC	Futures	2331.0	2363.4	2325.6	2337.1	304894.0
2020-09-01	ZN	Futures	138.094129	138.341887	137.954765	138.326402	66545.0
2020-09-01	A6	Futures	0.75886	0.76267	0.75701	0.75793	113624.0
2020-09-01	AD	Futures	0.77824	0.78118	0.77565	0.77636	78499.0
2020-09-01	ALI	Futures	2147.46	2176.64	2147.46	2164.73	338.0
2020-09-01	B	Futures	29.07	29.46	28.98	29.06	206724.0
2020-09-01	B6	Futures	1.3573	1.3691	1.3564	1.3591	126804.0
2020-09-01	BR	Futures	0.1458	0.14706	0.14502	0.14584	11.0
2020-09-01	BTC	Futures	15871.3	16472.1	15695.8	16303.4	8919.0
2020-09-01	BZ	Futures	28.42	28.82	28.35	28.42	19914.0
2020-09-01	C	Futures	1571.0	1599.0	1571.0	1593.0	3287.0
2020-09-01	CB	Futures	169.763	170.754	169.737	170.246	18.0
2020-09-01	CC	Futures	1749.0	1763.0	1741.0	1751.0	19305.0
2020-09-01	CNH	Futures	6.7517	6.7532	6.717	6.7394	1289.0
2020-09-01	CSC	Futures	3.304	3.304	3.295	3.304	35.0
2020-09-01	CT	Futures	65.68	66.35	65.39	65.39	22.0
2020-09-01	DC	Futures	26.76	26.84	26.55	26.79	78.0
2020-09-01	DX	Futures	89.03	89.252	88.6	89.191	33197.0
2020-09-01	E1	Futures	1.25738	1.26249	1.24829	1.2492	40870.0
2020-09-01	E6	Futures	1.28129	1.28923	1.27737	1.27829	263767.0
2020-09-01	E7	Futures	1.2748	1.2828	1.271	1.2719	11480.0
2020-09-01	EBM	Futures	225.14	227.84	224.24	227.54	4575.0
2020-09-01	ED	Futures	96.4378	96.4451	96.4354	96.4403	203898.0
2020-09-01	ER	Futures	98.401	98.401	98.396	98.401	33542.0
2020-09-01	ESG	Futures	321.18	322.45	321.18	322.45	9.0
2020-09-01	EW	Futures	2049.8	2066.1	2027.9	2063.3	12866.0
2020-09-01	FBON	Futures	145.72	146.0	145.55	145.91	898.0
2020-09-01	FBTP	Futures	132.08	132.84	132.08	132.69	176299.0
2020-09-01	FBTS	Futures	108.909	109.016	108.871	108.958	85985.0
2020-09-01	FCE	Futures	4841.6	4857.6	4758.3	4803.1	72259.0
2020-09-01	FDAX	Futures	13749.9	13944.9	13645.8	13766.9	85810.0
2020-09-01	FDIV	Futures	150.28	150.28	149.29	149.29	65.0
2020-09-01	FDXM	Futures	13699.8	13894.6	13596.1	13717.3	69606.0
2020-09-01	FESX	Futures	3017.6	3056.4	2992.7	3020.4	862523.0
2020-09-01	FEU3	Futures	99.149	99.149	99.144	99.144	100.0
2020-09-01	FGBL	Futures	167.64	168.33	167.37	167.89	1008775.0
2020-09-01	FGBM	Futures	134.56	134.81	134.48	134.68	807741.0
2020-09-01	FGBS	Futures	112.669	112.729	112.669	112.714	748589.0
2020-09-01	FGBX	Futures	223.05	225.43	221.82	223.96	89360.0
2020-09-01	FMWO	Futures	8628.7	8677.3	8601.4	8633.4	4016.0
2020-09-01	FOAT	Futures	155.34	155.72	155.11	155.61	291559.0
2020-09-01	FTDX	Futures	3225.3	3225.3	3177.3	3183.4	26.0
2020-09-01	FTI	Futures	514.26	518.54	509.78	514.38	29575.0
2020-09-01	FTUK	Futures	5618.8	5650.0	5498.3	5530.5	153701.0
2020-09-01	FVSA	Futures	212.88	223.67	208.32	219.52	24111.0
2020-09-01	FXXP	Futures	339.7	340.9	334.7	336.8	42770.0

> showing 50 of 122 rows — these rows as CSV

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