PREVIEW / etf_daily / 2010-06-01

all etf daily files

  file:    by_date/etf_daily/2010/2010-06-01.parquet
  size:    33 KB
  rows:    757

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-06-01	SPY	ETF	108.35	109.95	107.37	107.53	277909400.0
2010-06-01	QQQ	ETF	45.45	46.25	45.13	45.18	104242653.0
2010-06-01	IWM	ETF	65.6	66.47	64.19	64.24	88420300.0
2010-06-01	DIA	ETF	100.67	102.29	100.23	100.32	17009600.0
2010-06-01	GLD	ETF	119.88	120.25	119.63	119.91	12207800.0
2010-06-01	TLT	ETF	97.23	97.29	96.25	96.85	5536200.0
2010-06-01	AAXJ	ETF	51.0	52.17	50.83	50.87	6750200.0
2010-06-01	ACWI	ETF	39.18	39.71	38.75	38.8	137500.0
2010-06-01	ACWX	ETF	36.34	36.91	36.01	36.1	858830.0
2010-06-01	ADRE	ETF	39.51	40.32	39.25	39.29	147134.0
2010-06-01	AFK	ETF	28.44	29.09	28.41	28.51	15306.0
2010-06-01	AGG	ETF	105.33	105.61	105.29	105.56	1717500.0
2010-06-01	AGQ	ETF	126.24	128.66	124.24	124.24	118050.0
2010-06-01	AGZ	ETF	109.19	109.34	109.19	109.33	30642.0
2010-06-01	AIA	ETF	36.3	36.9299	36.18	36.29	11731.0
2010-06-01	AIQ	ETF	27.65	28.0	26.7	26.7	18119.0
2010-06-01	AIS	ETF	1.68	1.7	1.61	1.61	524222.0
2010-06-01	AIVI	ETF	36.96	37.94	36.96	37.01	8500.0
2010-06-01	AMJ	ETF	29.07	29.25	28.5	28.57	896714.0
2010-06-01	AOA	ETF	29.07	29.5	29.07	29.21	2900.0
2010-06-01	AOK	ETF	27.42	27.55	27.411	27.411	4039.0
2010-06-01	AOM	ETF	27.93	28.01	27.78	27.78	6277.0
2010-06-01	AOR	ETF	28.33	28.575	28.2736	28.2736	7664.0
2010-06-01	ARB	ETF	30.06	30.2391	28.86	28.92	224664.0
2010-06-01	BAB	ETF	26.0	26.0	25.87	26.0	382662.0
2010-06-01	BAL	ETF	37.48	37.69	37.422	37.422	4335.0
2010-06-01	BALT	ETF	12.32	12.44	11.97	12.21	254411.0
2010-06-01	BBH	ETF	29.13	29.57	28.8633	28.8733	155400.0
2010-06-01	BIB	ETF	5.7737	5.7737	5.5637	5.5663	3200.0
2010-06-01	BICK	ETF	26.91	27.11	26.68	26.7	4154.0
2010-06-01	BIL	ETF	91.7	91.72	91.7	91.72	550750.0
2010-06-01	BIS	ETF	11963.2	12336.0	11963.2	12336.0	2.5
2010-06-01	BITS	ETF	28.44	28.92	27.14	28.2	1036.0
2010-06-01	BIV	ETF	82.22	82.22	81.63	81.87	298300.0
2010-06-01	BJK	ETF	24.08	24.23	23.69	23.69	4000.0
2010-06-01	BKF	ETF	40.82	41.61	40.48	40.66	115967.0
2010-06-01	BLV	ETF	79.93	79.93	79.22	79.59	48300.0
2010-06-01	BMVP	ETF	12.3	12.48	12.18	12.18	58356.0
2010-06-01	BND	ETF	80.25	80.37	80.14	80.28	595400.0
2010-06-01	BNE	ETF	11.07	11.08	11.0	11.01	455352.0
2010-06-01	BRF	ETF	42.24	42.91	41.75	41.87	270841.0
2010-06-01	BSV	ETF	80.33	80.37	80.25	80.37	300600.0
2010-06-01	BTF	ETF	64.45	65.50049999999999	64.4	65.0	8064.0
2010-06-01	BWX	ETF	26.965	26.965	26.525	26.69	354080.0
2010-06-01	BWZ	ETF	33.42	33.65	33.339	33.5	15732.0
2010-06-01	BZQ	ETF	4419.2	4528.0	4241.6	4500.8	803.0
2010-06-01	CEF	ETF	15.06	15.18	15.06	15.08	1313700.0
2010-06-01	CEW	ETF	21.25	21.35	21.194	21.2448	73222.0
2010-06-01	CGO	ETF	13.07	13.27	12.94	13.0	29294.0
2010-06-01	CGW	ETF	16.66	16.8919	16.48	16.48	60155.0

> showing 50 of 757 rows — these rows as CSV

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