PREVIEW / etf_daily / 2013-04-03

all etf daily files

  file:    by_date/etf_daily/2013/2013-04-03.parquet
  size:    40 KB
  rows:    977

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-04-03	SPY	ETF	156.91	157.03	154.82	155.23	154167400.0
2013-04-03	QQQ	ETF	69.08	69.18	68.24	68.41	35131104.0
2013-04-03	IWM	ETF	92.94	92.98	90.92	91.13	65441400.0
2013-04-03	DIA	ETF	146.24	146.47	144.95	145.14	7661100.0
2013-04-03	GLD	ETF	152.02	152.53	149.92	150.73	15740800.0
2013-04-03	TLT	ETF	118.31	119.29	118.25	118.97	9527400.0
2013-04-03	AAXJ	ETF	58.69	58.76	58.13	58.28	520200.0
2013-04-03	ACTV	ETF	4.08	4.14	4.03	4.1	322059.0
2013-04-03	ACWI	ETF	50.83	50.86	50.19	50.29	735000.0
2013-04-03	ACWV	ETF	62.07	62.07	61.51	61.65	66600.0
2013-04-03	ACWX	ETF	42.71	42.8	42.2648	42.32	134777.0
2013-04-03	ADRE	ETF	38.22	38.3	37.77	37.8	63957.0
2013-04-03	AFK	ETF	30.28	30.28	29.82	29.8701	16062.0
2013-04-03	AGEM	ETF	22.2343	22.259	22.2343	22.259	420.0
2013-04-03	AGG	ETF	110.54	110.69	110.49	110.57	1260300.0
2013-04-03	AGQ	ETF	139.12	140.08	133.92	136.44	452750.0
2013-04-03	AGZ	ETF	113.2701	113.43	113.2701	113.38	9229.0
2013-04-03	AIA	ETF	46.204	46.21	45.742	45.76	10885.0
2013-04-03	AIQ	ETF	7.99	8.11	7.98	8.07	10748.0
2013-04-03	AIVI	ETF	42.25	42.25	41.85	41.9	25300.0
2013-04-03	AMJ	ETF	45.86	45.86	44.27	44.92	2508404.0
2013-04-03	AMLP	ETF	88.6	88.6	86.95	87.4	553220.0
2013-04-03	ANGL	ETF	26.66	26.8	26.66	26.8	5700.0
2013-04-03	AOA	ETF	39.58	39.63	39.18	39.22	65400.0
2013-04-03	AOK	ETF	31.11	31.11	31.06	31.069	8716.0
2013-04-03	AOM	ETF	32.68	32.68	32.546	32.56	12192.0
2013-04-03	AOR	ETF	35.48	35.5546	35.266	35.27	31436.0
2013-04-03	ARB	ETF	46.88	46.97	46.86	46.95	434525.0
2013-04-03	ARGT	ETF	17.12	17.12	16.94	16.94	2000.0
2013-04-03	ASEA	ETF	17.73	17.73	17.55	17.58	29700.0
2013-04-03	ATMP	ETF	26.2	26.2	25.59	25.64	26200.0
2013-04-03	AVIV	ETF	23.99	24.29	23.4	24.08	419751.0
2013-04-03	AWAY	ETF	31.53	31.655	29.92	30.35	2005836.0
2013-04-03	BAB	ETF	30.25	30.45	30.25	30.41	320532.0
2013-04-03	BAL	ETF	57.92	57.92	57.49	57.71	22443.0
2013-04-03	BALT	ETF	3.76	3.76	3.62	3.67	41766.0
2013-04-03	BBH	ETF	66.2	66.2	64.15	64.63	70900.0
2013-04-03	BIB	ETF	20.345	20.345	19.2	19.485	208720.0
2013-04-03	BICK	ETF	23.72	23.72	23.45	23.45	4643.0
2013-04-03	BIL	ETF	91.62	91.62	91.6	91.6	143350.0
2013-04-03	BIS	ETF	1842.8	1941.6	1842.8	1922.0	89.0
2013-04-03	BIV	ETF	87.59	87.78	87.5	87.69	228600.0
2013-04-03	BIZD	ETF	20.09	20.09	19.75	19.84	27600.0
2013-04-03	BJK	ETF	39.91	39.91	39.27	39.33	7300.0
2013-04-03	BKF	ETF	38.17	38.32	37.85	37.93	244907.0
2013-04-03	BKLN	ETF	25.12	25.12	25.09	25.11	3561600.0
2013-04-03	BLV	ETF	91.62	92.0	91.45	91.89	45400.0
2013-04-03	BMVP	ETF	18.3966	18.3966	18.2355	18.2355	618.0
2013-04-03	BND	ETF	83.43	83.58	83.42	83.47	1293900.0
2013-04-03	BNO	ETF	41.585	41.615	40.44	40.525	103600.0

> showing 50 of 977 rows — these rows as CSV

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