PREVIEW / futures_daily / 2017-08-09

all futures daily files

  file:    by_date/futures_daily/2017/2017-08-09.parquet
  size:    10 KB
  rows:    111

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-09	ES	Futures	2684.45	2689.34	2672.5	2687.71	1555517.0
2017-08-09	NQ	Futures	6951.27	6964.49	6890.73	6962.14	377648.0
2017-08-09	YM	Futures	23280.7	23289.1	23215.2	23275.4	142068.0
2017-08-09	CL	Futures	50.4	51.14	50.3	50.98	858250.0
2017-08-09	GC	Futures	1611.0	1634.7	1610.7	1627.8	290974.0
2017-08-09	ZN	Futures	124.257758	124.673284	124.257758	124.442436	1351014.0
2017-08-09	A6	Futures	0.81266	0.81266	0.8066	0.80948	103135.0
2017-08-09	AD	Futures	0.8035	0.80355	0.79994	0.80106	61457.0
2017-08-09	ALI	Futures	2648.51	2648.51	2648.51	2648.51	0.0
2017-08-09	B	Futures	36.37	36.97	36.24	36.86	265606.0
2017-08-09	B6	Futures	1.3593	1.3633	1.357	1.3606	94990.0
2017-08-09	BFX	Futures	4778.5	4778.5	4738.1	4738.1	4.0
2017-08-09	BR	Futures	0.23585	0.23585	0.23418	0.23477	1887.0
2017-08-09	BZ	Futures	35.95	36.63	35.95	36.55	26143.0
2017-08-09	C	Futures	1582.0	1584.0	1552.0	1569.0	5980.0
2017-08-09	CB	Futures	324.177	325.394	323.812	324.786	53.0
2017-08-09	CC	Futures	1501.0	1507.0	1472.0	1489.0	32526.0
2017-08-09	CNH	Futures	6.9383	6.9383	6.9234	6.9234	218.0
2017-08-09	CSC	Futures	3.458	3.536	3.446	3.536	71.0
2017-08-09	CT	Futures	83.29	83.96	83.2	83.82	10.0
2017-08-09	DC	Futures	28.83	29.51	28.59	29.49	573.0
2017-08-09	DX	Futures	87.279	87.573	87.181	87.242	20176.0
2017-08-09	E1	Futures	1.26449	1.28095	1.26412	1.27763	51354.0
2017-08-09	E6	Futures	1.34904	1.35059	1.34194	1.34933	207001.0
2017-08-09	E7	Futures	1.342	1.3435	1.3349	1.3422	4827.0
2017-08-09	EBM	Futures	180.1	180.1	179.27	179.82	4134.0
2017-08-09	ED	Futures	95.5983	95.5983	95.5935	95.5935	133433.0
2017-08-09	ER	Futures	98.342	98.342	98.337	98.342	96778.0
2017-08-09	EW	Futures	1855.8	1855.8	1836.2	1842.3	15644.0
2017-08-09	FBON	Futures	125.03	125.38	124.91	125.12	447.0
2017-08-09	FBTP	Futures	109.45	109.67	109.05	109.4	88988.0
2017-08-09	FBTS	Futures	103.0	103.027	102.982	103.009	32535.0
2017-08-09	FCE	Futures	4651.8	4654.9	4597.5	4619.9	112268.0
2017-08-09	FDAX	Futures	12843.4	12868.7	12730.2	12789.7	99004.0
2017-08-09	FDIV	Futures	145.13	145.3	145.13	145.3	2.0
2017-08-09	FDXM	Futures	12766.5	12789.5	12651.4	12711.0	35151.0
2017-08-09	FESX	Futures	2847.1	2852.0	2815.3	2829.2	1144097.0
2017-08-09	FEU3	Futures	99.016	99.016	99.016	99.016	5.0
2017-08-09	FGBL	Futures	148.33	148.98	148.3	148.89	608720.0
2017-08-09	FGBM	Futures	129.16	129.41	129.15	129.36	375050.0
2017-08-09	FGBS	Futures	112.272	112.327	112.272	112.312	194103.0
2017-08-09	FGBX	Futures	166.89	168.43	166.71	168.16	34565.0
2017-08-09	FMWO	Futures	6556.7	6556.7	6528.1	6538.8	976.0
2017-08-09	FOAT	Futures	135.79	136.16	135.7	136.13	112807.0
2017-08-09	FTDX	Futures	2275.2	2275.2	2247.6	2255.6	184.0
2017-08-09	FTI	Futures	488.2	489.59	486.03	486.81	31105.0
2017-08-09	FTUK	Futures	6441.0	6447.4	6410.3	6432.3	104434.0
2017-08-09	FVSA	Futures	421.25	452.4	416.8	442.02	43920.0
2017-08-09	FXXP	Futures	323.4	323.9	321.6	322.7	37484.0
2017-08-09	G	Futures	115.45	115.82	115.36	115.73	135636.0

> showing 50 of 111 rows — these rows as CSV

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