PREVIEW / etf_daily / 2017-09-29

all etf daily files

  file:    by_date/etf_daily/2017/2017-09-29.parquet
  size:    57 KB
  rows:    1,458

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-09-29	SPY	ETF	250.34	251.32	250.13	251.23	85578000.0
2017-09-29	QQQ	ETF	144.7	145.555	144.32	145.45	43102366.0
2017-09-29	IWM	ETF	147.92	148.43	147.74	148.18	21738700.0
2017-09-29	DIA	ETF	223.39	223.87	223.13	223.82	2415800.0
2017-09-29	GLD	ETF	122.29	122.3	121.55	121.58	10208000.0
2017-09-29	TLT	ETF	124.76	125.03	124.27	124.76	11285500.0
2017-09-29	AADR	ETF	55.26	55.62	55.26	55.6	31000.0
2017-09-29	AAXJ	ETF	71.77	72.35	71.71	72.22	1549700.0
2017-09-29	ACSI	ETF	29.2	29.23	29.2	29.23	2020.0
2017-09-29	ACTX	ETF	65.4906	66.6706	64.9006	66.6706	137.0
2017-09-29	ACWF	ETF	28.89	29.059	28.89	29.0	694.0
2017-09-29	ACWI	ETF	68.59	68.85	68.5	68.82	2570300.0
2017-09-29	ACWV	ETF	81.16	81.41	81.16	81.38	73600.0
2017-09-29	ACWX	ETF	48.13	48.38	48.11	48.35	236812.0
2017-09-29	ADRE	ETF	41.92	42.12	41.91	42.12	6541.0
2017-09-29	AFK	ETF	23.29	23.29	23.03	23.22	14472.0
2017-09-29	AFTY	ETF	16.93	16.93	16.8	16.811	6900.0
2017-09-29	AGG	ETF	109.74	109.77	109.54	109.59	5770800.0
2017-09-29	AGGY	ETF	50.76	50.76	50.613	50.72	70100.0
2017-09-29	AGNG	ETF	19.29	19.39	19.192	19.39	18200.0
2017-09-29	AGQ	ETF	33.76	33.85	33.07	33.15	107600.0
2017-09-29	AGZ	ETF	113.7562	113.7562	113.6386	113.66	10312.0
2017-09-29	AGZD	ETF	23.98	23.995	23.98	23.995	80800.0
2017-09-29	AIA	ETF	60.92	61.469	60.88	61.37	45376.0
2017-09-29	AIRR	ETF	26.16	26.16	26.027	26.04	14400.0
2017-09-29	AIVI	ETF	42.48	42.69	42.48	42.66	11200.0
2017-09-29	ALTY	ETF	15.91	15.91	15.72	15.78	4800.0
2017-09-29	AMJ	ETF	27.96	28.54	27.96	28.22	3694734.0
2017-09-29	AMLP	ETF	55.85	57.0	55.75	56.1	2309860.0
2017-09-29	AMZA	ETF	92.4	94.3	92.0	93.3	96660.0
2017-09-29	ANGL	ETF	30.33	30.36	30.26	30.31	1123800.0
2017-09-29	AOA	ETF	53.42	53.58	53.36	53.58	42500.0
2017-09-29	AOK	ETF	34.41	34.48	34.38	34.48	39020.0
2017-09-29	AOM	ETF	37.91	37.97	37.8702	37.97	259095.0
2017-09-29	AOR	ETF	44.74	44.83	44.6657	44.83	55330.0
2017-09-29	ARGT	ETF	31.35	31.81	31.35	31.8	196700.0
2017-09-29	ARKG	ETF	26.19	26.25	25.953	26.24	42100.0
2017-09-29	ARKK	ETF	34.14	34.34	34.1	34.288	100900.0
2017-09-29	ARKQ	ETF	31.39	31.849	31.39	31.83	24900.0
2017-09-29	ARKW	ETF	40.5	40.689	40.48	40.66	27700.0
2017-09-29	ASEA	ETF	15.61	15.68	15.59	15.68	3000.0
2017-09-29	ASET	ETF	28.0683	28.12	28.0683	28.12	3602.0
2017-09-29	ASHR	ETF	29.17	29.19	29.09	29.19	485000.0
2017-09-29	ASHS	ETF	36.41	36.44	36.3	36.44	1100.0
2017-09-29	ASHX	ETF	21.61	21.61	21.54	21.54	1070.0
2017-09-29	ATMP	ETF	21.15	21.5	21.15	21.37	52700.0
2017-09-29	BAB	ETF	30.42	30.42	30.3	30.38	183914.0
2017-09-29	BAL	ETF	45.5	45.51	45.21	45.21	1051.0
2017-09-29	BAR	ETF	12.86	12.86	12.8209	12.8209	30320.0
2017-09-29	BBC	ETF	29.07	29.17	28.75	29.15	12187.0

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

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