PREVIEW / futures_daily / 2017-08-22

all futures daily files

  file:    by_date/futures_daily/2017/2017-08-22.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-22	ES	Futures	2638.81	2667.33	2638.26	2665.7	1367156.0
2017-08-22	NQ	Futures	6812.55	6914.83	6811.38	6910.42	307895.0
2017-08-22	YM	Futures	22938.2	23147.5	22932.9	23135.9	121880.0
2017-08-22	CL	Futures	48.84	49.48	48.61	49.09	864387.0
2017-08-22	GC	Futures	1650.4	1651.7	1637.6	1642.7	268988.0
2017-08-22	ZN	Futures	124.950302	124.965692	124.627115	124.657894	980893.0
2017-08-22	A6	Futures	0.81492	0.81646	0.81102	0.81215	74305.0
2017-08-22	AD	Futures	0.80996	0.81229	0.80655	0.8098	61250.0
2017-08-22	ALI	Futures	2700.17	2700.17	2700.17	2700.17	0.0
2017-08-22	B	Futures	36.22	36.57	35.95	36.28	313918.0
2017-08-22	B6	Futures	1.349	1.3502	1.3399	1.3418	86190.0
2017-08-22	BR	Futures	0.23414	0.23544	0.23236	0.23422	1278.0
2017-08-22	BZ	Futures	35.84	36.25	35.65	35.97	36291.0
2017-08-22	C	Futures	1495.0	1511.0	1482.0	1492.0	5275.0
2017-08-22	CB	Futures	319.342	319.342	317.452	317.452	36.0
2017-08-22	CC	Futures	1404.0	1408.0	1386.0	1400.0	15627.0
2017-08-22	CNH	Futures	6.8882	6.8934	6.8875	6.8932	28.0
2017-08-22	CSC	Futures	3.571	3.577	3.507	3.54	118.0
2017-08-22	CT	Futures	80.25	80.61	80.25	80.39	2.0
2017-08-22	DC	Futures	29.81	29.89	29.25	29.46	410.0
2017-08-22	DX	Futures	86.864	87.298	86.822	87.271	19612.0
2017-08-22	E1	Futures	1.27923	1.27923	1.26965	1.27014	18482.0
2017-08-22	E6	Futures	1.35523	1.35666	1.34755	1.34829	143913.0
2017-08-22	E7	Futures	1.3481	1.3494	1.3405	1.3412	2748.0
2017-08-22	EBM	Futures	169.52	170.92	168.41	168.69	7947.0
2017-08-22	ED	Futures	95.6007	95.6007	95.5935	95.5935	123982.0
2017-08-22	ER	Futures	98.337	98.342	98.337	98.342	21872.0
2017-08-22	EW	Futures	1796.8	1814.4	1795.9	1812.6	12566.0
2017-08-22	FBON	Futures	125.13	125.2	124.64	124.82	297.0
2017-08-22	FBTP	Futures	109.32	109.36	108.36	108.58	108358.0
2017-08-22	FBTS	Futures	103.073	103.073	103.0	103.009	39429.0
2017-08-22	FCE	Futures	4565.1	4596.8	4562.4	4590.6	61368.0
2017-08-22	FDAX	Futures	12759.2	12897.7	12745.0	12868.7	74079.0
2017-08-22	FDXM	Futures	12675.4	12817.8	12666.0	12789.5	22082.0
2017-08-22	FESX	Futures	2803.9	2825.1	2799.8	2820.2	607654.0
2017-08-22	FGBL	Futures	149.34	149.41	149.09	149.38	468511.0
2017-08-22	FGBM	Futures	129.57	129.61	129.5	129.6	262477.0
2017-08-22	FGBS	Futures	112.392	112.407	112.372	112.402	179790.0
2017-08-22	FGBX	Futures	169.09	169.27	168.36	168.83	28493.0
2017-08-22	FMWO	Futures	6478.1	6500.7	6468.6	6488.8	701.0
2017-08-22	FOAT	Futures	136.32	136.35	136.05	136.27	80846.0
2017-08-22	FTDX	Futures	2262.1	2281.2	2257.6	2278.7	135.0
2017-08-22	FTI	Futures	479.77	483.94	479.08	483.02	22945.0
2017-08-22	FTUK	Futures	6322.1	6381.8	6322.1	6375.7	72052.0
2017-08-22	FVSA	Futures	533.73	533.73	513.26	516.41	13460.0
2017-08-22	FXXP	Futures	318.2	320.1	318.0	319.9	17090.0
2017-08-22	G	Futures	115.92	116.13	115.75	115.96	156147.0
2017-08-22	GF	Futures	305.083	312.537	305.083	311.441	4908.0
2017-08-22	GSCI	Futures	450.32	452.3	450.32	451.52	15.0
2017-08-22	HE	Futures	90.769	91.189	88.669	89.404	22786.0

> showing 50 of 109 rows — these rows as CSV

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