PREVIEW / etf_daily / 2017-06-02

all etf daily files

  file:    by_date/etf_daily/2017/2017-06-02.parquet
  size:    55 KB
  rows:    1,405

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-06-02	SPY	ETF	243.42	244.35	243.08	244.17	88666100.0
2017-06-02	QQQ	ETF	142.34	143.49	142.11	143.46	37222881.0
2017-06-02	IWM	ETF	139.45	141.02	139.05	139.85	46680200.0
2017-06-02	DIA	ETF	211.45	212.21	211.27	211.91	2314000.0
2017-06-02	GLD	ETF	121.31	121.71	121.19	121.61	7268100.0
2017-06-02	TLT	ETF	125.22	125.77	125.05	125.62	13245000.0
2017-06-02	AADR	ETF	47.89	48.06	47.87	48.03	26200.0
2017-06-02	AAXJ	ETF	67.69	67.8	67.55	67.78	856400.0
2017-06-02	ACSI	ETF	28.96	28.96	28.96	28.96	1004.0
2017-06-02	ACTX	ETF	45.1354	47.2004	44.2504	45.4304	289.0
2017-06-02	ACWF	ETF	27.44	27.52	27.44	27.52	350.0
2017-06-02	ACWI	ETF	66.44	66.68	66.32	66.61	3152700.0
2017-06-02	ACWV	ETF	80.98	81.2	80.84	81.14	291700.0
2017-06-02	ACWX	ETF	46.55	46.68	46.47	46.665	656776.0
2017-06-02	ADRE	ETF	38.29	38.313	38.162	38.2576	6460.0
2017-06-02	AFK	ETF	21.63	21.74	21.63	21.74	2111.0
2017-06-02	AFTY	ETF	14.82	14.83	14.791	14.8	6300.0
2017-06-02	AGG	ETF	109.74	109.89	109.69	109.84	1507400.0
2017-06-02	AGGY	ETF	50.7	50.77	50.64	50.74	10400.0
2017-06-02	AGNG	ETF	18.2	18.54	18.2	18.44	4900.0
2017-06-02	AGQ	ETF	37.24	38.01	37.15	37.76	196900.0
2017-06-02	AGZ	ETF	113.8	114.0	113.773	113.95	12687.0
2017-06-02	AGZD	ETF	23.94	23.96	23.94	23.945	6400.0
2017-06-02	AIA	ETF	57.03	57.27	56.92	57.21	57615.0
2017-06-02	AIQ	ETF	13.3	13.3	13.15	13.2	32771.0
2017-06-02	AIRR	ETF	23.4	23.8	23.39	23.48	100700.0
2017-06-02	AIVI	ETF	42.34	42.47	42.3	42.45	15600.0
2017-06-02	ALTY	ETF	15.52	15.52	15.5	15.51	5200.0
2017-06-02	AMJ	ETF	30.02	30.17	29.81	29.85	2007950.0
2017-06-02	AMLP	ETF	59.95	60.15	59.65	59.7	1810020.0
2017-06-02	AMZA	ETF	102.0	102.15	100.45	100.6	79760.0
2017-06-02	ANGL	ETF	29.67	29.74	29.64	29.72	594500.0
2017-06-02	AOA	ETF	52.03	52.16	51.94	52.13	53000.0
2017-06-02	AOK	ETF	34.1	34.1567	34.08	34.13	74214.0
2017-06-02	AOM	ETF	37.36	37.471	37.2934	37.46	58664.0
2017-06-02	AOR	ETF	43.83	43.925	43.7401	43.84	68496.0
2017-06-02	ARCM	ETF	100.05	100.05	100.05	100.05	5000.0
2017-06-02	ARGT	ETF	30.94	30.94	30.77	30.84	67700.0
2017-06-02	ARKG	ETF	20.93	21.155	20.76	21.14	20300.0
2017-06-02	ARKK	ETF	29.21	29.21	28.8	29.16	68300.0
2017-06-02	ARKQ	ETF	29.16	29.36	29.06	29.31	46400.0
2017-06-02	ARKW	ETF	36.0	36.0	35.614	35.88	74200.0
2017-06-02	ASEA	ETF	15.12	15.12	15.07	15.1	1700.0
2017-06-02	ASET	ETF	27.68	27.77	27.68	27.77	487.0
2017-06-02	ASHR	ETF	25.53	25.66	25.51	25.6	1031800.0
2017-06-02	ASHS	ETF	30.85	30.85	30.78	30.81	5500.0
2017-06-02	ATMP	ETF	22.18	22.23	22.08	22.1	60200.0
2017-06-02	BAB	ETF	30.03	30.15	29.99	30.08	93706.0
2017-06-02	BAL	ETF	48.95	49.14	48.692	48.7047	4216.0
2017-06-02	BBC	ETF	21.51	22.39	21.51	22.3299	12269.0

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

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