PREVIEW / etf_daily / 2013-02-22

all etf daily files

  file:    by_date/etf_daily/2013/2013-02-22.parquet
  size:    40 KB
  rows:    973

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-22	SPY	ETF	151.15	151.89	150.49	151.89	106356600.0
2013-02-22	QQQ	ETF	66.84	67.15	66.59	67.139	21969534.0
2013-02-22	IWM	ETF	90.41	91.03	90.37	91.03	24762300.0
2013-02-22	DIA	ETF	139.24	139.83	138.86	139.81	4158500.0
2013-02-22	GLD	ETF	152.26	152.99	151.93	152.97	10093200.0
2013-02-22	TLT	ETF	116.98	117.34	116.88	117.03	5316900.0
2013-02-22	AAXJ	ETF	60.11	60.14	59.77	59.95	371600.0
2013-02-22	ACTV	ETF	4.82	4.9	4.7	4.84	526100.0
2013-02-22	ACWI	ETF	49.82	49.97	49.62	49.96	426400.0
2013-02-22	ACWV	ETF	58.65	59.1	58.65	59.1	39000.0
2013-02-22	ACWX	ETF	42.49	42.7	42.36	42.7	192812.0
2013-02-22	ADRE	ETF	39.56	39.6	39.35	39.6	40002.0
2013-02-22	AFK	ETF	30.62	30.9799	30.62	30.8601	27113.0
2013-02-22	AGEM	ETF	22.92	22.92	22.86	22.86	568.0
2013-02-22	AGG	ETF	110.31	110.35	110.29	110.31	955700.0
2013-02-22	AGQ	ETF	154.12	156.52	152.04	156.52	312625.0
2013-02-22	AGZ	ETF	113.06	113.21	113.06	113.21	16475.0
2013-02-22	AIA	ETF	47.26	47.386	47.2	47.36	9921.0
2013-02-22	AIQ	ETF	6.85	7.09	6.85	6.97	16838.0
2013-02-22	AIVI	ETF	41.85	42.17	41.79	42.17	16200.0
2013-02-22	AMJ	ETF	43.44	43.55	43.19	43.26	2468351.0
2013-02-22	AMLP	ETF	85.3	85.8	84.9	85.3	540420.0
2013-02-22	ANGL	ETF	27.07	27.07	26.98	26.98	400.0
2013-02-22	AOA	ETF	38.67	38.83	38.62	38.83	37800.0
2013-02-22	AOK	ETF	30.89	30.92	30.84	30.92	41725.0
2013-02-22	AOM	ETF	32.23	32.37	32.23	32.37	22859.0
2013-02-22	AOR	ETF	34.99	35.03	34.9407	35.03	28068.0
2013-02-22	ARB	ETF	46.92	47.0	46.89	46.92	600246.0
2013-02-22	ARGT	ETF	17.18	17.18	17.14	17.14	300.0
2013-02-22	ASEA	ETF	17.11	17.19	17.08	17.18	31300.0
2013-02-22	AWAY	ETF	28.47	28.9825	28.06	28.65	1614704.0
2013-02-22	BAB	ETF	30.09	30.21	30.09	30.18	286060.0
2013-02-22	BAL	ETF	54.05	54.34	53.48	53.64	35378.0
2013-02-22	BALT	ETF	3.43	3.55	3.36	3.48	66128.0
2013-02-22	BBH	ETF	57.72	58.45	57.68	58.43	37800.0
2013-02-22	BCM	ETF	43.45	43.45	43.45	43.45	500.0
2013-02-22	BIB	ETF	15.9575	16.325	15.9575	16.325	42548.0
2013-02-22	BICK	ETF	24.94	25.01	24.94	25.01	5318.0
2013-02-22	BIL	ETF	91.6	91.62	91.6	91.62	70800.0
2013-02-22	BIV	ETF	87.47	87.51	87.38	87.42	228100.0
2013-02-22	BIZD	ETF	20.19	20.24	20.13	20.24	5100.0
2013-02-22	BJK	ETF	37.83	38.08	37.75	38.08	10600.0
2013-02-22	BKF	ETF	40.03	40.07	39.802	40.04	194689.0
2013-02-22	BKLN	ETF	25.0	25.0	24.98	25.0	1167600.0
2013-02-22	BLV	ETF	91.29	91.63	91.29	91.38	35500.0
2013-02-22	BMVP	ETF	17.66	17.75	17.64	17.75	5082.0
2013-02-22	BND	ETF	83.4	83.42	83.36	83.4	829500.0
2013-02-22	BNO	ETF	42.905	42.935	42.665	42.87	60000.0
2013-02-22	BOIL	ETF	711600.0	726000.0	701200.0	719400.0	6.0
2013-02-22	BOND	ETF	109.39	109.45	109.36	109.44	469635.0

> showing 50 of 973 rows — these rows as CSV

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