PREVIEW / etf_daily / 2017-11-02

all etf daily files

  file:    by_date/etf_daily/2017/2017-11-02.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-02	SPY	ETF	257.41	257.75	256.19	257.59	56449500.0
2017-11-02	QQQ	ETF	151.92	151.99	150.77	151.81	31017426.0
2017-11-02	IWM	ETF	148.24	149.23	147.72	148.71	28176600.0
2017-11-02	DIA	ETF	234.21	235.17	233.32	234.96	2459400.0
2017-11-02	GLD	ETF	121.29	121.96	121.05	121.19	5369500.0
2017-11-02	TLT	ETF	125.0	125.52	124.92	125.3	7222700.0
2017-11-02	AADR	ETF	57.52	57.52	56.93	57.09	24400.0
2017-11-02	AAXJ	ETF	75.99	76.16	75.75	76.14	1289300.0
2017-11-02	ACSI	ETF	29.479	29.569	29.479	29.51	1303.0
2017-11-02	ACTX	ETF	47.2004	47.2004	41.3004	41.3004	1198.0
2017-11-02	ACWF	ETF	29.99	30.18	29.9697	29.98	5880.0
2017-11-02	ACWI	ETF	70.41	70.56	70.24	70.52	1420100.0
2017-11-02	ACWV	ETF	82.47	82.68	82.45	82.62	52700.0
2017-11-02	ACWX	ETF	49.41	49.54	49.3475	49.54	444462.0
2017-11-02	ADRE	ETF	43.24	43.24	42.8	42.99	7093.0
2017-11-02	AFK	ETF	23.9	23.9	23.58	23.86	3956.0
2017-11-02	AFTY	ETF	18.07	18.07	18.01	18.022	3400.0
2017-11-02	AGG	ETF	109.35	109.5	109.33	109.35	2160500.0
2017-11-02	AGGY	ETF	50.69	50.77	50.69	50.729	37400.0
2017-11-02	AGNG	ETF	19.237	19.299	19.237	19.29	1400.0
2017-11-02	AGQ	ETF	35.06	35.33	34.59	34.94	167900.0
2017-11-02	AGZ	ETF	113.44	113.4599	113.328	113.4095	11981.0
2017-11-02	AGZD	ETF	24.135	24.14	24.075	24.075	2000.0
2017-11-02	AIA	ETF	65.48	65.605	65.2916	65.5659	12828.0
2017-11-02	AIEQ	ETF	24.86	24.86	24.62	24.68	104700.0
2017-11-02	AIRR	ETF	26.44	26.66	26.4	26.62	14400.0
2017-11-02	AIVI	ETF	43.27	43.38	43.24	43.35	22400.0
2017-11-02	ALTY	ETF	15.75	15.75	15.34	15.34	6300.0
2017-11-02	AMJ	ETF	27.49	27.51	26.7	26.96	3679135.0
2017-11-02	AMLP	ETF	54.5	54.5	52.8	53.4	3589100.0
2017-11-02	AMZA	ETF	85.3	85.4	81.6	83.0	203280.0
2017-11-02	ANGL	ETF	30.2	30.25	30.15	30.24	714600.0
2017-11-02	AOA	ETF	54.42	54.52	54.33	54.52	40100.0
2017-11-02	AOK	ETF	34.75	34.75	34.64	34.695	109043.0
2017-11-02	AOM	ETF	38.22	38.27	38.19	38.27	61146.0
2017-11-02	AOR	ETF	45.36	45.41	45.3	45.41	94495.0
2017-11-02	ARGT	ETF	32.13	32.27	32.05	32.18	48600.0
2017-11-02	ARKG	ETF	24.85	25.38	24.72	25.239	35600.0
2017-11-02	ARKK	ETF	34.9	34.96	34.61	34.83	120500.0
2017-11-02	ARKQ	ETF	32.92	32.92	32.56	32.77	31700.0
2017-11-02	ARKW	ETF	42.91	42.993	42.58	42.78	68900.0
2017-11-02	ASEA	ETF	15.98	15.98	15.98	15.98	100.0
2017-11-02	ASET	ETF	28.229	28.249	28.21	28.21	2713.0
2017-11-02	ASHR	ETF	30.66	30.66	30.55	30.59	522700.0
2017-11-02	ASHS	ETF	35.8	35.8	35.73	35.79	8600.0
2017-11-02	ASHX	ETF	22.5	22.5	22.5	22.5	100.0
2017-11-02	ATMP	ETF	20.64	20.8	20.21	20.43	28500.0
2017-11-02	BAB	ETF	30.5	30.59	30.4908	30.53	111398.0
2017-11-02	BAL	ETF	44.99	45.73	44.99	45.68	2614.0
2017-11-02	BAR	ETF	12.817	12.818	12.749	12.774	59200.0

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

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