PREVIEW / etf_daily / 2012-05-15

all etf daily files

  file:    by_date/etf_daily/2012/2012-05-15.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-15	SPY	ETF	134.02	134.81	133.13	133.34	207629300.0
2012-05-15	QQQ	ETF	63.79	64.27	63.26	63.37	66908427.0
2012-05-15	IWM	ETF	77.83	78.49	77.47	77.71	54317800.0
2012-05-15	DIA	ETF	126.82	127.59	126.07	126.31	6713000.0
2012-05-15	GLD	ETF	151.16	151.44	149.63	149.74	13354500.0
2012-05-15	TLT	ETF	121.09	121.73	120.82	121.66	6766400.0
2012-05-15	AADR	ETF	28.71	28.71	28.71	28.71	200.0
2012-05-15	AAXJ	ETF	52.69	52.93	52.28	52.4	2345700.0
2012-05-15	ACTV	ETF	14.04	14.46	13.85	13.86	215249.0
2012-05-15	ACWI	ETF	43.8	43.97	43.45	43.52	1415900.0
2012-05-15	ACWV	ETF	53.43	53.59	52.67	52.67	79000.0
2012-05-15	ACWX	ETF	37.18	37.332	36.82	36.84	215015.0
2012-05-15	ADRE	ETF	38.06	38.12	37.42	37.49	28377.0
2012-05-15	AFK	ETF	28.54	28.64	28.04	28.07	33368.0
2012-05-15	AGEM	ETF	20.6701	20.6801	20.67	20.6801	1200.0
2012-05-15	AGG	ETF	111.1	111.1	110.88	110.98	1187200.0
2012-05-15	AGQ	ETF	162.92	164.8	156.84	157.6	422725.0
2012-05-15	AGZ	ETF	113.22	113.24	113.09	113.1199	9975.0
2012-05-15	AIA	ETF	42.26	42.35	41.92	41.92	7643.0
2012-05-15	AIQ	ETF	6.45	6.6	6.1	6.15	8291.0
2012-05-15	AIS	ETF	3.11	3.18	3.06	3.06	536374.0
2012-05-15	AIVI	ETF	38.41	38.5	38.0	38.08	42000.0
2012-05-15	AMJ	ETF	38.42	38.73	38.34	38.34	3512109.0
2012-05-15	AMLP	ETF	80.45	80.85	80.25	80.25	423120.0
2012-05-15	ANGL	ETF	25.43	25.43	25.33	25.36	58000.0
2012-05-15	AOA	ETF	34.8	34.9	34.63	34.63	4600.0
2012-05-15	AOK	ETF	29.78	29.82	29.73	29.73	366125.0
2012-05-15	AOM	ETF	30.59	30.7	30.53	30.58	50333.0
2012-05-15	AOR	ETF	32.375	32.43	32.208	32.26	33434.0
2012-05-15	ARB	ETF	35.87	36.92	35.87	36.48	153069.0
2012-05-15	ARGT	ETF	16.4	16.5	16.26	16.28	2800.0
2012-05-15	ASEA	ETF	15.62	15.68	15.5	15.51	23000.0
2012-05-15	AWAY	ETF	25.13	26.19	24.84	25.69	722723.0
2012-05-15	BAB	ETF	29.77	29.81	29.71	29.8007	147639.0
2012-05-15	BAL	ETF	49.44	49.64	48.97	48.97	33793.0
2012-05-15	BALT	ETF	3.99	4.0015	3.83	3.88	98053.0
2012-05-15	BBH	ETF	46.79	47.07	46.58	46.81	25000.0
2012-05-15	BCM	ETF	41.9	41.9	41.6865	41.6865	22265.0
2012-05-15	BIB	ETF	12.6237	12.6275	12.3279	12.3887	166632.0
2012-05-15	BICK	ETF	22.97	23.066	22.75	22.75	3359.0
2012-05-15	BIL	ETF	91.64	91.66	91.64	91.66	528650.0
2012-05-15	BIS	ETF	3465.6	3473.6	3412.8	3473.6	8.75
2012-05-15	BIV	ETF	88.48	88.48	88.33	88.43	214000.0
2012-05-15	BJK	ETF	33.25	33.49	32.91	33.03	9200.0
2012-05-15	BKF	ETF	36.37	36.6	35.95	36.0	130862.0
2012-05-15	BKLN	ETF	24.65	24.68	24.58	24.6	250700.0
2012-05-15	BLNG	ETF	46.5799	46.5799	46.5799	46.5799	300.0
2012-05-15	BLV	ETF	93.36	93.67	93.22	93.6	193000.0
2012-05-15	BMVP	ETF	14.847	14.911	14.82	14.82	4232.0
2012-05-15	BND	ETF	84.12	84.14	84.01	84.12	1469000.0

> showing 50 of 935 rows — these rows as CSV

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