PREVIEW / etf_daily / 2012-03-20

all etf daily files

  file:    by_date/etf_daily/2012/2012-03-20.parquet
  size:    38 KB
  rows:    933

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-03-20	SPY	ETF	140.05	140.61	139.64	140.44	121729700.0
2012-03-20	QQQ	ETF	66.66	67.185	66.46	67.11	47290547.0
2012-03-20	IWM	ETF	83.12	83.3	82.58	82.95	43829100.0
2012-03-20	DIA	ETF	131.36	131.7	130.92	131.38	5403700.0
2012-03-20	GLD	ETF	160.2	161.08	159.77	160.13	11643700.0
2012-03-20	TLT	ETF	110.43	110.87	109.85	110.54	9443800.0
2012-03-20	AADR	ETF	30.76	30.76	30.76	30.76	500.0
2012-03-20	AAXJ	ETF	56.71	56.79	56.43	56.7	351400.0
2012-03-20	ACTV	ETF	16.71	16.84	16.53	16.75	93720.0
2012-03-20	ACWI	ETF	47.19	47.36	47.0	47.33	394700.0
2012-03-20	ACWV	ETF	53.46	53.7	53.46	53.7	3100.0
2012-03-20	ACWX	ETF	41.06	41.14	40.85	41.11	118663.0
2012-03-20	ADRE	ETF	42.42	42.5	42.16	42.48	91443.0
2012-03-20	AFK	ETF	29.77	29.81	29.28	29.81	15978.0
2012-03-20	AGEM	ETF	23.53	23.53	23.3299	23.36	11514.0
2012-03-20	AGG	ETF	108.92	109.09	108.84	109.09	960400.0
2012-03-20	AGQ	ETF	218.48	221.08	211.32	215.44	596500.0
2012-03-20	AGZ	ETF	111.99	112.27	111.9516	112.01	27282.0
2012-03-20	AIA	ETF	44.5538	44.5538	44.32	44.47	9454.0
2012-03-20	AIQ	ETF	8.45	8.55	8.0	8.0	17098.0
2012-03-20	AIS	ETF	2.96	3.17	2.95	3.13	2403567.0
2012-03-20	AIVI	ETF	42.07	42.29	41.97	42.25	89400.0
2012-03-20	AMJ	ETF	39.92	40.14	39.8029	40.1	1853967.0
2012-03-20	AMLP	ETF	84.1	84.4	83.65	84.35	419760.0
2012-03-20	AOA	ETF	36.45	36.53	36.39	36.5	6000.0
2012-03-20	AOK	ETF	30.0482	30.09	30.03	30.08	274591.0
2012-03-20	AOM	ETF	31.21	31.23	31.1825	31.23	18096.0
2012-03-20	AOR	ETF	33.27	33.36	33.21	33.34	18908.0
2012-03-20	ARB	ETF	35.58	35.81	35.14	35.47	151660.0
2012-03-20	ARGT	ETF	22.04	22.04	21.86	21.86	550.0
2012-03-20	ASEA	ETF	15.97	15.97	15.82	15.93	4400.0
2012-03-20	AWAY	ETF	25.56	25.56	25.02	25.15	255488.0
2012-03-20	BAB	ETF	28.61	28.6881	28.47	28.57	207465.0
2012-03-20	BAL	ETF	53.57	53.9728	53.119	53.38	51487.0
2012-03-20	BALT	ETF	4.1	4.13	4.0	4.0	53467.0
2012-03-20	BBH	ETF	43.1	43.1	42.77	42.84	6500.0
2012-03-20	BCM	ETF	45.88	45.88	45.7835	45.7835	2436.0
2012-03-20	BIB	ETF	11.4787	11.5587	11.4288	11.4887	42600.0
2012-03-20	BICK	ETF	26.94	26.94	26.621	26.816	23094.0
2012-03-20	BIL	ETF	91.64	91.66	91.64	91.66	117250.0
2012-03-20	BIS	ETF	3836.8	3844.16	3830.4	3830.4	16.9
2012-03-20	BIV	ETF	86.35	86.38	85.9	86.02	226300.0
2012-03-20	BJK	ETF	35.86	35.86	35.45	35.65	24100.0
2012-03-20	BKF	ETF	41.75	41.8169	41.5	41.68	674593.0
2012-03-20	BKLN	ETF	24.48	24.54	24.46	24.52	590400.0
2012-03-20	BLNG	ETF	50.41	50.6501	50.41	50.6501	1100.0
2012-03-20	BLV	ETF	87.47	87.83	87.23	87.62	47900.0
2012-03-20	BMVP	ETF	15.45	15.45	15.37	15.39	5801.0
2012-03-20	BND	ETF	82.7	82.73	82.59	82.65	971200.0
2012-03-20	BNO	ETF	43.43	43.785	43.29	43.62	63200.0

> showing 50 of 933 rows — these rows as CSV

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