PREVIEW / etf_daily / 2015-06-02

all etf daily files

  file:    by_date/etf_daily/2015/2015-06-02.parquet
  size:    48 KB
  rows:    1,177

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
2015-06-02	SPY	ETF	211.02	212.19	210.27	211.36	91531000.0
2015-06-02	QQQ	ETF	110.01	110.61	109.47	110.07	19449634.0
2015-06-02	IWM	ETF	123.8	125.31	123.48	124.52	29477600.0
2015-06-02	DIA	ETF	180.08	180.96	179.27	180.15	5106200.0
2015-06-02	GLD	ETF	114.36	114.65	114.17	114.46	3988600.0
2015-06-02	TLT	ETF	120.17	120.26	119.11	119.44	10076200.0
2015-06-02	AADR	ETF	40.33	40.33	40.33	40.33	1800.0
2015-06-02	AAXJ	ETF	65.76	66.11	65.6	65.93	433400.0
2015-06-02	ACTX	ETF	3.54	3.54	2.95	3.54	1065.0
2015-06-02	ACWF	ETF	25.11	25.11	25.1	25.1	1950.0
2015-06-02	ACWI	ETF	61.61	62.07	61.55	61.8	545000.0
2015-06-02	ACWV	ETF	71.93	72.27	71.87	72.05	577200.0
2015-06-02	ACWX	ETF	46.19	46.5699	46.17	46.38	622475.0
2015-06-02	ADRE	ETF	35.82	36.21	35.82	36.1298	10102.0
2015-06-02	AFK	ETF	25.55	25.86	25.55	25.78	15148.0
2015-06-02	AFTY	ETF	22.76	22.81	22.63	22.69	42600.0
2015-06-02	AGG	ETF	109.43	109.45	109.17	109.23	1830400.0
2015-06-02	AGQ	ETF	41.58	42.12	41.56	41.93	72100.0
2015-06-02	AGZ	ETF	113.3	113.35	113.15	113.18	14945.0
2015-06-02	AGZD	ETF	24.345	24.405	24.345	24.38	4600.0
2015-06-02	AIA	ETF	51.94	52.3199	51.94	52.16	20581.0
2015-06-02	AIQ	ETF	18.54	18.69	18.4	18.58	8841.0
2015-06-02	AIRR	ETF	18.252	18.46	18.252	18.38	20300.0
2015-06-02	AIVI	ETF	45.21	45.58	45.14	45.41	13300.0
2015-06-02	ALTL	ETF	37.0843	37.0843	37.0843	37.0843	469.0
2015-06-02	AMJ	ETF	43.16	43.38	43.0	43.31	1228550.0
2015-06-02	AMLP	ETF	82.8	83.25	82.6	83.1	579560.0
2015-06-02	AMZA	ETF	215.06	221.64	215.06	217.4	920.0
2015-06-02	ANGL	ETF	27.73	27.78	27.71	27.75	30700.0
2015-06-02	AOA	ETF	48.21	48.5	48.21	48.37	80800.0
2015-06-02	AOK	ETF	32.76	32.88	32.76	32.854	24849.0
2015-06-02	AOM	ETF	35.6	35.723	35.6	35.67	142961.0
2015-06-02	AOR	ETF	41.17	41.3399	41.15	41.24	65698.0
2015-06-02	ARGT	ETF	21.0	21.66	21.0	21.64	2300.0
2015-06-02	ARKG	ETF	23.25	23.3	23.23	23.24	2000.0
2015-06-02	ARKK	ETF	21.45	21.558	21.45	21.558	2000.0
2015-06-02	ARKQ	ETF	20.209	20.209	20.14	20.14	400.0
2015-06-02	ARKW	ETF	23.25	23.25	23.19	23.19	1200.0
2015-06-02	ASEA	ETF	15.15	15.21	15.11	15.19	9900.0
2015-06-02	ASHR	ETF	53.07	53.65	53.07	53.6	1975400.0
2015-06-02	ASHS	ETF	71.92	72.56	71.72	72.41	323200.0
2015-06-02	ATMP	ETF	29.34	29.46	29.34	29.42	12100.0
2015-06-02	AWAY	ETF	29.08	30.09	29.02	30.02	2348560.0
2015-06-02	BAB	ETF	28.98	28.98	28.85	28.9	99972.0
2015-06-02	BAL	ETF	43.41	43.43	42.99	43.185	13252.0
2015-06-02	BALT	ETF	1.5	1.55	1.5	1.54	196571.0
2015-06-02	BAR	ETF	2.6512	2.6515	2.6512	2.6515	2650.0
2015-06-02	BBC	ETF	35.0001	35.94	34.83	35.516	16547.0
2015-06-02	BBH	ETF	134.07	134.28	132.6	133.35	69300.0
2015-06-02	BBP	ETF	33.17	33.311	32.74	33.04	7600.0

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

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