PREVIEW / etf_daily / 2014-05-15

all etf daily files

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

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-15	SPY	ETF	188.68	188.72	186.48	187.4	154956000.0
2014-05-15	QQQ	ETF	87.81	87.96	86.58	87.135	59680284.0
2014-05-15	IWM	ETF	109.07	109.21	107.44	108.88	75870500.0
2014-05-15	DIA	ETF	165.78	165.87	164.02	164.55	7539300.0
2014-05-15	GLD	ETF	124.77	125.51	124.54	124.77	5861100.0
2014-05-15	TLT	ETF	113.78	114.41	113.6	113.86	12627900.0
2014-05-15	AAXJ	ETF	61.04	61.05	60.63	60.83	538100.0
2014-05-15	ACWI	ETF	59.21	59.21	58.52	58.81	2746400.0
2014-05-15	ACWV	ETF	65.87	65.87	65.28	65.54	29400.0
2014-05-15	ACWX	ETF	47.77	47.77	47.37	47.53	234672.0
2014-05-15	ADRE	ETF	38.69	38.69	38.24	38.39	5280.0
2014-05-15	AFK	ETF	33.47	33.47	33.1001	33.16	10176.0
2014-05-15	AGG	ETF	109.3	109.45	109.23	109.32	2408900.0
2014-05-15	AGQ	ETF	62.21	62.44	61.32	61.55	193400.0
2014-05-15	AGZ	ETF	112.4132	112.48	112.41	112.435	122026.0
2014-05-15	AGZD	ETF	25.5	25.5	25.0	25.05	4600.0
2014-05-15	AIA	ETF	47.73	47.73	47.3	47.43	4021.0
2014-05-15	AIQ	ETF	28.9	29.8	28.74	29.71	22929.0
2014-05-15	AIRR	ETF	19.06	19.06	18.17	18.4	25400.0
2014-05-15	AIVI	ETF	50.72	50.86	50.36	50.82	700600.0
2014-05-15	AMJ	ETF	49.19	49.485	48.95	49.19	319051.0
2014-05-15	AMLP	ETF	90.4	90.45	89.8	90.35	458220.0
2014-05-15	ANGL	ETF	28.03	28.03	27.96	27.98	22100.0
2014-05-15	AOA	ETF	45.64	45.64	45.21	45.44	32400.0
2014-05-15	AOK	ETF	32.595	32.595	32.5	32.52	14815.0
2014-05-15	AOM	ETF	35.06	35.06	34.86	34.96	36644.0
2014-05-15	AOR	ETF	39.32	39.32	39.1004	39.26	26381.0
2014-05-15	ARGT	ETF	19.85	19.85	19.3	19.3	3400.0
2014-05-15	ASEA	ETF	16.63	16.66	16.57	16.64	2100.0
2014-05-15	ASHR	ETF	22.1	22.1	21.91	21.92	50600.0
2014-05-15	ATMP	ETF	29.49	29.58	29.41	29.58	21800.0
2014-05-15	AVIV	ETF	27.25	27.49	27.16	27.48	236267.0
2014-05-15	AWAY	ETF	31.1	31.17	29.8	30.91	1252996.0
2014-05-15	BAB	ETF	29.3	29.407	29.28	29.32	148125.0
2014-05-15	BAL	ETF	55.8	55.98	55.64	55.64	9743.0
2014-05-15	BALT	ETF	6.22	6.25	6.04	6.22	402412.0
2014-05-15	BBH	ETF	88.33	88.86	86.53	87.49	82300.0
2014-05-15	BCHP	ETF	20.24	20.24	20.07	20.07	796.0
2014-05-15	BCM	ETF	41.18	41.26	41.17	41.23	2052.0
2014-05-15	BFOR	ETF	7.4025	7.4025	7.2625	7.3375	178400.0
2014-05-15	BIB	ETF	37.5	37.7749	35.78	36.81	517498.0
2014-05-15	BICK	ETF	25.04	25.04	25.0	25.02	1642.0
2014-05-15	BIL	ETF	91.52	91.54	91.52	91.54	193000.0
2014-05-15	BIS	ETF	720.0	746.0	708.0	724.8	23844.0
2014-05-15	BIV	ETF	84.67	84.87	84.61	84.75	348500.0
2014-05-15	BIZD	ETF	19.37	19.37	19.26	19.34	6500.0
2014-05-15	BJK	ETF	48.18	48.31	47.86	48.29	19400.0
2014-05-15	BKF	ETF	37.51	37.57	37.1401	37.3	79977.0
2014-05-15	BKLN	ETF	24.78	24.78	24.74	24.75	1447300.0
2014-05-15	BLV	ETF	89.85	90.25	89.64	89.84	46000.0

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

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