PREVIEW / etf_daily / 2014-05-09

all etf daily files

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

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-09	SPY	ETF	187.71	188.04	186.83	187.96	83679000.0
2014-05-09	QQQ	ETF	86.41	86.86	85.85	86.8	35081529.0
2014-05-09	IWM	ETF	108.69	110.06	108.28	110.03	48409900.0
2014-05-09	DIA	ETF	165.29	165.78	164.87	165.72	4228600.0
2014-05-09	GLD	ETF	124.39	124.47	123.82	124.1	3120000.0
2014-05-09	TLT	ETF	111.53	111.81	110.98	111.24	6000600.0
2014-05-09	AADR	ETF	37.57	37.61	37.57	37.61	1400.0
2014-05-09	AAXJ	ETF	59.49	59.72	59.42	59.58	110100.0
2014-05-09	ACWI	ETF	58.64	58.76	58.44	58.75	453800.0
2014-05-09	ACWV	ETF	65.14	65.57	65.14	65.47	26000.0
2014-05-09	ACWX	ETF	47.39	47.39	47.18	47.319	99642.0
2014-05-09	ADRE	ETF	37.94	38.06	37.9262	37.9714	4641.0
2014-05-09	AFK	ETF	32.84	33.05	32.8	33.0275	25840.0
2014-05-09	AGG	ETF	108.75	108.82	108.66	108.69	812800.0
2014-05-09	AGQ	ETF	60.07	60.07	58.94	59.6	150700.0
2014-05-09	AGZ	ETF	112.21	113.804	111.3801	112.198	17756.0
2014-05-09	AIA	ETF	46.7	46.71	46.56	46.56	4917.0
2014-05-09	AIQ	ETF	29.7	31.005	29.7	30.19	28276.0
2014-05-09	AIRR	ETF	18.55	18.64	18.31	18.64	43900.0
2014-05-09	AIVI	ETF	50.46	50.58	50.32	50.54	11600.0
2014-05-09	ALTL	ETF	33.838	33.838	33.838	33.838	470.0
2014-05-09	AMJ	ETF	49.14	49.14	48.7801	48.97	284584.0
2014-05-09	AMLP	ETF	90.45	90.6	89.75	89.95	472560.0
2014-05-09	ANGL	ETF	27.85	27.86	27.7	27.86	5000.0
2014-05-09	AOA	ETF	45.24	45.42	45.24	45.42	13800.0
2014-05-09	AOK	ETF	32.45	32.5	32.44	32.5	13670.0
2014-05-09	AOM	ETF	34.9	34.9	34.816	34.9	16288.0
2014-05-09	AOR	ETF	39.16	39.25	39.0801	39.25	24773.0
2014-05-09	ARGT	ETF	20.1	20.23	19.86	20.04	4800.0
2014-05-09	ASEA	ETF	16.53	16.61	16.53	16.55	800.0
2014-05-09	ASHR	ETF	21.9	21.91	21.84	21.84	19200.0
2014-05-09	ATMP	ETF	29.4	29.4	29.25	29.28	21700.0
2014-05-09	AVIV	ETF	27.17	27.43	27.01	27.14	177458.0
2014-05-09	AWAY	ETF	30.62	31.26	30.32	31.12	1048218.0
2014-05-09	BAB	ETF	29.2	29.2082	29.07	29.07	152155.0
2014-05-09	BAL	ETF	57.36	57.36	56.9	57.156	2585.0
2014-05-09	BALT	ETF	5.89	6.09	5.79	6.06	715167.0
2014-05-09	BBH	ETF	85.22	86.75	84.39	86.71	101100.0
2014-05-09	BCHP	ETF	20.04	20.04	19.94	20.0	2487.0
2014-05-09	BCM	ETF	41.22	41.22	41.118	41.118	1870.0
2014-05-09	BFOR	ETF	7.385	7.3925	7.325	7.3825	159200.0
2014-05-09	BIB	ETF	35.0	36.1	34.13	36.085	907878.0
2014-05-09	BICK	ETF	24.62	24.62	24.62	24.62	384.0
2014-05-09	BIL	ETF	91.52	91.54	91.52	91.54	71650.0
2014-05-09	BIS	ETF	774.0	786.796	743.6	744.0	15805.5
2014-05-09	BIV	ETF	84.18	84.18	84.07	84.14	153800.0
2014-05-09	BIZD	ETF	19.53	19.53	19.23	19.36	9100.0
2014-05-09	BJK	ETF	49.12	49.12	48.61	48.93	27800.0
2014-05-09	BKF	ETF	36.29	36.54	36.29	36.4	36417.0
2014-05-09	BKLN	ETF	24.82	24.87	24.81	24.87	2518300.0

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

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