PREVIEW / futures_daily / 2020-01-09

all futures daily files

  file:    by_date/futures_daily/2020/2020-01-09.parquet
  size:    10 KB
  rows:    120

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-01-09	ES	Futures	3522.19	3538.94	3518.41	3538.13	1297679.0
2020-01-09	NQ	Futures	10264.39	10348.69	10245.75	10333.5	457262.0
2020-01-09	YM	Futures	30216.5	30406.6	30188.1	30381.4	181585.0
2020-01-09	CL	Futures	61.5	61.83	60.14	61.06	750933.0
2020-01-09	GC	Futures	1916.4	1922.2	1895.8	1912.2	372880.0
2020-01-09	ZN	Futures	127.622509	127.792858	127.405701	127.746399	1594105.0
2020-01-09	A6	Futures	0.70481	0.70645	0.70327	0.70337	77314.0
2020-01-09	AD	Futures	0.77315	0.77365	0.76897	0.77053	79875.0
2020-01-09	ALI	Futures	2183.19	2202.49	2183.19	2192.24	226.0
2020-01-09	B	Futures	53.96	54.04	52.78	53.45	364446.0
2020-01-09	B6	Futures	1.3306	1.3332	1.322	1.3265	93817.0
2020-01-09	BR	Futures	0.19961	0.19961	0.1979	0.1981	179.0
2020-01-09	BTC	Futures	12308.9	12384.6	11823.8	11952.6	10399.0
2020-01-09	BZ	Futures	53.03	53.27	52.03	52.69	50520.0
2020-01-09	C	Futures	1726.0	1762.0	1721.0	1757.0	6769.0
2020-01-09	CB	Futures	238.875	240.349	238.404	239.082	144.0
2020-01-09	CC	Futures	1633.0	1677.0	1633.0	1671.0	16924.0
2020-01-09	CNH	Futures	6.9028	6.9079	6.8906	6.9005	561.0
2020-01-09	CSC	Futures	3.359	3.361	3.338	3.342	65.0
2020-01-09	CT	Futures	66.54	67.39	66.16	67.24	22487.0
2020-01-09	DC	Futures	28.04	28.04	27.86	27.9	135.0
2020-01-09	DX	Futures	94.133	94.415	94.104	94.305	11371.0
2020-01-09	E1	Futures	1.17833	1.18153	1.17696	1.17924	22394.0
2020-01-09	E6	Futures	1.20151	1.20286	1.19979	1.20135	146070.0
2020-01-09	E7	Futures	1.1952	1.1965	1.1936	1.1951	2098.0
2020-01-09	EBM	Futures	209.07	210.99	209.07	210.72	27665.0
2020-01-09	ED	Futures	95.3229	95.3326	95.3132	95.3277	194516.0
2020-01-09	ER	Futures	98.377	98.382	98.377	98.377	45483.0
2020-01-09	ESG	Futures	291.28	291.68	289.29	289.29	22.0
2020-01-09	EW	Futures	2166.6	2174.0	2161.2	2168.1	12418.0
2020-01-09	FBON	Futures	143.05	143.24	142.92	143.01	465.0
2020-01-09	FBTP	Futures	127.69	128.31	127.63	128.21	92787.0
2020-01-09	FBTS	Futures	108.124	108.201	108.105	108.182	44611.0
2020-01-09	FCE	Futures	5492.9	5501.9	5462.5	5470.7	65030.0
2020-01-09	FDAX	Futures	14161.3	14299.8	14153.9	14259.6	101492.0
2020-01-09	FDIV	Futures	162.0	162.28	162.0	162.1	5.0
2020-01-09	FDXM	Futures	13973.1	14120.3	13973.1	14080.6	49264.0
2020-01-09	FESX	Futures	3327.7	3343.5	3324.2	3331.2	838487.0
2020-01-09	FEU3	Futures	99.085	99.09	99.085	99.09	100.0
2020-01-09	FGBL	Futures	163.63	163.82	163.34	163.47	736337.0
2020-01-09	FGBM	Futures	133.54	133.54	133.35	133.41	569775.0
2020-01-09	FGBS	Futures	112.664	112.669	112.613	112.629	368103.0
2020-01-09	FGBX	Futures	209.24	209.85	208.57	208.86	62906.0
2020-01-09	FMWO	Futures	7929.1	7947.2	7924.5	7930.2	7557.0
2020-01-09	FOAT	Futures	151.28	151.6	151.19	151.35	213257.0
2020-01-09	FTDX	Futures	3094.6	3121.7	3094.6	3108.7	183.0
2020-01-09	FTI	Futures	587.63	589.74	585.76	586.63	25031.0
2020-01-09	FTUK	Futures	7065.3	7097.2	7053.1	7065.8	76550.0
2020-01-09	FVSA	Futures	124.11	124.11	120.36	122.23	26143.0
2020-01-09	FXXP	Futures	382.4	382.8	380.6	381.1	53035.0

> showing 50 of 120 rows — these rows as CSV

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