PREVIEW / etf_daily / 2013-10-28

all etf daily files

  file:    by_date/etf_daily/2013/2013-10-28.parquet
  size:    43 KB
  rows:    1,057

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
2013-10-28	SPY	ETF	175.89	176.47	175.7	176.23	84979000.0
2013-10-28	QQQ	ETF	82.9	83.05	82.55	82.92	28618375.0
2013-10-28	IWM	ETF	111.13	111.29	110.46	111.03	22512200.0
2013-10-28	DIA	ETF	155.2	155.65	154.99	155.37	4968800.0
2013-10-28	GLD	ETF	130.41	131.44	130.1	130.56	6807800.0
2013-10-28	TLT	ETF	108.01	108.38	107.91	107.92	6466400.0
2013-10-28	AADR	ETF	36.58	37.08	36.58	37.01	8900.0
2013-10-28	AAXJ	ETF	60.18	60.37	60.09	60.24	313400.0
2013-10-28	ACTV	ETF	14.41	14.43	14.4	14.4	678012.0
2013-10-28	ACWI	ETF	56.33	56.46	56.22	56.37	419800.0
2013-10-28	ACWV	ETF	64.17	64.33	63.99	64.26	69100.0
2013-10-28	ACWX	ETF	46.57	46.791	46.57	46.7	2847507.0
2013-10-28	ADRE	ETF	38.43	38.7	38.43	38.62	16955.0
2013-10-28	AFK	ETF	31.98	31.98	31.6825	31.88	40961.0
2013-10-28	AGG	ETF	108.0	108.09	107.94	107.96	936200.0
2013-10-28	AGQ	ETF	85.8	86.88	85.32	85.52	198875.0
2013-10-28	AGZ	ETF	112.0	112.2	111.55	111.58	44150.0
2013-10-28	AIA	ETF	47.92	47.959	47.77	47.82	57520.0
2013-10-28	AIQ	ETF	25.25	26.13	22.19	23.02	122070.0
2013-10-28	AIVI	ETF	47.65	47.74	47.51	47.59	11900.0
2013-10-28	ALTL	ETF	31.54	31.54	31.36	31.52	2033.0
2013-10-28	AMJ	ETF	46.37	46.43	45.51	45.63	521053.0
2013-10-28	AMLP	ETF	90.1	90.25	88.8	89.1	515940.0
2013-10-28	ANGL	ETF	26.95	26.95	26.95	26.95	300.0
2013-10-28	AOA	ETF	43.48	43.55	43.4	43.44	15600.0
2013-10-28	AOK	ETF	31.8879	31.932	31.85	31.85	26527.0
2013-10-28	AOM	ETF	33.99	34.08	33.97	34.04	42809.0
2013-10-28	AOR	ETF	37.88	37.93	37.83	37.9	23664.0
2013-10-28	ARGT	ETF	21.28	21.28	21.03	21.03	6400.0
2013-10-28	ASEA	ETF	17.2	17.32	17.2	17.3	19300.0
2013-10-28	ATMP	ETF	26.97	27.05	26.69	26.73	10900.0
2013-10-28	AVIV	ETF	25.71	25.72	25.16	25.6	78321.0
2013-10-28	AWAY	ETF	30.23	30.568	29.65	29.77	1097543.0
2013-10-28	BAB	ETF	27.88	27.92	27.75	27.78	99707.0
2013-10-28	BAL	ETF	50.23	50.4	50.09	50.09	20031.0
2013-10-28	BALT	ETF	4.7008	4.8204	4.56	4.66	1091292.0
2013-10-28	BBH	ETF	83.74	84.34	83.46	83.84	70100.0
2013-10-28	BCM	ETF	40.304	40.304	40.304	40.304	386.0
2013-10-28	BFOR	ETF	7.135	7.1425	7.0875	7.12	3772400.0
2013-10-28	BIB	ETF	33.09	33.5	32.6575	32.8912	173420.0
2013-10-28	BICK	ETF	24.7499	24.7499	24.65	24.65	400.0
2013-10-28	BIL	ETF	91.56	91.58	91.56	91.58	88300.0
2013-10-28	BIS	ETF	970.4	987.6	964.04	983.592	778.0
2013-10-28	BIV	ETF	84.47	84.63	84.45	84.52	274000.0
2013-10-28	BIZD	ETF	20.59	20.86	20.59	20.83	18200.0
2013-10-28	BJK	ETF	50.52	50.52	50.07	50.36	20000.0
2013-10-28	BKF	ETF	38.26	38.549	38.26	38.47	39830.0
2013-10-28	BKLN	ETF	24.8	24.82	24.78	24.81	4167200.0
2013-10-28	BLNG	ETF	38.7499	38.7499	38.7499	38.7499	100.0
2013-10-28	BLV	ETF	84.81	85.0	84.73	84.86	19300.0

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

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