PREVIEW / etf_daily / 2014-11-05

all etf daily files

  file:    by_date/etf_daily/2014/2014-11-05.parquet
  size:    46 KB
  rows:    1,144

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-11-05	SPY	ETF	202.54	202.59	201.45	202.34	91709000.0
2014-11-05	QQQ	ETF	102.01	102.03	101.015	101.37	25818604.0
2014-11-05	IWM	ETF	116.67	116.74	115.55	116.03	31073500.0
2014-11-05	DIA	ETF	174.59	174.62	173.71	174.55	5286200.0
2014-11-05	GLD	ETF	109.92	110.84	109.67	109.79	13560100.0
2014-11-05	TLT	ETF	118.91	119.37	118.82	119.16	4799600.0
2014-11-05	AADR	ETF	37.34	37.35	37.34	37.35	200.0
2014-11-05	AAXJ	ETF	62.17	62.17	61.81	62.13	349700.0
2014-11-05	ACWI	ETF	59.34	59.36	59.05	59.32	651100.0
2014-11-05	ACWV	ETF	69.13	69.17	68.9	69.15	43500.0
2014-11-05	ACWX	ETF	44.87	44.9	44.65	44.81	208076.0
2014-11-05	ADRE	ETF	39.07	39.1801	39.02	39.13	8733.0
2014-11-05	AFK	ETF	29.28	29.28	29.04	29.17	35277.0
2014-11-05	AGG	ETF	109.65	109.74	109.59	109.73	2699600.0
2014-11-05	AGQ	ETF	37.0	38.22	36.62	36.68	526500.0
2014-11-05	AGZ	ETF	113.13	113.13	112.5	112.9	9257.0
2014-11-05	AGZD	ETF	24.835	24.835	24.755	24.77	23600.0
2014-11-05	AIA	ETF	47.4	47.4	47.1	47.3158	17792.0
2014-11-05	AIQ	ETF	25.17	25.83	24.41	24.73	11779.0
2014-11-05	AIRR	ETF	19.18	19.18	18.84	18.86	27600.0
2014-11-05	AIVI	ETF	45.73	45.73	45.43	45.65	15300.0
2014-11-05	AMJ	ETF	49.68	50.21	49.36	50.18	854615.0
2014-11-05	AMLP	ETF	92.15	92.6	91.65	92.4	824960.0
2014-11-05	AMZA	ETF	236.74	240.8	236.74	240.2	490.0
2014-11-05	ANGL	ETF	27.42	27.94	27.42	27.51	125800.0
2014-11-05	AOA	ETF	46.4	46.4	46.2	46.34	21100.0
2014-11-05	AOK	ETF	32.74	32.74	32.6301	32.69	15873.0
2014-11-05	AOM	ETF	35.38	35.38	35.1604	35.24	75796.0
2014-11-05	AOR	ETF	40.08	40.08	39.96	40.05	37945.0
2014-11-05	ARGT	ETF	20.78	21.0	20.78	20.89	23000.0
2014-11-05	ARKG	ETF	20.31	20.31	20.0	20.03	4300.0
2014-11-05	ARKK	ETF	20.51	20.51	20.0	20.0	14900.0
2014-11-05	ARKQ	ETF	19.81	19.81	19.72	19.72	700.0
2014-11-05	ARKW	ETF	20.493	20.493	20.2	20.2	2000.0
2014-11-05	ASEA	ETF	16.63	16.69	16.56	16.65	22800.0
2014-11-05	ASHR	ETF	26.6	26.6	26.41	26.47	203500.0
2014-11-05	ASHS	ETF	34.34	34.34	34.2	34.27	3900.0
2014-11-05	ATMP	ETF	31.18	31.18	30.73	31.18	14300.0
2014-11-05	AVIV	ETF	33.64	33.99	33.48	33.6	753635.0
2014-11-05	AWAY	ETF	32.86	32.86	28.495	28.58	8552868.0
2014-11-05	BAB	ETF	29.8	29.88	29.7601	29.83	111246.0
2014-11-05	BAL	ETF	41.66	42.07	41.51	42.07	5808.0
2014-11-05	BALT	ETF	3.87	3.92	3.43	3.57	2164560.0
2014-11-05	BAR	ETF	2.54	2.5615	2.527	2.529	25980.0
2014-11-05	BBH	ETF	116.48	116.48	113.0	113.32	69100.0
2014-11-05	BCHP	ETF	18.2762	18.34	18.2762	18.318	22829.0
2014-11-05	BCM	ETF	35.3	35.33	35.3	35.3099	10366.0
2014-11-05	BFOR	ETF	7.835	7.865	7.8	7.83	166000.0
2014-11-05	BIB	ETF	60.805	60.805	57.05	57.445	675132.0
2014-11-05	BICK	ETF	24.98	24.98	24.94	24.95	766.0

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

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