PREVIEW / etf_daily / 2013-02-05

all etf daily files

  file:    by_date/etf_daily/2013/2013-02-05.parquet
  size:    40 KB
  rows:    969

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-05	SPY	ETF	150.35	151.48	150.29	151.05	113912400.0
2013-02-05	QQQ	ETF	66.76	67.67	66.61	67.46	35129982.0
2013-02-05	IWM	ETF	89.71	90.38	89.59	90.08	26551000.0
2013-02-05	DIA	ETF	139.24	139.85	139.21	139.39	5819800.0
2013-02-05	GLD	ETF	162.75	162.79	161.33	161.96	8979400.0
2013-02-05	TLT	ETF	116.27	116.43	115.86	115.98	6676500.0
2013-02-05	AADR	ETF	33.51	33.51	33.51	33.51	100.0
2013-02-05	AAXJ	ETF	60.22	60.23	59.99	60.05	606800.0
2013-02-05	ACTV	ETF	5.59	5.59	5.385	5.51	977671.0
2013-02-05	ACWI	ETF	49.81	50.1	49.8	49.96	1055100.0
2013-02-05	ACWV	ETF	58.1	58.34	58.03	58.11	106500.0
2013-02-05	ACWX	ETF	42.87	43.089	42.8613	42.95	200357.0
2013-02-05	ADRE	ETF	40.67	40.67	40.372	40.46	104562.0
2013-02-05	AFK	ETF	31.64	31.9	31.632	31.85	24514.0
2013-02-05	AGEM	ETF	23.7	23.72	23.6575	23.6575	2630.0
2013-02-05	AGG	ETF	110.04	110.11	110.02	110.02	1905900.0
2013-02-05	AGQ	ETF	193.4	193.88	189.44	192.0	226850.0
2013-02-05	AGZ	ETF	112.93	113.003	112.8101	112.86	8782.0
2013-02-05	AIA	ETF	46.87	46.9999	46.79	46.92	43465.0
2013-02-05	AIQ	ETF	6.68	6.69	6.582	6.68	22631.0
2013-02-05	AIVI	ETF	42.65	42.86	42.59	42.66	45200.0
2013-02-05	AMJ	ETF	43.48	43.53	42.82	42.98	1938129.0
2013-02-05	AMLP	ETF	86.65	86.75	85.8	86.35	763040.0
2013-02-05	ANGL	ETF	26.8	26.86	26.8	26.85	600.0
2013-02-05	AOA	ETF	38.7	38.85	38.69	38.78	14800.0
2013-02-05	AOK	ETF	30.83	30.9	30.83	30.88	30204.0
2013-02-05	AOM	ETF	32.28	32.35	32.24	32.34	87810.0
2013-02-05	AOR	ETF	34.92	35.01	34.908	34.97	32888.0
2013-02-05	ARB	ETF	47.0	47.16	46.92	47.05	806726.0
2013-02-05	ARGT	ETF	18.28	18.32	18.28	18.32	450.0
2013-02-05	ASEA	ETF	17.01	17.21	17.01	17.11	54600.0
2013-02-05	AWAY	ETF	23.75	24.12	23.55	23.9	247693.0
2013-02-05	BAB	ETF	30.12	30.122	30.02	30.05	195123.0
2013-02-05	BAL	ETF	53.11	53.6	52.8	53.57	70469.0
2013-02-05	BALT	ETF	3.15	3.1895	3.11	3.17	60999.0
2013-02-05	BBH	ETF	58.06	58.37	57.93	58.28	60500.0
2013-02-05	BCM	ETF	45.27	45.27	45.27	45.27	28815.0
2013-02-05	BIB	ETF	16.5	16.671	16.4275	16.625	53208.0
2013-02-05	BICK	ETF	25.44	25.44	25.395	25.4133	2977.0
2013-02-05	BIL	ETF	91.6	91.62	91.6	91.62	165500.0
2013-02-05	BIV	ETF	87.13	87.15	87.01	87.03	246100.0
2013-02-05	BJK	ETF	38.9	39.15	38.9	39.0	4300.0
2013-02-05	BKF	ETF	41.77	41.77	41.46	41.52	345544.0
2013-02-05	BKLN	ETF	25.08	25.1	25.08	25.09	3268800.0
2013-02-05	BLV	ETF	90.4	90.58	90.34	90.51	103100.0
2013-02-05	BMVP	ETF	17.6967	17.7933	17.6967	17.79	18686.0
2013-02-05	BND	ETF	83.26	83.29	83.17	83.2	2385600.0
2013-02-05	BNO	ETF	43.45	43.625	43.36	43.41	111000.0
2013-02-05	BOIL	ETF	760200.0	798800.0	751400.0	792400.0	12.4
2013-02-05	BOND	ETF	109.1	109.17	109.02	109.17	562850.0

> showing 50 of 969 rows — these rows as CSV

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