PREVIEW / futures_daily / 2020-01-17

all futures daily files

  file:    by_date/futures_daily/2020/2020-01-17.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-17	ES	Futures	3582.14	3596.72	3581.33	3591.05	1312253.0
2020-01-17	NQ	Futures	10480.31	10540.25	10472.29	10523.33	438669.0
2020-01-17	YM	Futures	30713.2	30836.1	30710.1	30749.0	170084.0
2020-01-17	CL	Futures	60.11	60.51	59.8	60.08	415846.0
2020-01-17	GC	Futures	1910.6	1920.9	1906.1	1919.6	264926.0
2020-01-17	ZN	Futures	127.963207	128.071611	127.761886	127.901262	1390519.0
2020-01-17	A6	Futures	0.70799	0.70952	0.70532	0.70604	69449.0
2020-01-17	AD	Futures	0.7727	0.7732	0.77063	0.77134	53418.0
2020-01-17	ALI	Futures	2194.6	2198.19	2190.7	2191.6	28.0
2020-01-17	B	Futures	52.89	53.63	52.72	53.02	238639.0
2020-01-17	B6	Futures	1.3281	1.3326	1.3209	1.3224	82884.0
2020-01-17	BR	Futures	0.19348	0.19445	0.19311	0.19445	1766.0
2020-01-17	BTC	Futures	13286.6	13771.7	13218.4	13529.1	6895.0
2020-01-17	BZ	Futures	52.19	52.51	51.98	52.27	35541.0
2020-01-17	C	Futures	1856.0	1908.0	1836.0	1904.0	15224.0
2020-01-17	CB	Futures	237.991	242.177	237.284	237.284	78.0
2020-01-17	CC	Futures	1766.0	1837.0	1754.0	1830.0	28188.0
2020-01-17	CNH	Futures	6.8546	6.8566	6.8347	6.8402	172.0
2020-01-17	CSC	Futures	3.398	3.413	3.394	3.396	40.0
2020-01-17	CT	Futures	66.58	67.89	66.54	67.77	19673.0
2020-01-17	DC	Futures	28.46	28.7	28.41	28.49	302.0
2020-01-17	DX	Futures	94.216	94.546	94.157	94.496	12417.0
2020-01-17	E1	Futures	1.18838	1.18895	1.18278	1.18495	25246.0
2020-01-17	E6	Futures	1.20399	1.20463	1.19849	1.1993	143037.0
2020-01-17	E7	Futures	1.1978	1.1982	1.192	1.1931	2374.0
2020-01-17	EBM	Futures	212.37	213.47	211.82	213.19	16179.0
2020-01-17	ED	Futures	95.3083	95.318	95.3083	95.3083	158865.0
2020-01-17	ER	Futures	98.372	98.377	98.372	98.372	18172.0
2020-01-17	EW	Futures	2211.2	2220.1	2204.1	2207.4	13847.0
2020-01-17	FBON	Futures	142.77	142.99	142.76	142.84	378.0
2020-01-17	FBTP	Futures	127.92	128.28	127.63	128.1	101605.0
2020-01-17	FBTS	Futures	108.086	108.115	108.009	108.066	51810.0
2020-01-17	FCE	Futures	5491.5	5536.0	5484.3	5526.4	88722.0
2020-01-17	FDAX	Futures	14254.3	14337.4	14240.6	14286.1	90832.0
2020-01-17	FDIV	Futures	161.12	161.12	160.61	160.61	30.0
2020-01-17	FDXM	Futures	14070.2	14153.7	14061.8	14106.7	47136.0
2020-01-17	FESX	Futures	3325.0	3350.6	3322.4	3342.7	1042691.0
2020-01-17	FGBL	Futures	163.96	164.12	163.77	163.91	484661.0
2020-01-17	FGBM	Futures	133.56	133.58	133.48	133.52	261513.0
2020-01-17	FGBS	Futures	112.629	112.634	112.613	112.619	153831.0
2020-01-17	FGBX	Futures	210.12	210.6	209.55	210.01	43118.0
2020-01-17	FMWO	Futures	8034.5	8057.2	8032.3	8037.9	1304.0
2020-01-17	FOAT	Futures	151.54	151.81	151.48	151.62	88967.0
2020-01-17	FTDX	Futures	3168.5	3175.0	3153.9	3166.5	58.0
2020-01-17	FTI	Futures	586.34	589.31	585.91	588.49	29866.0
2020-01-17	FTUK	Futures	7101.9	7155.9	7089.7	7141.8	95076.0
2020-01-17	FVSA	Futures	114.37	115.22	112.24	114.37	27256.0
2020-01-17	FXXP	Futures	383.3	386.2	383.0	385.6	72836.0
2020-01-17	G	Futures	121.55	122.01	121.48	121.72	203609.0
2020-01-17	GF	Futures	305.587	306.59	304.108	306.326	2783.0

> showing 50 of 120 rows — these rows as CSV

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