PREVIEW / etf_daily / 2014-09-19

all etf daily files

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

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-19	SPY	ETF	201.52	201.9	200.29	200.7	121649000.0
2014-09-19	QQQ	ETF	100.46	100.5646	99.58	99.98	46923054.0
2014-09-19	IWM	ETF	115.89	115.91	113.61	113.97	52459600.0
2014-09-19	DIA	ETF	173.0	173.32	172.19	172.45	9341000.0
2014-09-19	GLD	ETF	117.51	117.57	116.72	117.09	10930200.0
2014-09-19	TLT	ETF	113.58	114.68	113.2	114.6	13236900.0
2014-09-19	AADR	ETF	39.09	39.09	38.2	38.29	7300.0
2014-09-19	AAXJ	ETF	64.26	64.26	63.66	63.85	378500.0
2014-09-19	ACWI	ETF	60.72	60.79	60.37	60.45	439300.0
2014-09-19	ACWV	ETF	67.94	67.94	67.45	67.52	49600.0
2014-09-19	ACWX	ETF	47.22	47.29	46.8911	46.93	150198.0
2014-09-19	ADRE	ETF	42.03	42.03	41.37	41.4599	15637.0
2014-09-19	AFK	ETF	32.61	32.61	32.03	32.0924	26772.0
2014-09-19	AGG	ETF	108.56	108.73	108.51	108.68	929900.0
2014-09-19	AGQ	ETF	53.85	54.0	50.38	50.99	628200.0
2014-09-19	AGZ	ETF	112.02	112.33	111.7901	111.95	45797.0
2014-09-19	AGZD	ETF	24.885	24.895	24.835	24.895	17200.0
2014-09-19	AIA	ETF	49.14	49.14	48.78	48.95	51226.0
2014-09-19	AIQ	ETF	24.76	26.0	24.52	25.59	51159.0
2014-09-19	AIRR	ETF	19.54	19.54	19.18	19.22	47500.0
2014-09-19	AIVI	ETF	48.86	48.97	48.48	48.49	44000.0
2014-09-19	AMJ	ETF	53.5	53.835	53.385	53.83	946993.0
2014-09-19	AMLP	ETF	95.8	96.35	95.75	96.25	576440.0
2014-09-19	ANGL	ETF	27.85	28.09	27.85	28.03	4400.0
2014-09-19	AOA	ETF	46.84	46.88	46.56	46.65	25800.0
2014-09-19	AOK	ETF	32.8	32.8	32.6901	32.73	14274.0
2014-09-19	AOM	ETF	35.47	35.47	35.3298	35.35	73313.0
2014-09-19	AOR	ETF	40.31	40.31	40.0899	40.13	60679.0
2014-09-19	ARGT	ETF	21.69	21.8	21.5	21.53	10900.0
2014-09-19	ASEA	ETF	17.07	17.14	17.01	17.01	5600.0
2014-09-19	ASHR	ETF	25.46	25.54	25.32	25.37	416600.0
2014-09-19	ASHS	ETF	32.73	32.73	32.42	32.48	21800.0
2014-09-19	ATMP	ETF	32.62	32.72	32.62	32.71	18200.0
2014-09-19	AVIV	ETF	27.56	27.61	27.21	27.39	936009.0
2014-09-19	AWAY	ETF	33.56	34.47	33.56	34.42	1964436.0
2014-09-19	BAB	ETF	29.38	29.47	29.29	29.44	154688.0
2014-09-19	BAL	ETF	42.87	43.2301	42.7	43.13	30352.0
2014-09-19	BALT	ETF	5.47	5.55	5.09	5.21	612906.0
2014-09-19	BAR	ETF	3.15	3.15	3.095	3.109	21890.0
2014-09-19	BBH	ETF	107.44	107.62	106.27	106.97	50500.0
2014-09-19	BCM	ETF	37.38	37.39	37.32	37.32	1001.0
2014-09-19	BFOR	ETF	7.88	7.88	7.7825	7.785	98400.0
2014-09-19	BIB	ETF	53.0	53.456	51.865	52.65	325422.0
2014-09-19	BICK	ETF	26.66	26.66	26.66	26.66	231.0
2014-09-19	BIL	ETF	91.5	91.52	91.5	91.52	146050.0
2014-09-19	BIS	ETF	477.2	486.0	472.0	479.2	9881.0
2014-09-19	BIV	ETF	83.83	83.97	83.73	83.92	218000.0
2014-09-19	BIZD	ETF	20.25	20.25	20.01	20.04	22800.0
2014-09-19	BJK	ETF	45.21	45.25	44.72	44.85	19200.0
2014-09-19	BKF	ETF	39.79	39.79	39.25	39.37	17052.0

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

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