PREVIEW / etf_daily / 2017-07-05

all etf daily files

  file:    by_date/etf_daily/2017/2017-07-05.parquet
  size:    56 KB
  rows:    1,427

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-07-05	SPY	ETF	242.63	243.01	241.7	242.77	54427600.0
2017-07-05	QQQ	ETF	136.57	137.9	136.16	137.53	42116584.0
2017-07-05	IWM	ETF	141.7	141.85	140.7	141.59	21865500.0
2017-07-05	DIA	ETF	214.74	214.83	213.83	214.58	1799000.0
2017-07-05	GLD	ETF	115.91	116.67	115.87	116.52	7223300.0
2017-07-05	TLT	ETF	124.2	124.65	124.12	124.49	11394500.0
2017-07-05	AADR	ETF	46.95	47.18	46.91	47.12	4200.0
2017-07-05	AAXJ	ETF	67.29	67.64	67.13	67.59	997700.0
2017-07-05	ACSI	ETF	28.7	28.72	28.64	28.72	6045.0
2017-07-05	ACTX	ETF	97.3509	99.7109	94.4008	94.4008	324.0
2017-07-05	ACWF	ETF	27.1101	27.3	27.1101	27.3	9929.0
2017-07-05	ACWI	ETF	65.54	65.6	65.3	65.58	3957600.0
2017-07-05	ACWV	ETF	78.82	78.98	78.65	78.98	168400.0
2017-07-05	ACWX	ETF	45.41	45.6	45.32	45.6	397690.0
2017-07-05	ADRE	ETF	38.81	38.81	38.41	38.685	8386.0
2017-07-05	AFK	ETF	21.56	21.6562	21.52	21.62	7502.0
2017-07-05	AFTY	ETF	15.26	15.36	15.26	15.36	6200.0
2017-07-05	AGG	ETF	109.08	109.18	109.0	109.15	4288600.0
2017-07-05	AGGY	ETF	50.35	50.41	50.309	50.381	11900.0
2017-07-05	AGNG	ETF	18.7	19.12	18.7	18.83	4600.0
2017-07-05	AGQ	ETF	31.08	31.53	30.92	31.53	240600.0
2017-07-05	AGZ	ETF	113.42	113.74	113.42	113.48	25372.0
2017-07-05	AGZD	ETF	23.955	23.995	23.945	23.96	6800.0
2017-07-05	AIA	ETF	56.87	56.93	56.59	56.895	135511.0
2017-07-05	AIQ	ETF	13.25	13.3	13.2	13.2	34536.0
2017-07-05	AIRR	ETF	23.84	23.92	23.724	23.92	34500.0
2017-07-05	AIVI	ETF	40.59	40.71	40.55	40.65	10800.0
2017-07-05	ALTY	ETF	15.53	15.53	15.34	15.395	2800.0
2017-07-05	AMJ	ETF	30.06	30.25	29.69	29.77	2708627.0
2017-07-05	AMLP	ETF	60.25	60.25	59.5	59.5	5773880.0
2017-07-05	AMZA	ETF	98.0	98.0	95.6	95.9	195700.0
2017-07-05	ANGL	ETF	29.47	29.53	29.4	29.41	322400.0
2017-07-05	AOA	ETF	51.79	51.85	51.65	51.84	33300.0
2017-07-05	AOK	ETF	33.95	33.98	33.865	33.98	88041.0
2017-07-05	AOM	ETF	37.19	37.28	37.14	37.27	164759.0
2017-07-05	AOR	ETF	43.62	43.6699	43.5001	43.66	55460.0
2017-07-05	ARCM	ETF	100.09	100.09	100.09	100.09	20.0
2017-07-05	ARGT	ETF	29.76	29.77	29.52	29.64	35600.0
2017-07-05	ARKG	ETF	22.52	22.718	22.35	22.7	16300.0
2017-07-05	ARKK	ETF	28.84	29.05	28.679	28.99	46300.0
2017-07-05	ARKQ	ETF	28.0	28.072	27.78	28.02	27000.0
2017-07-05	ARKW	ETF	34.8	35.037	34.63	34.96	34900.0
2017-07-05	ASEA	ETF	15.07	15.11	15.05	15.08	2300.0
2017-07-05	ASHR	ETF	27.18	27.26	27.08	27.16	467100.0
2017-07-05	ASHS	ETF	33.08	33.23	33.08	33.21	1700.0
2017-07-05	ATMP	ETF	22.56	22.56	22.27	22.32	15600.0
2017-07-05	BAB	ETF	29.91	30.03	29.91	30.0	69867.0
2017-07-05	BAL	ETF	43.85	44.44	43.75	44.44	21643.0
2017-07-05	BBC	ETF	24.5	24.95	24.5	24.91	14755.0
2017-07-05	BBH	ETF	125.49	127.68	125.49	127.44	18100.0

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

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