PREVIEW / futures_daily / 2018-01-03

all futures daily files

  file:    by_date/futures_daily/2018/2018-01-03.parquet
  size:    10 KB
  rows:    113

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
2018-01-03	ES	Futures	2927.78	2950.06	2926.15	2946.53	1114548.0
2018-01-03	NQ	Futures	7628.19	7719.54	7625.84	7711.63	223243.0
2018-01-03	YM	Futures	26150.0	26268.1	26120.5	26236.5	93398.0
2018-01-03	CL	Futures	60.38	61.96	60.27	61.62	673859.0
2018-01-03	GC	Futures	1672.2	1677.3	1659.4	1671.6	353457.0
2018-01-03	ZN	Futures	122.114025	122.314566	122.067746	122.206583	955926.0
2018-01-03	A6	Futures	0.80501	0.80686	0.80275	0.80635	76130.0
2018-01-03	AD	Futures	0.81224	0.8132	0.8096	0.81056	57384.0
2018-01-03	B	Futures	47.64	48.71	47.54	48.58	260862.0
2018-01-03	B6	Futures	1.417	1.4193	1.4067	1.409	105289.0
2018-01-03	BR	Futures	0.23211	0.23309	0.23097	0.2329	1760.0
2018-01-03	BTC	Futures	19082.6	19787.0	18762.4	19178.6	719.0
2018-01-03	BZ	Futures	46.96	48.04	46.9	47.92	25878.0
2018-01-03	C	Futures	1271.0	1274.0	1250.0	1257.0	7403.0
2018-01-03	CB	Futures	275.626	275.626	274.668	274.73	32.0
2018-01-03	CC	Futures	1449.0	1450.0	1409.0	1423.0	21847.0
2018-01-03	CNH	Futures	6.6473	6.6631	6.6437	6.6493	25.0
2018-01-03	CSC	Futures	3.18	3.197	3.176	3.178	165.0
2018-01-03	CT	Futures	90.53	91.44	90.37	91.23	13372.0
2018-01-03	DC	Futures	25.0	25.2	25.0	25.05	170.0
2018-01-03	DX	Futures	85.984	86.388	85.961	86.3	17209.0
2018-01-03	E1	Futures	1.25592	1.25641	1.24524	1.24888	25655.0
2018-01-03	E6	Futures	1.3727	1.37384	1.36647	1.36817	184726.0
2018-01-03	E7	Futures	1.3662	1.3669	1.3597	1.3613	3770.0
2018-01-03	EBM	Futures	171.0	173.16	171.0	172.62	14410.0
2018-01-03	ED	Futures	95.3796	95.3942	95.3747	95.3796	389548.0
2018-01-03	ER	Futures	98.332	98.337	98.332	98.332	23845.0
2018-01-03	EW	Futures	2033.5	2045.2	2033.1	2040.6	19394.0
2018-01-03	FBON	Futures	125.18	125.8	125.18	125.53	313.0
2018-01-03	FBTP	Futures	110.16	110.82	110.16	110.54	93742.0
2018-01-03	FBTS	Futures	103.375	103.494	103.375	103.485	46837.0
2018-01-03	FCE	Futures	4732.2	4783.7	4730.4	4766.7	65054.0
2018-01-03	FDAX	Futures	13381.3	13506.3	13364.2	13472.6	67357.0
2018-01-03	FDIV	Futures	149.02	149.61	149.02	149.61	5.0
2018-01-03	FDXM	Futures	13407.2	13529.8	13386.4	13495.5	22548.0
2018-01-03	FESX	Futures	2842.9	2865.8	2838.8	2860.0	797688.0
2018-01-03	FEU3	Futures	99.006	99.011	99.006	99.011	60.0
2018-01-03	FGBL	Futures	149.45	149.97	149.4	149.75	607557.0
2018-01-03	FGBM	Futures	129.27	129.52	129.26	129.43	488075.0
2018-01-03	FGBS	Futures	112.352	112.402	112.352	112.377	309725.0
2018-01-03	FGBX	Futures	167.32	168.87	166.95	168.31	52111.0
2018-01-03	FMWO	Futures	6990.0	7021.5	6990.0	7020.4	1534.0
2018-01-03	FOAT	Futures	137.74	138.25	137.69	138.01	127026.0
2018-01-03	FTDX	Futures	2553.3	2599.7	2533.9	2589.7	486.0
2018-01-03	FTI	Futures	504.74	509.97	504.74	508.39	23088.0
2018-01-03	FTUK	Futures	6638.8	6673.8	6628.3	6657.6	74309.0
2018-01-03	FVSA	Futures	276.02	281.29	262.32	264.43	18390.0
2018-01-03	FXXP	Futures	330.0	332.2	329.9	331.5	22965.0
2018-01-03	G	Futures	114.44	115.24	114.41	115.17	178911.0
2018-01-03	GF	Futures	323.706	323.76	321.76	322.949	1272.0

> showing 50 of 113 rows — these rows as CSV

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