PREVIEW / etf_daily / 2015-11-04

all etf daily files

  file:    by_date/etf_daily/2015/2015-11-04.parquet
  size:    48 KB
  rows:    1,205

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-11-04	SPY	ETF	211.35	211.5	209.72	210.36	96224500.0
2015-11-04	QQQ	ETF	115.39	115.47	114.54	115.02	28633048.0
2015-11-04	IWM	ETF	118.65	119.0	117.69	118.29	25696000.0
2015-11-04	DIA	ETF	179.57	179.59	178.19	178.65	6870400.0
2015-11-04	GLD	ETF	107.02	107.09	105.92	105.97	7617800.0
2015-11-04	TLT	ETF	121.1	121.54	120.7	121.09	5980800.0
2015-11-04	AAXJ	ETF	58.27	58.37	57.65	57.85	1190700.0
2015-11-04	ACTX	ETF	9.4401	9.4401	7.6701	8.2601	5320.0
2015-11-04	ACWF	ETF	24.0	24.0135	24.0	24.0135	1503.0
2015-11-04	ACWI	ETF	59.05	59.06	58.5	58.69	1578000.0
2015-11-04	ACWV	ETF	71.13	71.19	70.7	70.73	204700.0
2015-11-04	ACWX	ETF	42.24	42.3	41.83	41.92	6334165.0
2015-11-04	ADRE	ETF	32.0	32.01	31.69	31.81	9257.0
2015-11-04	AFK	ETF	20.6	20.68	20.3502	20.41	5157.0
2015-11-04	AFTY	ETF	16.52	16.52	16.37	16.37	8100.0
2015-11-04	AGG	ETF	108.91	108.99	108.71	108.82	3542500.0
2015-11-04	AGQ	ETF	33.35	33.41	32.55	32.58	237000.0
2015-11-04	AGZ	ETF	113.38	113.55	113.22	113.2801	73216.0
2015-11-04	AGZD	ETF	24.095	24.095	24.07	24.07	1400.0
2015-11-04	AIA	ETF	46.92	47.14	46.433	46.52	41687.0
2015-11-04	AIQ	ETF	9.19	9.5636	9.06	9.24	24945.0
2015-11-04	AIRR	ETF	17.26	17.26	17.13	17.13	3100.0
2015-11-04	AIVI	ETF	40.86	40.86	40.52	40.6	23900.0
2015-11-04	ALTY	ETF	14.89	14.89	14.47	14.48	1400.0
2015-11-04	AMJ	ETF	34.62	35.17	33.43	33.72	4422328.0
2015-11-04	AMLP	ETF	70.45	70.8	67.95	69.2	3295060.0
2015-11-04	AMZA	ETF	150.4	150.4	143.2	146.0	4130.0
2015-11-04	ANGL	ETF	26.21	26.21	26.0	26.0	9300.0
2015-11-04	AOA	ETF	46.63	46.63	46.25	46.31	38300.0
2015-11-04	AOK	ETF	32.28	32.28	32.14	32.18	31371.0
2015-11-04	AOM	ETF	34.86	34.86	34.736	34.78	53643.0
2015-11-04	AOR	ETF	40.02	40.04	39.78	39.83	219648.0
2015-11-04	ARGT	ETF	19.62	19.62	19.34	19.45	3200.0
2015-11-04	ARKG	ETF	20.61	20.61	20.41	20.6	1000.0
2015-11-04	ARKK	ETF	20.5	20.97	20.5	20.836	2100.0
2015-11-04	ARKQ	ETF	19.39	19.39	19.39	19.39	200.0
2015-11-04	ARKW	ETF	23.696	23.696	23.648	23.69	1000.0
2015-11-04	ASEA	ETF	13.38	13.38	13.19	13.19	3900.0
2015-11-04	ASHR	ETF	36.76	36.8	36.35	36.45	2957700.0
2015-11-04	ASHS	ETF	44.57	44.59	44.2	44.21	92600.0
2015-11-04	ASHX	ETF	25.68	25.68	25.68	25.68	792.0
2015-11-04	ATMP	ETF	23.04	23.42	22.01	22.56	277200.0
2015-11-04	AWAY	ETF	31.87	32.44	31.74	32.04	3740143.0
2015-11-04	BAB	ETF	29.03	29.12	28.96	29.01	313946.0
2015-11-04	BAL	ETF	41.75	41.75	41.22	41.31	77151.0
2015-11-04	BBC	ETF	29.76	30.4	29.65	30.38	5476.0
2015-11-04	BBH	ETF	127.62	128.3	125.2	127.08	181000.0
2015-11-04	BBP	ETF	32.0	32.05	31.632	32.04	7300.0
2015-11-04	BCM	ETF	26.633	26.64	26.5883	26.64	2027.0
2015-11-04	BFOR	ETF	8.0375	8.0375	7.95	7.9725	178800.0

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

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