PREVIEW / etf_daily / 2012-07-30

all etf daily files

  file:    by_date/etf_daily/2012/2012-07-30.parquet
  size:    38 KB
  rows:    932

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-07-30	SPY	ETF	138.52	139.34	138.27	138.68	106782000.0
2012-07-30	QQQ	ETF	65.01	65.31	64.6	64.82	37821194.0
2012-07-30	IWM	ETF	79.52	79.91	78.74	79.05	34785200.0
2012-07-30	DIA	ETF	130.31	130.99	130.12	130.4	4235800.0
2012-07-30	GLD	ETF	156.84	157.66	154.81	157.43	7212100.0
2012-07-30	TLT	ETF	128.39	129.48	128.25	129.44	6025300.0
2012-07-30	AADR	ETF	28.8	28.8	28.8	28.8	200.0
2012-07-30	AAXJ	ETF	52.77	52.96	52.59	52.69	192400.0
2012-07-30	ACTV	ETF	14.69	14.75	14.5	14.66	112446.0
2012-07-30	ACWI	ETF	44.42	44.7	44.39	44.53	446100.0
2012-07-30	ACWV	ETF	55.6	55.76	55.59	55.73	3500.0
2012-07-30	ACWX	ETF	37.29	37.53	37.29	37.47	333707.0
2012-07-30	ADRE	ETF	38.03	38.24	37.902	38.17	22064.0
2012-07-30	AFK	ETF	28.09	28.329	28.048	28.2545	12085.0
2012-07-30	AGEM	ETF	21.65	21.67	21.37	21.59	7641.0
2012-07-30	AGG	ETF	112.31	112.52	112.27	112.48	618400.0
2012-07-30	AGQ	ETF	153.88	159.56	153.52	159.16	308175.0
2012-07-30	AGZ	ETF	113.89	113.93	113.72	113.93	19388.0
2012-07-30	AIA	ETF	42.1375	42.24	42.0332	42.05	7665.0
2012-07-30	AIQ	ETF	3.8	4.3	3.65	4.1	27380.0
2012-07-30	AIVI	ETF	37.87	38.16	37.76	38.09	39400.0
2012-07-30	AMJ	ETF	39.32	39.745	39.32	39.64	1452899.0
2012-07-30	AMLP	ETF	82.1	82.6	82.0	82.3	293980.0
2012-07-30	ANGL	ETF	25.85	25.85	25.85	25.85	700.0
2012-07-30	AOA	ETF	35.35	35.5	35.35	35.4	4100.0
2012-07-30	AOK	ETF	30.09	30.12	30.0611	30.12	27275.0
2012-07-30	AOM	ETF	30.9893	31.03	30.9813	31.01	25747.0
2012-07-30	AOR	ETF	32.79	32.89	32.79	32.86	27612.0
2012-07-30	ARB	ETF	36.88	37.0	35.69	35.98	76895.0
2012-07-30	ARGT	ETF	15.94	16.08	15.94	16.08	7500.0
2012-07-30	ASEA	ETF	16.13	16.24	15.75	16.19	24300.0
2012-07-30	AWAY	ETF	23.96	24.28	23.14	23.69	954949.0
2012-07-30	BAB	ETF	30.35	30.63	30.35	30.62	192908.0
2012-07-30	BAL	ETF	46.99	47.36	46.86	46.99	18871.0
2012-07-30	BALT	ETF	3.31	3.38	3.23	3.24	8629.0
2012-07-30	BBH	ETF	50.73	51.61	50.28	50.33	16600.0
2012-07-30	BIB	ETF	14.7475	14.7475	14.2576	14.2662	57624.0
2012-07-30	BICK	ETF	22.31	22.49	22.31	22.416	9365.0
2012-07-30	BIL	ETF	91.66	91.66	91.64	91.66	372150.0
2012-07-30	BIS	ETF	2899.2	2899.2	2800.0	2857.44	101.5
2012-07-30	BIV	ETF	89.79	90.05	89.77	90.05	209600.0
2012-07-30	BJK	ETF	30.45	30.63	30.31	30.35	2500.0
2012-07-30	BKF	ETF	35.96	36.12	35.85	36.0	67899.0
2012-07-30	BKLN	ETF	24.57	24.59	24.54	24.54	209600.0
2012-07-30	BLV	ETF	97.98	98.49	97.93	98.47	39500.0
2012-07-30	BMVP	ETF	15.44	15.51	15.43	15.46	5948.0
2012-07-30	BND	ETF	85.04	85.18	84.95	85.14	1772900.0
2012-07-30	BNO	ETF	37.745	37.8	37.63	37.63	20800.0
2012-07-30	BOIL	ETF	1111600.0	1160000.0	1109400.0	1139600.0	14.0
2012-07-30	BOND	ETF	107.05	107.329	107.0	107.31	490555.0

> showing 50 of 932 rows — these rows as CSV

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