PREVIEW / etf_daily / 2014-05-19

all etf daily files

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

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-19	SPY	ETF	187.69	188.89	187.52	188.74	63839000.0
2014-05-19	QQQ	ETF	87.47	88.46	87.3	88.32	32017036.0
2014-05-19	IWM	ETF	109.27	111.04	108.95	110.75	35336900.0
2014-05-19	DIA	ETF	164.14	164.91	164.03	164.71	2879900.0
2014-05-19	GLD	ETF	125.28	125.47	124.48	124.58	3902600.0
2014-05-19	TLT	ETF	113.93	113.96	112.62	112.7	7403300.0
2014-05-19	AADR	ETF	37.83	37.83	37.83	37.83	1000.0
2014-05-19	AAXJ	ETF	61.43	61.78	61.43	61.72	425000.0
2014-05-19	ACWI	ETF	58.92	59.13	58.8	59.11	224800.0
2014-05-19	ACWV	ETF	65.65	65.92	65.48	65.86	35100.0
2014-05-19	ACWX	ETF	47.57	47.73	47.5205	47.72	392385.0
2014-05-19	ADRE	ETF	38.49	38.66	38.456	38.58	10282.0
2014-05-19	AFK	ETF	33.06	33.287	32.81	32.81	185617.0
2014-05-19	AGG	ETF	109.34	109.39	109.15	109.16	945900.0
2014-05-19	AGQ	ETF	61.79	61.97	60.58	60.86	138900.0
2014-05-19	AGZ	ETF	112.459	112.48	112.39	112.4699	45628.0
2014-05-19	AIA	ETF	47.695	48.01	47.695	48.01	34408.0
2014-05-19	AIQ	ETF	29.32	29.705	28.88	29.08	16193.0
2014-05-19	AIRR	ETF	18.5	18.75	18.5	18.75	23900.0
2014-05-19	AIVI	ETF	51.0	51.0	50.85	50.97	20900.0
2014-05-19	ALTL	ETF	33.9604	33.9604	33.9604	33.9604	100.0
2014-05-19	AMJ	ETF	49.49	49.65	49.18	49.25	760092.0
2014-05-19	AMLP	ETF	90.65	90.8	90.2	90.25	575580.0
2014-05-19	ANGL	ETF	28.0	28.06	28.0	28.03	5400.0
2014-05-19	AOA	ETF	45.53	45.73	45.53	45.71	19200.0
2014-05-19	AOK	ETF	32.59	32.64	32.5753	32.6	15203.0
2014-05-19	AOM	ETF	35.01	35.06	34.99	35.05	31683.0
2014-05-19	AOR	ETF	39.34	39.46	39.34	39.46	43462.0
2014-05-19	ARGT	ETF	19.32	19.4	19.32	19.36	3800.0
2014-05-19	ASEA	ETF	16.81	16.97	16.77	16.89	23700.0
2014-05-19	ASHR	ETF	21.76	21.76	21.68	21.71	83600.0
2014-05-19	ATMP	ETF	29.72	29.73	29.48	29.51	32600.0
2014-05-19	AVIV	ETF	27.75	27.89	27.19	27.44	212439.0
2014-05-19	AWAY	ETF	30.54	31.28	30.45	31.15	590368.0
2014-05-19	BAB	ETF	29.39	29.4	29.211	29.228	49974.0
2014-05-19	BAL	ETF	55.2299	55.27	54.2201	54.3	19027.0
2014-05-19	BALT	ETF	6.32	6.55	6.32	6.45	404357.0
2014-05-19	BBH	ETF	87.1	88.59	87.02	88.48	70700.0
2014-05-19	BCHP	ETF	20.07	20.17	20.07	20.1699	2925.0
2014-05-19	BCM	ETF	41.37	41.41	41.369	41.41	2215.0
2014-05-19	BFOR	ETF	7.38	7.4425	7.38	7.435	110800.0
2014-05-19	BIB	ETF	36.43	37.835	36.24	37.75	318926.0
2014-05-19	BICK	ETF	25.65	25.65	25.646	25.646	354.0
2014-05-19	BIL	ETF	91.52	91.54	91.52	91.54	265750.0
2014-05-19	BIS	ETF	737.2	739.36	706.0	707.2	6518.0
2014-05-19	BIV	ETF	84.7	84.77	84.54	84.56	226100.0
2014-05-19	BIZD	ETF	19.26	19.54	19.26	19.53	14200.0
2014-05-19	BJK	ETF	48.36	48.7	48.19	48.61	28300.0
2014-05-19	BKF	ETF	37.7	37.83	37.7	37.77	80371.0
2014-05-19	BKLN	ETF	24.77	24.8	24.74	24.75	3082400.0

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

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