PREVIEW / etf_daily / 2014-12-17

all etf daily files

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

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-17	SPY	ETF	198.44	202.34	198.29	201.79	253910100.0
2014-12-17	QQQ	ETF	100.05	102.09	99.92	101.8	79715318.0
2014-12-17	IWM	ETF	113.64	116.99	113.49	116.89	70379400.0
2014-12-17	DIA	ETF	171.27	173.98	171.08	173.59	12901600.0
2014-12-17	GLD	ETF	115.1	115.48	113.58	114.27	9097300.0
2014-12-17	TLT	ETF	126.91	127.19	125.7	126.45	11558800.0
2014-12-17	AADR	ETF	36.14	36.63	36.14	36.63	900.0
2014-12-17	AAXJ	ETF	58.59	59.83	58.35	59.34	3265400.0
2014-12-17	ACWI	ETF	56.61	57.64	56.61	57.46	4797700.0
2014-12-17	ACWV	ETF	67.17	68.2	67.11	67.95	135700.0
2014-12-17	ACWX	ETF	42.12	42.81	42.01	42.51	1055024.0
2014-12-17	ADRE	ETF	34.1	35.23	34.1	35.05	15078.0
2014-12-17	AFK	ETF	24.57	24.969	24.35	24.77	31406.0
2014-12-17	AGG	ETF	110.5	110.68	110.28	110.39	2167500.0
2014-12-17	AGQ	ETF	38.68	39.61	37.67	38.5	308600.0
2014-12-17	AGZ	ETF	113.09	113.8	112.85	113.31	622280.0
2014-12-17	AGZD	ETF	24.57	24.655	24.505	24.585	7800.0
2014-12-17	AIA	ETF	46.83	46.83	45.72	46.09	48620.0
2014-12-17	AIQ	ETF	19.43	20.81	19.265	20.79	19100.0
2014-12-17	AIRR	ETF	16.69	17.57	16.62	17.527	76400.0
2014-12-17	AIVI	ETF	42.69	43.79	42.69	43.43	50200.0
2014-12-17	AMJ	ETF	43.07	45.5	43.07	45.23	3534149.0
2014-12-17	AMLP	ETF	83.65	86.4	83.65	86.2	3376160.0
2014-12-17	AMZA	ETF	213.3	220.8	213.3	220.8	250.0
2014-12-17	ANGL	ETF	26.46	26.46	26.33	26.4	1700.0
2014-12-17	AOA	ETF	45.29	45.88	45.24	45.83	68000.0
2014-12-17	AOK	ETF	32.4	32.52	32.333	32.5	61016.0
2014-12-17	AOM	ETF	34.78	35.04	34.745	35.01	218970.0
2014-12-17	AOR	ETF	39.26	39.7899	39.26	39.72	79422.0
2014-12-17	ARGT	ETF	17.92	18.61	17.92	18.34	26400.0
2014-12-17	ARKG	ETF	19.95	20.226	19.95	20.226	1000.0
2014-12-17	ARKK	ETF	19.06	19.16	18.95	19.16	800.0
2014-12-17	ARKQ	ETF	18.86	19.23	18.86	19.23	1200.0
2014-12-17	ARKW	ETF	19.49	19.49	19.49	19.49	300.0
2014-12-17	ASEA	ETF	15.43	15.77	15.43	15.76	39100.0
2014-12-17	ASHR	ETF	35.5	36.17	35.38	35.9	1025700.0
2014-12-17	ASHS	ETF	37.43	37.97	37.43	37.93	11400.0
2014-12-17	ATMP	ETF	28.75	30.1	28.73	30.1	41300.0
2014-12-17	AVIV	ETF	33.49	34.07	33.47	34.06	401911.0
2014-12-17	AWAY	ETF	28.32	28.73	27.83	28.47	1309963.0
2014-12-17	BAB	ETF	30.46	30.5391	30.33	30.36	189233.0
2014-12-17	BAL	ETF	40.7001	41.5799	40.58	41.5799	4956.0
2014-12-17	BALT	ETF	2.38	2.55	2.3	2.52	1014981.0
2014-12-17	BAR	ETF	2.942	3.048	2.761	2.761	23100.0
2014-12-17	BBC	ETF	25.5	26.7	25.5	26.7	6375.0
2014-12-17	BBH	ETF	113.54	116.75	113.05	116.54	150600.0
2014-12-17	BBP	ETF	25.15	26.09	25.15	26.05	4337.0
2014-12-17	BCM	ETF	32.47	32.96	32.47	32.66	71354.0
2014-12-17	BFOR	ETF	7.59	7.77	7.5	7.745	143200.0
2014-12-17	BIB	ETF	60.0	63.185	59.03	63.035	631974.0

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

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