PREVIEW / etf_daily / 2017-03-02

all etf daily files

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

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-03-02	SPY	ETF	239.56	239.57	238.21	238.27	70246000.0
2017-03-02	QQQ	ETF	131.43	131.43	130.62	130.78	19951386.0
2017-03-02	IWM	ETF	140.33	140.36	138.64	138.75	25937000.0
2017-03-02	DIA	ETF	211.19	211.19	209.84	209.89	3336900.0
2017-03-02	GLD	ETF	117.76	118.34	117.23	117.58	10986300.0
2017-03-02	TLT	ETF	119.01	119.21	118.62	119.04	8201200.0
2017-03-02	AADR	ETF	46.14	46.14	45.18	45.33	15300.0
2017-03-02	AAXJ	ETF	60.72	60.72	60.3	60.35	1559900.0
2017-03-02	ACSI	ETF	28.2597	28.26	28.1599	28.1599	1906.0
2017-03-02	ACTX	ETF	110.921	110.921	94.4008	101.4809	1609.0
2017-03-02	ACWF	ETF	25.4876	25.4876	25.4876	25.4876	195.0
2017-03-02	ACWI	ETF	63.0	63.06	62.74	62.79	1960800.0
2017-03-02	ACWV	ETF	76.59	76.59	76.33	76.37	300900.0
2017-03-02	ACWX	ETF	42.57	42.62	42.42	42.45	1100718.0
2017-03-02	ADRE	ETF	36.12	36.12	35.59	35.6674	4148.0
2017-03-02	AFK	ETF	20.64	20.849	20.34	20.35	16306.0
2017-03-02	AFTY	ETF	13.84	13.84	13.798	13.83	5100.0
2017-03-02	AGG	ETF	107.93	107.99	107.75	107.84	2299700.0
2017-03-02	AGGY	ETF	49.63	49.632	49.521	49.62	35800.0
2017-03-02	AGNG	ETF	16.95	16.95	16.94	16.94	400.0
2017-03-02	AGQ	ETF	41.9	42.22	39.07	39.34	582300.0
2017-03-02	AGZ	ETF	112.61	112.6599	112.38	112.42	23316.0
2017-03-02	AGZD	ETF	24.015	24.05	24.015	24.05	1200.0
2017-03-02	AIA	ETF	50.65	50.69	50.4095	50.4489	30536.0
2017-03-02	AIQ	ETF	9.919	10.0	9.5	9.8	15080.0
2017-03-02	AIRR	ETF	24.89	24.89	24.418	24.45	105700.0
2017-03-02	AIVI	ETF	38.97	39.01	38.87	38.87	43200.0
2017-03-02	ALTY	ETF	15.385	15.47	15.35	15.444	31100.0
2017-03-02	AMJ	ETF	32.86	33.17	32.86	33.03	1841383.0
2017-03-02	AMLP	ETF	64.75	65.0	64.5	64.8	1850620.0
2017-03-02	AMZA	ETF	113.0	113.3	112.57	113.1	36070.0
2017-03-02	ANGL	ETF	29.61	29.61	29.52	29.53	245500.0
2017-03-02	AOA	ETF	49.78	49.78	49.46	49.47	55200.0
2017-03-02	AOK	ETF	33.11	33.14	33.05	33.08	43621.0
2017-03-02	AOM	ETF	36.29	36.29	36.1	36.15	67278.0
2017-03-02	AOR	ETF	42.19	42.19	42.01	42.04	63205.0
2017-03-02	ARGT	ETF	26.75	26.75	26.4	26.42	50100.0
2017-03-02	ARKG	ETF	20.138	20.46	20.087	20.087	7100.0
2017-03-02	ARKK	ETF	23.451	23.451	23.25	23.25	2200.0
2017-03-02	ARKQ	ETF	24.28	24.28	23.95	23.99	21300.0
2017-03-02	ARKW	ETF	28.48	28.49	28.33	28.33	16300.0
2017-03-02	ASEA	ETF	13.59	13.59	13.59	13.59	100.0
2017-03-02	ASET	ETF	26.38	26.38	26.2699	26.2699	2112.0
2017-03-02	ASHR	ETF	24.96	24.97	24.83	24.83	653600.0
2017-03-02	ASHS	ETF	33.84	33.84	33.75	33.75	500.0
2017-03-02	ASHX	ETF	19.65	19.65	19.61	19.61	944.0
2017-03-02	ATMP	ETF	24.21	24.31	24.01	24.14	33400.0
2017-03-02	BAB	ETF	29.14	29.2099	29.1	29.12	175323.0
2017-03-02	BAL	ETF	51.01	51.48	49.53	49.93	21859.0
2017-03-02	BBC	ETF	22.69	23.3148	22.57	22.605	17588.0

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

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