PREVIEW / etf_daily / 2016-09-30

all etf daily files

  file:    by_date/etf_daily/2016/2016-09-30.parquet
  size:    53 KB
  rows:    1,326

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-09-30	SPY	ETF	215.65	217.12	215.36	216.3	117202900.0
2016-09-30	QQQ	ETF	118.145	119.07	118.03	118.72	25543200.0
2016-09-30	IWM	ETF	123.42	124.78	122.86	124.21	31764500.0
2016-09-30	DIA	ETF	182.13	183.44	181.97	182.78	4583000.0
2016-09-30	GLD	ETF	126.52	126.55	125.24	125.64	11204300.0
2016-09-30	TLT	ETF	138.55	138.64	136.87	137.51	11747100.0
2016-09-30	AADR	ETF	40.6	40.6	40.54	40.58	65300.0
2016-09-30	AAXJ	ETF	60.32	60.67	60.19	60.52	936700.0
2016-09-30	ACTX	ETF	5.31	5.31	5.31	5.31	11.0
2016-09-30	ACWI	ETF	58.95	59.3	58.81	59.1	986600.0
2016-09-30	ACWV	ETF	76.26	76.41	76.02	76.19	116800.0
2016-09-30	ACWX	ETF	41.36	41.6	41.26	41.48	259726.0
2016-09-30	ADRE	ETF	34.91	34.93	34.77	34.835	15875.0
2016-09-30	AFK	ETF	20.26	20.75	20.2	20.73	9612.0
2016-09-30	AFTY	ETF	13.46	13.52	13.44	13.52	3300.0
2016-09-30	AGG	ETF	112.57	112.65	112.27	112.42	3679800.0
2016-09-30	AGGY	ETF	51.97	52.01	51.93	52.0	19400.0
2016-09-30	AGQ	ETF	50.58	50.59	47.75	48.11	271100.0
2016-09-30	AGZ	ETF	115.77	115.77	115.5	115.6036	12147.0
2016-09-30	AGZD	ETF	23.97	23.97	23.885	23.885	1200.0
2016-09-30	AIA	ETF	49.82	50.2	49.77	50.1	26007.0
2016-09-30	AIQ	ETF	6.69	6.91	6.66	6.86	16090.0
2016-09-30	AIRR	ETF	20.39	20.57	20.39	20.508	28300.0
2016-09-30	AIVI	ETF	38.69	38.98	38.66	38.95	8200.0
2016-09-30	ALTY	ETF	15.75	15.75	15.65	15.66	12100.0
2016-09-30	AMJ	ETF	31.54	31.6489	31.27	31.5	1998728.0
2016-09-30	AMLP	ETF	63.55	63.6	63.0	63.45	1027420.0
2016-09-30	AMZA	ETF	116.5	117.5	114.7	115.5	19810.0
2016-09-30	ANGL	ETF	28.87	28.95	28.81	28.93	280600.0
2016-09-30	AOA	ETF	47.33	47.58	47.27	47.48	28400.0
2016-09-30	AOK	ETF	33.38	33.4299	33.3101	33.38	24180.0
2016-09-30	AOM	ETF	35.99	36.13	35.98	36.09	34608.0
2016-09-30	AOR	ETF	41.0	41.1999	40.94	41.15	84946.0
2016-09-30	ARGT	ETF	23.68	23.92	23.68	23.88	58300.0
2016-09-30	ARKG	ETF	19.792	19.915	19.792	19.915	400.0
2016-09-30	ARKK	ETF	22.011	22.182	22.011	22.18	800.0
2016-09-30	ARKQ	ETF	22.37	22.37	22.37	22.37	200.0
2016-09-30	ARKW	ETF	25.72	25.72	25.641	25.641	900.0
2016-09-30	ASEA	ETF	14.05	14.05	14.04	14.04	600.0
2016-09-30	ASHR	ETF	24.46	24.63	24.46	24.58	535100.0
2016-09-30	ASHS	ETF	34.8	34.8	34.55	34.69	6200.0
2016-09-30	ATMP	ETF	23.32	23.45	23.19	23.37	114500.0
2016-09-30	BAB	ETF	31.47	31.4797	31.28	31.39	194698.0
2016-09-30	BAL	ETF	44.61	45.2199	44.61	45.1	4112.0
2016-09-30	BBC	ETF	22.17	22.682	22.05	22.65	5105.0
2016-09-30	BBH	ETF	114.28	115.73	113.33	115.21	42200.0
2016-09-30	BBP	ETF	32.83	33.46	32.7	33.36	11900.0
2016-09-30	BCM	ETF	26.52	26.52	26.4975	26.515	2229.0
2016-09-30	BFOR	ETF	8.0075	8.0925	8.0025	8.0925	19200.0
2016-09-30	BIB	ETF	47.58	48.87	46.6	48.46	541224.0

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

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