PREVIEW / etf_daily / 2012-08-30

all etf daily files

  file:    by_date/etf_daily/2012/2012-08-30.parquet
  size:    38 KB
  rows:    938

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-30	SPY	ETF	140.9	140.94	140.19	140.49	96589900.0
2012-08-30	QQQ	ETF	68.11	68.13	67.6	67.71	24430939.0
2012-08-30	IWM	ETF	81.18	81.25	80.64	80.79	24562900.0
2012-08-30	DIA	ETF	130.38	130.39	129.65	129.92	4120700.0
2012-08-30	GLD	ETF	161.26	161.31	160.01	160.52	5813700.0
2012-08-30	TLT	ETF	126.27	126.44	125.73	125.94	3886400.0
2012-08-30	AADR	ETF	28.87	28.93	28.87	28.93	200.0
2012-08-30	AAXJ	ETF	52.82	52.87	52.58	52.64	738000.0
2012-08-30	ACTV	ETF	11.03	11.05	10.78	10.8	238743.0
2012-08-30	ACWI	ETF	45.41	45.42	45.08	45.15	196300.0
2012-08-30	ACWV	ETF	56.45	56.45	55.7	55.7	7700.0
2012-08-30	ACWX	ETF	38.05	38.06	37.674	37.72	151866.0
2012-08-30	ADRE	ETF	37.49	37.531	37.3302	37.45	18546.0
2012-08-30	AFK	ETF	29.54	29.54	29.17	29.2	5404.0
2012-08-30	AGEM	ETF	21.2904	21.2904	21.2904	21.2904	135.0
2012-08-30	AGG	ETF	112.02	112.14	112.02	112.02	436200.0
2012-08-30	AGQ	ETF	188.88	189.16	181.08	182.92	388200.0
2012-08-30	AGZ	ETF	113.7	113.83	113.69	113.82	8108.0
2012-08-30	AIA	ETF	41.77	41.82	41.62	41.66	5127.0
2012-08-30	AIQ	ETF	6.4	7.0	6.4	6.7	11743.0
2012-08-30	AIVI	ETF	39.59	39.59	39.13	39.19	14200.0
2012-08-30	AMJ	ETF	39.32	39.55	39.25	39.46	446878.0
2012-08-30	AMLP	ETF	81.35	81.6	81.3	81.4	281940.0
2012-08-30	ANGL	ETF	26.64	26.64	26.45	26.6	1600.0
2012-08-30	AOA	ETF	35.98	35.98	35.83	35.86	4400.0
2012-08-30	AOK	ETF	30.2	30.23	30.17	30.18	16617.0
2012-08-30	AOM	ETF	31.18	31.2296	31.156	31.1648	6985.0
2012-08-30	AOR	ETF	33.22	33.22	33.11	33.1783	11883.0
2012-08-30	ARB	ETF	35.41	36.0	35.06	35.64	72575.0
2012-08-30	ARGT	ETF	16.72	16.72	16.64	16.7	400.0
2012-08-30	ASEA	ETF	15.99	16.06	15.98	15.98	11200.0
2012-08-30	AWAY	ETF	23.33	23.7	23.33	23.6	336818.0
2012-08-30	BAB	ETF	30.33	30.33	30.2317	30.26	156383.0
2012-08-30	BAL	ETF	50.9	51.1	50.25	50.77	7021.0
2012-08-30	BALT	ETF	3.06	3.14	3.05	3.14	21674.0
2012-08-30	BBH	ETF	50.53	50.67	50.29	50.58	22000.0
2012-08-30	BCM	ETF	45.47	45.62	45.47	45.62	778.0
2012-08-30	BIB	ETF	14.1	14.25	14.0337	14.25	18728.0
2012-08-30	BICK	ETF	22.16	22.279	22.044	22.2199	6615.0
2012-08-30	BIL	ETF	91.64	91.64	91.62	91.62	137300.0
2012-08-30	BIS	ETF	2848.0	2866.96	2848.0	2851.2	13.45
2012-08-30	BIV	ETF	89.7	89.77	89.61	89.69	224500.0
2012-08-30	BJK	ETF	32.06	32.06	31.69	31.74	14400.0
2012-08-30	BKF	ETF	35.56	35.63	35.38	35.46	139409.0
2012-08-30	BKLN	ETF	24.77	24.81	24.76	24.81	1171800.0
2012-08-30	BLV	ETF	96.73	96.92	96.64	96.71	22800.0
2012-08-30	BMVP	ETF	15.9333	15.9333	15.8633	15.9192	5686.0
2012-08-30	BND	ETF	84.9	84.94	84.85	84.88	573200.0
2012-08-30	BNO	ETF	40.68	40.73	40.425	40.61	48600.0
2012-08-30	BOIL	ETF	780200.0	810200.0	748200.0	804000.0	13.8

> showing 50 of 938 rows — these rows as CSV

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