PREVIEW / etf_daily / 2012-05-09

all etf daily files

  file:    by_date/etf_daily/2012/2012-05-09.parquet
  size:    38 KB
  rows:    935

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-05-09	SPY	ETF	135.1	136.61	134.49	135.74	220752500.0
2012-05-09	QQQ	ETF	63.77	64.68	63.51	64.321	85715257.0
2012-05-09	IWM	ETF	78.25	79.26	77.97	78.8	64431000.0
2012-05-09	DIA	ETF	128.0	129.12	127.38	128.34	11921700.0
2012-05-09	GLD	ETF	154.1	154.98	153.6	154.47	13864000.0
2012-05-09	TLT	ETF	119.45	119.57	118.44	118.87	5828900.0
2012-05-09	AADR	ETF	28.87	28.96	28.87	28.96	400.0
2012-05-09	AAXJ	ETF	53.98	54.44	53.67	54.14	698900.0
2012-05-09	ACTV	ETF	14.63	14.94	14.576	14.88	292261.0
2012-05-09	ACWI	ETF	44.51	44.99	44.28	44.7	593500.0
2012-05-09	ACWV	ETF	53.6	54.09	53.5	54.03	52300.0
2012-05-09	ACWX	ETF	37.98	38.37	37.75	38.07	222372.0
2012-05-09	ADRE	ETF	39.0	39.3	38.84	39.21	16911.0
2012-05-09	AFK	ETF	29.06	29.3	28.94	29.3	13360.0
2012-05-09	AGEM	ETF	21.35	21.35	21.35	21.35	306.0
2012-05-09	AGG	ETF	110.92	110.92	110.72	110.82	930000.0
2012-05-09	AGQ	ETF	172.68	177.64	171.44	176.04	401000.0
2012-05-09	AGZ	ETF	113.06	113.2	113.06	113.09	39915.0
2012-05-09	AIA	ETF	43.25	43.54	43.01	43.36	61445.0
2012-05-09	AIQ	ETF	6.85	6.9	6.6	6.6	8796.0
2012-05-09	AIS	ETF	3.17	3.205	3.1	3.17	806306.0
2012-05-09	AIVI	ETF	39.0	39.43	38.93	39.28	20000.0
2012-05-09	AMJ	ETF	38.86	38.9	38.59	38.7	1179915.0
2012-05-09	AMLP	ETF	81.5	81.5	80.8	81.0	390160.0
2012-05-09	ANGL	ETF	25.55	25.55	25.44	25.44	12200.0
2012-05-09	AOA	ETF	35.04	35.34	34.95	35.34	13200.0
2012-05-09	AOK	ETF	29.8716	29.932	29.83	29.91	10161.0
2012-05-09	AOM	ETF	30.77	30.88	30.7158	30.84	10604.0
2012-05-09	AOR	ETF	32.54	32.71	32.46	32.63	24157.0
2012-05-09	ARB	ETF	35.77	36.24	35.73	36.03	238773.0
2012-05-09	ASEA	ETF	15.85	15.97	15.85	15.92	18600.0
2012-05-09	AWAY	ETF	25.18	25.66	25.032	25.48	251188.0
2012-05-09	BAB	ETF	29.76	29.79	29.64	29.68	133238.0
2012-05-09	BAL	ETF	53.2201	53.62	53.082	53.17	41019.0
2012-05-09	BALT	ETF	4.0	4.15	3.951	4.13	56976.0
2012-05-09	BBH	ETF	45.76	46.03	45.58	45.85	13800.0
2012-05-09	BCM	ETF	42.66	42.89	42.62	42.72	20213.0
2012-05-09	BIB	ETF	12.0188	12.1125	11.9787	12.0039	23280.0
2012-05-09	BICK	ETF	23.52	23.88	23.52	23.773	27459.0
2012-05-09	BIL	ETF	91.64	91.66	91.64	91.66	921250.0
2012-05-09	BIS	ETF	3630.4	3898.56	3576.0	3577.68	12.0
2012-05-09	BIV	ETF	88.14	88.33	88.06	88.07	263000.0
2012-05-09	BJK	ETF	34.28	34.63	34.03	34.46	11000.0
2012-05-09	BKF	ETF	37.45	37.7823	37.202	37.6	140022.0
2012-05-09	BKLN	ETF	24.71	24.72	24.64	24.72	70200.0
2012-05-09	BLNG	ETF	47.62	47.6201	47.62	47.6201	2341.0
2012-05-09	BLV	ETF	92.55	92.59	91.88	92.14	51000.0
2012-05-09	BMVP	ETF	15.011	15.047	15.011	15.022	3400.0
2012-05-09	BND	ETF	83.99	84.04	83.9	83.94	1595100.0
2012-05-09	BNO	ETF	39.34	39.825	39.315	39.695	103800.0

> showing 50 of 935 rows — these rows as CSV

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