PREVIEW / etf_daily / 2012-06-29

all etf daily files

  file:    by_date/etf_daily/2012/2012-06-29.parquet
  size:    39 KB
  rows:    938

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-06-29	SPY	ETF	135.2	136.27	134.85	136.1	212250900.0
2012-06-29	QQQ	ETF	63.37	64.16	63.21	64.16	44765803.0
2012-06-29	IWM	ETF	78.94	79.73	78.56	79.56	71660200.0
2012-06-29	DIA	ETF	127.75	128.57	127.44	128.45	5844400.0
2012-06-29	GLD	ETF	155.13	155.95	154.52	155.19	10378200.0
2012-06-29	TLT	ETF	125.03	125.63	124.63	125.2	8881900.0
2012-06-29	AADR	ETF	28.49	28.49	28.49	28.49	300.0
2012-06-29	AAXJ	ETF	52.36	52.61	52.14	52.61	714700.0
2012-06-29	ACTV	ETF	15.21	15.5	15.13	15.39	287973.0
2012-06-29	ACWI	ETF	43.68	43.88	43.54	43.87	545600.0
2012-06-29	ACWV	ETF	55.97	55.97	54.4	54.42	20600.0
2012-06-29	ACWX	ETF	37.06	37.22	36.95	37.19	254170.0
2012-06-29	ADRE	ETF	37.12	37.57	37.081	37.57	59460.0
2012-06-29	AFK	ETF	27.39	27.83	27.39	27.81	45233.0
2012-06-29	AGEM	ETF	20.82	20.94	20.82	20.94	816.0
2012-06-29	AGG	ETF	111.25	111.33	111.2	111.3	2052800.0
2012-06-29	AGQ	ETF	153.12	155.88	149.72	152.52	658825.0
2012-06-29	AGZ	ETF	113.5	113.5	113.4101	113.4699	17137.0
2012-06-29	AIA	ETF	41.3	41.44	41.1909	41.44	6545.0
2012-06-29	AIQ	ETF	4.75	4.99	4.5	4.99	23864.0
2012-06-29	AIVI	ETF	37.85	38.13	37.72	38.13	44100.0
2012-06-29	AMJ	ETF	38.24	39.31	37.97	38.76	2717792.0
2012-06-29	AMLP	ETF	79.3	79.9	79.3	79.9	428120.0
2012-06-29	ANGL	ETF	25.45	25.45	25.45	25.45	1000.0
2012-06-29	AOA	ETF	34.8	34.92	34.76	34.92	15300.0
2012-06-29	AOK	ETF	29.902	29.9582	29.8885	29.9499	28559.0
2012-06-29	AOM	ETF	30.6	30.662	30.58	30.61	17492.0
2012-06-29	AOR	ETF	32.35	32.44	32.25	32.42	161290.0
2012-06-29	ARB	ETF	35.45	35.785	34.97	35.0	155334.0
2012-06-29	ASEA	ETF	15.5	15.68	15.5	15.65	26500.0
2012-06-29	AWAY	ETF	21.77	22.17	21.59	21.74	629637.0
2012-06-29	BAB	ETF	29.82	29.88	29.55	29.7	245739.0
2012-06-29	BAL	ETF	46.2886	47.0	46.01	46.35	11626.0
2012-06-29	BALT	ETF	3.35	3.44	3.3	3.44	69620.0
2012-06-29	BBH	ETF	46.65	47.62	46.42	47.15	45800.0
2012-06-29	BIB	ETF	12.9738	13.1386	12.92	13.0938	33440.0
2012-06-29	BICK	ETF	22.32	22.4525	22.14	22.4275	3933.0
2012-06-29	BIL	ETF	91.64	91.66	91.62	91.62	1110950.0
2012-06-29	BIS	ETF	3281.6	3281.6	3146.4	3168.32	22.85
2012-06-29	BIV	ETF	88.71	88.89	88.67	88.82	199600.0
2012-06-29	BJK	ETF	31.83	32.0	31.83	31.98	2700.0
2012-06-29	BKF	ETF	35.39	35.87	35.34	35.87	113162.0
2012-06-29	BKLN	ETF	24.27	24.39	24.27	24.38	213600.0
2012-06-29	BLV	ETF	94.69	95.15	94.5	94.95	44700.0
2012-06-29	BMVP	ETF	15.253	15.287	15.244	15.287	16665.0
2012-06-29	BND	ETF	84.28	84.39	84.23	84.38	2044900.0
2012-06-29	BNO	ETF	33.805	34.845	33.715	34.595	77000.0
2012-06-29	BOIL	ETF	863400.0	920000.0	848400.0	915000.0	14.4
2012-06-29	BOND	ETF	105.46	105.62	105.33	105.49	789022.0
2012-06-29	BRF	ETF	35.65	36.59	35.54	36.59	278550.0

> showing 50 of 938 rows — these rows as CSV

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