PREVIEW / etf_daily / 2017-08-29

all etf daily files

  file:    by_date/etf_daily/2017/2017-08-29.parquet
  size:    56 KB
  rows:    1,441

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-08-29	SPY	ETF	243.06	245.15	242.93	244.85	51135700.0
2017-08-29	QQQ	ETF	141.18	143.21	141.06	142.97	24498333.0
2017-08-29	IWM	ETF	136.49	137.81	136.23	137.49	20277600.0
2017-08-29	DIA	ETF	216.68	218.76	216.62	218.59	2013300.0
2017-08-29	GLD	ETF	125.81	125.87	124.05	124.42	9861500.0
2017-08-29	TLT	ETF	128.46	128.52	127.31	127.65	7659400.0
2017-08-29	AADR	ETF	51.89	51.91	51.46	51.78	7400.0
2017-08-29	AAXJ	ETF	71.16	71.69	71.07	71.62	1123400.0
2017-08-29	ACSI	ETF	28.64	28.64	28.59	28.5945	706.0
2017-08-29	ACTX	ETF	72.5707	77.8807	72.5707	73.7507	279.0
2017-08-29	ACWF	ETF	27.882	27.882	27.882	27.882	300.0
2017-08-29	ACWI	ETF	66.6	67.04	66.53	66.94	1259300.0
2017-08-29	ACWV	ETF	80.68	80.92	80.67	80.84	137400.0
2017-08-29	ACWX	ETF	47.0	47.1815	46.94	47.13	479896.0
2017-08-29	ADRE	ETF	41.77	42.34	41.586	42.34	5688.0
2017-08-29	AFK	ETF	23.88	24.29	23.5899	23.67	13246.0
2017-08-29	AFTY	ETF	17.21	17.22	17.11	17.186	12800.0
2017-08-29	AGG	ETF	110.48	110.49	110.26	110.32	2092200.0
2017-08-29	AGGY	ETF	50.98	50.99	50.9	50.93	13700.0
2017-08-29	AGNG	ETF	18.818	18.818	18.8	18.8	400.0
2017-08-29	AGQ	ETF	37.45	37.48	35.93	36.31	256800.0
2017-08-29	AGZ	ETF	114.4	114.46	114.268	114.33	23912.0
2017-08-29	AGZD	ETF	23.895	23.92	23.89	23.9	4600.0
2017-08-29	AIA	ETF	60.37	60.7397	60.25	60.68	21363.0
2017-08-29	AIRR	ETF	22.62	23.21	22.62	23.2	25000.0
2017-08-29	AIVI	ETF	41.66	41.89	41.66	41.78	13200.0
2017-08-29	ALTY	ETF	15.5	15.6	15.5	15.586	6300.0
2017-08-29	AMJ	ETF	27.02	27.4	27.02	27.37	2183378.0
2017-08-29	AMLP	ETF	54.0	54.5	53.7	54.35	2287280.0
2017-08-29	AMZA	ETF	88.4	89.38	87.7	89.3	68470.0
2017-08-29	ANGL	ETF	29.9	29.94	29.85	29.89	971900.0
2017-08-29	AOA	ETF	52.08	52.37	52.08	52.29	40500.0
2017-08-29	AOK	ETF	34.23	34.29	34.2	34.24	68269.0
2017-08-29	AOM	ETF	37.49	37.59	37.462	37.58	130668.0
2017-08-29	AOR	ETF	43.86	44.07	43.86	44.02	95285.0
2017-08-29	ARCM	ETF	100.35	100.35	100.35	100.35	20000.0
2017-08-29	ARGT	ETF	29.52	29.61	29.37	29.49	207700.0
2017-08-29	ARKG	ETF	23.9	24.319	23.8	24.2	24100.0
2017-08-29	ARKK	ETF	32.09	32.909	32.05	32.8	147400.0
2017-08-29	ARKQ	ETF	29.04	29.48	28.96	29.45	24700.0
2017-08-29	ARKW	ETF	38.47	39.66	38.47	39.58	47200.0
2017-08-29	ASEA	ETF	15.5	15.52	15.5	15.52	800.0
2017-08-29	ASET	ETF	27.9998	27.9998	27.9998	27.9998	534.0
2017-08-29	ASHR	ETF	29.42	29.52	29.36	29.47	1520800.0
2017-08-29	ASHS	ETF	35.26	35.38	35.26	35.38	6600.0
2017-08-29	ASHX	ETF	21.62	21.62	21.62	21.62	500.0
2017-08-29	ATMP	ETF	20.53	20.72	20.47	20.72	114800.0
2017-08-29	BAB	ETF	30.68	30.68	30.4	30.5	205787.0
2017-08-29	BAL	ETF	46.09	46.502	46.0101	46.14	6899.0
2017-08-29	BBC	ETF	26.18	26.71	26.04	26.59	20988.0

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

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