PREVIEW / etf_daily / 2014-09-17

all etf daily files

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

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-17	SPY	ETF	200.77	201.68	199.75	200.75	151266000.0
2014-09-17	QQQ	ETF	99.37	100.0	98.93	99.53	37206375.0
2014-09-17	IWM	ETF	114.49	115.47	114.19	114.73	45543000.0
2014-09-17	DIA	ETF	171.57	172.25	170.93	171.58	8498600.0
2014-09-17	GLD	ETF	118.95	119.24	117.5	117.54	8328700.0
2014-09-17	TLT	ETF	113.53	113.83	112.73	112.8	12917000.0
2014-09-17	AADR	ETF	38.54	38.54	38.08	38.08	2400.0
2014-09-17	AAXJ	ETF	64.39	64.5	63.93	63.98	296500.0
2014-09-17	ACWI	ETF	60.43	60.57	60.11	60.25	744500.0
2014-09-17	ACWV	ETF	67.79	67.89	67.43	67.58	38800.0
2014-09-17	ACWX	ETF	47.21	47.21	46.83	46.88	85665.0
2014-09-17	ADRE	ETF	42.37	42.46	42.1001	42.1436	7304.0
2014-09-17	AFK	ETF	32.26	32.4	32.01	32.01	18988.0
2014-09-17	AGG	ETF	108.74	108.84	108.48	108.49	707200.0
2014-09-17	AGQ	ETF	55.53	56.22	54.42	54.47	174700.0
2014-09-17	AGZ	ETF	112.18	112.3509	112.18	112.22	8341.0
2014-09-17	AGZD	ETF	24.86	24.93	24.8	24.925	7000.0
2014-09-17	AIA	ETF	49.64	49.79	49.385	49.44	38986.0
2014-09-17	AIQ	ETF	24.9	24.93	24.12	24.62	18287.0
2014-09-17	AIRR	ETF	19.31	19.42	19.21	19.31	25500.0
2014-09-17	AIVI	ETF	48.64	48.72	48.33	48.33	8700.0
2014-09-17	ALTL	ETF	36.1089	36.1089	36.096	36.1072	1499.0
2014-09-17	AMJ	ETF	52.99	53.36	52.77	53.13	1214263.0
2014-09-17	AMLP	ETF	95.35	95.75	95.05	95.55	485340.0
2014-09-17	ANGL	ETF	27.86	28.06	27.81	27.91	2200.0
2014-09-17	AOA	ETF	46.68	46.83	46.58	46.8	27800.0
2014-09-17	AOK	ETF	32.71	32.741	32.64	32.66	21877.0
2014-09-17	AOM	ETF	35.4	35.406	35.25	35.25	40738.0
2014-09-17	AOR	ETF	40.13	40.23	40.07	40.12	31967.0
2014-09-17	ARGT	ETF	22.22	22.22	21.82	21.88	15900.0
2014-09-17	ASEA	ETF	17.08	17.08	17.0	17.01	5200.0
2014-09-17	ASHR	ETF	25.4	25.46	25.22	25.28	373800.0
2014-09-17	ASHS	ETF	31.98	32.0	31.87	32.0	700.0
2014-09-17	ATMP	ETF	32.08	32.34	32.08	32.17	24800.0
2014-09-17	AVIV	ETF	27.57	27.74	27.22	27.66	165027.0
2014-09-17	AWAY	ETF	33.07	33.38	32.84	33.0	485909.0
2014-09-17	BAB	ETF	29.45	29.47	29.27	29.2997	196351.0
2014-09-17	BAL	ETF	44.37	44.37	44.105	44.16	2175.0
2014-09-17	BALT	ETF	5.46	5.56	5.41	5.42	193332.0
2014-09-17	BAR	ETF	3.243	3.25	3.2	3.215	39090.0
2014-09-17	BBH	ETF	105.44	105.98	104.39	105.39	105500.0
2014-09-17	BCHP	ETF	20.03	20.03	20.03	20.03	220.0
2014-09-17	BCM	ETF	38.006	38.05	37.9572	37.97	3887.0
2014-09-17	BFOR	ETF	7.8175	7.845	7.79	7.8125	84800.0
2014-09-17	BIB	ETF	51.33	52.38	50.95	51.835	382278.0
2014-09-17	BICK	ETF	26.99	26.99	26.87	26.99	900.0
2014-09-17	BIL	ETF	91.52	91.52	91.5	91.5	359300.0
2014-09-17	BIS	ETF	495.2	495.996	480.8	486.4	7403.0
2014-09-17	BIV	ETF	83.96	84.17	83.71	83.76	287500.0
2014-09-17	BIZD	ETF	20.31	20.32	20.24	20.28	4700.0

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

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