PREVIEW / etf_daily / 2012-06-26

all etf daily files

  file:    by_date/etf_daily/2012/2012-06-26.parquet
  size:    39 KB
  rows:    934

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-26	SPY	ETF	131.7	132.38	130.93	131.98	141634000.0
2012-06-26	QQQ	ETF	62.33	62.7	62.0575	62.52	30610734.0
2012-06-26	IWM	ETF	76.09	76.58	75.42	76.2	42495600.0
2012-06-26	DIA	ETF	125.03	125.51	124.25	125.08	7551600.0
2012-06-26	GLD	ETF	153.03	153.3	152.13	152.62	6123400.0
2012-06-26	TLT	ETF	126.11	126.95	125.94	126.34	5359700.0
2012-06-26	AADR	ETF	27.78	27.78	27.65	27.77	1600.0
2012-06-26	AAXJ	ETF	50.67	50.77	50.21	50.58	1151700.0
2012-06-26	ACTV	ETF	15.45	15.55	15.25	15.32	370451.0
2012-06-26	ACWI	ETF	42.2	42.43	41.93	42.28	679200.0
2012-06-26	ACWV	ETF	53.68	53.72	53.54	53.7	7000.0
2012-06-26	ACWX	ETF	35.54	35.72	35.2801	35.66	197604.0
2012-06-26	ADRE	ETF	35.89	36.13	35.6591	35.98	46943.0
2012-06-26	AFK	ETF	27.04	27.15	26.851	27.131	5987.0
2012-06-26	AGEM	ETF	19.99	20.08	19.99	20.03	6528.0
2012-06-26	AGG	ETF	111.27	111.37	111.24	111.27	789100.0
2012-06-26	AGQ	ETF	150.36	151.56	145.36	148.6	260425.0
2012-06-26	AGZ	ETF	113.49	113.51	113.37	113.4799	8765.0
2012-06-26	AIA	ETF	39.6	39.77	39.475	39.71	4340.0
2012-06-26	AIQ	ETF	4.6	4.75	4.3	4.585	20066.0
2012-06-26	AIVI	ETF	36.02	36.28	35.87	36.25	36200.0
2012-06-26	AMJ	ETF	36.23	36.39	36.11	36.3	1257051.0
2012-06-26	AMLP	ETF	77.15	77.7	77.15	77.55	301420.0
2012-06-26	ANGL	ETF	25.38	25.38	25.3	25.35	1500.0
2012-06-26	AOA	ETF	33.89	34.02	33.7	33.98	21600.0
2012-06-26	AOK	ETF	29.61	29.7	29.61	29.654	89773.0
2012-06-26	AOM	ETF	30.2	30.2499	30.13	30.21	11105.0
2012-06-26	AOR	ETF	31.74	31.8096	31.6634	31.8	9198.0
2012-06-26	ARB	ETF	34.24	34.48	33.41	34.35	63771.0
2012-06-26	ASEA	ETF	14.97	15.14	14.97	15.14	4900.0
2012-06-26	AWAY	ETF	20.53	20.67	20.21	20.48	340662.0
2012-06-26	BAB	ETF	29.84	29.87	29.73	29.8	205876.0
2012-06-26	BAL	ETF	46.13	46.2	45.04	45.04	17905.0
2012-06-26	BALT	ETF	3.31	3.32	3.16	3.29	74410.0
2012-06-26	BBH	ETF	46.49	46.76	46.3	46.6	4200.0
2012-06-26	BCM	ETF	40.2696	40.4482	40.2696	40.4482	550.0
2012-06-26	BIB	ETF	12.5762	12.8969	12.5762	12.85	34616.0
2012-06-26	BICK	ETF	21.44	21.672	21.418	21.672	11105.0
2012-06-26	BIL	ETF	91.64	91.66	91.64	91.66	127900.0
2012-06-26	BIS	ETF	3289.6	3308.8	3251.2	3251.2	21.25
2012-06-26	BIV	ETF	88.65	88.74	81.05	88.64	257400.0
2012-06-26	BJK	ETF	31.12	31.25	30.86	31.16	41100.0
2012-06-26	BKF	ETF	34.13	34.27	33.863	34.19	92085.0
2012-06-26	BKLN	ETF	24.2	24.29	24.16	24.16	197900.0
2012-06-26	BLNG	ETF	46.21	46.2101	46.21	46.2101	204.0
2012-06-26	BLV	ETF	95.01	95.56	95.0	95.3	42600.0
2012-06-26	BMVP	ETF	14.74	14.9307	14.74	14.9307	1889.0
2012-06-26	BND	ETF	84.28	84.37	84.25	84.26	1166300.0
2012-06-26	BNO	ETF	32.655	33.05	32.47	32.995	55400.0
2012-06-26	BOIL	ETF	866400.0	914400.0	849200.0	912000.0	11.0

> showing 50 of 934 rows — these rows as CSV

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