PREVIEW / etf_daily / 2017-01-17

all etf daily files

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

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-17	SPY	ETF	226.31	226.78	225.8	226.25	61240800.0
2017-01-17	QQQ	ETF	122.79	123.03	122.4342	122.79	14538484.0
2017-01-17	IWM	ETF	135.6	135.69	134.13	134.41	28197800.0
2017-01-17	DIA	ETF	198.27	198.65	197.59	198.09	3329800.0
2017-01-17	GLD	ETF	115.89	115.96	115.5	115.85	9142400.0
2017-01-17	TLT	ETF	122.81	122.94	121.99	122.58	7853300.0
2017-01-17	AADR	ETF	43.44	43.77	43.42	43.77	3500.0
2017-01-17	AAXJ	ETF	57.61	57.85	57.61	57.72	1299500.0
2017-01-17	ACSI	ETF	27.2699	27.27	27.1	27.11	5527.0
2017-01-17	ACTX	ETF	47.2004	66.7886	41.3004	58.4105	9160.0
2017-01-17	ACWF	ETF	25.06	25.06	24.85	24.93	3762.0
2017-01-17	ACWI	ETF	60.4	60.6	60.4	60.51	2090000.0
2017-01-17	ACWV	ETF	73.45	73.87	73.45	73.8	119300.0
2017-01-17	ACWX	ETF	41.56	41.58	41.44	41.53	2136345.0
2017-01-17	ADRE	ETF	34.26	34.435	34.26	34.36	8171.0
2017-01-17	AFK	ETF	21.18	22.0	21.022	21.35	17455.0
2017-01-17	AFTY	ETF	13.61	13.658	13.6	13.61	700.0
2017-01-17	AGG	ETF	108.81	108.87	108.65	108.79	3685700.0
2017-01-17	AGGY	ETF	50.03	50.04	49.9	50.018	6200.0
2017-01-17	AGQ	ETF	36.92	37.4	36.77	37.25	203800.0
2017-01-17	AGZ	ETF	112.8	113.143	112.8	113.03	14807.0
2017-01-17	AGZD	ETF	23.985	24.14	23.975	24.085	27000.0
2017-01-17	AIA	ETF	48.59	48.7504	48.59	48.64	68478.0
2017-01-17	AIQ	ETF	9.7	9.7	9.65	9.7	7948.0
2017-01-17	AIRR	ETF	23.64	23.64	23.298	23.349	99400.0
2017-01-17	AIVI	ETF	38.49	38.55	38.44	38.48	32400.0
2017-01-17	ALTY	ETF	15.55	15.55	15.278	15.35	5200.0
2017-01-17	AMJ	ETF	32.01	32.28	32.01	32.17	3134112.0
2017-01-17	AMLP	ETF	63.9	64.15	63.85	63.9	1480620.0
2017-01-17	AMZA	ETF	109.8	110.1	109.0	109.8	72090.0
2017-01-17	ANGL	ETF	29.22	29.24	29.15	29.21	238700.0
2017-01-17	AOA	ETF	47.94	48.07	47.92	47.96	251600.0
2017-01-17	AOK	ETF	32.86	32.86	32.77	32.79	230246.0
2017-01-17	AOM	ETF	35.69	35.69	35.54	35.56	887522.0
2017-01-17	AOR	ETF	41.18	41.18	41.01	41.11	925601.0
2017-01-17	ARGT	ETF	25.24	25.28	25.11	25.2	134100.0
2017-01-17	ARKG	ETF	18.2	18.21	17.72	17.82	9600.0
2017-01-17	ARKK	ETF	21.74	21.8	21.72	21.72	6000.0
2017-01-17	ARKQ	ETF	23.32	23.32	22.9	22.92	4700.0
2017-01-17	ARKW	ETF	27.13	27.13	26.8	26.84	6900.0
2017-01-17	ASEA	ETF	13.43	13.43	13.3	13.31	35900.0
2017-01-17	ASET	ETF	26.0	26.0	25.9922	25.9922	339.0
2017-01-17	ASHR	ETF	24.39	24.52	24.39	24.51	1191000.0
2017-01-17	ASHS	ETF	32.17	32.22	32.13	32.17	16400.0
2017-01-17	ATMP	ETF	23.7	23.89	23.7	23.82	29500.0
2017-01-17	BAB	ETF	29.42	29.4699	29.29	29.36	181039.0
2017-01-17	BAL	ETF	47.73	47.8	47.325	47.43	10912.0
2017-01-17	BBC	ETF	19.2183	19.2256	19.14	19.2111	4009.0
2017-01-17	BBH	ETF	112.76	112.9	111.53	111.99	59200.0
2017-01-17	BBP	ETF	35.37	35.37	34.72	34.9	22600.0

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

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