PREVIEW / futures_daily / 2020-02-27

all futures daily files

  file:    by_date/futures_daily/2020/2020-02-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
2020-02-27	ES	Futures	3348.31	3366.4	3180.1	3193.6	4734434.0
2020-02-27	NQ	Futures	10106.96	10183.81	9559.54	9615.17	1580041.0
2020-02-27	YM	Futures	28166.5	28331.4	26780.2	26834.8	689083.0
2020-02-27	CL	Futures	49.65	49.81	46.85	48.08	1011915.0
2020-02-27	GC	Futures	2003.2	2027.0	1995.6	2002.6	573289.0
2020-02-27	ZN	Futures	131.912211	132.779443	131.83478	132.252909	2733280.0
2020-02-27	A6	Futures	0.67159	0.676	0.67108	0.67518	127393.0
2020-02-27	AD	Futures	0.75557	0.75668	0.75229	0.7539	120649.0
2020-02-27	ALI	Futures	2046.25	2046.85	2030.6	2030.6	80.0
2020-02-27	B	Futures	44.69	44.79	42.86	44.0	506258.0
2020-02-27	B6	Futures	1.3092	1.3135	1.3046	1.308	124685.0
2020-02-27	BR	Futures	0.1834	0.1834	0.18136	0.1823	431.0
2020-02-27	BTC	Futures	12849.3	13221.7	12520.8	13061.1	2186.0
2020-02-27	BZ	Futures	43.65	43.76	41.72	42.83	51309.0
2020-02-27	C	Futures	1869.0	1876.0	1860.0	1862.0	3733.0
2020-02-27	CB	Futures	216.373	217.544	214.672	215.09	30.0
2020-02-27	CC	Futures	1792.0	1806.0	1780.0	1798.0	18028.0
2020-02-27	CNH	Futures	6.9864	6.9938	6.9653	6.97	621.0
2020-02-27	CSC	Futures	3.198	3.205	3.178	3.192	184.0
2020-02-27	CT	Futures	63.03	63.03	60.14	60.17	37201.0
2020-02-27	DC	Futures	26.19	26.21	25.88	25.97	299.0
2020-02-27	DX	Futures	96.055	96.084	95.405	95.566	28474.0
2020-02-27	E1	Futures	1.17067	1.18198	1.17033	1.17878	49873.0
2020-02-27	E6	Futures	1.17355	1.18697	1.17318	1.18481	369600.0
2020-02-27	E7	Futures	1.1673	1.1807	1.167	1.1786	10320.0
2020-02-27	EBM	Futures	211.54	211.61	210.17	210.44	13641.0
2020-02-27	ED	Futures	95.4805	95.5751	95.4781	95.5314	969585.0
2020-02-27	ER	Futures	98.416	98.44	98.416	98.426	161134.0
2020-02-27	ESG	Futures	274.68	276.67	266.33	266.67	4661.0
2020-02-27	EW	Futures	2016.3	2026.5	1930.9	1949.2	35635.0
2020-02-27	FBON	Futures	146.15	146.38	145.26	145.42	1752.0
2020-02-27	FBTP	Futures	131.53	131.93	130.84	131.42	245602.0
2020-02-27	FBTS	Futures	108.509	108.557	108.326	108.432	147043.0
2020-02-27	FCE	Futures	5019.8	5074.1	4870.6	4968.3	228403.0
2020-02-27	FDAX	Futures	13262.4	13321.6	12834.6	13094.2	249000.0
2020-02-27	FDIV	Futures	147.62	147.62	143.91	145.4	392.0
2020-02-27	FDXM	Futures	13104.3	13153.3	12670.9	12929.9	220447.0
2020-02-27	FESX	Futures	3088.1	3106.6	2981.5	3044.9	3278031.0
2020-02-27	FEU3	Futures	99.139	99.139	99.134	99.134	1.0
2020-02-27	FGBL	Futures	168.1	168.96	167.97	168.66	1348659.0
2020-02-27	FGBM	Futures	134.78	135.13	134.77	134.98	729418.0
2020-02-27	FGBS	Futures	112.895	112.976	112.88	112.941	771655.0
2020-02-27	FGBX	Futures	223.52	226.6	223.15	225.72	105010.0
2020-02-27	FMWO	Futures	7459.6	7486.8	7221.4	7353.0	23674.0
2020-02-27	FOAT	Futures	155.26	155.73	155.18	155.53	331247.0
2020-02-27	FTDX	Futures	3004.7	3004.7	2914.2	2951.9	241.0
2020-02-27	FTI	Futures	546.32	550.35	527.89	537.27	69016.0
2020-02-27	FTUK	Futures	6452.7	6502.0	6249.1	6363.6	274636.0
2020-02-27	FVSA	Futures	167.98	193.6	163.1	185.88	110764.0
2020-02-27	FXXP	Futures	360.7	363.1	348.0	354.9	164087.0

> showing 50 of 122 rows — these rows as CSV

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