PREVIEW / etf_daily / 2017-01-10

all etf daily files

  file:    by_date/etf_daily/2017/2017-01-10.parquet
  size:    54 KB
  rows:    1,365

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-01-10	SPY	ETF	226.48	227.45	226.01	226.46	63771900.0
2017-01-10	QQQ	ETF	122.37	122.97	122.1	122.6	16176631.0
2017-01-10	IWM	ETF	135.0	136.38	134.76	136.09	21684900.0
2017-01-10	DIA	ETF	198.72	199.41	198.21	198.4	3029200.0
2017-01-10	GLD	ETF	112.94	113.45	112.64	113.15	6093400.0
2017-01-10	TLT	ETF	121.55	121.91	121.28	121.75	8417900.0
2017-01-10	AADR	ETF	43.04	43.04	42.8	42.82	2800.0
2017-01-10	AAXJ	ETF	57.01	57.47	56.99	57.13	1329300.0
2017-01-10	ACSI	ETF	27.1307	27.28	27.1307	27.21	5850.0
2017-01-10	ACTX	ETF	27.1402	28.9103	26.5502	27.7302	933.0
2017-01-10	ACWF	ETF	24.71	25.4	24.71	24.83	10959.0
2017-01-10	ACWI	ETF	60.24	60.47	60.21	60.24	1393600.0
2017-01-10	ACWV	ETF	73.47	73.6	73.3	73.45	113200.0
2017-01-10	ACWX	ETF	41.18	41.3	41.12	41.17	996918.0
2017-01-10	ADRE	ETF	33.85	34.1	33.85	34.0	9904.0
2017-01-10	AFK	ETF	20.75	20.97	20.3615	20.79	12294.0
2017-01-10	AFTY	ETF	13.21	13.327	13.21	13.3	400.0
2017-01-10	AGG	ETF	108.45	108.55	108.42	108.44	2396300.0
2017-01-10	AGGY	ETF	49.83	49.89	49.78	49.826	16700.0
2017-01-10	AGQ	ETF	35.11	36.13	35.1	35.66	238500.0
2017-01-10	AGZ	ETF	113.34	113.34	112.7127	112.8	24216.0
2017-01-10	AGZD	ETF	24.05	24.165	24.05	24.13	46600.0
2017-01-10	AIA	ETF	47.89	48.3292	47.89	48.09	59120.0
2017-01-10	AIQ	ETF	9.65	9.8	9.65	9.7	21532.0
2017-01-10	AIRR	ETF	23.14	23.68	23.1	23.65	191900.0
2017-01-10	AIVI	ETF	37.96	38.08	37.96	37.99	34000.0
2017-01-10	ALTY	ETF	15.273	15.273	15.273	15.273	100.0
2017-01-10	AMJ	ETF	32.09	32.09	31.51	31.54	2050222.0
2017-01-10	AMLP	ETF	63.85	63.9	63.1	63.15	2342400.0
2017-01-10	AMZA	ETF	109.6	109.6	107.9	108.1	59890.0
2017-01-10	ANGL	ETF	29.15	29.18	29.08	29.15	141400.0
2017-01-10	AOA	ETF	47.98	48.0	47.84	47.85	49500.0
2017-01-10	AOK	ETF	32.64	32.7899	32.64	32.74	45514.0
2017-01-10	AOM	ETF	35.46	35.548	35.45	35.51	107291.0
2017-01-10	AOR	ETF	41.11	41.11	40.93	41.01	138615.0
2017-01-10	ARGT	ETF	24.49	25.06	24.49	25.05	73500.0
2017-01-10	ARKG	ETF	18.45	18.66	18.45	18.62	2800.0
2017-01-10	ARKK	ETF	21.87	21.95	21.83	21.95	6600.0
2017-01-10	ARKQ	ETF	22.96	23.013	22.88	22.92	1900.0
2017-01-10	ARKW	ETF	26.89	26.997	26.89	26.95	4700.0
2017-01-10	ASEA	ETF	13.32	13.33	13.32	13.33	300.0
2017-01-10	ASET	ETF	26.04	26.04	26.04	26.04	228.0
2017-01-10	ASHR	ETF	24.31	24.35	24.25	24.34	1222200.0
2017-01-10	ASHS	ETF	33.51	33.65	33.51	33.59	8400.0
2017-01-10	ASHX	ETF	19.06	19.191	19.06	19.191	400.0
2017-01-10	ATMP	ETF	23.73	23.81	23.38	23.43	85400.0
2017-01-10	BAB	ETF	29.39	29.43	29.33	29.36	70806.0
2017-01-10	BAL	ETF	48.5372	48.5372	48.1599	48.1692	2712.0
2017-01-10	BBC	ETF	20.21	20.23	19.7996	20.22	5297.0
2017-01-10	BBH	ETF	115.73	116.65	115.04	116.23	58300.0

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

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