PREVIEW / etf_daily / 2011-08-29

all etf daily files

  file:    by_date/etf_daily/2011/2011-08-29.parquet
  size:    36 KB
  rows:    866

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
2011-08-29	SPY	ETF	119.56	121.43	118.06	121.36	190977200.0
2011-08-29	QQQ	ETF	53.64	54.67	53.64	54.61	45985744.0
2011-08-29	IWM	ETF	70.07	72.45	70.04	72.38	53069800.0
2011-08-29	DIA	ETF	113.97	115.2	113.92	115.14	7117800.0
2011-08-29	GLD	ETF	175.95	176.01	172.88	173.89	25265500.0
2011-08-29	TLT	ETF	106.7	107.4	106.6	106.99	6764300.0
2011-08-29	AADR	ETF	29.31	29.31	29.31	29.31	500.0
2011-08-29	AAXJ	ETF	54.55	55.39	54.53	55.37	213700.0
2011-08-29	ACTV	ETF	16.38	16.67	16.23	16.65	65354.0
2011-08-29	ACWI	ETF	42.84	43.31	42.78	43.26	273300.0
2011-08-29	ACWX	ETF	39.14	39.5	39.07	39.5	70011.0
2011-08-29	ADRE	ETF	40.92	41.4	40.82	41.4	135482.0
2011-08-29	AFK	ETF	28.88	29.15	28.81	29.15	41665.0
2011-08-29	AGEM	ETF	22.88	23.04	22.79	23.04	5155.0
2011-08-29	AGG	ETF	109.16	109.27	109.08	109.26	1150700.0
2011-08-29	AGQ	ETF	436.96	438.96	423.52	434.0	558800.0
2011-08-29	AGZ	ETF	112.08	112.34	112.08	112.14	9843.0
2011-08-29	AIA	ETF	40.96	41.47	40.96	41.47	19374.0
2011-08-29	AIQ	ETF	7.25	7.45	7.25	7.45	27735.0
2011-08-29	AIS	ETF	2.37	2.46	2.35	2.46	856125.0
2011-08-29	AIVI	ETF	41.88	42.26	41.88	42.25	33800.0
2011-08-29	AMJ	ETF	34.55	35.05	34.55	34.99	503854.0
2011-08-29	AMLP	ETF	76.1	77.1	76.1	76.95	81480.0
2011-08-29	AOA	ETF	32.21	32.76	32.21	32.76	67000.0
2011-08-29	AOK	ETF	28.94	29.04	28.9	29.0	98792.0
2011-08-29	AOM	ETF	29.64	30.38	29.64	29.8	112629.0
2011-08-29	AOR	ETF	30.56	30.92	30.56	30.92	50683.0
2011-08-29	ARB	ETF	35.45	36.75	35.31	36.74	110062.0
2011-08-29	ARGT	ETF	25.32	25.32	25.14	25.2	2650.0
2011-08-29	ASEA	ETF	15.87	16.02	15.87	16.02	1600.0
2011-08-29	AWAY	ETF	38.32	41.43	38.32	41.03	249507.0
2011-08-29	BAB	ETF	27.5	27.5	27.28	27.3699	123879.0
2011-08-29	BAL	ETF	65.15	65.62	64.87	64.91	39190.0
2011-08-29	BALT	ETF	4.51	4.82	4.51	4.79	136660.0
2011-08-29	BBH	ETF	32.6167	32.88	32.6167	32.88	28200.0
2011-08-29	BIB	ETF	7.0338	7.3673	7.0338	7.3666	95224.0
2011-08-29	BICK	ETF	26.26	26.8	26.26	26.8	14431.0
2011-08-29	BIL	ETF	91.72	91.72	91.7	91.72	11294400.0
2011-08-29	BIS	ETF	7155.2	7155.2	6856.0	6856.0	11.6
2011-08-29	BITS	ETF	22.16	22.2	21.28	22.008	725.0
2011-08-29	BIV	ETF	87.4	87.51	87.07	87.4	152100.0
2011-08-29	BJK	ETF	32.16	32.83	32.16	32.8	32600.0
2011-08-29	BKF	ETF	40.55	41.27	40.55	41.21	136355.0
2011-08-29	BKLN	ETF	22.8	22.93	22.74	22.89	1496300.0
2011-08-29	BLV	ETF	85.88	86.53	85.88	86.53	22900.0
2011-08-29	BMVP	ETF	13.5343	13.67	13.4567	13.67	7924.0
2011-08-29	BND	ETF	83.21	83.23	83.04	83.2	1632100.0
2011-08-29	BNO	ETF	37.58	37.67	37.43	37.51	39000.0
2011-08-29	BRF	ETF	48.42	50.06	48.42	49.95	193075.0
2011-08-29	BSCE	ETF	20.98	21.12	20.98	21.12	30265.0

> showing 50 of 866 rows — these rows as CSV

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