PREVIEW / etf_daily / 2016-08-15

all etf daily files

  file:    by_date/etf_daily/2016/2016-08-15.parquet
  size:    52 KB
  rows:    1,292

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
2016-08-15	SPY	ETF	218.89	219.5	218.88	219.09	49813500.0
2016-08-15	QQQ	ETF	117.33	117.97	117.31	117.7	11777762.0
2016-08-15	IWM	ETF	122.46	123.69	122.43	123.4	22048000.0
2016-08-15	DIA	ETF	186.4	186.88	186.33	186.52	1561500.0
2016-08-15	GLD	ETF	127.62	128.25	127.6	127.84	4530800.0
2016-08-15	TLT	ETF	139.34	139.63	138.75	138.76	5108600.0
2016-08-15	AADR	ETF	41.1	41.1	41.05	41.05	600.0
2016-08-15	AAXJ	ETF	59.68	60.07	59.68	60.02	3588800.0
2016-08-15	ACTX	ETF	2.95	3.54	2.891	2.891	1073.0
2016-08-15	ACWI	ETF	59.25	59.47	59.25	59.37	358000.0
2016-08-15	ACWV	ETF	78.13	78.2	77.93	77.94	121900.0
2016-08-15	ACWX	ETF	41.57	41.69	41.54	41.59	678847.0
2016-08-15	ADRE	ETF	34.7	34.9399	34.7	34.7959	11441.0
2016-08-15	AFK	ETF	21.49	21.49	20.93	21.41	19309.0
2016-08-15	AFTY	ETF	13.91	13.99	13.88	13.97	13800.0
2016-08-15	AGG	ETF	112.57	112.62	112.42	112.43	1950500.0
2016-08-15	AGGY	ETF	52.18	52.28	52.09	52.12	22300.0
2016-08-15	AGQ	ETF	51.85	52.34	51.73	52.03	83400.0
2016-08-15	AGZ	ETF	115.65	115.6899	115.49	115.67	12890.0
2016-08-15	AGZD	ETF	23.91	23.91	23.85	23.85	2000.0
2016-08-15	AIA	ETF	48.45	48.77	48.45	48.69	60297.0
2016-08-15	AIQ	ETF	6.15	6.33	6.15	6.27	17952.0
2016-08-15	AIRR	ETF	19.62	19.74	19.62	19.72	9800.0
2016-08-15	AIVI	ETF	39.21	39.4	39.21	39.33	23800.0
2016-08-15	ALTY	ETF	15.79	15.79	15.7	15.71	2000.0
2016-08-15	AMJ	ETF	32.24	32.36	32.06	32.11	1840096.0
2016-08-15	AMLP	ETF	64.0	64.1	63.45	63.55	1730580.0
2016-08-15	AMZA	ETF	115.3	116.5	115.0	116.1	13690.0
2016-08-15	ANGL	ETF	28.53	28.57	28.49	28.55	78500.0
2016-08-15	AOA	ETF	47.51	47.67	47.48	47.64	45500.0
2016-08-15	AOK	ETF	33.54	33.54	33.321	33.43	473085.0
2016-08-15	AOM	ETF	36.15	36.17	36.03	36.09	301629.0
2016-08-15	AOR	ETF	41.05	41.23	41.05	41.15	159419.0
2016-08-15	ARGT	ETF	23.22	23.29	23.09	23.12	15600.0
2016-08-15	ARKG	ETF	19.0	19.29	19.0	19.28	800.0
2016-08-15	ARKQ	ETF	21.55	21.59	21.53	21.59	1800.0
2016-08-15	ARKW	ETF	25.0	25.0	24.838	24.963	7600.0
2016-08-15	ASEA	ETF	14.23	14.34	14.23	14.3	11300.0
2016-08-15	ASHR	ETF	25.81	26.07	25.8	26.02	3711700.0
2016-08-15	ASHS	ETF	35.51	35.89	35.51	35.76	89500.0
2016-08-15	ATMP	ETF	23.36	23.36	23.19	23.24	29000.0
2016-08-15	BAB	ETF	31.63	31.6499	31.55	31.56	185757.0
2016-08-15	BAL	ETF	46.96	47.0053	45.53	45.55	26226.0
2016-08-15	BBC	ETF	21.0	21.3495	21.0	21.1042	6883.0
2016-08-15	BBH	ETF	116.11	117.0	115.93	116.75	64600.0
2016-08-15	BBP	ETF	31.005	31.304	31.005	31.188	4100.0
2016-08-15	BCM	ETF	26.24	26.59	26.24	26.59	8183.0
2016-08-15	BFOR	ETF	8.02	8.0975	8.02	8.0825	62000.0
2016-08-15	BIB	ETF	50.25	51.1906	49.97	50.85	626894.0
2016-08-15	BICK	ETF	22.9999	23.116	22.9999	23.11	2188.0

> showing 50 of 1,292 rows — these rows as CSV

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