PREVIEW / etf_daily / 2017-05-08

all etf daily files

  file:    by_date/etf_daily/2017/2017-05-08.parquet
  size:    54 KB
  rows:    1,383

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
2017-05-08	SPY	ETF	239.75	239.92	239.17	239.66	48385700.0
2017-05-08	QQQ	ETF	137.61	137.84	137.33	137.84	13279931.0
2017-05-08	IWM	ETF	138.66	138.98	137.76	138.41	16680000.0
2017-05-08	DIA	ETF	209.7	210.02	209.53	209.92	2311000.0
2017-05-08	GLD	ETF	117.03	117.14	116.68	116.75	5438400.0
2017-05-08	TLT	ETF	121.11	121.14	120.53	120.63	8057800.0
2017-05-08	AADR	ETF	47.83	47.83	47.58	47.8	8100.0
2017-05-08	AAXJ	ETF	64.67	64.82	64.52	64.53	878700.0
2017-05-08	ACSI	ETF	28.54	28.59	28.4972	28.57	1901.0
2017-05-08	ACTX	ETF	80.8307	80.8307	64.9006	72.5707	687.0
2017-05-08	ACWF	ETF	26.46	26.46	26.46	26.46	100.0
2017-05-08	ACWI	ETF	64.95	64.97	64.8	64.89	869800.0
2017-05-08	ACWV	ETF	78.54	78.62	78.33	78.45	163400.0
2017-05-08	ACWX	ETF	45.25	45.25	45.14	45.19	245081.0
2017-05-08	ADRE	ETF	37.34	37.5	37.3104	37.45	11024.0
2017-05-08	AFK	ETF	20.91	21.0999	20.8322	20.8945	3902.0
2017-05-08	AFTY	ETF	13.52	13.52	13.45	13.45	5700.0
2017-05-08	AGG	ETF	108.63	108.67	108.49	108.49	3568400.0
2017-05-08	AGGY	ETF	50.05	50.05	49.962	50.0	14600.0
2017-05-08	AGNG	ETF	17.75	17.75	17.407	17.407	1500.0
2017-05-08	AGQ	ETF	32.83	32.95	32.61	32.76	167300.0
2017-05-08	AGZ	ETF	113.05	113.22	113.0127	113.05	127431.0
2017-05-08	AGZD	ETF	24.075	24.075	24.025	24.065	16200.0
2017-05-08	AIA	ETF	54.65	54.75	54.6	54.65	16893.0
2017-05-08	AIQ	ETF	13.15	13.2	13.125	13.15	5410.0
2017-05-08	AIRR	ETF	24.41	24.41	24.14	24.19	55800.0
2017-05-08	AIVI	ETF	40.5	40.5	40.37	40.48	35800.0
2017-05-08	ALTY	ETF	15.61	15.61	15.41	15.45	15900.0
2017-05-08	AMJ	ETF	31.17	31.42	31.0301	31.31	870357.0
2017-05-08	AMLP	ETF	62.2	62.35	61.85	62.2	1529100.0
2017-05-08	AMZA	ETF	103.6	103.9	102.94	103.9	162300.0
2017-05-08	ANGL	ETF	29.42	29.45	29.31	29.43	274200.0
2017-05-08	AOA	ETF	50.97	51.01	50.86	50.91	34000.0
2017-05-08	AOK	ETF	33.63	33.63	33.55	33.59	38499.0
2017-05-08	AOM	ETF	36.81	36.82	36.7	36.8	43299.0
2017-05-08	AOR	ETF	43.04	43.04	42.96	43.03	38099.0
2017-05-08	ARCM	ETF	100.0	100.0	100.0	100.0	4000.0
2017-05-08	ARGT	ETF	29.92	29.92	29.69	29.79	51900.0
2017-05-08	ARKG	ETF	20.5	20.5	19.81	19.83	8500.0
2017-05-08	ARKK	ETF	25.9	25.9	25.61	25.69	18600.0
2017-05-08	ARKQ	ETF	27.03	27.03	26.86	26.916	18500.0
2017-05-08	ARKW	ETF	31.24	31.24	30.98	31.05	16200.0
2017-05-08	ASEA	ETF	14.72	14.72	14.63	14.71	500.0
2017-05-08	ASET	ETF	26.94	26.94	26.88	26.93	2302.0
2017-05-08	ASHR	ETF	24.15	24.2	24.02	24.04	943700.0
2017-05-08	ASHS	ETF	31.22	31.22	31.04	31.06	18000.0
2017-05-08	ASHX	ETF	18.84	18.84	18.75	18.75	609.0
2017-05-08	ATMP	ETF	23.07	23.2	22.95	23.17	41000.0
2017-05-08	BAB	ETF	29.41	29.4244	29.35	29.42	61334.0
2017-05-08	BAL	ETF	49.02	49.24	49.02	49.1	7095.0

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

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