PREVIEW / etf_daily / 2017-10-23

all etf daily files

  file:    by_date/etf_daily/2017/2017-10-23.parquet
  size:    58 KB
  rows:    1,484

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-10-23	SPY	ETF	257.48	257.51	256.02	256.11	63915300.0
2017-10-23	QQQ	ETF	149.01	149.03	147.53	147.74	29297126.0
2017-10-23	IWM	ETF	150.15	150.15	148.7	148.86	14676400.0
2017-10-23	DIA	ETF	233.58	233.58	232.61	232.65	2325100.0
2017-10-23	GLD	ETF	120.98	121.9	120.96	121.8	5069700.0
2017-10-23	TLT	ETF	124.16	124.49	124.02	124.2	6871100.0
2017-10-23	AADR	ETF	57.65	58.13	57.65	57.9	21500.0
2017-10-23	AAXJ	ETF	74.82	74.94	74.39	74.46	774800.0
2017-10-23	ACSI	ETF	29.659	29.659	29.57	29.57	1996.0
2017-10-23	ACTX	ETF	57.5255	57.5255	50.7405	53.1005	501.0
2017-10-23	ACWF	ETF	29.93	29.93	29.83	29.83	9003.0
2017-10-23	ACWI	ETF	70.25	70.27	69.91	69.98	876100.0
2017-10-23	ACWV	ETF	82.87	82.91	82.69	82.72	217100.0
2017-10-23	ACWX	ETF	49.15	49.15	48.95	48.97	578370.0
2017-10-23	ADRE	ETF	43.17	43.17	42.6754	42.73	11423.0
2017-10-23	AFK	ETF	23.6	23.82	23.53	23.7	25852.0
2017-10-23	AFTY	ETF	17.335	17.335	17.335	17.335	300.0
2017-10-23	AGG	ETF	109.4	109.47	109.36	109.42	2000800.0
2017-10-23	AGGY	ETF	50.75	50.89	50.75	50.783	58600.0
2017-10-23	AGNG	ETF	19.81	19.84	19.661	19.7	4900.0
2017-10-23	AGQ	ETF	34.05	34.87	33.86	34.81	130800.0
2017-10-23	AGZ	ETF	113.34	113.45	113.34	113.35	11648.0
2017-10-23	AGZD	ETF	24.125	24.125	24.125	24.125	400.0
2017-10-23	AIA	ETF	63.76	63.82	63.37	63.48	37119.0
2017-10-23	AIEQ	ETF	25.97	25.99	25.11	25.17	1762100.0
2017-10-23	AIRR	ETF	26.35	26.35	26.11	26.13	32900.0
2017-10-23	AIVI	ETF	42.9	42.95	42.81	42.81	7200.0
2017-10-23	ALTY	ETF	15.61	15.709	15.605	15.605	7800.0
2017-10-23	AMJ	ETF	27.3	27.33	26.83	26.87	2419684.0
2017-10-23	AMLP	ETF	54.15	54.15	53.1	53.15	3255200.0
2017-10-23	AMZA	ETF	85.2	85.3	82.9	83.2	273680.0
2017-10-23	ANGL	ETF	30.39	30.39	30.32	30.36	205700.0
2017-10-23	AOA	ETF	54.35	54.35	54.11	54.14	32500.0
2017-10-23	AOK	ETF	34.72	34.72	34.6	34.61	47713.0
2017-10-23	AOM	ETF	38.22	38.22	38.08	38.11	87289.0
2017-10-23	AOR	ETF	45.24	45.24	45.1	45.15	65872.0
2017-10-23	ARCM	ETF	100.2	100.2	100.2	100.2	160.0
2017-10-23	ARGT	ETF	31.53	32.2	31.4	32.02	147700.0
2017-10-23	ARKG	ETF	26.52	26.7	26.374	26.374	26100.0
2017-10-23	ARKK	ETF	35.02	35.08	34.441	34.52	156300.0
2017-10-23	ARKQ	ETF	33.0	33.0	32.5	32.558	34600.0
2017-10-23	ARKW	ETF	41.94	41.94	41.26	41.33	72600.0
2017-10-23	ASEA	ETF	15.77	15.82	15.73	15.82	2400.0
2017-10-23	ASET	ETF	28.28	28.32	28.268	28.268	2035.0
2017-10-23	ASHR	ETF	30.01	30.01	29.86	29.89	2340900.0
2017-10-23	ASHS	ETF	36.31	36.35	36.31	36.35	1900.0
2017-10-23	ASHX	ETF	22.09	22.09	22.09	22.09	500.0
2017-10-23	ATMP	ETF	20.64	20.64	20.31	20.36	61800.0
2017-10-23	BAB	ETF	30.35	30.4	30.35	30.39	72008.0
2017-10-23	BAL	ETF	45.43	46.0	45.35	45.9401	39717.0

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

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