PREVIEW / etf_daily / 2012-04-25

all etf daily files

  file:    by_date/etf_daily/2012/2012-04-25.parquet
  size:    38 KB
  rows:    924

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-04-25	SPY	ETF	138.65	139.25	138.53	139.19	150252200.0
2012-04-25	QQQ	ETF	66.06	66.49	65.97	66.45	57526761.0
2012-04-25	IWM	ETF	80.75	81.37	80.53	80.94	50263300.0
2012-04-25	DIA	ETF	130.5	130.83	130.11	130.64	7342000.0
2012-04-25	GLD	ETF	159.48	159.96	157.76	159.62	15093700.0
2012-04-25	TLT	ETF	116.41	117.32	115.69	116.49	8859500.0
2012-04-25	AADR	ETF	30.27	30.3	30.25	30.3	1700.0
2012-04-25	AAXJ	ETF	55.7	55.94	55.58	55.92	113100.0
2012-04-25	ACTV	ETF	16.74	17.0	16.73	16.93	413021.0
2012-04-25	ACWI	ETF	46.33	46.46	46.22	46.44	579700.0
2012-04-25	ACWV	ETF	54.0	54.22	54.0	54.17	18100.0
2012-04-25	ACWX	ETF	39.91	39.99	39.73	39.92	176959.0
2012-04-25	ADRE	ETF	40.88	40.92	40.628	40.8181	97841.0
2012-04-25	AFK	ETF	29.38	29.52	29.33	29.5	13458.0
2012-04-25	AGEM	ETF	22.5	22.77	22.42	22.77	5007.0
2012-04-25	AGG	ETF	110.41	110.5	110.24	110.48	982300.0
2012-04-25	AGQ	ETF	197.6	197.8	186.0	195.88	665650.0
2012-04-25	AGZ	ETF	112.79	112.86	112.706	112.86	11405.0
2012-04-25	AIA	ETF	44.42	44.53	44.2901	44.53	13432.0
2012-04-25	AIQ	ETF	6.7	6.95	6.6	6.75	6608.0
2012-04-25	AIS	ETF	2.99	3.1	2.95	3.1	879675.0
2012-04-25	AIVI	ETF	40.44	40.55	40.29	40.49	28700.0
2012-04-25	AMJ	ETF	39.68	39.73	39.24	39.31	1719813.0
2012-04-25	AMLP	ETF	83.65	83.75	83.0	83.05	438320.0
2012-04-25	ANGL	ETF	25.13	25.55	25.13	25.55	500.0
2012-04-25	AOA	ETF	35.94	36.04	35.9	36.04	7200.0
2012-04-25	AOK	ETF	30.03	30.1059	30.0101	30.1	25055.0
2012-04-25	AOM	ETF	31.08	31.15	31.052	31.132	24736.0
2012-04-25	AOR	ETF	33.06	33.14	32.98	33.0924	12611.0
2012-04-25	ARB	ETF	38.67	39.01	38.32	38.48	173656.0
2012-04-25	ARGT	ETF	18.5	18.5	18.5	18.5	200.0
2012-04-25	ASEA	ETF	16.12	16.12	16.0	16.02	8200.0
2012-04-25	AWAY	ETF	25.73	26.33	24.45	25.12	692309.0
2012-04-25	BAB	ETF	29.47	29.5	29.311	29.44	130856.0
2012-04-25	BAL	ETF	57.29	57.29	56.4001	56.76	67760.0
2012-04-25	BALT	ETF	4.58	4.64	4.53	4.62	107885.0
2012-04-25	BBH	ETF	45.21	45.6	45.06	45.57	14000.0
2012-04-25	BCM	ETF	44.41	44.41	44.35	44.35	5000.0
2012-04-25	BIB	ETF	11.875	12.0862	11.8375	12.075	36760.0
2012-04-25	BICK	ETF	25.3	25.36	25.254	25.28	6163.0
2012-04-25	BIL	ETF	91.64	91.66	91.64	91.64	415800.0
2012-04-25	BIS	ETF	3665.6	3665.6	3584.0	3584.0	34.4
2012-04-25	BIV	ETF	87.64	87.68	87.38	87.59	351000.0
2012-04-25	BJK	ETF	36.37	36.72	36.33	36.69	24800.0
2012-04-25	BKF	ETF	40.07	40.072	39.69	39.93	116887.0
2012-04-25	BKLN	ETF	24.43	24.53	24.42	24.51	213400.0
2012-04-25	BLNG	ETF	49.31	51.58	49.31	49.57	2808.0
2012-04-25	BLV	ETF	90.79	91.2	90.41	90.8	34900.0
2012-04-25	BMVP	ETF	15.27	15.49	15.27	15.46	3786.0
2012-04-25	BND	ETF	83.7	83.76	83.57	83.71	905200.0

> showing 50 of 924 rows — these rows as CSV

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