PREVIEW / etf_daily / 2017-02-01

all etf daily files

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

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-02-01	SPY	ETF	227.53	228.59	226.94	227.62	79117700.0
2017-02-01	QQQ	ETF	125.42	125.68	124.86	125.43	22861876.0
2017-02-01	IWM	ETF	136.22	136.87	134.7	135.15	30010500.0
2017-02-01	DIA	ETF	199.13	199.4	198.2	198.63	3676900.0
2017-02-01	GLD	ETF	114.66	115.45	114.14	115.2	6932900.0
2017-02-01	TLT	ETF	119.1	119.53	118.58	119.1	10975500.0
2017-02-01	AADR	ETF	44.64	44.81	44.13	44.46	13300.0
2017-02-01	AAXJ	ETF	59.26	59.36	58.99	59.09	1080600.0
2017-02-01	ACSI	ETF	27.09	27.09	27.0227	27.0227	2618.0
2017-02-01	ACTX	ETF	197.0618	294.4127	196.4718	292.6426	8243.0
2017-02-01	ACWF	ETF	25.905	26.0	25.33	25.34	503213.0
2017-02-01	ACWI	ETF	61.13	61.19	60.79	60.92	3562900.0
2017-02-01	ACWV	ETF	74.08	74.08	73.55	73.63	192500.0
2017-02-01	ACWX	ETF	42.02	42.06	41.82	41.98	1524398.0
2017-02-01	ADRE	ETF	35.4	35.4	35.1	35.33	3218.0
2017-02-01	AFK	ETF	21.25	21.4	21.1804	21.36	18688.0
2017-02-01	AFTY	ETF	13.91	13.91	13.91	13.91	100.0
2017-02-01	AGG	ETF	107.77	108.01	107.69	107.92	2994200.0
2017-02-01	AGGY	ETF	49.53	49.604	49.45	49.557	6800.0
2017-02-01	AGNG	ETF	15.903	15.903	15.903	15.903	100.0
2017-02-01	AGQ	ETF	38.33	39.17	37.91	38.69	193300.0
2017-02-01	AGZ	ETF	112.63	112.8199	112.45	112.45	27738.0
2017-02-01	AGZD	ETF	24.02	24.09	23.98	23.98	18400.0
2017-02-01	AIA	ETF	49.95	49.99	49.7565	49.85	18968.0
2017-02-01	AIQ	ETF	9.775	9.8	9.75	9.8	32646.0
2017-02-01	AIRR	ETF	24.24	24.385	24.01	24.13	191400.0
2017-02-01	AIVI	ETF	38.43	38.57	38.34	38.47	16100.0
2017-02-01	ALTY	ETF	15.23	15.23	15.151	15.18	4700.0
2017-02-01	AMJ	ETF	33.56	33.94	33.3	33.58	2311950.0
2017-02-01	AMLP	ETF	65.9	66.05	65.45	65.95	1936440.0
2017-02-01	AMZA	ETF	112.2	112.65	110.86	111.7	42030.0
2017-02-01	ANGL	ETF	29.27	29.3	29.21	29.26	248500.0
2017-02-01	AOA	ETF	48.44	48.44	48.17	48.32	67100.0
2017-02-01	AOK	ETF	32.77	32.83	32.6904	32.83	152794.0
2017-02-01	AOM	ETF	35.6	35.65	35.5	35.65	78633.0
2017-02-01	AOR	ETF	41.23	41.27	41.0998	41.19	102735.0
2017-02-01	ARGT	ETF	25.85	25.94	25.66	25.86	67700.0
2017-02-01	ARKG	ETF	18.2	18.25	18.2	18.25	900.0
2017-02-01	ARKK	ETF	22.41	22.41	22.208	22.274	2700.0
2017-02-01	ARKQ	ETF	23.498	23.67	23.393	23.406	3000.0
2017-02-01	ARKW	ETF	27.72	27.72	27.523	27.63	1800.0
2017-02-01	ASEA	ETF	13.64	13.64	13.64	13.64	1500.0
2017-02-01	ASET	ETF	25.74	25.77	25.74	25.7642	1425.0
2017-02-01	ASHR	ETF	24.96	24.97	24.91	24.91	238700.0
2017-02-01	ASHS	ETF	33.31	33.33	33.24	33.24	4800.0
2017-02-01	ATMP	ETF	24.38	25.01	24.19	25.01	103100.0
2017-02-01	BAB	ETF	29.09	29.14	29.0201	29.12	221016.0
2017-02-01	BAL	ETF	49.89	50.49	49.89	50.49	12955.0
2017-02-01	BBC	ETF	19.7699	19.9199	19.6552	19.8299	3806.0
2017-02-01	BBH	ETF	114.66	115.47	113.69	115.33	61900.0

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

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