PREVIEW / etf_daily / 2017-06-22

all etf daily files

  file:    by_date/etf_daily/2017/2017-06-22.parquet
  size:    56 KB
  rows:    1,418

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-22	SPY	ETF	242.96	243.53	242.64	242.84	44148100.0
2017-06-22	QQQ	ETF	140.94	141.22	140.34	140.7	24099115.0
2017-06-22	IWM	ETF	139.37	140.39	139.01	139.98	17917200.0
2017-06-22	DIA	ETF	214.08	214.29	213.66	213.73	2697100.0
2017-06-22	GLD	ETF	119.13	119.2	118.6	118.92	5811900.0
2017-06-22	TLT	ETF	127.71	127.87	127.31	127.84	6608100.0
2017-06-22	AADR	ETF	46.13	46.39	45.87	46.33	9700.0
2017-06-22	AAXJ	ETF	67.67	67.89	67.6	67.67	3471300.0
2017-06-22	ACSI	ETF	28.7	28.75	28.66	28.7	65244.0
2017-06-22	ACTX	ETF	105.67	112.101	103.8409	112.101	1111.0
2017-06-22	ACWF	ETF	27.0794	27.0794	27.0794	27.0794	598.0
2017-06-22	ACWI	ETF	65.46	65.59	65.39	65.43	2049500.0
2017-06-22	ACWV	ETF	80.0	80.11	79.9	79.97	96900.0
2017-06-22	ACWX	ETF	45.36	45.45	45.29	45.385	755107.0
2017-06-22	ADRE	ETF	38.37	38.51	38.3464	38.3901	2553.0
2017-06-22	AFK	ETF	21.36	21.51	21.35	21.51	4758.0
2017-06-22	AFTY	ETF	15.04	15.075	15.04	15.075	700.0
2017-06-22	AGG	ETF	110.06	110.09	109.95	110.03	1427400.0
2017-06-22	AGGY	ETF	50.83	50.89	50.77	50.81	41500.0
2017-06-22	AGNG	ETF	19.43	19.43	19.12	19.12	4000.0
2017-06-22	AGQ	ETF	33.73	33.91	33.51	33.75	162000.0
2017-06-22	AGZ	ETF	113.8	114.0701	113.8	114.06	9171.0
2017-06-22	AGZD	ETF	24.0	24.0	23.965	23.965	800.0
2017-06-22	AIA	ETF	57.44	57.539	57.31	57.3793	15973.0
2017-06-22	AIQ	ETF	13.3	13.3	13.25	13.275	31655.0
2017-06-22	AIRR	ETF	23.01	23.27	23.01	23.17	23300.0
2017-06-22	AIVI	ETF	41.35	41.42	41.32	41.37	10200.0
2017-06-22	ALTY	ETF	15.42	15.43	15.42	15.43	800.0
2017-06-22	AMJ	ETF	27.69	28.035	27.66	27.92	2825675.0
2017-06-22	AMLP	ETF	55.5	56.2	55.4	56.0	1977440.0
2017-06-22	AMZA	ETF	90.5	91.9	90.46	91.5	70200.0
2017-06-22	ANGL	ETF	29.45	29.45	29.22	29.28	2249300.0
2017-06-22	AOA	ETF	51.91	51.92	51.8	51.83	32900.0
2017-06-22	AOK	ETF	34.08	34.13	34.0626	34.11	48971.0
2017-06-22	AOM	ETF	37.31	37.42	37.31	37.39	69114.0
2017-06-22	AOR	ETF	43.81	43.81	43.66	43.75	40170.0
2017-06-22	ARCM	ETF	100.4	100.4	100.4	100.4	40.0
2017-06-22	ARGT	ETF	29.26	29.69	29.17	29.66	98600.0
2017-06-22	ARKG	ETF	22.71	23.045	22.651	22.89	66300.0
2017-06-22	ARKK	ETF	29.8	30.288	29.8	30.05	163900.0
2017-06-22	ARKQ	ETF	29.13	29.3	28.96	29.21	28400.0
2017-06-22	ARKW	ETF	36.21	36.589	36.21	36.37	45200.0
2017-06-22	ASEA	ETF	14.99	15.07	14.99	15.07	1100.0
2017-06-22	ASET	ETF	27.565	27.58	27.525	27.525	1213.0
2017-06-22	ASHR	ETF	26.45	26.49	26.36	26.42	841900.0
2017-06-22	ASHS	ETF	32.04	32.04	31.94	31.98	5800.0
2017-06-22	ATMP	ETF	20.95	21.11	20.91	21.06	66300.0
2017-06-22	BAB	ETF	30.14	30.23	30.1	30.23	106861.0
2017-06-22	BAL	ETF	44.21	44.326	43.86	44.0	11815.0
2017-06-22	BBC	ETF	24.25	24.76	24.24	24.5	19054.0

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

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