PREVIEW / etf_daily / 2014-12-15

all etf daily files

  file:    by_date/etf_daily/2014/2014-12-15.parquet
  size:    47 KB
  rows:    1,160

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-12-15	SPY	ETF	201.98	202.53	198.78	199.51	189965800.0
2014-12-15	QQQ	ETF	103.2	103.58	101.315	101.61	52968448.0
2014-12-15	IWM	ETF	115.26	115.74	113.16	113.55	66361200.0
2014-12-15	DIA	ETF	173.75	174.13	171.21	171.79	8874300.0
2014-12-15	GLD	ETF	116.22	116.97	114.36	114.39	8796000.0
2014-12-15	TLT	ETF	125.64	126.7	125.43	126.04	9387400.0
2014-12-15	AAXJ	ETF	60.08	60.29	59.32	59.55	598100.0
2014-12-15	ACWI	ETF	58.05	58.16	56.97	57.16	2925100.0
2014-12-15	ACWV	ETF	68.57	68.59	67.65	67.85	204900.0
2014-12-15	ACWX	ETF	42.84	42.98	42.0	42.15	2077598.0
2014-12-15	ADRE	ETF	35.15	35.15	34.34	34.38	13498.0
2014-12-15	AFK	ETF	25.47	25.47	24.92	24.94	58880.0
2014-12-15	AGG	ETF	110.38	110.54	110.25	110.26	2540700.0
2014-12-15	AGQ	ETF	43.9	44.18	40.16	40.28	584300.0
2014-12-15	AGZ	ETF	113.33	113.6199	113.14	113.2	11898.0
2014-12-15	AGZD	ETF	24.575	24.625	24.57	24.605	5000.0
2014-12-15	AIA	ETF	46.52	46.52	45.92	46.06	101722.0
2014-12-15	AIQ	ETF	19.93	20.79	19.64	19.94	14240.0
2014-12-15	AIRR	ETF	17.25	17.337	16.85	16.99	15200.0
2014-12-15	AIVI	ETF	43.31	43.31	42.39	42.59	55600.0
2014-12-15	ALTL	ETF	36.2923	36.2923	36.2923	36.2923	200.0
2014-12-15	AMJ	ETF	43.57	44.1	41.66	42.11	2722722.0
2014-12-15	AMLP	ETF	84.5	85.0	81.9	82.5	1661040.0
2014-12-15	AMZA	ETF	204.6	213.2	203.1	205.5	660.0
2014-12-15	ANGL	ETF	26.65	26.94	26.4	26.45	11200.0
2014-12-15	AOA	ETF	45.74	45.96	44.97	45.14	95900.0
2014-12-15	AOK	ETF	32.42	32.44	32.24	32.27	28636.0
2014-12-15	AOM	ETF	34.95	35.2	34.6204	34.68	111233.0
2014-12-15	AOR	ETF	39.65	39.6845	39.24	39.3	42061.0
2014-12-15	ARGT	ETF	18.84	18.84	18.1	18.1	18300.0
2014-12-15	ARKG	ETF	20.55	20.59	20.22	20.28	1300.0
2014-12-15	ARKK	ETF	19.64	19.64	19.28	19.28	1300.0
2014-12-15	ARKQ	ETF	19.35	19.35	19.0	19.0	800.0
2014-12-15	ARKW	ETF	19.96	19.96	19.65	19.73	800.0
2014-12-15	ASEA	ETF	15.85	15.85	15.6	15.63	23200.0
2014-12-15	ASHR	ETF	33.93	34.07	33.4	33.55	1465800.0
2014-12-15	ASHS	ETF	37.61	37.78	37.05	37.21	26000.0
2014-12-15	ATMP	ETF	28.97	28.97	27.93	28.13	181700.0
2014-12-15	AVIV	ETF	34.29	34.46	33.59	33.64	656073.0
2014-12-15	AWAY	ETF	30.39	30.46	29.3	29.35	986454.0
2014-12-15	BAB	ETF	30.31	30.4899	30.2901	30.4299	97443.0
2014-12-15	BAL	ETF	41.68	41.68	41.37	41.37	7105.0
2014-12-15	BALT	ETF	2.53	2.6	2.41	2.43	512736.0
2014-12-15	BAR	ETF	2.941	2.941	2.773	2.773	15100.0
2014-12-15	BBH	ETF	118.9	120.05	114.76	115.0	305300.0
2014-12-15	BCHP	ETF	17.58	17.58	17.55	17.55	545.0
2014-12-15	BCM	ETF	33.119	33.18	32.83	32.8301	97857.0
2014-12-15	BFOR	ETF	7.69	7.72	7.5725	7.615	101200.0
2014-12-15	BIB	ETF	64.755	65.42	60.265	60.625	993784.0
2014-12-15	BICK	ETF	23.08	23.1	23.08	23.1	14101.0

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

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