PREVIEW / etf_daily / 2014-05-05

all etf daily files

  file:    by_date/etf_daily/2014/2014-05-05.parquet
  size:    44 KB
  rows:    1,093

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-05-05	SPY	ETF	187.14	188.55	186.62	188.42	75883000.0
2014-05-05	QQQ	ETF	86.98	87.97	86.76	87.95	27924376.0
2014-05-05	IWM	ETF	111.12	112.18	110.53	111.89	28108400.0
2014-05-05	DIA	ETF	163.97	165.17	163.45	164.93	4059700.0
2014-05-05	GLD	ETF	126.47	126.63	126.0	126.22	5196500.0
2014-05-05	TLT	ETF	112.76	112.81	111.89	112.03	8043000.0
2014-05-05	AADR	ETF	37.86	37.86	37.81	37.81	400.0
2014-05-05	AAXJ	ETF	59.53	59.67	59.31	59.67	141700.0
2014-05-05	ACWI	ETF	58.52	58.78	58.31	58.77	3007300.0
2014-05-05	ACWV	ETF	65.0	65.36	64.94	65.36	187500.0
2014-05-05	ACWX	ETF	47.14	47.32	47.01	47.32	195957.0
2014-05-05	ADRE	ETF	37.43	37.62	37.39	37.55	3991.0
2014-05-05	AFK	ETF	33.16	33.36	33.02	33.12	32753.0
2014-05-05	AGG	ETF	108.72	108.74	108.56	108.64	1261100.0
2014-05-05	AGQ	ETF	62.77	62.84	62.1	62.1	136200.0
2014-05-05	AGZ	ETF	112.28	112.28	111.98	112.11	7934.0
2014-05-05	AIA	ETF	46.49	46.49	46.24	46.46	6345.0
2014-05-05	AIQ	ETF	28.19	28.83	27.58	28.51	28193.0
2014-05-05	AIRR	ETF	18.865	18.97	18.865	18.97	11200.0
2014-05-05	AIVI	ETF	49.91	50.39	49.91	50.39	12000.0
2014-05-05	ALTL	ETF	34.02	34.02	34.02	34.02	328.0
2014-05-05	AMJ	ETF	48.9	49.58	48.48	49.51	513768.0
2014-05-05	AMLP	ETF	91.35	92.15	91.2	92.0	1251860.0
2014-05-05	ANGL	ETF	27.63	27.75	27.63	27.75	2300.0
2014-05-05	AOA	ETF	45.32	45.51	45.22	45.51	10500.0
2014-05-05	AOK	ETF	32.43	32.51	32.428	32.506	9114.0
2014-05-05	AOM	ETF	34.87	34.93	34.78	34.93	28407.0
2014-05-05	AOR	ETF	39.17	39.28	39.09	39.28	28509.0
2014-05-05	ARGT	ETF	20.39	20.39	20.1	20.26	22800.0
2014-05-05	ASEA	ETF	16.45	16.53	16.45	16.53	1500.0
2014-05-05	ASHR	ETF	21.87	22.02	21.85	22.02	106700.0
2014-05-05	ATMP	ETF	29.15	29.62	29.12	29.62	38100.0
2014-05-05	AVIV	ETF	26.68	26.98	26.57	26.97	180826.0
2014-05-05	AWAY	ETF	33.39	33.4	32.71	33.22	584968.0
2014-05-05	BAB	ETF	29.3	29.3	29.13	29.17	78813.0
2014-05-05	BAL	ETF	58.39	58.559	58.388	58.51	8017.0
2014-05-05	BALT	ETF	6.36	6.4	6.18	6.2	448464.0
2014-05-05	BBH	ETF	85.9	88.72	85.62	88.72	68400.0
2014-05-05	BCHP	ETF	20.06	20.1	20.06	20.1	5180.0
2014-05-05	BFOR	ETF	7.4475	7.5	7.415	7.49	49600.0
2014-05-05	BIB	ETF	35.96	38.35	35.7865	38.35	612058.0
2014-05-05	BICK	ETF	24.6799	24.725	24.585	24.725	1223.0
2014-05-05	BIL	ETF	91.52	91.54	91.52	91.54	164600.0
2014-05-05	BIS	ETF	752.4	754.4	703.6	704.4	13168.5
2014-05-05	BIV	ETF	84.05	84.05	83.85	83.92	169000.0
2014-05-05	BIZD	ETF	19.86	19.86	19.73	19.82	29800.0
2014-05-05	BJK	ETF	50.71	50.71	50.27	50.59	35300.0
2014-05-05	BKF	ETF	35.91	36.08	35.88	36.03	94337.0
2014-05-05	BKLN	ETF	24.78	24.81	24.76	24.8	2347900.0
2014-05-05	BLV	ETF	89.29	89.36	88.77	88.83	73100.0

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

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