PREVIEW / etf_daily / 2017-10-05

all etf daily files

  file:    by_date/etf_daily/2017/2017-10-05.parquet
  size:    57 KB
  rows:    1,457

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-05	SPY	ETF	253.54	254.68	253.2	254.66	63522800.0
2017-10-05	QQQ	ETF	146.54	147.54	146.4063	147.46	31562353.0
2017-10-05	IWM	ETF	150.29	150.63	149.87	150.26	22538500.0
2017-10-05	DIA	ETF	226.61	227.66	226.45	227.64	2258500.0
2017-10-05	GLD	ETF	121.15	121.24	120.4	120.52	6205400.0
2017-10-05	TLT	ETF	124.27	124.3	123.69	123.94	8180300.0
2017-10-05	AADR	ETF	56.77	56.87	56.55	56.59	31200.0
2017-10-05	AAXJ	ETF	73.5	74.03	73.5	73.97	2134300.0
2017-10-05	ACSI	ETF	29.46	29.52	29.46	29.5	5111.0
2017-10-05	ACTX	ETF	57.8205	64.9006	56.9355	63.1306	244.0
2017-10-05	ACWF	ETF	29.31	29.47	29.31	29.37	6218.0
2017-10-05	ACWI	ETF	69.25	69.51	69.25	69.49	846500.0
2017-10-05	ACWV	ETF	81.82	81.99	81.82	81.93	1077700.0
2017-10-05	ACWX	ETF	48.54	48.65	48.512	48.62	156490.0
2017-10-05	ADRE	ETF	42.79	42.99	42.79	42.87	13856.0
2017-10-05	AFK	ETF	23.4	23.56	23.4	23.55	5952.0
2017-10-05	AFTY	ETF	17.55	17.78	17.37	17.41	7700.0
2017-10-05	AGG	ETF	109.54	109.54	109.37	109.44	1909900.0
2017-10-05	AGGY	ETF	50.78	50.78	50.72	50.732	13600.0
2017-10-05	AGNG	ETF	19.62	19.665	19.585	19.643	17200.0
2017-10-05	AGQ	ETF	33.38	33.44	32.87	32.97	78500.0
2017-10-05	AGZ	ETF	113.435	113.4688	113.37	113.38	20792.0
2017-10-05	AGZD	ETF	24.07	24.07	24.07	24.07	2000.0
2017-10-05	AIA	ETF	62.62	63.21	62.55	63.21	33541.0
2017-10-05	AIRR	ETF	26.39	26.417	26.28	26.33	11200.0
2017-10-05	AIVI	ETF	42.33	42.37	42.31	42.32	3800.0
2017-10-05	ALTY	ETF	15.92	15.92	15.756	15.79	3800.0
2017-10-05	AMJ	ETF	28.55	28.7	28.435	28.7	1449159.0
2017-10-05	AMLP	ETF	56.75	57.15	56.6	57.15	1187000.0
2017-10-05	AMZA	ETF	88.8	90.0	88.71	89.8	96360.0
2017-10-05	ANGL	ETF	30.2	30.25	30.18	30.21	200800.0
2017-10-05	AOA	ETF	53.79	53.84	53.67	53.82	79600.0
2017-10-05	AOK	ETF	34.5	34.52	34.44	34.51	33894.0
2017-10-05	AOM	ETF	37.96	37.98	37.86	37.96	98794.0
2017-10-05	AOR	ETF	44.89	44.94	44.8	44.94	85473.0
2017-10-05	ARGT	ETF	32.38	32.57	32.38	32.49	55200.0
2017-10-05	ARKG	ETF	26.66	26.86	26.472	26.818	19900.0
2017-10-05	ARKK	ETF	34.94	35.13	34.68	35.12	113000.0
2017-10-05	ARKQ	ETF	32.57	32.639	32.324	32.62	13200.0
2017-10-05	ARKW	ETF	41.05	41.57	41.05	41.57	34900.0
2017-10-05	ASEA	ETF	15.69	15.88	15.69	15.88	1300.0
2017-10-05	ASET	ETF	28.01	28.1056	28.01	28.1056	451.0
2017-10-05	ASHR	ETF	30.03	30.1	29.99	30.09	389200.0
2017-10-05	ASHS	ETF	37.32	37.41	37.28	37.4	4200.0
2017-10-05	ASHX	ETF	22.21	22.2913	22.21	22.2913	265.0
2017-10-05	ATMP	ETF	21.37	21.68	21.37	21.67	31500.0
2017-10-05	BAB	ETF	30.35	30.4299	30.33	30.38	122272.0
2017-10-05	BAL	ETF	45.25	45.25	44.966	44.966	612.0
2017-10-05	BAR	ETF	12.728	12.728	12.687	12.687	20650.0
2017-10-05	BBC	ETF	30.04	30.12	29.681	29.91	40888.0

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

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