PREVIEW / etf_daily / 2014-05-22

all etf daily files

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

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-22	SPY	ETF	189.18	189.98	188.86	189.59	61549000.0
2014-05-22	QQQ	ETF	88.94	89.48	88.8	89.23	30617089.0
2014-05-22	IWM	ETF	109.96	111.05	109.62	110.76	41295000.0
2014-05-22	DIA	ETF	165.09	165.39	164.6	165.18	3564100.0
2014-05-22	GLD	ETF	125.14	125.24	124.54	124.67	3458800.0
2014-05-22	TLT	ETF	112.26	112.4	111.79	112.1	6495700.0
2014-05-22	AADR	ETF	38.21	38.21	38.05	38.11	1600.0
2014-05-22	AAXJ	ETF	62.06	62.14	61.96	62.1	240700.0
2014-05-22	ACWI	ETF	59.22	59.37	59.13	59.3	1150900.0
2014-05-22	ACWV	ETF	66.08	66.26	65.97	66.16	67200.0
2014-05-22	ACWX	ETF	47.8	47.9	47.78	47.87	163085.0
2014-05-22	ADRE	ETF	38.62	38.656	38.52	38.63	14730.0
2014-05-22	AFK	ETF	33.1	33.3799	32.96	33.16	60242.0
2014-05-22	AGG	ETF	109.14	109.18	109.06	109.12	633900.0
2014-05-22	AGQ	ETF	62.5	62.54	61.47	61.67	145100.0
2014-05-22	AGZ	ETF	112.575	112.5799	112.442	112.45	10998.0
2014-05-22	AIA	ETF	48.27	48.35	48.22	48.28	23851.0
2014-05-22	AIQ	ETF	28.96	29.99	28.96	29.81	15085.0
2014-05-22	AIRR	ETF	18.61	18.62	18.44	18.55	34800.0
2014-05-22	AIVI	ETF	50.95	50.97	50.72	50.88	572300.0
2014-05-22	AMJ	ETF	49.55	49.88	49.28	49.842	1054847.0
2014-05-22	AMLP	ETF	90.75	91.15	90.75	91.05	520960.0
2014-05-22	ANGL	ETF	27.98	28.12	27.98	28.1	3200.0
2014-05-22	AOA	ETF	45.72	45.83	45.69	45.76	11300.0
2014-05-22	AOK	ETF	32.64	32.65	32.604	32.634	27769.0
2014-05-22	AOM	ETF	35.09	35.13	35.0501	35.13	70732.0
2014-05-22	AOR	ETF	39.47	39.53	39.4057	39.5	24785.0
2014-05-22	ARGT	ETF	19.25	19.5	19.25	19.5	12100.0
2014-05-22	ASEA	ETF	16.78	16.85	16.75	16.84	12000.0
2014-05-22	ASHR	ETF	21.82	21.91	21.82	21.9	68800.0
2014-05-22	ATMP	ETF	29.65	30.05	29.65	29.75	25800.0
2014-05-22	AVIV	ETF	27.31	27.31	27.06	27.19	196177.0
2014-05-22	AWAY	ETF	31.23	32.45	31.185	32.3	1464073.0
2014-05-22	BAB	ETF	29.14	29.2399	29.14	29.17	48202.0
2014-05-22	BAL	ETF	55.66	55.66	54.2	54.2	55111.0
2014-05-22	BALT	ETF	6.53	6.69	6.53	6.65	413100.0
2014-05-22	BBH	ETF	87.43	89.83	87.43	88.92	102800.0
2014-05-22	BCHP	ETF	20.28	20.29	20.268	20.28	12584.0
2014-05-22	BCM	ETF	41.55	41.57	41.47	41.53	5241.0
2014-05-22	BFOR	ETF	7.4025	7.4775	7.4025	7.4575	162400.0
2014-05-22	BIB	ETF	37.045	39.18	37.045	38.535	684962.0
2014-05-22	BICK	ETF	25.77	25.77	25.75	25.76	466.0
2014-05-22	BIL	ETF	91.52	91.54	91.52	91.52	130950.0
2014-05-22	BIS	ETF	715.2	719.6	678.0	693.2	20464.0
2014-05-22	BIV	ETF	84.66	84.66	84.51	84.56	205800.0
2014-05-22	BIZD	ETF	19.55	19.65	19.55	19.61	13000.0
2014-05-22	BJK	ETF	48.96	49.53	48.96	49.38	33200.0
2014-05-22	BKF	ETF	38.0	38.08	37.95	38.04	37604.0
2014-05-22	BKLN	ETF	24.76	24.78	24.75	24.78	1601700.0
2014-05-22	BLV	ETF	88.92	88.97	88.59	88.79	36300.0

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

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