PREVIEW / etf_daily / 2017-11-13

all etf daily files

  file:    by_date/etf_daily/2017/2017-11-13.parquet
  size:    59 KB
  rows:    1,514

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-11-13	SPY	ETF	257.31	258.59	257.27	258.33	50228600.0
2017-11-13	QQQ	ETF	153.12	154.0693	153.1	153.87	12522399.0
2017-11-13	IWM	ETF	145.93	146.82	145.5	146.61	14680000.0
2017-11-13	DIA	ETF	233.66	234.78	233.63	234.66	2452400.0
2017-11-13	GLD	ETF	121.43	121.55	121.27	121.31	6249300.0
2017-11-13	TLT	ETF	124.8	124.81	124.31	124.36	5880800.0
2017-11-13	AADR	ETF	56.3	56.44	55.47	56.29	24100.0
2017-11-13	AAXJ	ETF	75.83	76.22	75.8	76.11	381700.0
2017-11-13	ACSI	ETF	29.6	29.6	29.51	29.57	8526.0
2017-11-13	ACTX	ETF	46.9054	52.5105	44.8404	50.1505	847.0
2017-11-13	ACWF	ETF	29.81	30.03	29.81	30.03	14030.0
2017-11-13	ACWI	ETF	70.02	70.35	69.96	70.28	789800.0
2017-11-13	ACWV	ETF	82.57	82.91	82.51	82.82	64600.0
2017-11-13	ACWX	ETF	48.83	49.07	48.79	49.04	315061.0
2017-11-13	ADRE	ETF	42.87	43.0099	42.67	42.8738	14157.0
2017-11-13	AFK	ETF	23.51	23.66	23.51	23.561	7744.0
2017-11-13	AFTY	ETF	18.32	18.41	18.32	18.403	1800.0
2017-11-13	AGG	ETF	109.11	109.11	108.96	108.99	1891600.0
2017-11-13	AGGY	ETF	50.51	50.53	50.457	50.49	51100.0
2017-11-13	AGNG	ETF	19.14	19.299	19.14	19.299	1000.0
2017-11-13	AGQ	ETF	34.34	34.64	34.18	34.47	124300.0
2017-11-13	AGZ	ETF	113.28	113.32	113.21	113.2473	6627.0
2017-11-13	AGZD	ETF	24.115	24.115	24.085	24.085	30000.0
2017-11-13	AIA	ETF	65.85	66.09	65.79	66.0614	67774.0
2017-11-13	AIEQ	ETF	24.29	24.4	24.18	24.4	113600.0
2017-11-13	AIRR	ETF	25.78	25.82	25.6	25.814	169400.0
2017-11-13	AIVI	ETF	42.5	42.69	42.5	42.69	11100.0
2017-11-13	ALTY	ETF	15.46	15.46	15.385	15.41	4000.0
2017-11-13	AMJ	ETF	27.19	27.19	26.69	26.74	2874734.0
2017-11-13	AMLP	ETF	52.75	52.75	51.6	51.65	3291160.0
2017-11-13	AMZA	ETF	83.1	83.2	81.46	81.8	164870.0
2017-11-13	ANGL	ETF	29.77	29.85	29.74	29.77	164700.0
2017-11-13	AOA	ETF	54.08	54.31	54.08	54.27	48600.0
2017-11-13	AOK	ETF	34.48	34.57	34.46	34.56	59633.0
2017-11-13	AOM	ETF	38.0	38.14	37.99	38.13	110934.0
2017-11-13	AOR	ETF	45.05	45.2307	45.0403	45.23	85029.0
2017-11-13	ARGT	ETF	32.28	32.28	31.85	31.96	43600.0
2017-11-13	ARKG	ETF	24.55	24.57	24.27	24.36	28200.0
2017-11-13	ARKK	ETF	34.66	34.967	34.48	34.85	97600.0
2017-11-13	ARKQ	ETF	32.88	33.17	32.691	33.16	37300.0
2017-11-13	ARKW	ETF	42.9	43.29	42.826	43.18	72900.0
2017-11-13	ASEA	ETF	16.09	16.17	16.05	16.15	1200.0
2017-11-13	ASET	ETF	28.299	28.299	28.299	28.299	302.0
2017-11-13	ASHR	ETF	31.44	31.49	31.41	31.48	757200.0
2017-11-13	ASHS	ETF	36.7	36.7	36.39	36.48	20500.0
2017-11-13	ASHX	ETF	23.33	23.38	23.3206	23.3206	534.0
2017-11-13	ATMP	ETF	20.63	20.63	20.17	20.17	51900.0
2017-11-13	BAB	ETF	30.46	30.479	30.4	30.41	60945.0
2017-11-13	BAL	ETF	45.76	45.76	45.295	45.3872	862.0
2017-11-13	BBC	ETF	27.22	27.45	26.88	27.08	19494.0

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

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