PREVIEW / etf_daily / 2017-08-24

all etf daily files

  file:    by_date/etf_daily/2017/2017-08-24.parquet
  size:    56 KB
  rows:    1,431

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-08-24	SPY	ETF	245.0	245.18	243.75	243.99	50741700.0
2017-08-24	QQQ	ETF	143.03	143.17	141.47	142.27	38160803.0
2017-08-24	IWM	ETF	136.64	136.93	136.02	136.49	15726600.0
2017-08-24	DIA	ETF	218.55	218.55	217.46	217.66	1934400.0
2017-08-24	GLD	ETF	122.39	122.64	122.13	122.29	4193400.0
2017-08-24	TLT	ETF	126.88	127.31	126.72	126.83	5569400.0
2017-08-24	AADR	ETF	52.0	52.13	51.87	51.96	26800.0
2017-08-24	AAXJ	ETF	71.72	71.89	71.46	71.8	5299400.0
2017-08-24	ACSI	ETF	28.83	28.83	28.66	28.66	11203.0
2017-08-24	ACTX	ETF	75.5207	79.0017	73.1607	74.3407	345.0
2017-08-24	ACWF	ETF	27.92	27.92	27.88	27.88	684.0
2017-08-24	ACWI	ETF	67.0	67.05	66.74	66.79	4048500.0
2017-08-24	ACWV	ETF	80.87	80.88	80.55	80.58	47900.0
2017-08-24	ACWX	ETF	47.16	47.19	47.03	47.06	280172.0
2017-08-24	ADRE	ETF	42.64	42.67	42.3901	42.54	4714.0
2017-08-24	AFK	ETF	23.46	23.5654	22.9354	23.38	5649.0
2017-08-24	AFTY	ETF	16.59	16.59	16.47	16.48	1500.0
2017-08-24	AGG	ETF	110.07	110.16	109.99	110.04	2102100.0
2017-08-24	AGGY	ETF	50.77	50.81	50.72	50.73	14600.0
2017-08-24	AGNG	ETF	18.62	18.69	18.6	18.63	13900.0
2017-08-24	AGQ	ETF	34.67	34.85	34.34	34.65	116300.0
2017-08-24	AGZ	ETF	114.2	114.2	114.14	114.18	6705.0
2017-08-24	AGZD	ETF	23.915	23.96	23.895	23.96	1200.0
2017-08-24	AIA	ETF	60.77	60.8514	60.66	60.8	33183.0
2017-08-24	AIRR	ETF	22.7	22.7	22.56	22.63	29700.0
2017-08-24	AIVI	ETF	41.73	41.8	41.67	41.7	8100.0
2017-08-24	ALTY	ETF	15.52	15.61	15.52	15.599	2300.0
2017-08-24	AMJ	ETF	27.37	27.59	27.28	27.39	2503520.0
2017-08-24	AMLP	ETF	54.4	54.75	54.15	54.35	2528260.0
2017-08-24	AMUB	ETF	17.27	17.286	17.27	17.286	240.0
2017-08-24	AMZA	ETF	88.8	89.6	88.4	89.0	35460.0
2017-08-24	ANGL	ETF	29.85	29.86	29.76	29.86	899200.0
2017-08-24	AOA	ETF	52.32	52.32	52.15	52.17	26400.0
2017-08-24	AOK	ETF	34.19	34.24	34.14	34.14	80684.0
2017-08-24	AOM	ETF	37.53	37.55	37.4495	37.48	60272.0
2017-08-24	AOR	ETF	44.04	44.05	43.91	43.93	40937.0
2017-08-24	ARCM	ETF	100.37	100.37	100.13	100.315	80300.0
2017-08-24	ARGT	ETF	29.45	29.63	29.39	29.62	16800.0
2017-08-24	ARKG	ETF	22.54	22.73	22.449	22.73	4600.0
2017-08-24	ARKK	ETF	31.67	31.81	31.446	31.74	68300.0
2017-08-24	ARKQ	ETF	29.29	29.29	29.14	29.24	10100.0
2017-08-24	ARKW	ETF	39.2	39.3	39.001	39.2	39300.0
2017-08-24	ASEA	ETF	15.36	15.38	15.26	15.3	27400.0
2017-08-24	ASET	ETF	28.035	28.035	27.95	27.95	1392.0
2017-08-24	ASHR	ETF	28.34	28.34	28.12	28.33	313500.0
2017-08-24	ASHS	ETF	34.23	34.32	34.23	34.28	3500.0
2017-08-24	ATMP	ETF	20.79	20.89	20.67	20.76	50800.0
2017-08-24	BAB	ETF	30.5	30.5299	30.4501	30.47	61644.0
2017-08-24	BAL	ETF	45.5199	46.13	45.4517	46.1	2739.0
2017-08-24	BBC	ETF	25.0	25.4396	25.0	25.4396	3919.0

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

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