PREVIEW / etf_daily / 2017-01-31

all etf daily files

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

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-31	SPY	ETF	226.98	227.6	226.32	227.53	75880800.0
2017-01-31	QQQ	ETF	124.4	124.6	123.85	124.57	19091133.0
2017-01-31	IWM	ETF	133.87	135.56	133.48	135.23	32945000.0
2017-01-31	DIA	ETF	198.72	198.89	197.56	198.36	4628100.0
2017-01-31	GLD	ETF	115.27	115.82	115.18	115.55	10421900.0
2017-01-31	TLT	ETF	119.33	120.4	119.25	120.1	13298500.0
2017-01-31	AADR	ETF	44.18	44.36	43.89	44.22	3200.0
2017-01-31	AAXJ	ETF	58.84	59.07	58.83	58.99	702000.0
2017-01-31	ACSI	ETF	26.99	27.14	26.95	27.14	4809.0
2017-01-31	ACTX	ETF	179.9516	206.4429	174.0516	196.4718	4682.0
2017-01-31	ACWF	ETF	25.1386	25.1386	24.985	25.05	4208.0
2017-01-31	ACWI	ETF	60.85	60.93	60.61	60.89	2894400.0
2017-01-31	ACWV	ETF	73.51	73.97	73.51	73.97	105800.0
2017-01-31	ACWX	ETF	41.78	41.86	41.6487	41.81	1164129.0
2017-01-31	ADRE	ETF	35.05	35.2199	35.0	35.2199	8473.0
2017-01-31	AFK	ETF	21.05	21.48	21.05	21.2499	6088.0
2017-01-31	AFTY	ETF	13.888	13.888	13.888	13.888	400.0
2017-01-31	AGG	ETF	108.08	108.37	108.08	108.29	7552700.0
2017-01-31	AGGY	ETF	49.66	49.7	49.561	49.67	26300.0
2017-01-31	AGQ	ETF	38.42	39.04	38.22	38.86	227400.0
2017-01-31	AGZ	ETF	113.11	113.13	112.79	112.91	10188.0
2017-01-31	AGZD	ETF	24.075	24.075	24.04	24.065	7200.0
2017-01-31	AIA	ETF	49.77	49.9	49.653	49.81	207800.0
2017-01-31	AIQ	ETF	9.75	9.8	9.75	9.775	4940.0
2017-01-31	AIRR	ETF	23.94	23.98	23.536	23.95	133800.0
2017-01-31	AIVI	ETF	38.41	38.45	38.29	38.45	60500.0
2017-01-31	ALTY	ETF	15.236	15.34	15.236	15.34	900.0
2017-01-31	AMJ	ETF	33.05	33.11	32.71	33.11	1814604.0
2017-01-31	AMLP	ETF	65.05	65.1	64.4	65.05	1728060.0
2017-01-31	AMUB	ETF	20.6705	20.6705	20.6705	20.6705	100.0
2017-01-31	AMZA	ETF	109.7	110.0	108.6	109.9	35950.0
2017-01-31	ANGL	ETF	29.37	29.38	29.33	29.33	191000.0
2017-01-31	AOA	ETF	48.15	48.23	48.03	48.18	41000.0
2017-01-31	AOK	ETF	32.61	32.7792	32.61	32.73	60963.0
2017-01-31	AOM	ETF	35.44	35.57	35.44	35.57	69130.0
2017-01-31	AOR	ETF	41.01	41.16	41.01	41.11	121223.0
2017-01-31	ARGT	ETF	25.41	25.7	25.4	25.68	24800.0
2017-01-31	ARKG	ETF	17.4	18.19	17.4	18.19	32600.0
2017-01-31	ARKK	ETF	22.05	22.13	22.05	22.091	2200.0
2017-01-31	ARKQ	ETF	23.28	23.37	23.24	23.37	2600.0
2017-01-31	ARKW	ETF	27.357	27.59	27.357	27.59	1000.0
2017-01-31	ASEA	ETF	13.59	13.61	13.5	13.61	13900.0
2017-01-31	ASET	ETF	25.8068	25.85	25.8068	25.85	1406.0
2017-01-31	ASHR	ETF	24.92	24.96	24.86	24.95	416900.0
2017-01-31	ASHS	ETF	33.27	33.36	33.27	33.33	3200.0
2017-01-31	ATMP	ETF	23.81	24.12	23.68	24.12	31100.0
2017-01-31	BAB	ETF	29.11	29.1999	29.06	29.17	162986.0
2017-01-31	BAL	ETF	49.19	49.6	49.19	49.6	4018.0
2017-01-31	BBC	ETF	19.2934	19.86	19.27	19.84	12241.0
2017-01-31	BBH	ETF	110.28	114.02	110.28	113.97	115900.0

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

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