PREVIEW / futures_daily / 2020-03-02

all futures daily files

  file:    by_date/futures_daily/2020/2020-03-02.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-03-02	ES	Futures	3132.04	3340.75	3120.43	3310.24	3689149.0
2020-03-02	NQ	Futures	9576.75	10189.26	9433.37	10083.73	1373357.0
2020-03-02	YM	Futures	26461.0	28052.0	26098.6	27796.8	637915.0
2020-03-02	CL	Futures	44.62	48.56	44.23	47.73	949471.0
2020-03-02	GC	Futures	1942.0	1965.6	1921.9	1944.5	443528.0
2020-03-02	ZN	Futures	133.832511	134.637798	133.383409	134.064805	85076.0
2020-03-02	A6	Futures	0.66513	0.67364	0.66493	0.66985	221050.0
2020-03-02	AD	Futures	0.74952	0.75683	0.74952	0.75456	149291.0
2020-03-02	ALI	Futures	2055.58	2066.11	2046.55	2065.81	113.0
2020-03-02	B	Futures	41.64	45.25	41.17	44.15	417555.0
2020-03-02	B6	Futures	1.2977	1.3037	1.2924	1.2961	171264.0
2020-03-02	BFX	Futures	4166.5	4166.5	4163.0	4163.0	8.0
2020-03-02	BR	Futures	0.18156	0.18238	0.18115	0.18222	321.0
2020-03-02	BTC	Futures	12623.0	13185.2	12469.7	13104.9	2157.0
2020-03-02	BZ	Futures	40.6	43.7	40.06	42.97	47286.0
2020-03-02	C	Futures	1839.0	1848.0	1802.0	1820.0	3990.0
2020-03-02	CB	Futures	220.249	220.834	217.21	217.21	33.0
2020-03-02	CC	Futures	1756.0	1762.0	1718.0	1743.0	27937.0
2020-03-02	CNH	Futures	6.9525	6.9556	6.9198	6.9291	1374.0
2020-03-02	CSC	Futures	3.194	3.194	3.19	3.194	13.0
2020-03-02	CT	Futures	60.13	61.85	59.4	61.02	31985.0
2020-03-02	DC	Futures	26.29	26.43	26.16	26.35	109.0
2020-03-02	DX	Futures	95.104	95.162	94.279	94.457	45678.0
2020-03-02	E1	Futures	1.18689	1.19797	1.18427	1.19443	76410.0
2020-03-02	E6	Futures	1.19192	1.20598	1.19004	1.20367	440293.0
2020-03-02	E7	Futures	1.1853	1.1996	1.1839	1.1974	13345.0
2020-03-02	EBM	Futures	207.7	208.25	204.95	205.22	11114.0
2020-03-02	ED	Futures	95.706	95.8782	95.706	95.8079	1308828.0
2020-03-02	ER	Futures	98.465	98.48	98.445	98.475	160272.0
2020-03-02	ESG	Futures	265.48	276.55	264.7	276.14	4860.0
2020-03-02	EW	Futures	1895.2	1974.6	1877.1	1973.0	44571.0
2020-03-02	FBON	Futures	145.34	146.25	145.33	145.7	2470.0
2020-03-02	FBTP	Futures	131.3	131.34	129.56	130.23	336654.0
2020-03-02	FBTS	Futures	108.278	108.365	108.066	108.182	151924.0
2020-03-02	FCE	Futures	4848.9	4918.5	4694.2	4821.3	260769.0
2020-03-02	FDAX	Futures	12420.1	12915.5	12285.2	12546.4	208985.0
2020-03-02	FDIV	Futures	139.09	139.36	139.09	139.36	60.0
2020-03-02	FDXM	Futures	12285.6	12749.2	12131.0	12389.0	349611.0
2020-03-02	FESX	Futures	2898.7	3006.2	2865.3	2941.0	3061526.0
2020-03-02	FGBL	Futures	169.85	170.38	169.06	169.86	1985802.0
2020-03-02	FGBM	Futures	135.33	135.59	135.14	135.45	948959.0
2020-03-02	FGBS	Futures	113.071	113.117	113.016	113.112	924699.0
2020-03-02	FGBX	Futures	231.01	232.98	228.13	231.18	177131.0
2020-03-02	FMWO	Futures	7218.0	7376.8	7030.9	7252.1	15626.0
2020-03-02	FOAT	Futures	156.06	156.46	155.72	156.03	533670.0
2020-03-02	FTDX	Futures	2926.3	2944.4	2809.7	2869.0	198.0
2020-03-02	FTI	Futures	523.81	531.88	508.02	520.11	76083.0
2020-03-02	FTUK	Futures	6148.7	6330.8	6069.9	6221.9	294378.0
2020-03-02	FVSA	Futures	198.89	216.79	185.47	200.52	122710.0
2020-03-02	FXXP	Futures	346.7	349.8	335.8	342.6	215315.0

> showing 50 of 122 rows — these rows as CSV

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