PREVIEW / etf_daily / 2017-04-17

all etf daily files

  file:    by_date/etf_daily/2017/2017-04-17.parquet
  size:    55 KB
  rows:    1,394

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-04-17	SPY	ETF	233.11	234.57	232.88	234.57	68405400.0
2017-04-17	QQQ	ETF	130.8	131.5	130.72	131.48	13325508.0
2017-04-17	IWM	ETF	134.07	135.32	133.68	135.29	18278800.0
2017-04-17	DIA	ETF	204.93	206.26	204.86	206.17	2260900.0
2017-04-17	GLD	ETF	122.55	123.07	121.99	122.24	8469600.0
2017-04-17	TLT	ETF	123.46	123.55	122.86	123.09	8015000.0
2017-04-17	AADR	ETF	46.08	46.45	46.02	46.45	7200.0
2017-04-17	AAXJ	ETF	62.85	63.11	62.78	63.11	326100.0
2017-04-17	ACSI	ETF	27.8014	27.83	27.8014	27.83	382.0
2017-04-17	ACTX	ETF	108.561	128.6212	107.971	110.331	2613.0
2017-04-17	ACWI	ETF	62.83	63.08	62.76	63.08	2123600.0
2017-04-17	ACWV	ETF	77.41	77.76	77.41	77.76	233600.0
2017-04-17	ACWX	ETF	43.36	43.59	43.36	43.59	439413.0
2017-04-17	ADRE	ETF	36.38	36.5398	36.3	36.5398	5387.0
2017-04-17	AFK	ETF	21.16	21.5899	21.13	21.46	13635.0
2017-04-17	AFTY	ETF	13.72	13.75	13.68	13.68	1800.0
2017-04-17	AGG	ETF	109.3	109.4	109.18	109.21	1646100.0
2017-04-17	AGGY	ETF	50.37	50.37	50.233	50.244	3600.0
2017-04-17	AGNG	ETF	17.015	17.015	17.015	17.015	100.0
2017-04-17	AGQ	ETF	42.53	42.79	41.88	42.08	133500.0
2017-04-17	AGZ	ETF	113.53	113.7499	113.5251	113.57	12077.0
2017-04-17	AGZD	ETF	23.995	24.015	23.985	23.99	5200.0
2017-04-17	AIA	ETF	52.44	52.59	52.36	52.59	22116.0
2017-04-17	AIQ	ETF	12.85	12.95	12.85	12.9	75586.0
2017-04-17	AIRR	ETF	23.27	23.54	23.27	23.521	29000.0
2017-04-17	AIVI	ETF	39.21	39.33	39.21	39.33	4500.0
2017-04-17	ALTY	ETF	15.72	15.72	15.526	15.535	1800.0
2017-04-17	AMJ	ETF	31.92	32.02	31.79	31.92	636935.0
2017-04-17	AMLP	ETF	63.2	63.25	62.85	63.1	745960.0
2017-04-17	AMUB	ETF	20.045	20.0625	20.045	20.0625	513.0
2017-04-17	AMZA	ETF	105.1	105.4	104.6	105.0	86030.0
2017-04-17	ANGL	ETF	29.49	29.56	29.47	29.52	222000.0
2017-04-17	AOA	ETF	49.52	49.75	49.52	49.75	44000.0
2017-04-17	AOK	ETF	33.37	33.42	33.32	33.4	61061.0
2017-04-17	AOM	ETF	36.31	36.39	36.258	36.39	67360.0
2017-04-17	AOR	ETF	42.17	42.26	42.09	42.26	108061.0
2017-04-17	ARCM	ETF	100.0	100.0	100.0	100.0	3000.0
2017-04-17	ARGT	ETF	28.84	29.03	28.74	29.03	38500.0
2017-04-17	ARKG	ETF	20.294	20.294	20.294	20.294	400.0
2017-04-17	ARKK	ETF	23.87	24.011	23.765	23.986	6000.0
2017-04-17	ARKQ	ETF	24.55	24.568	24.45	24.568	8000.0
2017-04-17	ARKW	ETF	29.014	29.078	29.014	29.05	2700.0
2017-04-17	ASEA	ETF	14.68	14.68	14.39	14.43	1100.0
2017-04-17	ASET	ETF	26.93	26.96	26.93	26.96	425.0
2017-04-17	ASHR	ETF	25.29	25.29	25.12	25.13	571600.0
2017-04-17	ASHS	ETF	34.54	34.54	33.98	34.01	10100.0
2017-04-17	ASHX	ETF	19.7	19.7	19.5101	19.5101	466.0
2017-04-17	ATMP	ETF	23.64	23.68	23.49	23.54	29000.0
2017-04-17	BAB	ETF	29.56	29.6132	29.55	29.56	49949.0
2017-04-17	BAL	ETF	49.06	49.87	49.06	49.87	5092.0

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

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