PREVIEW / etf_daily / 2014-08-19

all etf daily files

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

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-08-19	SPY	ETF	197.84	198.54	197.44	198.39	59135000.0
2014-08-19	QQQ	ETF	98.38	98.76	98.32	98.7	21363394.0
2014-08-19	IWM	ETF	115.13	115.73	115.06	115.44	22692600.0
2014-08-19	DIA	ETF	168.64	169.02	168.33	168.89	3057200.0
2014-08-19	GLD	ETF	125.0	125.0	124.48	124.68	4878400.0
2014-08-19	TLT	ETF	117.08	117.15	115.98	116.18	5936900.0
2014-08-19	AADR	ETF	37.9	38.44	37.9	38.44	1000.0
2014-08-19	AAXJ	ETF	65.86	66.13	65.86	66.08	493500.0
2014-08-19	ACWI	ETF	60.35	60.51	60.3	60.48	5075300.0
2014-08-19	ACWV	ETF	67.75	67.93	67.7	67.92	10800.0
2014-08-19	ACWX	ETF	47.61	47.69	47.57	47.66	204646.0
2014-08-19	ADRE	ETF	42.56	42.7599	42.5	42.73	23593.0
2014-08-19	AFK	ETF	33.54	33.61	33.34	33.58	48277.0
2014-08-19	AGG	ETF	109.76	109.8	109.49	109.51	1820700.0
2014-08-19	AGQ	ETF	61.37	61.43	60.1	60.7	401400.0
2014-08-19	AGZ	ETF	112.69	113.1099	112.63	112.85	9967.0
2014-08-19	AIA	ETF	51.13	51.1445	51.054	51.13	11698.0
2014-08-19	AIQ	ETF	28.79	28.97	28.3	28.45	27380.0
2014-08-19	AIRR	ETF	19.23	19.23	19.09	19.1	566100.0
2014-08-19	AIVI	ETF	49.6	49.72	49.51	49.59	32300.0
2014-08-19	ALTL	ETF	35.8	35.8	35.8	35.8	2000.0
2014-08-19	AMJ	ETF	53.01	53.35	53.0	53.22	237395.0
2014-08-19	AMLP	ETF	94.65	95.0	94.6	94.9	605260.0
2014-08-19	ANGL	ETF	28.22	28.22	28.12	28.12	1100.0
2014-08-19	AOA	ETF	46.78	46.85	46.75	46.85	19200.0
2014-08-19	AOK	ETF	32.85	32.9	32.85	32.9	23480.0
2014-08-19	AOM	ETF	35.53	35.53	35.47	35.52	32024.0
2014-08-19	AOR	ETF	40.27	40.28	40.211	40.28	22274.0
2014-08-19	ARGT	ETF	21.43	21.47	21.3	21.3	6500.0
2014-08-19	ASEA	ETF	17.49	17.51	17.48	17.51	1600.0
2014-08-19	ASHR	ETF	25.2	25.23	25.16	25.22	1321500.0
2014-08-19	ASHS	ETF	30.77	30.85	30.77	30.78	10000.0
2014-08-19	ATMP	ETF	32.34	32.46	32.31	32.44	35100.0
2014-08-19	AVIV	ETF	28.21	28.31	28.13	28.27	78345.0
2014-08-19	AWAY	ETF	33.33	33.33	32.7	32.89	583218.0
2014-08-19	BAB	ETF	29.64	29.7	29.54	29.61	93091.0
2014-08-19	BAL	ETF	43.08	43.158	42.88	43.158	6136.0
2014-08-19	BALT	ETF	5.92	5.99	5.805	5.87	321084.0
2014-08-19	BBH	ETF	103.44	103.52	102.44	103.24	105600.0
2014-08-19	BCHP	ETF	20.2699	20.29	20.26	20.29	6941.0
2014-08-19	BCM	ETF	39.1	39.13	39.1	39.12	1411.0
2014-08-19	BFOR	ETF	7.8025	7.825	7.7975	7.8225	29200.0
2014-08-19	BIB	ETF	49.61	50.0434	48.8475	49.865	706738.0
2014-08-19	BICK	ETF	27.42	27.421	27.4	27.421	1677.0
2014-08-19	BIL	ETF	91.5	91.52	91.5	91.52	502550.0
2014-08-19	BIS	ETF	512.0	523.56	510.8	512.0	9655.5
2014-08-19	BIV	ETF	85.18	85.21	84.98	85.0	404600.0
2014-08-19	BIZD	ETF	20.62	20.62	20.42	20.43	20200.0
2014-08-19	BJK	ETF	49.29	49.43	49.23	49.35	8100.0
2014-08-19	BKF	ETF	40.97	41.27	40.97	41.27	352866.0

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

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