PREVIEW / etf_daily / 2013-02-12

all etf daily files

  file:    by_date/etf_daily/2013/2013-02-12.parquet
  size:    40 KB
  rows:    970

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-12	SPY	ETF	151.78	152.3	151.61	152.02	65392700.0
2013-02-12	QQQ	ETF	67.92	68.05	67.66	67.73	22061318.0
2013-02-12	IWM	ETF	90.74	91.24	90.68	91.1	19792700.0
2013-02-12	DIA	ETF	139.59	140.21	139.51	140.05	3498600.0
2013-02-12	GLD	ETF	159.35	160.05	158.88	159.89	7632300.0
2013-02-12	TLT	ETF	116.69	117.02	116.46	116.74	4513700.0
2013-02-12	AADR	ETF	33.41	33.41	33.4	33.41	1100.0
2013-02-12	AAXJ	ETF	60.24	60.5	60.01	60.3	518600.0
2013-02-12	ACTV	ETF	5.62	5.62	5.12	5.34	3637766.0
2013-02-12	ACWI	ETF	50.0	50.29	49.99	50.17	914100.0
2013-02-12	ACWV	ETF	58.13	58.54	58.13	58.39	23200.0
2013-02-12	ACWX	ETF	42.85	43.12	42.82	43.02	197981.0
2013-02-12	ADRE	ETF	40.05	40.266	39.946	40.18	13740.0
2013-02-12	AFK	ETF	31.5	31.74	31.35	31.6	52624.0
2013-02-12	AGEM	ETF	23.49	23.5799	23.49	23.5345	1157.0
2013-02-12	AGG	ETF	110.1	110.18	110.08	110.15	666800.0
2013-02-12	AGQ	ETF	179.96	183.76	178.76	183.36	219725.0
2013-02-12	AGZ	ETF	112.97	113.08	112.94	112.94	16599.0
2013-02-12	AIA	ETF	47.27	47.4599	47.1	47.3	8571.0
2013-02-12	AIQ	ETF	6.94	7.43	6.94	7.43	9415.0
2013-02-12	AIVI	ETF	42.46	42.76	42.38	42.66	114200.0
2013-02-12	AMJ	ETF	43.44	43.5	43.18	43.48	1369737.0
2013-02-12	AMLP	ETF	85.45	85.6	85.15	85.55	501700.0
2013-02-12	ANGL	ETF	26.84	26.84	26.75	26.75	600.0
2013-02-12	AOA	ETF	38.97	39.03	38.82	38.98	12100.0
2013-02-12	AOK	ETF	30.9	30.95	30.86	30.94	25462.0
2013-02-12	AOM	ETF	32.3384	32.41	32.3384	32.39	12122.0
2013-02-12	AOR	ETF	35.04	35.11	35.0101	35.11	16552.0
2013-02-12	ARB	ETF	47.0	47.09	46.99	47.05	339596.0
2013-02-12	ARGT	ETF	17.58	17.78	17.58	17.7	600.0
2013-02-12	ASEA	ETF	17.03	17.15	17.01	17.14	4700.0
2013-02-12	AWAY	ETF	24.35	24.83	24.33	24.83	358314.0
2013-02-12	BAB	ETF	30.16	30.22	30.15	30.17	234370.0
2013-02-12	BAL	ETF	54.01	54.02	53.4601	53.52	20578.0
2013-02-12	BALT	ETF	3.09	3.22	3.09	3.22	25523.0
2013-02-12	BBH	ETF	57.89	57.89	57.44	57.47	14400.0
2013-02-12	BCM	ETF	44.7525	44.85	44.7525	44.85	10656.0
2013-02-12	BIB	ETF	16.3025	16.3652	16.1975	16.205	49084.0
2013-02-12	BICK	ETF	25.181	25.37	25.181	25.3695	4708.0
2013-02-12	BIL	ETF	91.62	91.62	91.6	91.62	195600.0
2013-02-12	BIS	ETF	2322.4	2338.8	2308.0	2338.4	140.0
2013-02-12	BIV	ETF	87.21	87.32	87.21	87.25	227200.0
2013-02-12	BIZD	ETF	20.17	20.17	20.17	20.17	300.0
2013-02-12	BJK	ETF	38.85	39.11	38.82	38.97	9600.0
2013-02-12	BKF	ETF	41.05	41.27	40.93	41.1	41243.0
2013-02-12	BKLN	ETF	24.99	25.02	24.99	25.02	5071400.0
2013-02-12	BLNG	ETF	49.418	49.418	49.418	49.418	100.0
2013-02-12	BLV	ETF	91.0	91.22	90.94	91.11	29900.0
2013-02-12	BMVP	ETF	17.9133	17.9294	17.89	17.89	7467.0
2013-02-12	BND	ETF	83.31	83.33	83.24	83.31	1120300.0

> showing 50 of 970 rows — these rows as CSV

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