PREVIEW / etf_daily / 2016-08-22

all etf daily files

  file:    by_date/etf_daily/2016/2016-08-22.parquet
  size:    51 KB
  rows:    1,289

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-22	SPY	ETF	218.26	218.8	217.83	218.53	61368800.0
2016-08-22	QQQ	ETF	117.09	117.55	116.87	117.35	14500622.0
2016-08-22	IWM	ETF	122.68	123.34	122.33	123.22	16929700.0
2016-08-22	DIA	ETF	184.95	185.51	184.46	185.12	3152400.0
2016-08-22	GLD	ETF	127.63	127.92	127.45	127.78	8627200.0
2016-08-22	TLT	ETF	139.65	140.14	139.37	139.88	5549700.0
2016-08-22	AAXJ	ETF	59.05	59.05	58.72	58.86	708800.0
2016-08-22	ACTX	ETF	3.54	3.54	2.95	3.54	248.0
2016-08-22	ACWI	ETF	59.0	59.18	58.9	59.1	1251900.0
2016-08-22	ACWV	ETF	77.0	77.2	76.91	77.15	304900.0
2016-08-22	ACWX	ETF	41.2	41.31	41.115	41.29	279043.0
2016-08-22	ADRE	ETF	34.31	34.31	34.04	34.13	11567.0
2016-08-22	AFK	ETF	20.95	21.25	20.7701	21.21	4512.0
2016-08-22	AFTY	ETF	13.595	13.62	13.595	13.619	1200.0
2016-08-22	AGG	ETF	112.66	112.74	112.56	112.65	1808500.0
2016-08-22	AGGY	ETF	52.025	52.22	52.011	52.15	4600.0
2016-08-22	AGQ	ETF	47.59	47.62	46.97	47.3	264400.0
2016-08-22	AGZ	ETF	115.71	115.71	115.57	115.63	14719.0
2016-08-22	AIA	ETF	48.5	48.5	48.24	48.31	25806.0
2016-08-22	AIQ	ETF	6.17	6.21	6.15	6.19	19267.0
2016-08-22	AIRR	ETF	19.52	19.68	19.52	19.68	38200.0
2016-08-22	AIVI	ETF	38.96	39.2	38.96	39.08	8200.0
2016-08-22	ALTY	ETF	15.81	15.81	15.665	15.665	4100.0
2016-08-22	AMJ	ETF	31.75	31.99	31.6	31.73	1680296.0
2016-08-22	AMLP	ETF	63.25	63.35	62.9	63.05	1067060.0
2016-08-22	AMZA	ETF	116.4	116.4	114.8	115.1	13860.0
2016-08-22	ANGL	ETF	28.67	28.69	28.6	28.68	161300.0
2016-08-22	AOA	ETF	47.38	47.5	47.33	47.48	22100.0
2016-08-22	AOK	ETF	33.38	33.507	33.35	33.42	53114.0
2016-08-22	AOM	ETF	36.04	36.1725	35.9401	36.08	62688.0
2016-08-22	AOR	ETF	40.97	41.1199	40.97	41.02	47584.0
2016-08-22	ARGT	ETF	22.83	22.84	22.76	22.83	27000.0
2016-08-22	ARKG	ETF	18.96	18.96	18.96	18.96	100.0
2016-08-22	ARKK	ETF	21.12	21.166	21.12	21.166	1200.0
2016-08-22	ARKQ	ETF	21.5	21.51	21.478	21.507	2800.0
2016-08-22	ARKW	ETF	24.72	24.72	24.51	24.51	200.0
2016-08-22	ASEA	ETF	14.1	14.16	14.1	14.16	7100.0
2016-08-22	ASHR	ETF	25.37	25.4	25.3	25.36	1032000.0
2016-08-22	ASHS	ETF	35.45	35.45	35.29	35.37	8900.0
2016-08-22	ASHX	ETF	23.1001	23.103	23.1001	23.1008	510.0
2016-08-22	ATMP	ETF	23.43	23.43	22.96	23.03	26900.0
2016-08-22	BAB	ETF	31.62	31.6999	31.5	31.66	226567.0
2016-08-22	BAL	ETF	45.13	45.6	45.13	45.22	9357.0
2016-08-22	BBC	ETF	20.61	21.01	20.61	21.01	11719.0
2016-08-22	BBH	ETF	116.8	118.51	116.8	118.49	69300.0
2016-08-22	BBP	ETF	30.98	31.55	30.98	31.55	9100.0
2016-08-22	BCM	ETF	26.7984	26.8	26.715	26.715	5776.0
2016-08-22	BFOR	ETF	8.03	8.0825	8.03	8.07	47600.0
2016-08-22	BIB	ETF	49.66	51.32	49.66	51.09	599624.0
2016-08-22	BICK	ETF	22.71	22.71	22.537	22.537	352.0

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

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