PREVIEW / etf_daily / 2010-11-02

all etf daily files

  file:    by_date/etf_daily/2010/2010-11-02.parquet
  size:    34 KB
  rows:    800

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
2010-11-02	SPY	ETF	119.42	119.75	119.1	119.47	158345900.0
2010-11-02	QQQ	ETF	52.66	52.93	52.575	52.78	48137409.0
2010-11-02	IWM	ETF	70.67	71.31	70.27	71.27	55102800.0
2010-11-02	DIA	ETF	112.01	112.28	111.85	111.88	4073600.0
2010-11-02	GLD	ETF	132.44	132.59	131.88	132.49	9396900.0
2010-11-02	TLT	ETF	100.46	101.09	100.42	100.98	6537400.0
2010-11-02	AADR	ETF	29.02	29.02	29.02	29.02	200.0
2010-11-02	AAXJ	ETF	63.52	63.68	63.36	63.59	700700.0
2010-11-02	ACWI	ETF	45.33	45.45	45.24	45.32	266900.0
2010-11-02	ACWX	ETF	43.4	43.44	43.2301	43.36	141038.0
2010-11-02	ADRE	ETF	46.6	47.0	46.6	46.95	144483.0
2010-11-02	AFK	ETF	33.52	33.67	33.43	33.6699	25906.0
2010-11-02	AGG	ETF	108.47	108.47	108.33	108.42	1052600.0
2010-11-02	AGQ	ETF	213.14	214.26	210.12	213.08	235150.0
2010-11-02	AGZ	ETF	111.36	111.52	111.36	111.5	9251.0
2010-11-02	AIA	ETF	44.9	45.01	44.81	44.93	18365.0
2010-11-02	AIQ	ETF	21.55	22.9	21.5	22.25	138985.0
2010-11-02	AIS	ETF	1.41	1.44	1.38	1.4	354261.0
2010-11-02	AIVI	ETF	45.82	46.05	45.79	45.92	4000.0
2010-11-02	AMJ	ETF	35.65	35.947	35.6	35.88	684123.0
2010-11-02	AMLP	ETF	80.35	80.35	79.8	80.2	121660.0
2010-11-02	AOA	ETF	32.94	32.97	32.88	32.96	14900.0
2010-11-02	AOK	ETF	28.85	28.86	28.79	28.86	6859.0
2010-11-02	AOM	ETF	29.7355	29.79	29.7355	29.79	1072.0
2010-11-02	AOR	ETF	30.91	30.94	30.89	30.94	14787.0
2010-11-02	ARB	ETF	26.33	26.4999	25.93	26.32	221909.0
2010-11-02	BAB	ETF	26.16	26.28	26.16	26.24	163639.0
2010-11-02	BAL	ETF	65.9	68.07	65.6701	66.35	62985.0
2010-11-02	BALT	ETF	11.61	11.78	11.48	11.67	214100.0
2010-11-02	BBH	ETF	34.28	34.3133	34.1033	34.13	21600.0
2010-11-02	BICK	ETF	33.15	33.37	32.8919	33.354	84096.0
2010-11-02	BIL	ETF	91.7	91.72	91.68	91.68	226500.0
2010-11-02	BITS	ETF	27.72	28.8	27.72	28.04	3600.0
2010-11-02	BIV	ETF	86.7	86.7	86.54	86.67	56400.0
2010-11-02	BJK	ETF	31.75	32.02	31.74	32.01	15300.0
2010-11-02	BKF	ETF	50.3	50.45	50.07	50.32	105135.0
2010-11-02	BLV	ETF	83.45	83.99	83.45	83.94	32400.0
2010-11-02	BMVP	ETF	13.817	13.876	13.797	13.854	11692.0
2010-11-02	BND	ETF	82.63	82.63	82.55	82.61	870300.0
2010-11-02	BNE	ETF	11.37	11.37	11.34	11.37	338023.0
2010-11-02	BRF	ETF	61.24	61.96	60.91	61.79	526246.0
2010-11-02	BSCE	ETF	21.04	21.04	21.02	21.02	11689.0
2010-11-02	BSV	ETF	81.88	81.91	81.83	81.9	353100.0
2010-11-02	BTF	ETF	78.25	78.44999999999999	77.5	77.6	9249.6
2010-11-02	BWX	ETF	30.725	30.805	30.72	30.735	363858.0
2010-11-02	BWZ	ETF	37.9701	38.06	37.9	38.05	12773.0
2010-11-02	BZQ	ETF	2544.0	2587.2	2516.8	2536.0	364.5
2010-11-02	CEF	ETF	17.7	17.73	17.51	17.55	1279900.0
2010-11-02	CEW	ETF	23.26	23.2999	23.2	23.23	205345.0
2010-11-02	CGO	ETF	14.72	14.732	14.59	14.644	46007.0

> showing 50 of 800 rows — these rows as CSV

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