PREVIEW / etf_daily / 2014-07-30

all etf daily files

  file:    by_date/etf_daily/2014/2014-07-30.parquet
  size:    45 KB
  rows:    1,113

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-07-30	SPY	ETF	197.65	197.91	196.16	196.98	104222000.0
2014-07-30	QQQ	ETF	97.13	97.32	96.6	96.98	35348519.0
2014-07-30	IWM	ETF	114.18	114.31	113.31	113.79	30219000.0
2014-07-30	DIA	ETF	169.27	169.52	167.78	168.48	5446600.0
2014-07-30	GLD	ETF	124.89	124.93	124.41	124.83	5614800.0
2014-07-30	TLT	ETF	115.15	115.38	114.17	114.32	12251200.0
2014-07-30	AADR	ETF	38.59	38.59	38.59	38.59	400.0
2014-07-30	AAXJ	ETF	66.03	66.03	65.24	65.55	756900.0
2014-07-30	ACWI	ETF	60.73	60.73	60.26	60.51	689100.0
2014-07-30	ACWV	ETF	67.41	67.41	66.57	66.84	567300.0
2014-07-30	ACWX	ETF	48.26	48.26	47.95	48.1	139590.0
2014-07-30	ADRE	ETF	41.82	41.84	41.44	41.59	12786.0
2014-07-30	AFK	ETF	34.0	34.0399	33.5114	33.9228	63507.0
2014-07-30	AGG	ETF	109.25	109.29	109.02	109.07	1245000.0
2014-07-30	AGQ	ETF	68.12	68.39	67.24	67.93	85000.0
2014-07-30	AGZ	ETF	112.4	112.53	112.01	112.364	11666.0
2014-07-30	AGZD	ETF	24.95	25.01	24.925	25.01	23000.0
2014-07-30	AIA	ETF	51.07	51.12	50.63	50.82	29507.0
2014-07-30	AIQ	ETF	30.02	30.02	28.61	29.27	86629.0
2014-07-30	AIRR	ETF	18.18	18.22	18.13	18.21	15400.0
2014-07-30	AIVI	ETF	50.62	50.62	50.28	50.49	40300.0
2014-07-30	ALTL	ETF	35.69	35.69	35.4525	35.4525	2135.0
2014-07-30	AMJ	ETF	52.14	52.25	51.19	51.41	855438.0
2014-07-30	AMLP	ETF	94.7	94.7	93.35	93.7	563520.0
2014-07-30	ANGL	ETF	27.86	27.98	27.86	27.98	1300.0
2014-07-30	AOA	ETF	46.75	46.77	46.47	46.61	15900.0
2014-07-30	AOK	ETF	32.91	32.91	32.7728	32.81	25135.0
2014-07-30	AOM	ETF	35.48	35.48	35.31	35.33	33830.0
2014-07-30	AOR	ETF	40.23	40.23	39.97	40.06	31556.0
2014-07-30	ARGT	ETF	22.59	23.52	22.59	23.2	64100.0
2014-07-30	ASEA	ETF	17.36	17.39	17.32	17.36	13900.0
2014-07-30	ASHR	ETF	24.58	24.59	24.34	24.38	320800.0
2014-07-30	ASHS	ETF	28.66	28.66	28.57	28.63	2200.0
2014-07-30	ATMP	ETF	31.7	31.7	31.19	31.31	41700.0
2014-07-30	AVIV	ETF	28.81	28.85	28.35	28.78	183363.0
2014-07-30	AWAY	ETF	35.87	35.92	35.312	35.59	1124082.0
2014-07-30	BAB	ETF	29.56	29.57	29.4201	29.445	94790.0
2014-07-30	BAL	ETF	43.61	43.61	42.78	43.02	58970.0
2014-07-30	BALT	ETF	5.3	5.34	5.18	5.27	342456.0
2014-07-30	BBH	ETF	100.0	100.77	99.0	99.27	106500.0
2014-07-30	BCHP	ETF	20.43	20.43	20.43	20.43	397.0
2014-07-30	BCM	ETF	40.243	40.302	40.18	40.257	5416.0
2014-07-30	BFOR	ETF	7.7775	7.79	7.725	7.7475	45600.0
2014-07-30	BIB	ETF	46.895	47.55	45.95	46.345	367398.0
2014-07-30	BICK	ETF	27.04	27.155	27.04	27.155	799.0
2014-07-30	BIL	ETF	91.52	91.52	91.5	91.52	48500.0
2014-07-30	BIS	ETF	548.0	561.48	541.2	557.6	10053.5
2014-07-30	BIV	ETF	84.52	84.54	84.26	84.35	225100.0
2014-07-30	BIZD	ETF	20.48	20.48	20.37	20.39	8300.0
2014-07-30	BJK	ETF	51.07	51.29	50.89	51.13	53400.0

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

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