PREVIEW / futures_daily / 2020-07-24

all futures daily files

  file:    by_date/futures_daily/2020/2020-07-24.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-07-24	ES	Futures	3635.65	3645.78	3592.31	3606.38	1761346.0
2020-07-24	NQ	Futures	12262.74	12299.3	11955.75	12139.13	652482.0
2020-07-24	YM	Futures	28451.3	28523.1	28174.8	28209.1	179326.0
2020-07-24	CL	Futures	29.96	30.41	29.67	30.13	353159.0
2020-07-24	GC	Futures	2263.0	2286.7	2257.8	2278.2	300174.0
2020-07-24	ZN	Futures	138.372857	138.527706	138.279948	138.326402	704619.0
2020-07-24	A6	Futures	0.73047	0.73314	0.72676	0.73016	90084.0
2020-07-24	AD	Futures	0.75723	0.75885	0.75505	0.75627	51704.0
2020-07-24	ALI	Futures	2061.89	2079.8	2055.82	2073.12	428.0
2020-07-24	B	Futures	28.19	28.6	27.88	28.24	191054.0
2020-07-24	B6	Futures	1.2936	1.3004	1.2916	1.2991	82898.0
2020-07-24	BR	Futures	0.15138	0.15328	0.15075	0.15241	2303.0
2020-07-24	BTC	Futures	13290.8	13311.3	13106.1	13256.6	825.0
2020-07-24	BZ	Futures	27.62	27.96	27.26	27.61	21918.0
2020-07-24	C	Futures	1398.0	1419.0	1396.0	1404.0	5317.0
2020-07-24	CB	Futures	190.466	191.777	190.466	191.777	1.0
2020-07-24	CC	Futures	1436.0	1476.0	1435.0	1459.0	13654.0
2020-07-24	CNH	Futures	6.9187	6.9444	6.9187	6.9319	358.0
2020-07-24	CSC	Futures	4.306	4.318	4.18	4.199	46.0
2020-07-24	CT	Futures	62.77	62.84	60.23	60.64	93.0
2020-07-24	DC	Futures	35.39	35.59	34.3	34.37	355.0
2020-07-24	DX	Futures	91.522	91.551	90.894	91.165	18247.0
2020-07-24	E1	Futures	1.2291	1.23568	1.22819	1.23318	19293.0
2020-07-24	E6	Futures	1.24577	1.25232	1.24411	1.25007	213788.0
2020-07-24	E7	Futures	1.2395	1.246	1.2379	1.2438	7502.0
2020-07-24	EBM	Futures	220.35	223.05	220.35	222.45	15564.0
2020-07-24	ED	Futures	96.4378	96.4378	96.433	96.433	45551.0
2020-07-24	ER	Futures	98.372	98.372	98.362	98.367	45419.0
2020-07-24	ESG	Futures	290.11	290.69	289.33	290.69	17.0
2020-07-24	EW	Futures	1985.7	1988.9	1959.0	1962.8	10922.0
2020-07-24	FBON	Futures	146.77	146.77	146.02	146.21	60.0
2020-07-24	FBTP	Futures	133.03	133.16	132.63	132.87	72408.0
2020-07-24	FBTS	Futures	108.861	108.909	108.822	108.861	38377.0
2020-07-24	FCE	Futures	4806.4	4816.1	4756.6	4787.1	63973.0
2020-07-24	FDAX	Futures	13804.1	13837.0	13561.9	13632.0	90033.0
2020-07-24	FDIV	Futures	148.25	148.34	147.77	147.77	350.0
2020-07-24	FDXM	Futures	13757.0	13789.8	13513.5	13582.8	51596.0
2020-07-24	FESX	Futures	3084.1	3093.4	3035.2	3049.0	955215.0
2020-07-24	FEU3	Futures	99.119	99.119	99.114	99.114	115.0
2020-07-24	FGBL	Futures	168.9	169.1	168.11	168.25	608328.0
2020-07-24	FGBM	Futures	134.84	134.9	134.59	134.63	397785.0
2020-07-24	FGBS	Futures	112.744	112.749	112.694	112.704	373150.0
2020-07-24	FGBX	Futures	229.37	230.79	226.85	227.43	48911.0
2020-07-24	FMWO	Futures	8052.7	8064.6	7997.0	8044.4	2049.0
2020-07-24	FOAT	Futures	156.45	156.52	155.66	155.79	139408.0
2020-07-24	FTDX	Futures	3179.9	3179.9	3098.1	3113.4	110.0
2020-07-24	FTI	Futures	529.69	530.63	521.52	524.77	29109.0
2020-07-24	FTUK	Futures	5806.0	5814.9	5731.3	5754.5	85815.0
2020-07-24	FVSA	Futures	242.06	250.66	239.8	243.42	24057.0
2020-07-24	FXXP	Futures	340.2	340.6	336.4	337.8	64511.0

> showing 50 of 121 rows — these rows as CSV

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