PREVIEW / etf_daily / 2014-04-29

all etf daily files

  file:    by_date/etf_daily/2014/2014-04-29.parquet
  size:    44 KB
  rows:    1,083

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
2014-04-29	SPY	ETF	187.48	188.04	187.08	187.75	84098000.0
2014-04-29	QQQ	ETF	86.75	87.32	86.31	87.16	36742661.0
2014-04-29	IWM	ETF	111.42	111.98	110.9	111.24	34487600.0
2014-04-29	DIA	ETF	164.62	165.27	164.49	165.0	4581400.0
2014-04-29	GLD	ETF	124.95	125.38	124.65	124.86	5241600.0
2014-04-29	TLT	ETF	110.17	110.73	110.04	110.64	5235200.0
2014-04-29	AADR	ETF	37.68	37.74	37.68	37.74	1500.0
2014-04-29	AAXJ	ETF	59.98	60.12	59.67	59.96	269500.0
2014-04-29	ACWI	ETF	58.62	58.73	58.46	58.64	601100.0
2014-04-29	ACWV	ETF	64.9	65.34	64.9	65.11	26300.0
2014-04-29	ACWX	ETF	47.09	47.3199	47.09	47.23	183101.0
2014-04-29	ADRE	ETF	37.25	37.56	37.25	37.3	10139.0
2014-04-29	AFK	ETF	32.22	32.79	32.22	32.5972	25453.0
2014-04-29	AGG	ETF	108.26	108.4	108.24	108.37	858600.0
2014-04-29	AGQ	ETF	61.7	62.21	61.49	61.94	124400.0
2014-04-29	AGZ	ETF	111.82	111.94	111.7701	111.8699	9117.0
2014-04-29	AIA	ETF	46.98	47.01	46.92	46.92	14392.0
2014-04-29	AIQ	ETF	29.71	30.35	28.84	29.11	24809.0
2014-04-29	AIRR	ETF	19.28	19.33	19.017	19.059	48300.0
2014-04-29	AIVI	ETF	49.91	50.1	49.9	50.03	13800.0
2014-04-29	AMJ	ETF	48.1	48.59	48.01	48.53	1571196.0
2014-04-29	AMLP	ETF	90.2	90.75	90.15	90.7	550780.0
2014-04-29	ANGL	ETF	27.8	27.81	27.77	27.81	1200.0
2014-04-29	AOA	ETF	45.28	45.33	45.23	45.28	16200.0
2014-04-29	AOK	ETF	32.44	32.45	32.39	32.44	11658.0
2014-04-29	AOM	ETF	34.8	34.82	34.78	34.81	20685.0
2014-04-29	AOR	ETF	39.09	39.15	39.0324	39.11	21416.0
2014-04-29	ARGT	ETF	19.75	20.01	19.75	20.0	700.0
2014-04-29	ASEA	ETF	16.33	16.36	16.31	16.35	13900.0
2014-04-29	ASHR	ETF	21.83	21.95	21.8	21.94	208000.0
2014-04-29	ATMP	ETF	28.9	29.0	28.79	28.98	9400.0
2014-04-29	AVIV	ETF	26.43	26.56	26.12	26.16	205137.0
2014-04-29	AWAY	ETF	32.7	32.99	32.03	32.94	2126118.0
2014-04-29	BAB	ETF	28.91	28.95	28.86	28.95	56189.0
2014-04-29	BAL	ETF	57.15	58.32	57.15	58.09	12790.0
2014-04-29	BALT	ETF	6.05	6.06	5.83	5.89	1432333.0
2014-04-29	BBH	ETF	85.05	87.78	84.78	87.25	245000.0
2014-04-29	BCHP	ETF	20.04	20.08	20.0247	20.08	2880.0
2014-04-29	BCM	ETF	41.636	41.669	41.6	41.6	4048.0
2014-04-29	BFOR	ETF	7.435	7.45	7.38	7.4275	141600.0
2014-04-29	BIB	ETF	35.675	37.435	35.0555	37.115	956428.0
2014-04-29	BICK	ETF	24.8299	24.8299	24.55	24.55	1996.0
2014-04-29	BIL	ETF	91.56	91.56	91.54	91.54	101050.0
2014-04-29	BIS	ETF	757.2	774.4	723.2	728.8	17727.0
2014-04-29	BIV	ETF	83.56	83.67	83.51	83.64	151200.0
2014-04-29	BIZD	ETF	19.92	20.0	19.78	19.81	79800.0
2014-04-29	BJK	ETF	49.57	50.01	49.34	49.99	73300.0
2014-04-29	BKF	ETF	36.05	36.41	36.05	36.1	37535.0
2014-04-29	BKLN	ETF	24.69	24.7	24.67	24.69	3007200.0
2014-04-29	BLNG	ETF	36.08	36.1	36.01	36.06	13800.0

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

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