PREVIEW / etf_daily / 2012-10-25

all etf daily files

  file:    by_date/etf_daily/2012/2012-10-25.parquet
  size:    39 KB
  rows:    948

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-10-25	SPY	ETF	142.02	142.28	140.57	141.43	134457400.0
2012-10-25	QQQ	ETF	65.61	65.72	64.97	65.16	52688680.0
2012-10-25	IWM	ETF	81.88	82.14	80.87	81.53	27794000.0
2012-10-25	DIA	ETF	131.19	131.35	130.09	130.78	6313100.0
2012-10-25	GLD	ETF	166.29	166.53	165.77	166.02	7013800.0
2012-10-25	TLT	ETF	120.56	121.54	120.33	120.86	5292500.0
2012-10-25	AADR	ETF	29.54	31.0	29.54	29.75	4700.0
2012-10-25	AAXJ	ETF	56.9	57.03	56.58	56.9	495700.0
2012-10-25	ACTV	ETF	9.27	9.28	8.97	9.21	908800.0
2012-10-25	ACWI	ETF	46.84	46.96	46.42	46.68	305900.0
2012-10-25	ACWV	ETF	56.33	56.45	56.22	56.35	10400.0
2012-10-25	ACWX	ETF	39.95	39.997	39.58	39.76	83380.0
2012-10-25	ADRE	ETF	39.44	39.5	39.1717	39.29	12182.0
2012-10-25	AFK	ETF	31.64	31.82	31.39	31.404	20049.0
2012-10-25	AGEM	ETF	22.57	22.57	22.57	22.57	185.0
2012-10-25	AGG	ETF	111.78	111.95	111.71	111.73	970700.0
2012-10-25	AGQ	ETF	201.2	202.48	199.04	201.08	237300.0
2012-10-25	AGZ	ETF	113.52	113.53	113.38	113.38	13351.0
2012-10-25	AIA	ETF	45.13	45.22	44.962	45.09	24119.0
2012-10-25	AIQ	ETF	6.95	6.95	6.65	6.75	29121.0
2012-10-25	AIVI	ETF	40.34	40.39	40.03	40.08	12300.0
2012-10-25	AMJ	ETF	41.04	41.09	40.84	40.91	730150.0
2012-10-25	AMLP	ETF	83.8	83.85	83.35	83.5	256420.0
2012-10-25	ANGL	ETF	26.94	26.94	26.94	26.94	300.0
2012-10-25	AOA	ETF	36.46	36.46	36.2	36.31	5700.0
2012-10-25	AOK	ETF	30.33	30.4252	30.33	30.35	14137.0
2012-10-25	AOM	ETF	31.43	31.484	31.3408	31.41	10465.0
2012-10-25	AOR	ETF	33.47	33.56	33.39	33.41	6024.0
2012-10-25	ARB	ETF	36.73	36.73	35.81	36.29	78975.0
2012-10-25	ARGT	ETF	16.9	16.92	16.9	16.92	1750.0
2012-10-25	ASEA	ETF	16.83	16.85	16.69	16.76	10300.0
2012-10-25	AWAY	ETF	26.04	26.04	24.94	25.13	179813.0
2012-10-25	BAB	ETF	29.87	29.96	29.77	29.92	236533.0
2012-10-25	BAL	ETF	47.93	48.16	47.56	48.07	3200.0
2012-10-25	BALT	ETF	3.52	3.52	3.401	3.42	56920.0
2012-10-25	BBH	ETF	52.76	53.09	52.36	52.48	13100.0
2012-10-25	BCM	ETF	44.52	44.52	44.4924	44.51	765.0
2012-10-25	BIB	ETF	14.185	14.7496	14.185	14.42	24244.0
2012-10-25	BICK	ETF	23.81	23.92	23.75	23.795	3207.0
2012-10-25	BIL	ETF	91.62	91.64	91.62	91.62	223350.0
2012-10-25	BIS	ETF	2738.4	2758.4	2703.2	2749.904	79.0
2012-10-25	BIV	ETF	89.65	89.84	89.56	89.7	171800.0
2012-10-25	BJK	ETF	34.85	34.93	34.61	34.85	4900.0
2012-10-25	BKF	ETF	38.77	38.88	38.52	38.68	54665.0
2012-10-25	BKLN	ETF	24.88	24.88	24.87	24.88	463800.0
2012-10-25	BLV	ETF	95.4	95.84	95.19	95.4	56000.0
2012-10-25	BMVP	ETF	15.8933	15.8933	15.7202	15.7933	10381.0
2012-10-25	BND	ETF	84.53	84.64	84.5	84.57	650900.0
2012-10-25	BNO	ETF	39.625	39.625	39.225	39.47	49800.0
2012-10-25	BOIL	ETF	1093400.0	1121400.0	1062200.0	1097000.0	9.0

> showing 50 of 948 rows — these rows as CSV

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