PREVIEW / etf_daily / 2012-10-05

all etf daily files

  file:    by_date/etf_daily/2012/2012-10-05.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-10-05	SPY	ETF	146.91	147.16	145.7	146.14	124842100.0
2012-10-05	QQQ	ETF	69.68	69.8	68.8	68.98	25207826.0
2012-10-05	IWM	ETF	84.58	85.25	83.84	84.11	40981400.0
2012-10-05	DIA	ETF	136.09	136.44	135.48	135.96	4560300.0
2012-10-05	GLD	ETF	172.87	173.37	172.01	172.62	8871000.0
2012-10-05	TLT	ETF	121.57	121.68	120.92	121.15	8340700.0
2012-10-05	AAXJ	ETF	57.55	57.71	57.13	57.27	339600.0
2012-10-05	ACTV	ETF	11.6	11.6	11.36	11.38	497183.0
2012-10-05	ACWI	ETF	47.82	47.87	47.4	47.51	1013200.0
2012-10-05	ACWV	ETF	57.48	57.89	57.37	57.44	92600.0
2012-10-05	ACWX	ETF	40.45	40.6	40.18	40.25	456355.0
2012-10-05	ADRE	ETF	39.68	39.88	39.41	39.45	20701.0
2012-10-05	AFK	ETF	31.42	31.6399	31.178	31.26	28699.0
2012-10-05	AGEM	ETF	22.57	22.6615	22.57	22.6615	2117.0
2012-10-05	AGG	ETF	111.94	111.99	111.84	111.86	580200.0
2012-10-05	AGQ	ETF	237.08	238.56	230.0	232.76	330125.0
2012-10-05	AGZ	ETF	113.83	113.88	113.7511	113.87	27222.0
2012-10-05	AIA	ETF	45.25	45.6	45.1668	45.24	54656.0
2012-10-05	AIQ	ETF	6.8015	7.15	6.8	7.15	22875.0
2012-10-05	AIVI	ETF	41.05	41.14	40.6	40.72	15100.0
2012-10-05	AMJ	ETF	41.3	41.53	41.18	41.335	378964.0
2012-10-05	AMLP	ETF	83.75	84.35	83.75	84.1	382080.0
2012-10-05	ANGL	ETF	26.45	26.45	26.37	26.42	900.0
2012-10-05	AOA	ETF	37.23	37.27	37.03	37.03	3600.0
2012-10-05	AOK	ETF	30.68	30.68	30.57	30.59	3409.0
2012-10-05	AOM	ETF	31.86	31.8864	31.738	31.77	22455.0
2012-10-05	AOR	ETF	34.1199	34.12	33.9332	33.97	12729.0
2012-10-05	ARB	ETF	37.01	38.31	37.01	37.56	143718.0
2012-10-05	ARGT	ETF	18.18	18.4	18.18	18.32	6200.0
2012-10-05	ASEA	ETF	17.18	17.18	16.95	16.95	10700.0
2012-10-05	AWAY	ETF	26.28	26.79	25.99	26.14	504139.0
2012-10-05	BAB	ETF	29.93	29.94	29.81	29.82	210064.0
2012-10-05	BAL	ETF	47.17	47.2701	46.9017	47.1	3050.0
2012-10-05	BALT	ETF	3.1599	3.2	3.07	3.12	27365.0
2012-10-05	BBH	ETF	56.24	56.66	55.98	56.17	23200.0
2012-10-05	BCM	ETF	46.13	46.13	45.9	45.9	1331.0
2012-10-05	BIB	ETF	17.3975	17.3975	16.715	16.845	178112.0
2012-10-05	BICK	ETF	24.19	24.299	24.12	24.13	2471.0
2012-10-05	BIL	ETF	91.64	91.64	91.62	91.62	541650.0
2012-10-05	BIS	ETF	2360.0	2360.0	2360.0	2360.0	6.25
2012-10-05	BIV	ETF	90.03	90.08	89.87	89.9	269400.0
2012-10-05	BJK	ETF	34.2	34.37	34.07	34.09	5300.0
2012-10-05	BKF	ETF	38.65	38.76	38.26	38.39	54109.0
2012-10-05	BKLN	ETF	24.96	24.98	24.96	24.98	821000.0
2012-10-05	BLV	ETF	95.61	95.72	95.3	95.33	32400.0
2012-10-05	BMVP	ETF	16.47	16.47	16.29	16.29	3135.0
2012-10-05	BND	ETF	84.82	84.82	84.73	84.78	665100.0
2012-10-05	BNO	ETF	40.56	40.56	39.93	40.37	82600.0
2012-10-05	BOIL	ETF	1064400.0	1079200.0	1029200.0	1060400.0	12.0
2012-10-05	BOND	ETF	108.99	108.99	108.89	108.96	635591.0

> showing 50 of 946 rows — these rows as CSV

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