PREVIEW / etf_daily / 2014-08-05

all etf daily files

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

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-05	SPY	ETF	193.1	193.6	191.31	192.01	152690000.0
2014-08-05	QQQ	ETF	94.94	95.21	94.15	94.59	50331066.0
2014-08-05	IWM	ETF	111.11	112.23	110.56	111.38	44375000.0
2014-08-05	DIA	ETF	164.8	165.14	163.34	163.92	8522800.0
2014-08-05	GLD	ETF	123.74	124.52	123.4	123.87	8342500.0
2014-08-05	TLT	ETF	114.07	114.8	113.68	114.63	8032000.0
2014-08-05	AADR	ETF	38.23	38.23	37.55	37.65	3800.0
2014-08-05	AAXJ	ETF	64.74	64.76	64.3	64.36	660200.0
2014-08-05	ACWI	ETF	59.32	59.34	58.68	58.86	582000.0
2014-08-05	ACWV	ETF	66.02	66.04	65.55	65.7	62800.0
2014-08-05	ACWX	ETF	47.07	47.07	46.6614	46.74	321712.0
2014-08-05	ADRE	ETF	41.06	41.06	40.5801	40.76	8446.0
2014-08-05	AFK	ETF	33.57	33.61	33.3401	33.48	37886.0
2014-08-05	AGG	ETF	109.12	109.2	108.95	109.12	1875100.0
2014-08-05	AGQ	ETF	64.2	64.23	62.61	62.91	448300.0
2014-08-05	AGZ	ETF	112.4	112.7325	112.27	112.45	7210.0
2014-08-05	AGZD	ETF	24.855	24.935	24.83	24.83	11400.0
2014-08-05	AIA	ETF	49.6	49.69	49.38	49.46	16474.0
2014-08-05	AIQ	ETF	27.75	28.55	27.44	28.31	43958.0
2014-08-05	AIRR	ETF	17.92	18.28	17.92	18.115	6500.0
2014-08-05	AIVI	ETF	49.5	49.5	48.85	49.0	36200.0
2014-08-05	ALTL	ETF	34.86	34.93	34.81	34.82	2016.0
2014-08-05	AMJ	ETF	50.77	50.9	50.061	50.18	400482.0
2014-08-05	AMLP	ETF	93.0	93.3	91.95	92.15	589620.0
2014-08-05	ANGL	ETF	27.6	27.86	27.6	27.61	4900.0
2014-08-05	AOA	ETF	45.84	45.89	45.48	45.62	25000.0
2014-08-05	AOK	ETF	32.58	32.58	32.45	32.5	32941.0
2014-08-05	AOM	ETF	35.01	35.0499	34.91	34.92	39209.0
2014-08-05	AOR	ETF	39.58	39.58	39.38	39.44	32631.0
2014-08-05	ARGT	ETF	21.84	21.88	21.13	21.16	26700.0
2014-08-05	ASEA	ETF	17.33	17.35	17.26	17.32	24400.0
2014-08-05	ASHR	ETF	24.95	24.96	24.77	24.81	392800.0
2014-08-05	ASHS	ETF	29.25	29.25	29.17	29.22	4900.0
2014-08-05	ATMP	ETF	31.45	31.45	30.4	30.47	42000.0
2014-08-05	AVIV	ETF	28.03	28.03	26.95	27.42	569466.0
2014-08-05	AWAY	ETF	33.68	33.96	33.18	33.18	1098301.0
2014-08-05	BAB	ETF	29.5	29.58	29.418	29.52	91050.0
2014-08-05	BAL	ETF	43.24	43.24	42.47	42.87	23829.0
2014-08-05	BALT	ETF	5.07	5.1	4.97	5.07	418441.0
2014-08-05	BBH	ETF	96.62	97.96	96.38	97.14	93000.0
2014-08-05	BFOR	ETF	7.585	7.6025	7.525	7.56	132800.0
2014-08-05	BIB	ETF	44.0	45.112	43.545	44.28	343692.0
2014-08-05	BICK	ETF	26.92	26.945	26.56	26.592	2297.0
2014-08-05	BIL	ETF	91.5	91.52	91.5	91.5	175300.0
2014-08-05	BIS	ETF	582.8	591.2	570.0	581.6	11858.5
2014-08-05	BIV	ETF	84.45	84.59	84.34	84.54	180100.0
2014-08-05	BIZD	ETF	20.09	20.09	19.93	19.96	9500.0
2014-08-05	BJK	ETF	50.01	50.19	49.52	49.53	33300.0
2014-08-05	BKF	ETF	39.67	39.87	39.43	39.55	130089.0
2014-08-05	BKLN	ETF	24.58	24.59	24.55	24.55	4386100.0

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

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