PREVIEW / etf_daily / 2012-08-22

all etf daily files

  file:    by_date/etf_daily/2012/2012-08-22.parquet
  size:    39 KB
  rows:    946

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-22	SPY	ETF	141.4	142.05	141.07	141.82	133243500.0
2012-08-22	QQQ	ETF	67.99	68.5601	67.81	68.43	44555654.0
2012-08-22	IWM	ETF	81.27	81.5	80.79	81.09	37611400.0
2012-08-22	DIA	ETF	131.57	131.8	130.94	131.47	4496200.0
2012-08-22	GLD	ETF	159.19	160.63	158.51	160.54	13605900.0
2012-08-22	TLT	ETF	123.52	124.51	123.21	124.41	11384400.0
2012-08-22	AAXJ	ETF	53.99	54.28	53.82	54.2	242300.0
2012-08-22	ACTV	ETF	11.35	11.48	11.28	11.3	212211.0
2012-08-22	ACWI	ETF	45.74	46.06	45.67	45.99	108100.0
2012-08-22	ACWV	ETF	56.09	56.09	55.59	56.06	16700.0
2012-08-22	ACWX	ETF	38.6	38.92	38.53	38.87	87644.0
2012-08-22	ADRE	ETF	38.46	38.73	38.34	38.7	16784.0
2012-08-22	AFK	ETF	29.18	29.39	29.18	29.39	30494.0
2012-08-22	AGEM	ETF	21.71	22.0	21.63	21.98	4496.0
2012-08-22	AGG	ETF	111.6	111.82	111.51	111.82	405500.0
2012-08-22	AGQ	ETF	172.96	178.32	172.04	177.56	444925.0
2012-08-22	AGZ	ETF	113.5	113.6	113.38	113.6	18021.0
2012-08-22	AIA	ETF	42.5	42.766	42.46	42.74	8375.0
2012-08-22	AIQ	ETF	6.7	6.8	6.5	6.75	9026.0
2012-08-22	AIVI	ETF	39.67	40.06	39.63	39.99	63600.0
2012-08-22	AMJ	ETF	40.0	40.15	39.69	39.86	554116.0
2012-08-22	AMLP	ETF	81.6	81.75	81.2	81.4	344180.0
2012-08-22	ANGL	ETF	26.35	26.35	26.35	26.35	2000.0
2012-08-22	AOA	ETF	36.11	36.23	36.06	36.23	17300.0
2012-08-22	AOK	ETF	30.15	30.24	30.1289	30.2301	8439.0
2012-08-22	AOM	ETF	31.2	31.3097	31.1899	31.28	17478.0
2012-08-22	AOR	ETF	33.2	33.36	33.2	33.3422	6934.0
2012-08-22	ARB	ETF	36.58	36.58	36.14	36.3	65347.0
2012-08-22	ARGT	ETF	17.08	17.08	17.06	17.06	500.0
2012-08-22	ASEA	ETF	16.45	16.51	16.32	16.49	37500.0
2012-08-22	AWAY	ETF	24.78	25.19	24.53	24.91	743094.0
2012-08-22	BAB	ETF	29.92	29.92	29.8	29.88	480565.0
2012-08-22	BAL	ETF	49.94	50.7208	49.8	50.6435	13118.0
2012-08-22	BALT	ETF	3.11	3.11	3.02	3.02	40037.0
2012-08-22	BBH	ETF	49.97	50.41	49.72	50.27	55300.0
2012-08-22	BIB	ETF	13.5137	13.9817	13.5137	13.8925	8280.0
2012-08-22	BICK	ETF	23.25	23.3099	23.08	23.24	66422.0
2012-08-22	BIL	ETF	91.62	91.64	91.62	91.62	102850.0
2012-08-22	BIS	ETF	3004.8	3004.8	2916.8	2916.8	2.6
2012-08-22	BIV	ETF	89.04	89.35	89.0	89.33	211700.0
2012-08-22	BJK	ETF	32.17	32.52	32.12	32.41	9200.0
2012-08-22	BKF	ETF	36.63	37.0	36.573	36.92	150025.0
2012-08-22	BKLN	ETF	24.72	24.74	24.7	24.73	313200.0
2012-08-22	BLNG	ETF	49.06	49.06	49.06	49.06	1600.0
2012-08-22	BLV	ETF	95.45	95.85	95.11	95.85	85800.0
2012-08-22	BMVP	ETF	16.0167	16.0533	15.96	16.0533	1507.0
2012-08-22	BND	ETF	84.47	84.71	84.46	84.68	1242900.0
2012-08-22	BNO	ETF	41.035	41.465	41.035	41.405	131600.0
2012-08-22	BOIL	ETF	858000.0	879800.0	840000.0	878200.0	11.8
2012-08-22	BOND	ETF	106.98	107.18	106.9	107.17	363481.0

> showing 50 of 946 rows — these rows as CSV

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