PREVIEW / etf_daily / 2014-04-21

all etf daily files

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

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-21	SPY	ETF	186.44	187.1	186.21	187.04	68329000.0
2014-04-21	QQQ	ETF	86.41	86.84	86.0	86.84	25947923.0
2014-04-21	IWM	ETF	113.13	113.53	112.28	113.45	31970700.0
2014-04-21	DIA	ETF	163.84	164.25	163.7	164.03	3066100.0
2014-04-21	GLD	ETF	124.07	124.33	123.76	124.24	6579200.0
2014-04-21	TLT	ETF	110.37	110.62	109.84	109.96	4316300.0
2014-04-21	AADR	ETF	37.84	38.05	37.84	38.05	700.0
2014-04-21	AAXJ	ETF	60.76	60.76	60.47	60.59	407000.0
2014-04-21	ACWI	ETF	58.3	58.44	58.23	58.43	199300.0
2014-04-21	ACWV	ETF	64.76	64.79	64.15	64.71	38200.0
2014-04-21	ACWX	ETF	47.05	47.06	46.9098	47.05	134781.0
2014-04-21	ADRE	ETF	37.47	37.66	37.45	37.58	16833.0
2014-04-21	AFK	ETF	32.13	32.1825	31.97	32.1825	8656.0
2014-04-21	AGG	ETF	108.27	108.29	108.13	108.18	1018200.0
2014-04-21	AGQ	ETF	61.5	61.61	61.09	61.56	278900.0
2014-04-21	AGZ	ETF	111.8281	111.92	111.682	111.75	8304.0
2014-04-21	AIA	ETF	47.39	47.55	47.37	47.3916	14189.0
2014-04-21	AIQ	ETF	29.45	30.6	29.45	30.33	46570.0
2014-04-21	AIRR	ETF	19.365	19.37	19.25	19.357	9100.0
2014-04-21	AIVI	ETF	49.42	49.64	49.4	49.57	41500.0
2014-04-21	AMJ	ETF	48.29	48.6	48.14	48.6	507391.0
2014-04-21	AMLP	ETF	90.45	90.75	90.25	90.7	827540.0
2014-04-21	ANGL	ETF	27.7	27.7	27.64	27.67	5000.0
2014-04-21	AOA	ETF	45.23	45.24	45.08	45.21	48100.0
2014-04-21	AOK	ETF	32.42	32.42	32.37	32.39	19581.0
2014-04-21	AOM	ETF	34.6906	34.79	34.6906	34.77	20331.0
2014-04-21	AOR	ETF	39.08	39.08	38.9701	39.07	24548.0
2014-04-21	ARGT	ETF	19.48	19.77	19.48	19.5	2000.0
2014-04-21	ASEA	ETF	16.57	16.57	16.49	16.51	4600.0
2014-04-21	ASHR	ETF	22.22	22.28	22.1	22.13	202300.0
2014-04-21	ATMP	ETF	29.04	29.04	28.8	28.93	19000.0
2014-04-21	AVIV	ETF	25.69	26.2525	25.67	25.7	499616.0
2014-04-21	AWAY	ETF	36.09	36.28	35.2	35.74	2298174.0
2014-04-21	BAB	ETF	28.8	28.87	28.75	28.76	63735.0
2014-04-21	BAL	ETF	56.74	57.04	56.57	57.04	9610.0
2014-04-21	BALT	ETF	6.42	6.54	6.38	6.46	299075.0
2014-04-21	BBH	ETF	85.84	87.2	84.95	87.19	97900.0
2014-04-21	BFOR	ETF	7.4825	7.5325	7.46	7.5175	164000.0
2014-04-21	BIB	ETF	35.215	36.58	34.685	36.525	681882.0
2014-04-21	BICK	ETF	24.7	24.95	24.65	24.95	660.0
2014-04-21	BIL	ETF	91.52	91.54	91.52	91.54	127050.0
2014-04-21	BIS	ETF	768.8	790.796	748.4	750.0	9370.5
2014-04-21	BIV	ETF	83.53	83.66	83.5	83.54	395400.0
2014-04-21	BIZD	ETF	19.9	20.02	19.9	19.98	31300.0
2014-04-21	BJK	ETF	51.18	51.18	50.71	50.96	13200.0
2014-04-21	BKF	ETF	36.69	36.74	36.48	36.62	22453.0
2014-04-21	BKLN	ETF	24.66	24.69	24.66	24.67	2233300.0
2014-04-21	BLNG	ETF	35.87	35.87	35.83	35.83	202.0
2014-04-21	BLV	ETF	87.68	87.87	87.5	87.59	101700.0
2014-04-21	BMVP	ETF	23.5167	23.5846	23.4304	23.5417	28528.0

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

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