PREVIEW / etf_daily / 2017-06-23

all etf daily files

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

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-23	SPY	ETF	242.91	243.51	242.47	243.13	66986800.0
2017-06-23	QQQ	ETF	140.53	141.42	140.15	141.24	21654314.0
2017-06-23	IWM	ETF	140.14	141.08	139.55	140.91	20772500.0
2017-06-23	DIA	ETF	213.44	213.95	213.06	213.74	1346800.0
2017-06-23	GLD	ETF	119.65	119.66	119.31	119.43	9258600.0
2017-06-23	TLT	ETF	127.47	127.9	127.4	127.78	4329900.0
2017-06-23	AADR	ETF	46.42	46.42	46.16	46.25	10300.0
2017-06-23	AAXJ	ETF	67.7	67.93	67.63	67.82	240200.0
2017-06-23	ACSI	ETF	28.73	28.73	28.63	28.67	29803.0
2017-06-23	ACTX	ETF	109.151	116.8211	88.5008	102.9559	573.0
2017-06-23	ACWF	ETF	27.09	27.28	27.08	27.27	24791.0
2017-06-23	ACWI	ETF	65.5	65.64	65.36	65.54	1096900.0
2017-06-23	ACWV	ETF	79.88	80.09	79.82	79.96	430200.0
2017-06-23	ACWX	ETF	45.42	45.56	45.33	45.5	230710.0
2017-06-23	ADRE	ETF	38.37	38.577	38.35	38.56	10942.0
2017-06-23	AFK	ETF	21.56	21.66	21.46	21.5	3661.0
2017-06-23	AFTY	ETF	15.15	15.18	15.131	15.131	4000.0
2017-06-23	AGG	ETF	110.01	110.11	109.98	110.05	1259100.0
2017-06-23	AGGY	ETF	50.89	50.93	50.82	50.84	18300.0
2017-06-23	AGNG	ETF	19.2	19.28	19.14	19.15	3700.0
2017-06-23	AGQ	ETF	34.32	34.42	34.12	34.22	152600.0
2017-06-23	AGZ	ETF	113.93	114.14	113.8	113.91	10760.0
2017-06-23	AGZD	ETF	23.985	23.985	23.97	23.975	2200.0
2017-06-23	AIA	ETF	57.27	57.4615	57.21	57.41	72936.0
2017-06-23	AIQ	ETF	13.3	13.3	13.25	13.3	3366.0
2017-06-23	AIRR	ETF	23.25	23.381	23.11	23.38	18000.0
2017-06-23	AIVI	ETF	41.25	41.58	41.24	41.58	16600.0
2017-06-23	ALTY	ETF	15.459	15.525	15.459	15.525	400.0
2017-06-23	AMJ	ETF	27.95	28.58	27.93	28.54	2000532.0
2017-06-23	AMLP	ETF	56.15	57.4	56.1	57.35	2203540.0
2017-06-23	AMZA	ETF	91.9	94.9	91.7	94.8	83640.0
2017-06-23	ANGL	ETF	29.38	29.48	29.31	29.48	667900.0
2017-06-23	AOA	ETF	51.82	51.97	51.75	51.92	37800.0
2017-06-23	AOK	ETF	34.11	34.1499	34.05	34.14	55773.0
2017-06-23	AOM	ETF	37.41	37.45	37.3	37.44	60747.0
2017-06-23	AOR	ETF	43.76	43.83	43.66	43.76	46059.0
2017-06-23	ARCM	ETF	100.0	100.15	100.0	100.15	80.0
2017-06-23	ARGT	ETF	29.6	29.67	29.48	29.54	36200.0
2017-06-23	ARKG	ETF	22.94	23.14	22.61	23.1	37700.0
2017-06-23	ARKK	ETF	30.05	30.32	29.871	30.3	92800.0
2017-06-23	ARKQ	ETF	29.13	29.35	29.13	29.27	26000.0
2017-06-23	ARKW	ETF	36.42	36.661	36.282	36.62	40900.0
2017-06-23	ASEA	ETF	15.25	15.25	15.25	15.25	200.0
2017-06-23	ASET	ETF	27.35	27.41	27.35	27.3598	1973.0
2017-06-23	ASHR	ETF	26.6	26.73	26.6	26.72	1352800.0
2017-06-23	ASHS	ETF	32.03	32.09	32.02	32.09	1500.0
2017-06-23	ASHX	ETF	20.4301	20.4301	20.4301	20.4301	200.0
2017-06-23	ATMP	ETF	21.12	21.51	21.12	21.49	45500.0
2017-06-23	BAB	ETF	30.21	30.27	30.19	30.27	84148.0
2017-06-23	BAL	ETF	43.91	44.37	43.7	44.37	7315.0

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

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