PREVIEW / etf_daily / 2014-08-06

all etf daily files

  file:    by_date/etf_daily/2014/2014-08-06.parquet
  size:    45 KB
  rows:    1,106

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-08-06	SPY	ETF	191.11	192.89	191.08	192.07	94818000.0
2014-08-06	QQQ	ETF	93.99	95.11	93.92	94.52	34431913.0
2014-08-06	IWM	ETF	110.67	112.47	110.63	111.73	33658300.0
2014-08-06	DIA	ETF	163.46	164.75	163.37	164.2	4781100.0
2014-08-06	GLD	ETF	125.71	126.0	125.52	125.67	9327800.0
2014-08-06	TLT	ETF	115.47	115.47	114.6	114.7	7289200.0
2014-08-06	AADR	ETF	37.52	37.79	37.5	37.53	14400.0
2014-08-06	AAXJ	ETF	64.12	64.45	64.12	64.26	1033200.0
2014-08-06	ACWI	ETF	58.66	58.98	58.52	58.81	605100.0
2014-08-06	ACWV	ETF	65.63	65.88	65.54	65.72	13000.0
2014-08-06	ACWX	ETF	46.42	46.76	46.41	46.65	179239.0
2014-08-06	ADRE	ETF	40.577	40.98	40.535	40.9003	19301.0
2014-08-06	AFK	ETF	33.15	33.53	33.1	33.47	148473.0
2014-08-06	AGG	ETF	109.27	109.27	109.11	109.13	708800.0
2014-08-06	AGQ	ETF	64.01	64.74	63.92	64.27	235300.0
2014-08-06	AGZ	ETF	112.78	112.78	112.42	112.56	17359.0
2014-08-06	AGZD	ETF	24.845	24.865	24.82	24.82	1800.0
2014-08-06	AIA	ETF	49.34	49.65	49.34	49.6	660318.0
2014-08-06	AIQ	ETF	28.13	29.44	27.92	28.624	41038.0
2014-08-06	AIRR	ETF	18.12	18.31	18.02	18.23	13500.0
2014-08-06	AIVI	ETF	48.78	49.06	48.43	48.97	35300.0
2014-08-06	AMJ	ETF	50.08	50.32	49.61	50.03	571132.0
2014-08-06	AMLP	ETF	90.6	90.85	90.1	90.4	567780.0
2014-08-06	ANGL	ETF	27.88	27.88	27.88	27.88	400.0
2014-08-06	AOA	ETF	45.55	45.69	45.39	45.58	13600.0
2014-08-06	AOK	ETF	32.42	32.5	32.4	32.5	14946.0
2014-08-06	AOM	ETF	34.8	35.0	34.8	34.95	31320.0
2014-08-06	AOR	ETF	39.4	39.49	39.33	39.41	74669.0
2014-08-06	ARGT	ETF	21.36	21.47	21.1	21.38	11300.0
2014-08-06	ASEA	ETF	17.25	17.25	17.14	17.21	6400.0
2014-08-06	ASHR	ETF	24.66	24.87	24.64	24.72	509200.0
2014-08-06	ASHS	ETF	29.36	29.4	29.36	29.38	1900.0
2014-08-06	ATMP	ETF	30.36	30.75	30.3	30.38	33100.0
2014-08-06	AVIV	ETF	27.28	27.45	26.91	27.02	211698.0
2014-08-06	AWAY	ETF	32.89	33.79	32.71	33.2	704874.0
2014-08-06	BAB	ETF	29.57	29.57	29.42	29.47	96700.0
2014-08-06	BAL	ETF	43.39	43.45	43.02	43.16	7918.0
2014-08-06	BALT	ETF	5.07	5.23	5.06	5.19	203023.0
2014-08-06	BBH	ETF	96.42	97.78	95.97	97.08	64700.0
2014-08-06	BCHP	ETF	19.93	19.9701	19.93	19.9701	430.0
2014-08-06	BCM	ETF	40.072	40.072	40.072	40.072	577.0
2014-08-06	BFOR	ETF	7.525	7.605	7.505	7.5725	154800.0
2014-08-06	BIB	ETF	43.395	45.065	43.235	44.275	248056.0
2014-08-06	BICK	ETF	26.6175	26.6175	26.6175	26.6175	584.0
2014-08-06	BIL	ETF	91.5	91.52	91.5	91.5	108550.0
2014-08-06	BIS	ETF	586.0	594.8	571.072	580.0	6398.0
2014-08-06	BIV	ETF	84.65	84.7	84.53	84.56	350200.0
2014-08-06	BIZD	ETF	19.96	20.05	19.96	20.05	7000.0
2014-08-06	BJK	ETF	49.55	49.55	48.78	48.88	14100.0
2014-08-06	BKF	ETF	39.26	39.56	39.25	39.33	58363.0

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

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