PREVIEW / etf_daily / 2017-06-12

all etf daily files

  file:    by_date/etf_daily/2017/2017-06-12.parquet
  size:    55 KB
  rows:    1,404

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-06-12	SPY	ETF	243.13	243.42	242.38	243.36	86108100.0
2017-06-12	QQQ	ETF	138.84	139.48	137.47	139.23	104453977.0
2017-06-12	IWM	ETF	141.66	141.99	140.89	141.38	34665500.0
2017-06-12	DIA	ETF	212.46	212.78	211.88	212.4	3682300.0
2017-06-12	GLD	ETF	120.33	120.69	120.27	120.36	4927400.0
2017-06-12	TLT	ETF	124.21	124.99	124.14	124.36	4335800.0
2017-06-12	AADR	ETF	47.18	47.18	46.78	46.99	10600.0
2017-06-12	AAXJ	ETF	67.38	67.45	67.08	67.37	437800.0
2017-06-12	ACSI	ETF	28.86	28.88	28.82	28.88	7848.0
2017-06-12	ACTX	ETF	81.4207	100.8909	81.4207	94.4008	1786.0
2017-06-12	ACWF	ETF	27.19	27.25	27.04	27.25	9049.0
2017-06-12	ACWI	ETF	66.06	66.15	65.89	66.11	3059100.0
2017-06-12	ACWV	ETF	80.1	80.27	80.04	80.27	82200.0
2017-06-12	ACWX	ETF	46.03	46.07	45.87	46.03	366578.0
2017-06-12	ADRE	ETF	38.56	38.56	38.121	38.35	3924.0
2017-06-12	AFK	ETF	22.14	22.16	21.7131	21.795	6882.0
2017-06-12	AFTY	ETF	15.118	15.13	15.118	15.13	2900.0
2017-06-12	AGG	ETF	109.51	109.7	109.47	109.56	1394800.0
2017-06-12	AGGY	ETF	50.58	50.64	50.55	50.62	6300.0
2017-06-12	AGNG	ETF	18.14	18.261	18.04	18.11	5800.0
2017-06-12	AGQ	ETF	35.75	35.89	35.04	35.35	185700.0
2017-06-12	AGZ	ETF	113.54	113.8466	113.54	113.74	7891.0
2017-06-12	AGZD	ETF	23.96	23.96	23.955	23.955	3600.0
2017-06-12	AIA	ETF	56.47	56.54	56.27	56.54	127641.0
2017-06-12	AIQ	ETF	13.2	13.25	13.2	13.25	22000.0
2017-06-12	AIRR	ETF	24.25	24.283	24.0	24.06	26300.0
2017-06-12	AIVI	ETF	41.69	41.69	41.57	41.63	1300.0
2017-06-12	ALTY	ETF	15.52	15.52	15.458	15.458	500.0
2017-06-12	AMJ	ETF	29.55	29.88	29.31	29.41	2118923.0
2017-06-12	AMLP	ETF	59.55	59.75	58.9	59.2	1355980.0
2017-06-12	AMUB	ETF	19.0	19.0	19.0	19.0	250.0
2017-06-12	AMZA	ETF	99.4	100.3	98.0	98.8	96360.0
2017-06-12	ANGL	ETF	29.59	29.69	29.55	29.69	813200.0
2017-06-12	AOA	ETF	51.73	51.77	51.59	51.77	79900.0
2017-06-12	AOK	ETF	33.97	34.01	33.95	33.99	32797.0
2017-06-12	AOM	ETF	37.26	37.31	37.16	37.29	64238.0
2017-06-12	AOR	ETF	43.62	43.65	43.5316	43.64	68535.0
2017-06-12	ARCM	ETF	100.05	100.05	100.05	100.05	20.0
2017-06-12	ARGT	ETF	30.21	30.21	29.78	29.85	157100.0
2017-06-12	ARKG	ETF	21.1	21.208	20.89	21.13	5000.0
2017-06-12	ARKK	ETF	28.57	28.57	27.89	28.27	74400.0
2017-06-12	ARKQ	ETF	28.6	28.653	28.041	28.5	61300.0
2017-06-12	ARKW	ETF	34.98	34.98	32.6	34.62	153100.0
2017-06-12	ASEA	ETF	14.95	15.11	14.95	15.11	4700.0
2017-06-12	ASET	ETF	27.64	27.64	27.58	27.63	711.0
2017-06-12	ASHR	ETF	26.35	26.42	26.3	26.32	754900.0
2017-06-12	ASHS	ETF	31.55	31.6	31.55	31.6	1700.0
2017-06-12	ASHX	ETF	20.1185	20.1185	20.0	20.0	704.0
2017-06-12	ATMP	ETF	22.14	22.14	21.82	21.95	48800.0
2017-06-12	BAB	ETF	29.98	30.04	29.95	29.99	79381.0

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

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