PREVIEW / etf_daily / 2016-04-05

all etf daily files

  file:    by_date/etf_daily/2016/2016-04-05.parquet
  size:    50 KB
  rows:    1,246

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
2016-04-05	SPY	ETF	204.67	206.26	203.89	204.19	99662200.0
2016-04-05	QQQ	ETF	109.08	109.5	108.74	108.88	20107915.0
2016-04-05	IWM	ETF	109.37	109.86	108.84	108.94	32515800.0
2016-04-05	DIA	ETF	176.08	176.96	175.57	175.82	5439600.0
2016-04-05	GLD	ETF	117.76	117.93	117.15	117.66	8865900.0
2016-04-05	TLT	ETF	132.01	132.36	131.78	132.19	6482800.0
2016-04-05	AAXJ	ETF	53.25	53.27	52.84	52.9	1358300.0
2016-04-05	ACTX	ETF	6.0181	7.0801	6.0181	6.4901	1075.0
2016-04-05	ACWI	ETF	55.12	55.23	54.97	55.02	1330800.0
2016-04-05	ACWV	ETF	72.91	73.11	72.76	72.77	172200.0
2016-04-05	ACWX	ETF	38.33	38.37	38.19	38.22	384893.0
2016-04-05	ADRE	ETF	30.27	30.27	30.1295	30.16	4809.0
2016-04-05	AFK	ETF	18.86	18.94	18.6501	18.91	66450.0
2016-04-05	AFTY	ETF	13.04	13.04	12.85	12.85	19300.0
2016-04-05	AGG	ETF	110.95	110.98	110.71	110.77	2954100.0
2016-04-05	AGGY	ETF	50.74	50.74	50.66	50.68	3300.0
2016-04-05	AGQ	ETF	31.81	31.81	31.44	31.68	181300.0
2016-04-05	AGZ	ETF	114.5	114.73	114.5	114.625	1357511.0
2016-04-05	AGZD	ETF	23.8	23.8	23.69	23.795	10000.0
2016-04-05	AIA	ETF	41.94	41.9785	41.78	41.78	11187.0
2016-04-05	AIQ	ETF	6.925	7.21	6.925	7.05	21737.0
2016-04-05	AIRR	ETF	17.14	17.2	17.14	17.15	4900.0
2016-04-05	AIVI	ETF	37.07	37.17	37.0	37.0	6300.0
2016-04-05	ALTY	ETF	14.124	14.124	14.124	14.124	200.0
2016-04-05	AMJ	ETF	25.84	26.23	25.52	25.55	1615032.0
2016-04-05	AMLP	ETF	51.25	52.05	51.2	51.35	1674580.0
2016-04-05	AMZA	ETF	81.1	82.48	80.1	80.3	15240.0
2016-04-05	ANGL	ETF	25.61	25.61	25.5	25.52	63500.0
2016-04-05	AOA	ETF	44.58	44.6	44.4	44.4	46600.0
2016-04-05	AOK	ETF	32.03	32.1399	31.97	32.11	40357.0
2016-04-05	AOM	ETF	34.38	34.4843	34.38	34.43	71849.0
2016-04-05	AOR	ETF	38.89	38.9199	38.82	38.84	49052.0
2016-04-05	ARGT	ETF	18.77	18.93	18.66	18.73	27600.0
2016-04-05	ARKG	ETF	18.117	18.117	18.117	18.117	200.0
2016-04-05	ARKK	ETF	19.4	19.4	19.4	19.4	600.0
2016-04-05	ARKW	ETF	20.44	20.6	20.44	20.53	400.0
2016-04-05	ASEA	ETF	13.32	13.38	13.3	13.3	1400.0
2016-04-05	ASHR	ETF	24.8	24.9	24.64	24.71	1364400.0
2016-04-05	ASHS	ETF	35.37	35.49	35.21	35.21	46700.0
2016-04-05	ASHX	ETF	22.06	22.06	22.04	22.04	361.0
2016-04-05	ATMP	ETF	17.05	17.23	17.0	17.07	78400.0
2016-04-05	BAB	ETF	30.34	30.34	30.2171	30.26	110484.0
2016-04-05	BAL	ETF	38.74	38.74	38.351	38.5791	2008.0
2016-04-05	BBC	ETF	19.99	20.2825	19.9	19.92	90064.0
2016-04-05	BBH	ETF	106.17	107.99	105.97	106.67	150400.0
2016-04-05	BBP	ETF	25.0	25.493	25.0	25.3	4400.0
2016-04-05	BCM	ETF	23.75	23.78	23.71	23.757	2086.0
2016-04-05	BFOR	ETF	7.4575	7.4875	7.45	7.465	127200.0
2016-04-05	BIB	ETF	43.45	44.7522	42.88	43.73	1142238.0
2016-04-05	BICK	ETF	19.47	19.47	19.4375	19.4375	399.0

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

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