PREVIEW / etf_daily / 2012-08-28

all etf daily files

  file:    by_date/etf_daily/2012/2012-08-28.parquet
  size:    38 KB
  rows:    930

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
2012-08-28	SPY	ETF	141.18	141.84	140.97	141.4	75689600.0
2012-08-28	QQQ	ETF	68.34	68.585	68.11	68.4	27337854.0
2012-08-28	IWM	ETF	80.97	81.51	80.75	81.35	28505600.0
2012-08-28	DIA	ETF	130.75	131.3	130.6	130.86	3028000.0
2012-08-28	GLD	ETF	161.63	162.19	161.3	161.64	5074200.0
2012-08-28	TLT	ETF	125.75	126.36	125.59	125.84	3412600.0
2012-08-28	AADR	ETF	29.25	29.25	29.25	29.25	100.0
2012-08-28	AAXJ	ETF	53.33	53.44	53.15	53.28	170800.0
2012-08-28	ACTV	ETF	11.09	11.14	10.99	11.01	260621.0
2012-08-28	ACWI	ETF	45.5	45.78	45.5	45.69	445000.0
2012-08-28	ACWV	ETF	56.23	56.23	55.87	55.95	7300.0
2012-08-28	ACWX	ETF	38.35	38.44	38.25	38.32	211775.0
2012-08-28	ADRE	ETF	38.02	38.18	37.97	38.05	22040.0
2012-08-28	AFK	ETF	29.4	29.56	29.36	29.52	21278.0
2012-08-28	AGEM	ETF	21.4801	21.5707	21.48	21.5	2400.0
2012-08-28	AGG	ETF	112.04	112.11	111.98	112.06	699200.0
2012-08-28	AGQ	ETF	189.24	190.2	187.0	189.4	280550.0
2012-08-28	AGZ	ETF	113.6	113.722	113.6	113.62	8991.0
2012-08-28	AIA	ETF	42.07	42.14	41.901	42.02	17198.0
2012-08-28	AIQ	ETF	6.5	6.9	6.4005	6.6	6280.0
2012-08-28	AIVI	ETF	39.71	39.83	39.66	39.76	27900.0
2012-08-28	AMJ	ETF	39.06	39.48	39.06	39.4	385922.0
2012-08-28	AMLP	ETF	81.1	81.45	81.0	81.45	382180.0
2012-08-28	ANGL	ETF	26.69	26.69	26.65	26.65	1000.0
2012-08-28	AOA	ETF	36.13	36.19	36.08	36.15	5900.0
2012-08-28	AOK	ETF	30.26	30.3	30.26	30.3	12167.0
2012-08-28	AOM	ETF	31.29	31.34	31.2701	31.31	42201.0
2012-08-28	AOR	ETF	33.27	33.345	33.2689	33.292	14468.0
2012-08-28	ARB	ETF	35.65	36.46	35.44	36.3	112852.0
2012-08-28	ARGT	ETF	16.96	17.0	16.96	17.0	1250.0
2012-08-28	ASEA	ETF	16.31	16.34	16.25	16.3	5800.0
2012-08-28	AWAY	ETF	23.92	24.1	23.7	23.79	180043.0
2012-08-28	BAB	ETF	30.24	30.32	30.17	30.26	149954.0
2012-08-28	BAL	ETF	49.7	50.26	49.59	50.202	62451.0
2012-08-28	BALT	ETF	3.03	3.14	3.03	3.06	39885.0
2012-08-28	BBH	ETF	50.85	51.0	50.75	50.83	7800.0
2012-08-28	BCM	ETF	45.53	45.5708	45.53	45.5708	800.0
2012-08-28	BIB	ETF	14.25	14.3786	14.25	14.3786	4000.0
2012-08-28	BICK	ETF	22.62	22.73	22.5901	22.68	6673.0
2012-08-28	BIL	ETF	91.62	91.64	91.62	91.62	99500.0
2012-08-28	BIS	ETF	2836.8	2836.8	2836.64	2836.64	2.5
2012-08-28	BIV	ETF	89.55	89.66	89.48	89.56	180600.0
2012-08-28	BJK	ETF	31.97	32.28	31.96	32.16	28500.0
2012-08-28	BKF	ETF	36.14	36.25	36.06	36.13	82217.0
2012-08-28	BKLN	ETF	24.74	24.77	24.72	24.75	585500.0
2012-08-28	BLV	ETF	96.55	96.92	96.52	96.71	39600.0
2012-08-28	BMVP	ETF	15.9733	16.0001	15.9267	15.9767	5921.0
2012-08-28	BND	ETF	84.85	84.92	84.82	84.88	1081700.0
2012-08-28	BNO	ETF	40.375	40.59	40.37	40.55	32800.0
2012-08-28	BOIL	ETF	769800.0	776200.0	741000.0	742800.0	14.4

> showing 50 of 930 rows — these rows as CSV

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