PREVIEW / etf_daily / 2012-05-14

all etf daily files

  file:    by_date/etf_daily/2012/2012-05-14.parquet
  size:    39 KB
  rows:    942

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-14	SPY	ETF	134.31	135.61	133.91	134.11	163910000.0
2012-05-14	QQQ	ETF	63.63	64.08	63.48	63.58	46359983.0
2012-05-14	IWM	ETF	78.09	78.46	77.61	77.85	51220200.0
2012-05-14	DIA	ETF	127.18	127.69	126.6	126.95	6069000.0
2012-05-14	GLD	ETF	151.58	152.03	151.0	151.33	13388200.0
2012-05-14	TLT	ETF	120.87	121.3	120.6	121.17	8789400.0
2012-05-14	AADR	ETF	28.72	28.72	28.72	28.72	100.0
2012-05-14	AAXJ	ETF	52.85	52.96	52.49	52.61	409100.0
2012-05-14	ACTV	ETF	14.59	14.59	13.91	14.0	261116.0
2012-05-14	ACWI	ETF	43.98	44.24	43.94	43.99	246000.0
2012-05-14	ACWV	ETF	53.54	53.62	53.37	53.38	37200.0
2012-05-14	ACWX	ETF	37.52	37.57	37.3	37.3	106158.0
2012-05-14	ADRE	ETF	38.06	38.19	37.88	37.881	23098.0
2012-05-14	AFK	ETF	28.91	28.91	28.68	28.7	5396.0
2012-05-14	AGEM	ETF	20.85	20.89	20.85	20.89	200.0
2012-05-14	AGG	ETF	111.0	111.06	110.93	111.04	763300.0
2012-05-14	AGQ	ETF	167.28	167.52	164.0	164.44	335450.0
2012-05-14	AGZ	ETF	113.37	113.44	113.08	113.32	17572.0
2012-05-14	AIA	ETF	42.32	42.32	42.0	42.08	118950.0
2012-05-14	AIQ	ETF	6.45	6.5	6.35	6.45	9000.0
2012-05-14	AIS	ETF	3.11	3.12	3.0	3.1	926926.0
2012-05-14	AIVI	ETF	38.65	38.83	38.51	38.56	49300.0
2012-05-14	AMJ	ETF	38.51	38.85	38.4	38.45	1336035.0
2012-05-14	AMLP	ETF	80.6	81.05	80.4	80.6	302000.0
2012-05-14	ANGL	ETF	25.43	25.45	25.28	25.38	58300.0
2012-05-14	AOA	ETF	34.85	35.01	34.85	34.85	13300.0
2012-05-14	AOK	ETF	29.83	29.8408	29.78	29.78	21344.0
2012-05-14	AOM	ETF	30.66	30.73	30.64	30.67	16735.0
2012-05-14	AOR	ETF	32.41	32.48	32.3674	32.37	14157.0
2012-05-14	ARB	ETF	35.34	36.25	35.34	35.96	228260.0
2012-05-14	ARGT	ETF	17.1	17.1	17.1	17.1	100.0
2012-05-14	ASEA	ETF	15.73	15.73	15.56	15.59	21700.0
2012-05-14	AWAY	ETF	25.15	25.41	25.13	25.19	175741.0
2012-05-14	BAB	ETF	29.82	29.9	29.8	29.88	175566.0
2012-05-14	BAL	ETF	48.78	49.4005	48.531	48.82	65703.0
2012-05-14	BALT	ETF	3.95	4.06	3.86	4.0	148517.0
2012-05-14	BBH	ETF	46.5	46.98	46.39	46.82	17000.0
2012-05-14	BCM	ETF	41.9399	42.0	41.89	41.8935	5730.0
2012-05-14	BIB	ETF	12.37	12.525	12.2581	12.4875	11376.0
2012-05-14	BICK	ETF	23.05	23.09	22.95	22.9601	3979.0
2012-05-14	BIL	ETF	91.64	91.66	91.64	91.66	221050.0
2012-05-14	BIS	ETF	3435.2	3435.2	3428.784	3430.4	4.44
2012-05-14	BIV	ETF	88.39	88.49	88.3	88.32	216400.0
2012-05-14	BJK	ETF	33.88	33.88	33.31	33.31	11200.0
2012-05-14	BKF	ETF	36.76	36.76	36.3397	36.36	96736.0
2012-05-14	BKLN	ETF	24.75	24.75	24.66	24.68	205700.0
2012-05-14	BLNG	ETF	46.7599	46.7599	46.7599	46.7599	200.0
2012-05-14	BLV	ETF	93.14	93.35	92.86	93.17	121300.0
2012-05-14	BMVP	ETF	14.93	14.97	14.88	14.88	2408.0
2012-05-14	BND	ETF	84.08	84.14	84.03	84.1	759400.0

> showing 50 of 942 rows — these rows as CSV

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