PREVIEW / etf_daily / 2017-04-13

all etf daily files

  file:    by_date/etf_daily/2017/2017-04-13.parquet
  size:    54 KB
  rows:    1,375

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-13	SPY	ETF	233.64	234.49	232.51	232.51	92880400.0
2017-04-13	QQQ	ETF	130.75	131.51	130.38	130.4	23683020.0
2017-04-13	IWM	ETF	134.88	135.37	133.66	133.72	30207000.0
2017-04-13	DIA	ETF	205.34	205.94	204.36	204.37	3605200.0
2017-04-13	GLD	ETF	122.54	122.65	122.03	122.6	9892600.0
2017-04-13	TLT	ETF	123.45	123.74	122.91	123.47	8396700.0
2017-04-13	AADR	ETF	46.06	46.06	45.76	45.76	12500.0
2017-04-13	AAXJ	ETF	62.99	63.17	62.76	62.79	909500.0
2017-04-13	ACSI	ETF	27.89	27.89	27.83	27.83	1254.0
2017-04-13	ACTX	ETF	106.201	112.101	105.6109	106.201	766.0
2017-04-13	ACWF	ETF	25.52	25.52	25.52	25.52	17602.0
2017-04-13	ACWI	ETF	62.88	63.02	62.59	62.59	1809800.0
2017-04-13	ACWV	ETF	77.43	77.52	77.19	77.24	847700.0
2017-04-13	ACWX	ETF	43.39	43.45	43.24	43.24	317633.0
2017-04-13	ADRE	ETF	36.31	36.518	36.31	36.4316	1461.0
2017-04-13	AFK	ETF	21.1918	21.3501	21.1918	21.26	9194.0
2017-04-13	AGG	ETF	109.25	109.39	109.13	109.27	2339900.0
2017-04-13	AGGY	ETF	50.26	50.349	50.243	50.326	3200.0
2017-04-13	AGNG	ETF	16.967	16.967	16.967	16.967	100.0
2017-04-13	AGQ	ETF	42.67	42.81	42.11	42.54	150900.0
2017-04-13	AGZ	ETF	113.73	113.736	113.49	113.63	35939.0
2017-04-13	AGZD	ETF	23.99	24.015	23.98	24.015	42200.0
2017-04-13	AIA	ETF	52.71	52.76	52.45	52.45	47847.0
2017-04-13	AIQ	ETF	12.9	12.95	12.8202	12.85	43816.0
2017-04-13	AIRR	ETF	23.44	23.66	23.276	23.28	243900.0
2017-04-13	AIVI	ETF	39.18	39.26	39.1	39.1	5800.0
2017-04-13	ALTY	ETF	15.55	15.56	15.5	15.5	11900.0
2017-04-13	AMJ	ETF	32.12	32.26	31.88	31.93	729228.0
2017-04-13	AMLP	ETF	63.3	63.55	63.05	63.1	1523620.0
2017-04-13	AMZA	ETF	106.0	106.02	104.8	104.9	85350.0
2017-04-13	ANGL	ETF	29.49	29.53	29.43	29.46	400400.0
2017-04-13	AOA	ETF	49.61	49.65	49.39	49.41	34200.0
2017-04-13	AOK	ETF	33.4	33.4	33.27	33.38	37804.0
2017-04-13	AOM	ETF	36.41	36.41	36.23	36.31	50194.0
2017-04-13	AOR	ETF	42.17	42.1999	42.0	42.0	46847.0
2017-04-13	ARCM	ETF	100.185	100.19	100.185	100.19	80.0
2017-04-13	ARGT	ETF	28.84	28.97	28.65	28.66	28100.0
2017-04-13	ARKG	ETF	20.13	20.13	20.13	20.13	800.0
2017-04-13	ARKK	ETF	23.85	23.88	23.749	23.85	5400.0
2017-04-13	ARKQ	ETF	24.52	24.54	24.35	24.41	9300.0
2017-04-13	ARKW	ETF	29.0	29.12	28.84	28.84	2400.0
2017-04-13	ASEA	ETF	14.24	14.54	14.24	14.54	9000.0
2017-04-13	ASET	ETF	26.86	26.86	26.75	26.77	1052.0
2017-04-13	ASHR	ETF	25.42	25.46	25.39	25.4	350300.0
2017-04-13	ASHS	ETF	34.42	34.84	34.42	34.8	1000.0
2017-04-13	ATMP	ETF	23.79	23.81	23.54	23.54	22600.0
2017-04-13	BAB	ETF	29.59	29.5916	29.5	29.56	93261.0
2017-04-13	BAL	ETF	48.5	48.5	48.4	48.4	3421.0
2017-04-13	BBC	ETF	21.7	21.97	21.5	21.94	10615.0
2017-04-13	BBH	ETF	117.98	119.26	117.98	118.95	13900.0

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

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