PREVIEW / etf_daily / 2016-11-10

all etf daily files

  file:    by_date/etf_daily/2016/2016-11-10.parquet
  size:    54 KB
  rows:    1,338

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-11-10	SPY	ETF	217.3	218.31	215.22	216.92	172113300.0
2016-11-10	QQQ	ETF	118.14	118.38	114.195	115.75	72825446.0
2016-11-10	IWM	ETF	124.26	125.4	122.62	124.5	83440700.0
2016-11-10	DIA	ETF	186.83	188.82	186.35	188.13	8748100.0
2016-11-10	GLD	ETF	121.52	121.54	119.38	119.75	22268000.0
2016-11-10	TLT	ETF	123.97	124.96	122.72	122.73	22961200.0
2016-11-10	AADR	ETF	41.5	41.5	40.05	40.55	1900.0
2016-11-10	AAXJ	ETF	57.75	57.81	56.54	56.72	3279500.0
2016-11-10	ACSI	ETF	25.59	25.59	25.48	25.55	19127.0
2016-11-10	ACTX	ETF	16.5201	16.5201	14.1601	15.3401	3112.0
2016-11-10	ACWI	ETF	58.4	58.64	57.82	58.24	1659100.0
2016-11-10	ACWV	ETF	73.68	73.68	72.77	72.93	273800.0
2016-11-10	ACWX	ETF	40.37	40.48	39.92	40.12	647071.0
2016-11-10	ADRE	ETF	34.15	34.17	33.0777	33.135	7643.0
2016-11-10	AFK	ETF	19.98	19.99	19.56	19.6508	8454.0
2016-11-10	AFTY	ETF	13.61	13.63	13.39	13.5	7700.0
2016-11-10	AGG	ETF	109.66	109.88	109.42	109.45	4179200.0
2016-11-10	AGGY	ETF	50.575	50.69	50.44	50.44	11900.0
2016-11-10	AGQ	ETF	44.75	45.54	43.82	44.26	206800.0
2016-11-10	AGZ	ETF	114.62	114.62	113.7901	114.05	13631.0
2016-11-10	AGZD	ETF	23.925	23.925	23.92	23.925	4000.0
2016-11-10	AIA	ETF	48.15	48.15	47.18	47.31	212021.0
2016-11-10	AIQ	ETF	7.35	7.5	7.1	7.35	28307.0
2016-11-10	AIRR	ETF	21.22	21.6	20.76	21.52	281500.0
2016-11-10	AIVI	ETF	37.24	37.26	36.83	37.04	25200.0
2016-11-10	ALTY	ETF	14.91	14.91	14.45	14.6	22000.0
2016-11-10	AMJ	ETF	30.18	30.705	30.11	30.43	2969007.0
2016-11-10	AMLP	ETF	60.7	61.3	60.5	61.05	4767420.0
2016-11-10	AMZA	ETF	107.9	109.5	107.9	109.1	37240.0
2016-11-10	ANGL	ETF	28.6	28.66	28.28	28.28	459000.0
2016-11-10	AOA	ETF	46.93	46.93	46.26	46.48	253200.0
2016-11-10	AOK	ETF	32.63	32.63	32.44	32.46	101535.0
2016-11-10	AOM	ETF	35.25	35.363	35.0105	35.13	78936.0
2016-11-10	AOR	ETF	40.49	40.49	40.02	40.11	182478.0
2016-11-10	ARGT	ETF	23.71	23.8	23.03	23.04	68100.0
2016-11-10	ARKG	ETF	18.72	18.94	18.49	18.85	106700.0
2016-11-10	ARKK	ETF	20.55	20.65	20.174	20.44	4600.0
2016-11-10	ARKQ	ETF	21.099	21.099	21.099	21.099	300.0
2016-11-10	ARKW	ETF	25.68	25.68	24.38	24.79	2200.0
2016-11-10	ASEA	ETF	13.4	13.4	13.05	13.13	8700.0
2016-11-10	ASHR	ETF	25.03	25.07	24.68	24.79	1277800.0
2016-11-10	ASHS	ETF	34.7	34.71	34.45	34.67	4100.0
2016-11-10	ASHX	ETF	23.36	23.36	23.18	23.18	400.0
2016-11-10	ATMP	ETF	22.87	22.96	22.66	22.75	98400.0
2016-11-10	BAB	ETF	30.0	30.016	29.64	29.71	335296.0
2016-11-10	BAL	ETF	45.87	46.2	45.87	45.8777	3707.0
2016-11-10	BBC	ETF	20.73	21.05	20.42	20.88	32055.0
2016-11-10	BBH	ETF	117.19	117.19	114.07	115.54	212600.0
2016-11-10	BBP	ETF	34.31	35.01	34.151	34.56	47900.0
2016-11-10	BCM	ETF	26.136	26.136	26.136	26.136	451.0

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

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