PREVIEW / futures_daily / 2017-08-29

all futures daily files

  file:    by_date/futures_daily/2017/2017-08-29.parquet
  size:    9 KB
  rows:    109

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-08-29	ES	Futures	2645.33	2661.09	2631.2	2659.46	1615262.0
2017-08-29	NQ	Futures	6841.65	6906.89	6791.4	6900.13	334338.0
2017-08-29	YM	Futures	22993.2	23128.5	22880.0	23123.2	159945.0
2017-08-29	CL	Futures	48.09	48.2	46.96	47.66	895643.0
2017-08-29	GC	Futures	1680.2	1694.7	1667.6	1678.2	460450.0
2017-08-29	ZN	Futures	125.11959	125.673625	125.11959	125.273489	2641883.0
2017-08-29	A6	Futures	0.81554	0.81995	0.81194	0.81728	92703.0
2017-08-29	AD	Futures	0.81209	0.81789	0.81052	0.81194	67873.0
2017-08-29	ALI	Futures	2691.04	2691.04	2691.04	2691.04	0.0
2017-08-29	B	Futures	36.14	36.32	35.75	36.23	299417.0
2017-08-29	B6	Futures	1.3524	1.3573	1.3492	1.3514	87643.0
2017-08-29	BR	Futures	0.23604	0.23604	0.23539	0.23539	322.0
2017-08-29	BZ	Futures	35.86	36.01	35.45	35.92	30873.0
2017-08-29	C	Futures	1572.0	1572.0	1532.0	1540.0	13020.0
2017-08-29	CB	Futures	319.027	319.027	314.965	317.421	13.0
2017-08-29	CC	Futures	1484.0	1492.0	1443.0	1455.0	19534.0
2017-08-29	CNH	Futures	6.821	6.8309	6.821	6.8309	4.0
2017-08-29	CSC	Futures	3.458	3.466	3.445	3.46	43.0
2017-08-29	CT	Futures	82.0	82.69	81.87	82.35	37.0
2017-08-29	DC	Futures	28.74	28.79	28.6	28.71	62.0
2017-08-29	DX	Futures	86.079	86.289	85.486	86.078	51870.0
2017-08-29	E1	Futures	1.29151	1.30453	1.28611	1.28918	40901.0
2017-08-29	E6	Futures	1.37384	1.38433	1.37006	1.37522	287421.0
2017-08-29	E7	Futures	1.3665	1.377	1.3629	1.368	6145.0
2017-08-29	EBM	Futures	168.69	169.52	167.85	169.25	2894.0
2017-08-29	ED	Futures	95.5935	95.5983	95.5935	95.5935	150203.0
2017-08-29	ER	Futures	98.342	98.342	98.337	98.337	22103.0
2017-08-29	EW	Futures	1809.0	1814.5	1797.5	1812.5	12904.0
2017-08-29	FBON	Futures	124.82	125.18	124.76	124.96	308.0
2017-08-29	FBTP	Futures	108.85	109.03	108.58	108.93	93601.0
2017-08-29	FBTS	Futures	103.027	103.054	103.0	103.045	34715.0
2017-08-29	FCE	Futures	4513.6	4524.8	4466.2	4501.5	112050.0
2017-08-29	FDAX	Futures	12682.3	12712.9	12490.7	12575.5	130128.0
2017-08-29	FDXM	Futures	12609.5	12633.6	12413.8	12498.1	45593.0
2017-08-29	FESX	Futures	2771.2	2779.4	2743.4	2764.7	1262922.0
2017-08-29	FGBL	Futures	149.92	150.52	149.89	150.28	789594.0
2017-08-29	FGBM	Futures	129.91	130.09	129.89	130.01	473069.0
2017-08-29	FGBS	Futures	112.462	112.487	112.442	112.457	407272.0
2017-08-29	FGBX	Futures	169.74	171.36	169.62	170.87	57838.0
2017-08-29	FMWO	Futures	6460.2	6499.5	6450.7	6485.2	708.0
2017-08-29	FOAT	Futures	136.55	136.93	136.48	136.79	121043.0
2017-08-29	FTDX	Futures	2242.1	2243.6	2210.6	2228.1	190.0
2017-08-29	FTI	Futures	474.03	474.54	468.2	472.18	40289.0
2017-08-29	FTUK	Futures	6361.5	6369.7	6291.9	6337.3	115640.0
2017-08-29	FVSA	Futures	533.73	566.79	516.41	527.43	37731.0
2017-08-29	FXXP	Futures	315.1	315.2	311.3	313.5	39294.0
2017-08-29	G	Futures	116.69	117.0	116.61	116.89	248096.0
2017-08-29	GF	Futures	320.101	322.348	312.537	313.579	3039.0
2017-08-29	GSCI	Futures	450.62	451.7	450.02	451.46	124.0
2017-08-29	HE	Futures	86.255	86.43	83.735	84.295	20615.0

> showing 50 of 109 rows — these rows as CSV

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