PREVIEW / etf_daily / 2016-10-19

all etf daily files

  file:    by_date/etf_daily/2016/2016-10-19.parquet
  size:    51 KB
  rows:    1,296

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-10-19	SPY	ETF	214.02	214.64	213.6	214.28	66519200.0
2016-10-19	QQQ	ETF	117.77	118.02	117.64	117.85	13702918.0
2016-10-19	IWM	ETF	121.17	121.95	120.5	121.49	18477400.0
2016-10-19	DIA	ETF	181.85	182.41	181.57	182.0	1503700.0
2016-10-19	GLD	ETF	121.13	121.46	120.89	121.11	6019800.0
2016-10-19	TLT	ETF	132.37	133.27	132.32	132.97	6941300.0
2016-10-19	AADR	ETF	41.3	41.67	41.3	41.35	3400.0
2016-10-19	AAXJ	ETF	60.02	60.27	59.94	60.2	2149200.0
2016-10-19	ACTX	ETF	10.6201	10.6201	8.8501	10.6201	2516.0
2016-10-19	ACWI	ETF	58.48	58.65	58.39	58.55	848400.0
2016-10-19	ACWV	ETF	74.58	74.59	74.33	74.51	269800.0
2016-10-19	ACWX	ETF	41.05	41.22	41.04	41.15	112376.0
2016-10-19	ADRE	ETF	35.79	35.8209	35.7399	35.78	2929.0
2016-10-19	AFK	ETF	20.31	20.9191	19.92	20.25	6061.0
2016-10-19	AFTY	ETF	13.537	13.537	13.537	13.537	500.0
2016-10-19	AGG	ETF	111.68	111.83	111.64	111.8	1550000.0
2016-10-19	AGGY	ETF	51.71	51.8	51.71	51.76	11200.0
2016-10-19	AGNG	ETF	15.79	15.79	15.79	15.79	200.0
2016-10-19	AGQ	ETF	40.75	40.91	40.14	40.62	121500.0
2016-10-19	AGZ	ETF	114.99	115.21	114.97	115.13	10060.0
2016-10-19	AIA	ETF	49.6996	49.94	49.6996	49.86	5156.0
2016-10-19	AIQ	ETF	7.9	7.9	7.75	7.8	15430.0
2016-10-19	AIRR	ETF	19.93	20.08	19.87	20.07	5900.0
2016-10-19	AIVI	ETF	37.9	38.17	37.9	38.11	17600.0
2016-10-19	ALTY	ETF	15.23	15.3	15.138	15.21	8700.0
2016-10-19	AMJ	ETF	31.36	31.63	31.26	31.47	1928105.0
2016-10-19	AMLP	ETF	63.2	63.65	63.1	63.45	1501020.0
2016-10-19	AMZA	ETF	109.0	109.88	108.5	109.2	8490.0
2016-10-19	ANGL	ETF	29.2	29.2	29.11	29.17	183800.0
2016-10-19	AOA	ETF	46.9	47.0	46.82	46.95	65800.0
2016-10-19	AOK	ETF	33.05	33.114	33.0	33.06	26837.0
2016-10-19	AOM	ETF	35.65	35.73	35.58	35.68	115375.0
2016-10-19	AOR	ETF	40.49	40.68	40.49	40.61	116521.0
2016-10-19	ARGT	ETF	24.28	24.4	24.01	24.37	15500.0
2016-10-19	ARKG	ETF	17.79	17.79	17.79	17.79	100.0
2016-10-19	ARKK	ETF	20.66	20.66	20.65	20.65	700.0
2016-10-19	ARKQ	ETF	21.374	21.374	21.35	21.36	1600.0
2016-10-19	ARKW	ETF	24.88	24.88	24.88	24.88	200.0
2016-10-19	ASET	ETF	25.9399	25.9399	25.9399	25.9399	100.0
2016-10-19	ASHR	ETF	24.79	24.8	24.71	24.75	2030100.0
2016-10-19	ASHS	ETF	35.13	35.26	35.13	35.22	9000.0
2016-10-19	ATMP	ETF	23.21	23.42	23.12	23.26	21000.0
2016-10-19	BAB	ETF	30.8	30.9599	30.767	30.93	76974.0
2016-10-19	BAL	ETF	46.97	47.2	46.89	47.19	13153.0
2016-10-19	BBC	ETF	19.63	19.63	19.43	19.4575	7612.0
2016-10-19	BBH	ETF	107.44	107.56	106.69	106.7	59900.0
2016-10-19	BBP	ETF	30.46	30.46	30.099	30.145	1200.0
2016-10-19	BCM	ETF	26.875	26.875	26.8492	26.8492	3467.0
2016-10-19	BFOR	ETF	7.9625	7.985	7.9325	7.98	26400.0
2016-10-19	BIB	ETF	42.0	42.0	41.21	41.21	399750.0

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

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