PREVIEW / etf_daily / 2013-02-21

all etf daily files

  file:    by_date/etf_daily/2013/2013-02-21.parquet
  size:    40 KB
  rows:    979

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-02-21	SPY	ETF	150.96	151.42	149.94	150.42	183257000.0
2013-02-21	QQQ	ETF	66.96	67.01	66.23	66.47	45855576.0
2013-02-21	IWM	ETF	90.77	90.82	89.37	89.95	45067400.0
2013-02-21	DIA	ETF	138.65	138.88	138.06	138.51	7517900.0
2013-02-21	GLD	ETF	152.0	153.41	151.9	152.62	17964800.0
2013-02-21	TLT	ETF	116.9	117.31	116.74	116.95	8297400.0
2013-02-21	AADR	ETF	33.0	33.0	33.0	33.0	100.0
2013-02-21	AAXJ	ETF	59.86	59.99	59.51	59.79	814600.0
2013-02-21	ACTV	ETF	4.97	5.04	4.725	4.75	707722.0
2013-02-21	ACWI	ETF	49.62	49.62	49.28	49.48	679400.0
2013-02-21	ACWV	ETF	58.37	58.64	58.37	58.47	10800.0
2013-02-21	ACWX	ETF	42.44	42.44	42.06	42.23	433664.0
2013-02-21	ADRE	ETF	39.52	39.52	39.0322	39.18	32881.0
2013-02-21	AFK	ETF	31.09	31.09	30.661	30.69	13756.0
2013-02-21	AGEM	ETF	23.0	23.0	22.78	22.82	1369.0
2013-02-21	AGG	ETF	110.26	110.37	110.24	110.25	829600.0
2013-02-21	AGQ	ETF	154.52	157.48	154.16	155.6	431400.0
2013-02-21	AGZ	ETF	113.11	113.19	113.0001	113.19	7532.0
2013-02-21	AIA	ETF	47.32	47.32	47.0	47.16	16498.0
2013-02-21	AIQ	ETF	6.93	7.045	6.751	6.95	10236.0
2013-02-21	AIVI	ETF	41.59	41.63	41.27	41.39	14000.0
2013-02-21	AMJ	ETF	43.71	43.71	42.84	43.22	2125697.0
2013-02-21	AMLP	ETF	85.95	85.95	84.6	85.0	622760.0
2013-02-21	ANGL	ETF	26.68	26.91	26.68	26.78	2200.0
2013-02-21	AOA	ETF	38.67	38.67	38.42	38.52	28200.0
2013-02-21	AOK	ETF	30.8249	30.834	30.78	30.79	12992.0
2013-02-21	AOM	ETF	32.28	32.28	32.1599	32.2	11333.0
2013-02-21	AOR	ETF	34.84	34.869	34.7444	34.82	47791.0
2013-02-21	ARB	ETF	46.91	47.0225	46.87	46.9	309224.0
2013-02-21	ARGT	ETF	17.26	17.36	17.04	17.16	16850.0
2013-02-21	ASEA	ETF	17.1	17.13	16.91	16.98	26700.0
2013-02-21	AWAY	ETF	27.0	28.74	27.0	28.38	3928759.0
2013-02-21	BAB	ETF	30.12	30.18	30.09	30.12	1210216.0
2013-02-21	BAL	ETF	54.31	54.75	53.668	53.68	44250.0
2013-02-21	BALT	ETF	3.37	3.48	3.31	3.44	102750.0
2013-02-21	BBH	ETF	57.48	57.53	56.92	57.28	71600.0
2013-02-21	BCM	ETF	43.41	43.53	43.35	43.38	32054.0
2013-02-21	BIB	ETF	15.9025	16.0525	15.6375	15.8375	71976.0
2013-02-21	BICK	ETF	24.76	24.8522	24.7472	24.8522	1935.0
2013-02-21	BIL	ETF	91.62	91.62	91.6	91.6	290850.0
2013-02-21	BIS	ETF	2390.0	2401.196	2390.0	2400.4	79.0
2013-02-21	BIV	ETF	87.47	87.51	87.34	87.34	280200.0
2013-02-21	BIZD	ETF	20.26	20.26	19.93	19.93	8500.0
2013-02-21	BJK	ETF	37.51	37.51	37.16	37.4	7600.0
2013-02-21	BKF	ETF	40.05	40.1194	39.6	39.81	99913.0
2013-02-21	BKLN	ETF	24.98	24.98	24.95	24.98	1367900.0
2013-02-21	BLV	ETF	91.39	91.7	91.33	91.46	52200.0
2013-02-21	BMVP	ETF	17.64	17.64	17.45	17.58	4043.0
2013-02-21	BND	ETF	83.38	83.4	83.31	83.36	803000.0
2013-02-21	BNO	ETF	42.705	42.87	42.535	42.67	90800.0

> showing 50 of 979 rows — these rows as CSV

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