PREVIEW / etf_daily / 2016-08-30

all etf daily files

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

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-30	SPY	ETF	218.26	218.59	217.35	218.0	58114500.0
2016-08-30	QQQ	ETF	116.73	117.09	116.16	116.56	19843301.0
2016-08-30	IWM	ETF	123.83	124.17	123.38	123.93	14031300.0
2016-08-30	DIA	ETF	184.93	185.15	184.02	184.51	1866700.0
2016-08-30	GLD	ETF	125.73	125.95	124.88	125.03	9877000.0
2016-08-30	TLT	ETF	140.17	140.26	139.67	139.67	5161800.0
2016-08-30	AADR	ETF	40.6	40.71	40.51	40.71	4800.0
2016-08-30	AAXJ	ETF	59.23	59.44	59.03	59.12	425700.0
2016-08-30	ACTX	ETF	3.54	3.54	2.95	2.95	582.0
2016-08-30	ACWF	ETF	23.96	23.96	23.96	23.96	2281.0
2016-08-30	ACWI	ETF	58.97	59.01	58.65	58.78	1505400.0
2016-08-30	ACWV	ETF	76.45	76.49	75.94	76.07	119900.0
2016-08-30	ACWX	ETF	41.17	41.22	40.988	41.05	195549.0
2016-08-30	ADRE	ETF	34.1387	34.2006	34.1387	34.2006	908.0
2016-08-30	AFK	ETF	20.43	20.57	20.09	20.09	11261.0
2016-08-30	AGG	ETF	112.71	112.71	112.55	112.59	1712300.0
2016-08-30	AGGY	ETF	52.17	52.36	52.143	52.18	32500.0
2016-08-30	AGQ	ETF	46.34	46.68	45.6	45.73	274900.0
2016-08-30	AGZ	ETF	115.36	115.7107	115.36	115.57	11806.0
2016-08-30	AGZD	ETF	24.01	24.01	24.01	24.01	600.0
2016-08-30	AIA	ETF	48.74	48.74	48.64	48.7164	28708.0
2016-08-30	AIQ	ETF	6.35	6.35	6.26	6.26	7903.0
2016-08-30	AIRR	ETF	19.87	19.876	19.87	19.876	500.0
2016-08-30	AIVI	ETF	38.99	39.08	38.81	38.87	72500.0
2016-08-30	ALTY	ETF	15.731	15.76	15.696	15.736	5300.0
2016-08-30	AMJ	ETF	31.26	31.41	30.94	31.09	1851898.0
2016-08-30	AMLP	ETF	62.95	63.25	62.6	62.95	958020.0
2016-08-30	AMZA	ETF	115.9	116.49	114.81	115.3	8590.0
2016-08-30	ANGL	ETF	28.79	28.84	28.77	28.83	73100.0
2016-08-30	AOA	ETF	47.4	47.5	47.17	47.27	29000.0
2016-08-30	AOK	ETF	33.32	33.4599	33.32	33.36	31489.0
2016-08-30	AOM	ETF	36.06	36.1499	35.9	35.99	61703.0
2016-08-30	AOR	ETF	41.06	41.0899	40.9284	41.01	32824.0
2016-08-30	ARGT	ETF	22.63	22.83	22.46	22.47	101500.0
2016-08-30	ARKG	ETF	18.255	18.255	18.255	18.255	100.0
2016-08-30	ARKK	ETF	20.835	20.835	20.835	20.835	200.0
2016-08-30	ARKQ	ETF	21.75	21.76	21.58	21.62	2100.0
2016-08-30	ARKW	ETF	24.411	24.411	24.411	24.411	100.0
2016-08-30	ASEA	ETF	13.98	14.02	13.98	14.0	2900.0
2016-08-30	ASHR	ETF	25.07	25.07	24.98	25.02	667400.0
2016-08-30	ASHS	ETF	35.17	35.17	35.08	35.12	1300.0
2016-08-30	ATMP	ETF	22.71	22.71	22.47	22.61	126400.0
2016-08-30	BAB	ETF	31.75	31.75	31.67	31.7	115023.0
2016-08-30	BAL	ETF	44.0	44.0001	43.37	43.95	13387.0
2016-08-30	BBC	ETF	20.3601	20.55	20.3601	20.4425	4355.0
2016-08-30	BBH	ETF	114.48	115.16	114.02	114.16	42000.0
2016-08-30	BBP	ETF	30.76	30.85	30.417	30.539	4000.0
2016-08-30	BCM	ETF	26.17	26.17	26.015	26.015	2542.0
2016-08-30	BFOR	ETF	8.0875	8.12	8.0875	8.1175	46000.0
2016-08-30	BIB	ETF	46.66	47.52	46.3	46.65	430893.0

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

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