PREVIEW / etf_daily / 2012-02-23

all etf daily files

  file:    by_date/etf_daily/2012/2012-02-23.parquet
  size:    38 KB
  rows:    910

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-02-23	SPY	ETF	135.96	136.73	135.5	136.63	137704300.0
2012-02-23	QQQ	ETF	63.4	63.81	63.09	63.74	54249254.0
2012-02-23	IWM	ETF	81.71	82.85	81.26	82.8	53177500.0
2012-02-23	DIA	ETF	128.99	129.69	128.55	129.58	12890500.0
2012-02-23	GLD	ETF	172.69	173.77	172.28	173.02	11654200.0
2012-02-23	TLT	ETF	116.14	117.22	115.93	116.74	5163900.0
2012-02-23	AAXJ	ETF	57.52	57.6	57.22	57.49	320300.0
2012-02-23	ACTV	ETF	15.7101	15.74	15.441	15.49	137034.0
2012-02-23	ACWI	ETF	46.27	46.5	46.06	46.49	823000.0
2012-02-23	ACWV	ETF	53.34	53.34	53.34	53.34	500.0
2012-02-23	ACWX	ETF	40.87	41.05	40.6	40.95	203940.0
2012-02-23	ADRE	ETF	43.5	43.55	43.25	43.48	31044.0
2012-02-23	AFK	ETF	29.75	30.08	29.72	30.04	16327.0
2012-02-23	AGEM	ETF	24.0	24.0	23.8401	23.89	885.0
2012-02-23	AGG	ETF	110.42	110.6	110.37	110.57	788400.0
2012-02-23	AGQ	ETF	258.28	270.0	255.0	266.68	947800.0
2012-02-23	AGZ	ETF	112.9	112.91	112.684	112.91	15814.0
2012-02-23	AIA	ETF	44.73	44.73	44.628	44.6894	7288.0
2012-02-23	AIQ	ETF	7.4	7.4	7.2	7.3	10931.0
2012-02-23	AIS	ETF	2.7	2.74	2.66	2.7	1146415.0
2012-02-23	AIVI	ETF	41.98	42.25	41.78	42.23	38300.0
2012-02-23	AMJ	ETF	41.29	41.38	41.0101	41.29	790272.0
2012-02-23	AMLP	ETF	85.55	85.55	85.1	85.4	266340.0
2012-02-23	AOA	ETF	35.8	35.98	35.7	35.98	18200.0
2012-02-23	AOK	ETF	30.08	30.14	30.04	30.14	33819.0
2012-02-23	AOM	ETF	31.0	31.13	31.0	31.13	20665.0
2012-02-23	AOR	ETF	32.92	33.05	32.92	33.0	11871.0
2012-02-23	ARB	ETF	34.76	35.71	34.49	35.62	158661.0
2012-02-23	ARGT	ETF	23.94	23.94	23.8	23.86	750.0
2012-02-23	ASEA	ETF	15.95	16.02	15.91	16.02	12900.0
2012-02-23	AWAY	ETF	24.02	24.77	21.23	24.01	4606010.0
2012-02-23	BAB	ETF	29.14	29.3	29.12	29.25	308761.0
2012-02-23	BAL	ETF	54.98	54.98	54.12	54.27	24269.0
2012-02-23	BALT	ETF	4.41	4.53	4.31	4.43	250274.0
2012-02-23	BBH	ETF	41.94	42.53	41.83	42.5	25700.0
2012-02-23	BCM	ETF	46.61	46.825	46.55	46.822	18394.0
2012-02-23	BIB	ETF	10.9863	11.2647	10.8837	11.2538	55672.0
2012-02-23	BICK	ETF	27.91	27.91	27.6824	27.77	10966.0
2012-02-23	BIL	ETF	91.66	91.66	91.64	91.64	156300.0
2012-02-23	BIS	ETF	4080.0	4080.0	3939.2	3940.48	53.0
2012-02-23	BITS	ETF	21.92	21.92	20.96	21.4	2719.0
2012-02-23	BIV	ETF	87.67	87.86	87.55	87.78	209000.0
2012-02-23	BJK	ETF	34.03	34.2	33.9	34.18	18800.0
2012-02-23	BKF	ETF	43.37	43.4424	43.065	43.37	65634.0
2012-02-23	BKLN	ETF	24.43	24.49	24.41	24.43	226500.0
2012-02-23	BLV	ETF	90.68	91.32	90.6	91.07	24500.0
2012-02-23	BMVP	ETF	15.263	15.351	15.263	15.351	6047.0
2012-02-23	BND	ETF	83.71	83.82	83.63	83.78	991600.0
2012-02-23	BNO	ETF	43.11	43.27	42.61	43.2	230000.0
2012-02-23	BOIL	ETF	1450000.0	1450000.0	1343000.0	1389000.0	6.2

> showing 50 of 910 rows — these rows as CSV

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