PREVIEW / etf_daily / 2012-05-11

all etf daily files

  file:    by_date/etf_daily/2012/2012-05-11.parquet
  size:    38 KB
  rows:    932

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-11	SPY	ETF	135.17	136.87	135.11	135.61	153032400.0
2012-05-11	QQQ	ETF	63.94	64.86	63.91	64.18	47106689.0
2012-05-11	IWM	ETF	78.45	79.56	78.42	78.9	44862900.0
2012-05-11	DIA	ETF	127.8	129.16	127.73	128.18	3673800.0
2012-05-11	GLD	ETF	153.44	154.47	153.24	153.56	8285600.0
2012-05-11	TLT	ETF	119.49	119.6	118.96	119.5	5234300.0
2012-05-11	AADR	ETF	29.05	29.06	29.05	29.06	300.0
2012-05-11	AAXJ	ETF	53.57	54.04	53.47	53.53	208200.0
2012-05-11	ACTV	ETF	14.81	14.93	14.6	14.68	152728.0
2012-05-11	ACWI	ETF	44.57	45.04	44.43	44.64	318800.0
2012-05-11	ACWV	ETF	53.89	54.23	53.87	54.02	15000.0
2012-05-11	ACWX	ETF	37.93	38.45	37.93	38.09	89856.0
2012-05-11	ADRE	ETF	38.93	39.41	38.78	38.9	15310.0
2012-05-11	AFK	ETF	29.38	29.38	29.0101	29.078	1659.0
2012-05-11	AGEM	ETF	21.42	21.42	21.26	21.29	741.0
2012-05-11	AGG	ETF	110.92	110.93	110.75	110.79	446300.0
2012-05-11	AGQ	ETF	168.2	174.8	166.68	172.32	289725.0
2012-05-11	AGZ	ETF	113.116	113.22	113.0601	113.1	13410.0
2012-05-11	AIA	ETF	42.7146	43.09	42.7136	42.81	3200.0
2012-05-11	AIQ	ETF	6.6	6.7	6.05	6.5	19237.0
2012-05-11	AIS	ETF	3.11	3.14	3.05	3.09	838298.0
2012-05-11	AIVI	ETF	39.17	39.63	39.14	39.29	33000.0
2012-05-11	AMJ	ETF	38.77	39.04	38.74	38.84	488265.0
2012-05-11	AMLP	ETF	80.85	81.3	80.85	81.15	254700.0
2012-05-11	ANGL	ETF	25.42	25.45	25.37	25.4	35000.0
2012-05-11	AOA	ETF	35.09	35.43	35.04	35.22	9800.0
2012-05-11	AOK	ETF	29.82	29.954	29.82	29.88	11038.0
2012-05-11	AOM	ETF	30.72	30.91	30.72	30.82	39495.0
2012-05-11	AOR	ETF	32.55	32.77	32.54	32.63	27271.0
2012-05-11	ARB	ETF	35.84	36.66	35.84	36.21	109040.0
2012-05-11	ARGT	ETF	17.02	17.24	17.02	17.24	300.0
2012-05-11	ASEA	ETF	15.94	15.99	15.85	15.88	12000.0
2012-05-11	AWAY	ETF	25.03	25.48	24.64	25.35	254857.0
2012-05-11	BAB	ETF	29.68	29.76	29.66	29.73	88267.0
2012-05-11	BAL	ETF	49.89	49.89	48.72	48.8884	57850.0
2012-05-11	BALT	ETF	4.01	4.02	3.96	4.0	98692.0
2012-05-11	BBH	ETF	46.19	46.85	46.13	46.75	33000.0
2012-05-11	BCM	ETF	42.52	42.76	42.4369	42.4369	4960.0
2012-05-11	BIB	ETF	12.0819	12.6	12.0819	12.525	28000.0
2012-05-11	BICK	ETF	23.57	23.779	23.39	23.51	4764.0
2012-05-11	BIL	ETF	91.66	91.66	91.64	91.66	128000.0
2012-05-11	BIS	ETF	3513.6	3513.6	3425.52	3425.52	22.5
2012-05-11	BIV	ETF	88.13	88.26	88.08	88.23	193000.0
2012-05-11	BJK	ETF	34.45	34.78	34.43	34.45	13000.0
2012-05-11	BKF	ETF	37.27	37.86	37.22	37.33	125318.0
2012-05-11	BKLN	ETF	24.75	24.77	24.66	24.68	131000.0
2012-05-11	BLV	ETF	92.33	92.5	92.09	92.49	26000.0
2012-05-11	BMVP	ETF	15.07	15.14	15.07	15.08	5174.0
2012-05-11	BND	ETF	84.02	84.03	83.92	83.95	1734700.0
2012-05-11	BNO	ETF	39.355	39.69	39.355	39.475	46000.0

> showing 50 of 932 rows — these rows as CSV

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