PREVIEW / etf_daily / 2014-04-09

all etf daily files

  file:    by_date/etf_daily/2014/2014-04-09.parquet
  size:    43 KB
  rows:    1,073

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-04-09	SPY	ETF	185.6	187.15	185.06	187.09	100254000.0
2014-04-09	QQQ	ETF	86.67	87.87	86.43	87.82	45685231.0
2014-04-09	IWM	ETF	114.0	115.25	113.5	115.25	42744900.0
2014-04-09	DIA	ETF	163.0	164.14	162.43	164.1	6008300.0
2014-04-09	GLD	ETF	125.46	126.72	125.33	126.32	5305600.0
2014-04-09	TLT	ETF	108.88	109.35	108.64	108.83	5771500.0
2014-04-09	AAXJ	ETF	60.9	61.21	60.44	60.97	313700.0
2014-04-09	ACWI	ETF	58.21	58.63	58.03	58.6	1510500.0
2014-04-09	ACWV	ETF	64.58	64.77	64.23	64.77	10000.0
2014-04-09	ACWX	ETF	46.95	47.31	46.86	47.28	226986.0
2014-04-09	ADRE	ETF	37.55	37.71	37.24	37.71	9600.0
2014-04-09	AFK	ETF	31.86	32.21	31.72	32.2	21289.0
2014-04-09	AGG	ETF	108.0	108.21	107.93	108.08	1167100.0
2014-04-09	AGQ	ETF	63.6	64.98	63.45	64.56	363800.0
2014-04-09	AGZ	ETF	111.87	113.99	111.65	112.19	212876.0
2014-04-09	AIA	ETF	47.35	47.72	47.31	47.6	15218.0
2014-04-09	AIQ	ETF	33.08	33.46	31.91	32.22	46061.0
2014-04-09	AIRR	ETF	19.41	19.45	19.2	19.45	39400.0
2014-04-09	AIVI	ETF	49.52	49.8	49.38	49.78	10100.0
2014-04-09	AMJ	ETF	47.2	47.5799	47.1901	47.49	184046.0
2014-04-09	AMLP	ETF	89.25	89.7	88.9	89.35	512140.0
2014-04-09	ANGL	ETF	27.63	27.65	27.62	27.62	2500.0
2014-04-09	AOA	ETF	45.08	45.4	45.02	45.4	40500.0
2014-04-09	AOK	ETF	32.38	32.43	32.28	32.37	32833.0
2014-04-09	AOM	ETF	34.66	34.82	34.636	34.82	24252.0
2014-04-09	AOR	ETF	38.99	39.16	38.8604	39.16	38364.0
2014-04-09	ARGT	ETF	20.04	20.43	20.04	20.43	6500.0
2014-04-09	ASEA	ETF	16.41	16.42	16.3	16.38	17500.0
2014-04-09	ASHR	ETF	23.09	23.09	22.83	22.96	347600.0
2014-04-09	ATMP	ETF	28.33	28.37	28.18	28.37	22500.0
2014-04-09	AVIV	ETF	24.23	24.356	23.83	24.22	778304.0
2014-04-09	AWAY	ETF	35.3	36.08	34.91	35.68	3180244.0
2014-04-09	BAB	ETF	28.8	28.8362	28.711	28.78	94360.0
2014-04-09	BAL	ETF	57.54	57.6316	56.52	56.7	13978.0
2014-04-09	BALT	ETF	6.17	6.28	6.14	6.19	777445.0
2014-04-09	BBH	ETF	87.1	90.27	87.1	90.23	254600.0
2014-04-09	BFOR	ETF	7.475	7.555	7.4575	7.555	116000.0
2014-04-09	BIB	ETF	36.99	39.4299	36.785	39.28	1086858.0
2014-04-09	BICK	ETF	25.43	25.43	25.3325	25.3325	776.0
2014-04-09	BIL	ETF	91.54	91.56	91.54	91.54	99600.0
2014-04-09	BIS	ETF	760.0	768.0	708.8	712.0	18821.0
2014-04-09	BIV	ETF	83.38	83.7	83.29	83.62	245700.0
2014-04-09	BIZD	ETF	20.21	20.26	20.12	20.22	12800.0
2014-04-09	BJK	ETF	51.64	51.83	51.14	51.76	29200.0
2014-04-09	BKF	ETF	36.86	37.32	36.67	37.15	51566.0
2014-04-09	BKLN	ETF	24.79	24.82	24.77	24.82	3890600.0
2014-04-09	BLV	ETF	86.65	87.01	86.6	86.8	54100.0
2014-04-09	BMVP	ETF	23.34	23.61	23.33	23.61	15237.0
2014-04-09	BND	ETF	81.19	81.32	81.13	81.25	3904300.0
2014-04-09	BNDX	ETF	50.6	50.66	50.51	50.6	1055500.0

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

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