PREVIEW / etf_daily / 2014-09-24

all etf daily files

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

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-24	SPY	ETF	198.04	199.69	197.52	199.56	107276000.0
2014-09-24	QQQ	ETF	98.87	99.8868	98.54	99.84	35958950.0
2014-09-24	IWM	ETF	111.15	112.11	110.6	112.02	34323100.0
2014-09-24	DIA	ETF	170.36	171.9	169.98	171.79	5813000.0
2014-09-24	GLD	ETF	117.12	117.72	116.9	117.05	5515000.0
2014-09-24	TLT	ETF	115.29	115.55	114.64	114.81	5223300.0
2014-09-24	AADR	ETF	37.47	37.5	37.47	37.5	800.0
2014-09-24	AAXJ	ETF	63.21	63.64	63.02	63.51	622600.0
2014-09-24	ACWI	ETF	59.68	60.01	59.44	59.95	648300.0
2014-09-24	ACWV	ETF	66.97	67.45	66.9	67.33	224000.0
2014-09-24	ACWX	ETF	46.36	46.6	46.18	46.54	64296.0
2014-09-24	ADRE	ETF	40.6	41.1062	40.6	41.05	9549.0
2014-09-24	AFK	ETF	31.5	32.05	31.5	31.74	31277.0
2014-09-24	AGG	ETF	109.08	109.08	108.84	108.86	836700.0
2014-09-24	AGQ	ETF	49.25	50.31	48.83	49.71	236200.0
2014-09-24	AGZ	ETF	112.58	112.58	112.12	112.18	6960.0
2014-09-24	AGZD	ETF	24.895	24.925	24.865	24.865	4200.0
2014-09-24	AIA	ETF	48.07	48.45	48.02	48.38	18927.0
2014-09-24	AIQ	ETF	25.02	25.02	24.36	24.68	19500.0
2014-09-24	AIRR	ETF	18.75	18.86	18.736	18.84	7400.0
2014-09-24	AIVI	ETF	47.57	47.8	47.42	47.75	75600.0
2014-09-24	ALTL	ETF	35.51	35.51	35.5	35.5	942.0
2014-09-24	AMJ	ETF	52.36	52.65	51.66	52.46	1395527.0
2014-09-24	AMLP	ETF	94.4	95.0	93.6	94.7	725180.0
2014-09-24	ANGL	ETF	27.8	27.8	27.8	27.8	400.0
2014-09-24	AOA	ETF	46.08	46.29	45.91	46.26	35600.0
2014-09-24	AOK	ETF	32.55	32.63	32.55	32.63	33214.0
2014-09-24	AOM	ETF	35.15	35.2	35.07	35.16	21060.0
2014-09-24	AOR	ETF	39.71	39.86	39.649	39.85	40006.0
2014-09-24	ARGT	ETF	21.29	21.44	21.12	21.38	156100.0
2014-09-24	ASEA	ETF	17.0	17.06	17.0	17.03	11500.0
2014-09-24	ASHR	ETF	25.63	25.84	25.52	25.77	439200.0
2014-09-24	ASHS	ETF	33.0	33.19	33.0	33.19	212500.0
2014-09-24	ATMP	ETF	32.09	32.2	31.69	32.02	51200.0
2014-09-24	AVIV	ETF	26.85	27.2	26.644	26.94	178256.0
2014-09-24	AWAY	ETF	33.79	33.94	32.99	33.63	727396.0
2014-09-24	BAB	ETF	29.54	29.5799	29.45	29.5	84786.0
2014-09-24	BAL	ETF	41.05	41.95	40.81	41.149	25182.0
2014-09-24	BALT	ETF	4.5	4.56	4.36	4.37	625629.0
2014-09-24	BAR	ETF	3.095	3.1344	3.095	3.1344	23600.0
2014-09-24	BBH	ETF	105.9	108.7	105.9	108.67	80300.0
2014-09-24	BCHP	ETF	19.68	19.68	19.68	19.68	200.0
2014-09-24	BCM	ETF	36.981	37.228	36.98	37.228	4574.0
2014-09-24	BFOR	ETF	7.6175	7.6875	7.5225	7.6875	92000.0
2014-09-24	BIB	ETF	51.75	54.3004	51.75	54.245	506574.0
2014-09-24	BICK	ETF	25.74	26.07	25.74	26.07	4109.0
2014-09-24	BIL	ETF	91.52	91.52	91.5	91.52	65150.0
2014-09-24	BIS	ETF	490.8	490.8	462.8	463.6	18626.0
2014-09-24	BIV	ETF	84.13	84.18	83.94	83.99	257700.0
2014-09-24	BIZD	ETF	19.85	19.89	19.8	19.89	47400.0

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

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