PREVIEW / futures_daily / 2017-12-29

all futures daily files

  file:    by_date/futures_daily/2017/2017-12-29.parquet
  size:    10 KB
  rows:    112

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
2017-12-29	ES	Futures	2918.0	2932.67	2899.52	2908.49	1092038.0
2017-12-29	NQ	Futures	7547.67	7574.9	7475.93	7505.8	210114.0
2017-12-29	YM	Futures	26162.7	26244.9	26014.0	26085.7	74016.0
2017-12-29	CL	Futures	59.9	60.5	59.81	60.41	464478.0
2017-12-29	GC	Futures	1644.9	1660.5	1643.2	1659.9	241274.0
2017-12-29	ZN	Futures	122.252861	122.499681	122.237435	122.468828	699637.0
2017-12-29	A6	Futures	0.80193	0.80491	0.8011	0.80347	56812.0
2017-12-29	AD	Futures	0.80874	0.81209	0.80726	0.81122	76612.0
2017-12-29	B	Futures	47.37	47.96	47.37	47.88	157948.0
2017-12-29	B6	Futures	1.4005	1.4123	1.3996	1.41	91094.0
2017-12-29	BR	Futures	0.22759	0.22782	0.22759	0.22782	3.0
2017-12-29	BTC	Futures	17885.1	19217.0	17718.6	18531.9	1078.0
2017-12-29	BZ	Futures	46.7	47.29	46.7	47.23	12234.0
2017-12-29	C	Futures	1262.0	1271.0	1250.0	1260.0	6136.0
2017-12-29	CB	Futures	277.201	277.201	275.996	275.996	12.0
2017-12-29	CC	Futures	1418.0	1431.0	1400.0	1412.0	15244.0
2017-12-29	CNH	Futures	6.6864	6.6883	6.6661	6.669	106.0
2017-12-29	CSC	Futures	3.221	3.225	3.221	3.225	81.0
2017-12-29	CT	Futures	91.98	92.19	91.36	91.84	12399.0
2017-12-29	DC	Futures	25.33	25.42	25.26	25.42	134.0
2017-12-29	DX	Futures	86.731	86.749	86.214	86.234	21612.0
2017-12-29	E1	Futures	1.24682	1.25386	1.24657	1.25361	17121.0
2017-12-29	E6	Futures	1.35967	1.36942	1.35933	1.36896	172363.0
2017-12-29	E7	Futures	1.3528	1.3626	1.3524	1.3621	3804.0
2017-12-29	EBM	Futures	171.81	172.08	171.27	171.54	7161.0
2017-12-29	ED	Futures	95.399	95.4136	95.399	95.4087	100474.0
2017-12-29	ER	Futures	98.337	98.337	98.332	98.332	33015.0
2017-12-29	EW	Futures	2029.5	2038.2	2011.6	2017.3	15198.0
2017-12-29	FBON	Futures	126.27	126.3	125.47	125.62	223.0
2017-12-29	FBTP	Futures	111.6	111.74	111.12	111.2	55367.0
2017-12-29	FBTS	Futures	103.439	103.485	103.384	103.393	38682.0
2017-12-29	FCE	Futures	4777.9	4782.3	4737.6	4750.6	40222.0
2017-12-29	FDAX	Futures	13484.6	13484.6	13303.5	13393.8	52172.0
2017-12-29	FDXM	Futures	13504.8	13516.3	13326.1	13416.5	15364.0
2017-12-29	FESX	Futures	2873.1	2873.9	2842.9	2853.5	565330.0
2017-12-29	FEU3	Futures	99.016	99.016	99.011	99.011	3.0
2017-12-29	FGBL	Futures	149.92	150.01	149.64	149.84	250042.0
2017-12-29	FGBM	Futures	129.35	129.4	129.26	129.38	168483.0
2017-12-29	FGBS	Futures	112.342	112.382	112.331	112.377	164569.0
2017-12-29	FGBX	Futures	169.03	169.26	168.37	168.58	20033.0
2017-12-29	FMWO	Futures	6960.8	6977.2	6945.7	6959.7	1202.0
2017-12-29	FOAT	Futures	138.21	138.49	137.96	138.1	58423.0
2017-12-29	FTDX	Futures	2520.4	2520.9	2508.5	2517.9	116.0
2017-12-29	FTI	Futures	506.68	506.96	502.84	504.0	13192.0
2017-12-29	FTUK	Futures	6612.2	6683.4	6607.8	6672.9	49266.0
2017-12-29	FVSA	Futures	289.71	297.09	288.66	291.82	13404.0
2017-12-29	FXXP	Futures	331.2	331.2	329.1	330.0	23011.0
2017-12-29	G	Futures	115.33	115.6	115.21	115.43	65327.0
2017-12-29	GF	Futures	315.49	316.517	312.409	315.652	2359.0
2017-12-29	GSCI	Futures	513.87	515.33	513.18	514.51	132.0

> showing 50 of 112 rows — these rows as CSV

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