PREVIEW / etf_daily / 2012-05-29

all etf daily files

  file:    by_date/etf_daily/2012/2012-05-29.parquet
  size:    38 KB
  rows:    926

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-29	SPY	ETF	133.16	133.93	131.17	133.7	152883500.0
2012-05-29	QQQ	ETF	62.63	63.15	62.28	62.86	44221458.0
2012-05-29	IWM	ETF	77.33	77.91	76.76	77.7	51160000.0
2012-05-29	DIA	ETF	125.23	125.92	124.9	125.6	6828700.0
2012-05-29	GLD	ETF	153.47	153.62	150.25	151.02	11243100.0
2012-05-29	TLT	ETF	123.39	123.81	123.0	123.02	5874100.0
2012-05-29	AAXJ	ETF	51.31	51.56	51.09	51.41	261100.0
2012-05-29	ACTV	ETF	13.95	14.25	13.91	14.23	468244.0
2012-05-29	ACWI	ETF	43.09	43.23	42.81	43.09	298600.0
2012-05-29	ACWV	ETF	52.96	53.06	52.77	52.86	700.0
2012-05-29	ACWX	ETF	36.28	36.51	36.08	36.3	136482.0
2012-05-29	ADRE	ETF	37.12	37.34	36.81	37.07	16605.0
2012-05-29	AFK	ETF	28.16	28.16	27.77	27.92	11099.0
2012-05-29	AGEM	ETF	20.5	20.61	20.3099	20.3722	2024.0
2012-05-29	AGG	ETF	110.95	110.99	110.83	110.86	1192100.0
2012-05-29	AGQ	ETF	167.52	168.88	158.0	160.04	438250.0
2012-05-29	AGZ	ETF	113.2	113.25	113.14	113.14	4273.0
2012-05-29	AIA	ETF	40.84	40.91	40.6309	40.83	16860.0
2012-05-29	AIQ	ETF	5.25	5.35	5.15	5.2	8371.0
2012-05-29	AIS	ETF	2.92	2.94	2.86	2.9	701395.0
2012-05-29	AIVI	ETF	37.21	37.31	36.88	37.16	24400.0
2012-05-29	AMJ	ETF	37.41	37.65	37.32	37.53	1559563.0
2012-05-29	AMLP	ETF	80.25	80.45	79.75	80.1	358240.0
2012-05-29	ANGL	ETF	25.08	25.08	24.99	25.04	19800.0
2012-05-29	AOA	ETF	34.45	34.57	34.35	34.52	11100.0
2012-05-29	AOK	ETF	29.64	29.6841	29.636	29.65	17116.0
2012-05-29	AOM	ETF	30.46	30.5	30.37	30.47	22391.0
2012-05-29	AOR	ETF	32.14	32.17	32.0335	32.13	15466.0
2012-05-29	ARB	ETF	34.01	34.24	33.67	34.24	163930.0
2012-05-29	ARGT	ETF	16.2	16.4	16.2	16.24	1800.0
2012-05-29	ASEA	ETF	14.89	14.95	14.84	14.91	31900.0
2012-05-29	AWAY	ETF	24.44	24.88	24.26	24.8	603717.0
2012-05-29	BAB	ETF	29.71	29.8	29.6969	29.7	179472.0
2012-05-29	BAL	ETF	46.38	46.53	44.68	44.76	43472.0
2012-05-29	BALT	ETF	3.83	3.87	3.736	3.77	48538.0
2012-05-29	BBH	ETF	45.8	46.09	45.66	45.97	17300.0
2012-05-29	BCM	ETF	41.32	41.33	41.244	41.2999	2307.0
2012-05-29	BIB	ETF	12.2125	12.2886	12.0475	12.1962	60096.0
2012-05-29	BICK	ETF	22.37	22.43	22.21	22.31	5037.0
2012-05-29	BIL	ETF	91.66	91.66	91.64	91.66	150950.0
2012-05-29	BIS	ETF	3499.2	3545.6	3480.64	3483.52	27.8
2012-05-29	BIV	ETF	88.32	88.38	88.2	88.23	408300.0
2012-05-29	BJK	ETF	32.5	32.53	32.21	32.41	11100.0
2012-05-29	BKF	ETF	35.65	35.73	35.23	35.58	125255.0
2012-05-29	BKLN	ETF	24.34	24.36	24.23	24.26	200600.0
2012-05-29	BLV	ETF	93.77	93.96	93.53	93.53	77300.0
2012-05-29	BMVP	ETF	14.78	14.78	14.71	14.77	1276.0
2012-05-29	BND	ETF	84.08	84.12	84.01	84.03	1351600.0
2012-05-29	BNO	ETF	38.03	38.12	37.585	37.685	44600.0
2012-05-29	BOIL	ETF	859000.0	871400.0	782200.0	798600.0	10.4

> showing 50 of 926 rows — these rows as CSV

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