PREVIEW / etf_daily / 2014-09-15

all etf daily files

  file:    by_date/etf_daily/2014/2014-09-15.parquet
  size:    45 KB
  rows:    1,119

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-09-15	SPY	ETF	199.16	199.32	198.38	198.98	76401000.0
2014-09-15	QQQ	ETF	99.59	99.6	98.215	98.52	32972159.0
2014-09-15	IWM	ETF	115.36	115.4	113.71	114.11	41644400.0
2014-09-15	DIA	ETF	170.06	170.57	169.55	170.32	5130700.0
2014-09-15	GLD	ETF	118.79	118.86	118.46	118.64	4775400.0
2014-09-15	TLT	ETF	113.85	114.07	113.36	113.55	5510700.0
2014-09-15	AADR	ETF	38.16	38.24	38.06	38.24	11000.0
2014-09-15	AAXJ	ETF	64.3	64.35	63.85	63.85	1870000.0
2014-09-15	ACWI	ETF	60.12	60.13	59.94	60.05	426800.0
2014-09-15	ACWV	ETF	67.4	67.4	67.19	67.28	60100.0
2014-09-15	ACWX	ETF	46.95	47.0134	46.89	46.95	179896.0
2014-09-15	ADRE	ETF	41.83	41.94	41.57	41.755	19541.0
2014-09-15	AFK	ETF	32.15	32.24	32.0	32.1	46764.0
2014-09-15	AGG	ETF	108.73	108.76	108.59	108.61	1210800.0
2014-09-15	AGQ	ETF	55.38	55.63	54.88	55.63	134900.0
2014-09-15	AGZ	ETF	112.44	112.46	112.12	112.261	14005.0
2014-09-15	AGZD	ETF	24.885	24.905	24.81	24.815	15000.0
2014-09-15	AIA	ETF	49.67	49.67	49.322	49.37	21143.0
2014-09-15	AIQ	ETF	25.9	25.9	25.17	25.29	17783.0
2014-09-15	AIRR	ETF	19.332	19.332	19.12	19.18	10300.0
2014-09-15	AIVI	ETF	48.5	48.63	48.46	48.6	12600.0
2014-09-15	ALTL	ETF	35.76	35.76	35.76	35.76	780.0
2014-09-15	AMJ	ETF	52.61	52.61	51.81	52.39	1525219.0
2014-09-15	AMLP	ETF	94.65	94.75	93.85	94.5	709160.0
2014-09-15	ANGL	ETF	28.01	28.01	27.85	27.85	1200.0
2014-09-15	AOA	ETF	46.54	46.54	46.33	46.41	23000.0
2014-09-15	AOK	ETF	32.66	32.663	32.63	32.64	28553.0
2014-09-15	AOM	ETF	35.32	35.32	35.2	35.24	59490.0
2014-09-15	AOR	ETF	40.08	40.08	39.8862	39.932	27186.0
2014-09-15	ARGT	ETF	21.61	21.88	21.47	21.47	34900.0
2014-09-15	ASEA	ETF	17.04	17.05	16.99	16.99	5200.0
2014-09-15	ASHR	ETF	25.7	25.72	25.55	25.6	288300.0
2014-09-15	ASHS	ETF	32.75	32.81	32.71	32.73	7800.0
2014-09-15	ATMP	ETF	31.99	31.99	31.57	31.77	14600.0
2014-09-15	AVIV	ETF	27.49	27.49	27.2	27.29	137149.0
2014-09-15	AWAY	ETF	33.35	33.48	32.726	32.89	547621.0
2014-09-15	BAB	ETF	29.44	29.4799	29.38	29.38	337433.0
2014-09-15	BAL	ETF	44.76	44.76	44.0	44.17	14590.0
2014-09-15	BALT	ETF	5.62	5.64	5.375	5.47	342926.0
2014-09-15	BAR	ETF	3.24	3.25	3.2245	3.2245	41170.0
2014-09-15	BBH	ETF	104.07	104.07	102.18	102.89	133100.0
2014-09-15	BFOR	ETF	7.81	7.8325	7.765	7.7675	71200.0
2014-09-15	BIB	ETF	50.265	50.305	48.345	49.16	575146.0
2014-09-15	BICK	ETF	26.7	26.7	26.5204	26.5204	847.0
2014-09-15	BIL	ETF	91.5	91.52	91.5	91.5	143250.0
2014-09-15	BIS	ETF	503.2	522.0	502.0	514.0	15765.5
2014-09-15	BIV	ETF	83.89	83.97	83.87	83.94	284700.0
2014-09-15	BIZD	ETF	20.42	20.42	20.22	20.23	40600.0
2014-09-15	BJK	ETF	45.25	45.25	44.91	44.93	14600.0
2014-09-15	BKF	ETF	39.79	39.86	39.5401	39.74	68156.0

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

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