PREVIEW / etf_daily / 2011-04-19

all etf daily files

  file:    by_date/etf_daily/2011/2011-04-19.parquet
  size:    35 KB
  rows:    836

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-04-19	SPY	ETF	130.76	131.35	130.44	131.31	124258800.0
2011-04-19	QQQ	ETF	56.39	56.6	56.1	56.6	38608391.0
2011-04-19	IWM	ETF	82.41	82.7	81.67	82.15	31991000.0
2011-04-19	DIA	ETF	121.96	122.49	121.73	122.39	5007200.0
2011-04-19	GLD	ETF	145.73	146.24	145.18	145.93	10950100.0
2011-04-19	TLT	ETF	92.86	93.28	92.76	93.28	5295100.0
2011-04-19	AADR	ETF	30.62	30.93	30.62	30.92	1300.0
2011-04-19	AAXJ	ETF	63.26	63.43	62.99	63.41	151700.0
2011-04-19	ACWI	ETF	48.18	48.3	48.01	48.28	559400.0
2011-04-19	ACWX	ETF	45.21	45.41	45.1099	45.38	46514.0
2011-04-19	ADRE	ETF	47.47	47.669	47.28	47.63	41299.0
2011-04-19	AFK	ETF	32.81	33.38	32.6601	33.38	48057.0
2011-04-19	AGG	ETF	105.81	105.88	105.75	105.84	470800.0
2011-04-19	AGQ	ETF	588.74	612.84	579.28	610.24	970800.0
2011-04-19	AGZ	ETF	109.75	109.753	109.66	109.75	9377.0
2011-04-19	AIA	ETF	47.62	47.82	47.6	47.73	43867.0
2011-04-19	AIQ	ETF	22.85	23.0	22.65	22.7	20763.0
2011-04-19	AIS	ETF	1.67	1.69	1.62	1.64	209711.0
2011-04-19	AIVI	ETF	47.14	47.35	47.05	47.35	12000.0
2011-04-19	AMJ	ETF	37.95	38.05	37.85	37.975	455376.0
2011-04-19	AMLP	ETF	82.0	82.15	81.8	82.1	82240.0
2011-04-19	AOA	ETF	35.57	35.7	35.55	35.69	8900.0
2011-04-19	AOK	ETF	29.2144	29.27	29.19	29.27	6125.0
2011-04-19	AOM	ETF	30.54	30.58	30.52	30.5752	8377.0
2011-04-19	AOR	ETF	32.38	32.49	32.3501	32.49	10097.0
2011-04-19	ARB	ETF	35.81	35.839	35.23	35.28	138479.0
2011-04-19	ARGT	ETF	29.68	30.08	29.68	30.08	700.0
2011-04-19	ASEA	ETF	16.17	16.19	16.12	16.19	3000.0
2011-04-19	BAB	ETF	25.5	25.58	25.46	25.548	99304.0
2011-04-19	BAL	ETF	96.38	96.62	94.05	94.71	134435.0
2011-04-19	BALT	ETF	8.14	8.329	7.87	8.23	217582.0
2011-04-19	BBH	ETF	36.3567	36.45	36.1633	36.4467	41100.0
2011-04-19	BIB	ETF	9.2963	9.2963	8.939	9.0265	60912.0
2011-04-19	BICK	ETF	34.05	34.18	33.94	34.07	16444.0
2011-04-19	BIL	ETF	91.7	91.72	91.7	91.7	110650.0
2011-04-19	BITS	ETF	25.0	25.2	25.0	25.2	350.0
2011-04-19	BIV	ETF	82.64	82.7	82.53	82.6	125100.0
2011-04-19	BJK	ETF	33.96	33.96	33.56	33.68	5000.0
2011-04-19	BKF	ETF	49.75	50.09	49.73	49.86	497354.0
2011-04-19	BKLN	ETF	25.25	25.26	25.23	25.25	153400.0
2011-04-19	BLV	ETF	78.97	79.43	78.97	79.21	22800.0
2011-04-19	BMVP	ETF	15.45	15.52	15.45	15.5	3919.0
2011-04-19	BND	ETF	80.46	80.54	80.42	80.49	531200.0
2011-04-19	BNO	ETF	39.87	40.615	39.785	40.275	87600.0
2011-04-19	BRF	ETF	57.64	58.45	57.48	58.43	219866.0
2011-04-19	BSCE	ETF	20.97	21.03	20.97	21.0299	4877.0
2011-04-19	BSV	ETF	80.45	80.51	80.42	80.51	1501800.0
2011-04-19	BTF	ETF	81.99999999999999	82.4995	81.8	82.35	2162.4
2011-04-19	BWX	ETF	30.16	30.315	30.16	30.265	196516.0
2011-04-19	BWZ	ETF	38.88	38.88	38.58	38.82	175352.0

> showing 50 of 836 rows — these rows as CSV

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