PREVIEW / futures_daily / 2020-03-05

all futures daily files

  file:    by_date/futures_daily/2020/2020-03-05.parquet
  size:    10 KB
  rows:    121

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-03-05	ES	Futures	3358.03	3362.89	3236.26	3256.78	2807262.0
2020-03-05	NQ	Futures	10195.85	10208.18	9876.7	9920.28	954104.0
2020-03-05	YM	Futures	28272.6	28327.2	27216.1	27368.3	461258.0
2020-03-05	CL	Futures	48.12	48.57	46.61	46.87	704591.0
2020-03-05	GC	Futures	1997.4	2042.9	1994.2	2033.7	362995.0
2020-03-05	ZN	Futures	134.54488	135.721838	134.467449	135.551489	22117.0
2020-03-05	A6	Futures	0.67867	0.68051	0.67498	0.676	117597.0
2020-03-05	AD	Futures	0.75264	0.753	0.74987	0.75063	92753.0
2020-03-05	ALI	Futures	2083.56	2083.56	2064.3	2067.31	79.0
2020-03-05	B	Futures	43.94	44.27	42.28	42.52	361035.0
2020-03-05	B6	Futures	1.3055	1.3153	1.3045	1.313	116660.0
2020-03-05	BR	Futures	0.178	0.178	0.17488	0.1757	123.0
2020-03-05	BTC	Futures	12856.6	13506.4	12842.0	13426.1	3734.0
2020-03-05	BZ	Futures	42.76	43.06	41.15	41.39	39679.0
2020-03-05	C	Futures	1798.0	1800.0	1760.0	1763.0	3359.0
2020-03-05	CB	Futures	219.384	219.942	217.488	217.488	11.0
2020-03-05	CC	Futures	1720.0	1724.0	1690.0	1701.0	19989.0
2020-03-05	CNH	Futures	6.8851	6.9095	6.8851	6.908	983.0
2020-03-05	CSC	Futures	3.189	3.194	3.181	3.185	85.0
2020-03-05	CT	Futures	60.91	61.76	60.39	60.99	15836.0
2020-03-05	DC	Futures	26.24	26.37	26.16	26.37	157.0
2020-03-05	DX	Futures	94.482	94.546	93.653	93.944	24401.0
2020-03-05	E1	Futures	1.19557	1.20985	1.19398	1.20494	50609.0
2020-03-05	E6	Futures	1.20006	1.21201	1.19849	1.20733	336945.0
2020-03-05	E7	Futures	1.1938	1.2056	1.1922	1.201	7908.0
2020-03-05	EBM	Futures	205.77	206.89	205.49	206.33	19034.0
2020-03-05	ED	Futures	96.014	96.1256	96.0092	96.0843	710843.0
2020-03-05	ER	Futures	98.475	98.48	98.45	98.47	120320.0
2020-03-05	ESG	Futures	272.43	275.74	269.37	271.32	1496.0
2020-03-05	EW	Futures	1989.8	1993.2	1904.2	1925.8	32552.0
2020-03-05	FBON	Futures	147.05	147.05	146.12	146.47	1689.0
2020-03-05	FBTP	Futures	131.93	132.27	130.69	131.25	193492.0
2020-03-05	FBTS	Futures	108.403	108.47	108.095	108.278	125712.0
2020-03-05	FCE	Futures	4969.2	4982.8	4756.6	4847.5	153198.0
2020-03-05	FDAX	Futures	12858.4	12922.4	12421.7	12643.7	180676.0
2020-03-05	FDIV	Futures	140.48	140.48	140.29	140.29	84.0
2020-03-05	FDXM	Futures	12725.2	12760.7	12265.7	12485.0	140038.0
2020-03-05	FESX	Futures	3023.8	3037.9	2905.8	2965.7	2285102.0
2020-03-05	FGBL	Futures	169.92	171.16	169.77	170.84	1020463.0
2020-03-05	FGBM	Futures	135.56	135.98	135.5	135.86	567569.0
2020-03-05	FGBS	Futures	113.127	113.252	113.117	113.202	482172.0
2020-03-05	FGBX	Futures	230.4	235.24	230.3	233.73	87227.0
2020-03-05	FMWO	Futures	7416.5	7417.6	7214.6	7379.1	10182.0
2020-03-05	FOAT	Futures	156.58	157.21	156.34	157.07	265792.0
2020-03-05	FTDX	Futures	2996.1	2996.1	2895.1	2926.3	114.0
2020-03-05	FTI	Futures	539.36	539.94	519.97	530.06	56608.0
2020-03-05	FTUK	Futures	6405.3	6418.5	6184.4	6293.2	169128.0
2020-03-05	FVSA	Futures	203.37	244.04	203.37	215.98	89272.0
2020-03-05	FXXP	Futures	354.3	355.2	341.2	347.5	131327.0
2020-03-05	G	Futures	124.48	125.38	124.4	125.16	242936.0

> showing 50 of 121 rows — these rows as CSV

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