PREVIEW / etf_daily / 2017-11-20

all etf daily files

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

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-20	SPY	ETF	258.14	258.52	257.86	258.3	48075500.0
2017-11-20	QQQ	ETF	154.08	154.2	153.61	153.83	21143944.0
2017-11-20	IWM	ETF	148.76	149.58	148.33	149.53	22793000.0
2017-11-20	DIA	ETF	233.66	234.37	233.42	234.15	2056600.0
2017-11-20	GLD	ETF	122.3	122.41	121.04	121.31	8356700.0
2017-11-20	TLT	ETF	125.91	126.38	125.91	126.34	4232300.0
2017-11-20	AADR	ETF	57.08	57.3	56.51	56.69	42200.0
2017-11-20	AAXJ	ETF	76.75	77.18	76.75	77.11	689500.0
2017-11-20	ACSI	ETF	29.869	29.869	29.869	29.869	1115.0
2017-11-20	ACTX	ETF	49.5604	67.8506	49.5604	67.8506	1969.0
2017-11-20	ACWF	ETF	30.28	30.33	30.28	30.2913	8127.0
2017-11-20	ACWI	ETF	70.48	70.58	70.4	70.52	889400.0
2017-11-20	ACWV	ETF	83.04	83.26	83.04	83.1	202300.0
2017-11-20	ACWX	ETF	49.3	49.35	49.2329	49.27	834964.0
2017-11-20	ADRE	ETF	43.52	43.52	43.06	43.22	5150.0
2017-11-20	AFK	ETF	23.93	24.08	23.8365	23.9	13373.0
2017-11-20	AFTY	ETF	18.79	18.92	18.79	18.92	20500.0
2017-11-20	AGG	ETF	109.23	109.3	109.18	109.25	2639100.0
2017-11-20	AGGY	ETF	50.55	50.65	50.55	50.604	28700.0
2017-11-20	AGNG	ETF	19.58	19.58	19.48	19.525	3100.0
2017-11-20	AGQ	ETF	34.74	34.82	33.7	34.06	258700.0
2017-11-20	AGZ	ETF	113.33	113.47	113.3007	113.34	11229.0
2017-11-20	AGZD	ETF	24.1	24.125	24.1	24.12	4000.0
2017-11-20	AIA	ETF	66.65	67.019	66.604	66.9758	106707.0
2017-11-20	AIEQ	ETF	24.81	24.93	24.74	24.9	81700.0
2017-11-20	AIRR	ETF	25.73	26.05	25.73	26.02	9700.0
2017-11-20	AIVI	ETF	42.6	42.63	42.54	42.54	4400.0
2017-11-20	ALTY	ETF	15.44	15.46	15.43	15.46	1100.0
2017-11-20	AMJ	ETF	26.43	26.61	26.11	26.57	4268314.0
2017-11-20	AMLP	ETF	51.1	51.55	50.45	51.25	4672360.0
2017-11-20	AMZA	ETF	80.0	80.6	78.65	80.4	133930.0
2017-11-20	ANGL	ETF	29.93	29.94	29.87	29.9	260400.0
2017-11-20	AOA	ETF	54.45	54.5	54.43	54.48	71000.0
2017-11-20	AOK	ETF	34.65	34.67	34.6101	34.63	78138.0
2017-11-20	AOM	ETF	38.22	38.25	38.15	38.23	135569.0
2017-11-20	AOR	ETF	45.33	45.37	45.3	45.36	255233.0
2017-11-20	ARGT	ETF	31.93	31.93	31.52	31.74	26200.0
2017-11-20	ARKG	ETF	24.74	24.84	24.564	24.697	37500.0
2017-11-20	ARKK	ETF	35.71	35.85	35.6	35.84	213500.0
2017-11-20	ARKQ	ETF	33.69	33.74	33.612	33.72	36400.0
2017-11-20	ARKW	ETF	44.29	44.48	44.24	44.42	153400.0
2017-11-20	ASEA	ETF	16.23	16.36	16.19	16.36	1100.0
2017-11-20	ASET	ETF	28.15	28.15	28.15	28.15	431.0
2017-11-20	ASHR	ETF	31.52	31.62	31.5	31.59	574300.0
2017-11-20	ASHS	ETF	35.2	35.24	35.13	35.21	13200.0
2017-11-20	ASHX	ETF	23.32	23.4324	23.2734	23.41	10154.0
2017-11-20	ATMP	ETF	20.07	20.11	19.68	20.02	217400.0
2017-11-20	BAB	ETF	30.58	30.58	30.499	30.53	70507.0
2017-11-20	BAL	ETF	46.12	46.68	46.12	46.59	11017.0
2017-11-20	BAR	ETF	12.8579	12.8579	12.78	12.781	55250.0

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

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