PREVIEW / etf_daily / 2017-07-26

all etf daily files

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

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-26	SPY	ETF	247.75	247.79	247.13	247.43	47575400.0
2017-07-26	QQQ	ETF	144.74	144.95	144.53	144.87	18610634.0
2017-07-26	IWM	ETF	144.15	144.15	143.05	143.25	13574900.0
2017-07-26	DIA	ETF	216.81	217.16	216.56	216.81	2041000.0
2017-07-26	GLD	ETF	118.57	120.15	118.55	119.88	8527900.0
2017-07-26	TLT	ETF	123.27	124.09	123.08	123.77	8459500.0
2017-07-26	AADR	ETF	49.55	49.71	49.5	49.71	11600.0
2017-07-26	AAXJ	ETF	70.85	71.25	70.75	71.23	646200.0
2017-07-26	ACSI	ETF	29.09	29.1	29.04	29.04	21161.0
2017-07-26	ACTX	ETF	77.2907	77.8807	71.9806	73.1607	310.0
2017-07-26	ACWF	ETF	28.09	28.09	28.07	28.07	752.0
2017-07-26	ACWI	ETF	67.34	67.47	67.24	67.4	4450300.0
2017-07-26	ACWV	ETF	80.06	80.28	79.96	80.22	146000.0
2017-07-26	ACWX	ETF	47.07	47.31	46.98	47.23	1213059.0
2017-07-26	ADRE	ETF	41.01	41.43	41.01	41.43	9910.0
2017-07-26	AFK	ETF	23.14	23.36	23.1	23.36	6191.0
2017-07-26	AFTY	ETF	16.097	16.179	16.097	16.179	4300.0
2017-07-26	AGG	ETF	109.37	109.71	109.35	109.64	2249800.0
2017-07-26	AGGY	ETF	50.51	50.68	50.489	50.57	16800.0
2017-07-26	AGNG	ETF	19.25	19.3	19.25	19.3	1200.0
2017-07-26	AGQ	ETF	32.9	33.87	32.78	33.77	151900.0
2017-07-26	AGZ	ETF	113.54	113.88	113.52	113.85	24738.0
2017-07-26	AGZD	ETF	23.975	24.035	23.97	24.035	6200.0
2017-07-26	AIA	ETF	60.17	60.4658	60.067	60.4	28876.0
2017-07-26	AIQ	ETF	13.25	13.25	13.2	13.25	17800.0
2017-07-26	AIRR	ETF	23.97	24.04	23.89	23.93	91900.0
2017-07-26	AIVI	ETF	41.71	41.94	41.65	41.88	11200.0
2017-07-26	ALTY	ETF	15.784	15.785	15.674	15.744	3800.0
2017-07-26	AMJ	ETF	30.16	30.185	29.985	30.01	882792.0
2017-07-26	AMLP	ETF	60.25	60.35	59.9	60.0	1371220.0
2017-07-26	AMZA	ETF	97.9	98.0	96.9	97.0	93830.0
2017-07-26	ANGL	ETF	29.93	29.97	29.88	29.96	142000.0
2017-07-26	AOA	ETF	52.52	52.62	52.43	52.53	36600.0
2017-07-26	AOK	ETF	34.15	34.235	34.12	34.22	45382.0
2017-07-26	AOM	ETF	37.46	37.55	37.3801	37.54	55233.0
2017-07-26	AOR	ETF	44.08	44.15	44.02	44.15	81719.0
2017-07-26	ARCM	ETF	100.05	100.05	100.05	100.05	20.0
2017-07-26	ARGT	ETF	29.74	29.92	29.74	29.83	82700.0
2017-07-26	ARKG	ETF	22.93	23.02	22.642	22.89	15900.0
2017-07-26	ARKK	ETF	30.46	30.46	30.185	30.29	105800.0
2017-07-26	ARKQ	ETF	30.0	30.15	29.88	30.01	24700.0
2017-07-26	ARKW	ETF	37.57	37.57	37.364	37.494	26500.0
2017-07-26	ASEA	ETF	15.43	15.46	15.43	15.43	1300.0
2017-07-26	ASET	ETF	27.66	27.73	27.66	27.7299	1648.0
2017-07-26	ASHR	ETF	27.87	27.91	27.78	27.87	264400.0
2017-07-26	ASHS	ETF	33.3	33.3	33.2	33.28	7800.0
2017-07-26	ASHX	ETF	21.03	21.03	21.03	21.03	254.0
2017-07-26	ATMP	ETF	22.97	22.97	22.7	22.77	99100.0
2017-07-26	BAB	ETF	29.99	30.0	29.9	29.95	109704.0
2017-07-26	BAL	ETF	44.76	45.2183	44.76	45.2183	4267.0

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

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