PREVIEW / etf_daily / 2017-09-21

all etf daily files

  file:    by_date/etf_daily/2017/2017-09-21.parquet
  size:    57 KB
  rows:    1,445

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-09-21	SPY	ETF	249.88	249.98	249.19	249.39	48211400.0
2017-09-21	QQQ	ETF	145.25	145.26	143.95	144.46	28841835.0
2017-09-21	IWM	ETF	144.02	144.26	143.48	143.69	17395900.0
2017-09-21	DIA	ETF	223.9	223.97	223.39	223.47	1741400.0
2017-09-21	GLD	ETF	122.56	123.07	122.49	122.68	7757900.0
2017-09-21	TLT	ETF	126.16	126.56	125.82	125.84	6147800.0
2017-09-21	AADR	ETF	55.36	55.53	55.08	55.46	23200.0
2017-09-21	AAXJ	ETF	73.71	73.72	73.27	73.47	468700.0
2017-09-21	ACSI	ETF	28.8626	28.87	28.8626	28.87	1211.0
2017-09-21	ACTX	ETF	71.3906	73.9277	71.3906	73.7507	91.0
2017-09-21	ACWF	ETF	28.88	28.88	28.87	28.87	731.0
2017-09-21	ACWI	ETF	68.82	68.82	68.61	68.68	1264200.0
2017-09-21	ACWV	ETF	81.28	81.31	81.0	81.0	75700.0
2017-09-21	ACWX	ETF	48.43	48.495	48.34	48.42	493765.0
2017-09-21	ADRE	ETF	42.78	43.03	42.6627	42.81	6085.0
2017-09-21	AFK	ETF	23.51	23.829	23.36	23.401	5742.0
2017-09-21	AFTY	ETF	17.15	17.18	17.05	17.05	4900.0
2017-09-21	AGG	ETF	109.82	109.85	109.68	109.69	2210900.0
2017-09-21	AGGY	ETF	50.84	50.86	50.755	50.76	10800.0
2017-09-21	AGNG	ETF	19.475	19.475	19.407	19.407	2300.0
2017-09-21	AGQ	ETF	34.21	34.72	34.06	34.49	118600.0
2017-09-21	AGZ	ETF	113.75	113.82	113.75	113.82	15770.0
2017-09-21	AGZD	ETF	24.065	24.07	24.015	24.015	4000.0
2017-09-21	AIA	ETF	62.41	62.41	62.19	62.27	36977.0
2017-09-21	AIRR	ETF	24.95	25.04	24.93	24.98	9200.0
2017-09-21	AIVI	ETF	42.82	43.0	42.82	42.98	5200.0
2017-09-21	ALTY	ETF	15.6	15.61	15.6	15.61	900.0
2017-09-21	AMJ	ETF	28.07	28.1	27.79	27.9	1196234.0
2017-09-21	AMLP	ETF	55.95	56.1	55.3	55.6	1767960.0
2017-09-21	AMUB	ETF	17.465	17.465	17.465	17.465	142.0
2017-09-21	AMZA	ETF	92.4	92.4	90.7	91.3	114770.0
2017-09-21	ANGL	ETF	30.18	30.19	30.12	30.15	134200.0
2017-09-21	AOA	ETF	53.41	53.44	53.3	53.38	31900.0
2017-09-21	AOK	ETF	34.46	34.48	34.39	34.41	49230.0
2017-09-21	AOM	ETF	37.94	37.9688	37.85	37.92	55384.0
2017-09-21	AOR	ETF	44.74	44.74	44.66	44.7	90458.0
2017-09-21	ARGT	ETF	31.39	31.53	31.2	31.29	60200.0
2017-09-21	ARKG	ETF	25.57	26.1	25.57	25.752	17100.0
2017-09-21	ARKK	ETF	34.25	34.3	33.9	33.97	80600.0
2017-09-21	ARKQ	ETF	31.81	31.81	31.35	31.469	32300.0
2017-09-21	ARKW	ETF	41.14	41.14	40.39	40.64	61200.0
2017-09-21	ASET	ETF	28.29	28.29	28.25	28.26	3208.0
2017-09-21	ASHR	ETF	29.61	29.64	29.52	29.63	326400.0
2017-09-21	ASHS	ETF	36.86	36.86	36.75	36.86	9400.0
2017-09-21	ATMP	ETF	21.31	21.31	21.1	21.2	23000.0
2017-09-21	BAB	ETF	30.49	30.52	30.4	30.47	48935.0
2017-09-21	BAL	ETF	45.33	45.33	45.0	45.01	4078.0
2017-09-21	BAR	ETF	12.945	12.945	12.937	12.937	4570.0
2017-09-21	BBC	ETF	29.14	29.14	28.6628	28.6996	9753.0
2017-09-21	BBH	ETF	133.79	134.06	133.57	133.63	8500.0

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

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