PREVIEW / etf_daily / 2010-05-26

all etf daily files

  file:    by_date/etf_daily/2010/2010-05-26.parquet
  size:    33 KB
  rows:    755

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-05-26	SPY	ETF	108.48	109.47	106.85	107.17	349719300.0
2010-05-26	QQQ	ETF	44.93	45.57	44.12	44.2	140203134.0
2010-05-26	IWM	ETF	64.44	65.95	63.98	64.35	104172900.0
2010-05-26	DIA	ETF	100.88	101.8	99.52	99.68	18499900.0
2010-05-26	GLD	ETF	118.58	119.08	118.32	118.47	13153500.0
2010-05-26	TLT	ETF	98.22	98.4	97.4	98.29	12644800.0
2010-05-26	AAXJ	ETF	51.23	51.42	50.3	50.43	393100.0
2010-05-26	ACWI	ETF	38.89	39.13	38.13	38.23	441900.0
2010-05-26	ACWX	ETF	35.81	36.02	35.18	35.24	118509.0
2010-05-26	ADRE	ETF	38.35	39.2	38.04	38.2	246468.0
2010-05-26	AFK	ETF	27.9	28.0699	27.85	27.85	18577.0
2010-05-26	AGG	ETF	105.91	105.94	105.7	105.85	886400.0
2010-05-26	AGQ	ETF	122.06	124.54	120.5	120.58	164350.0
2010-05-26	AGZ	ETF	109.15	109.4	108.92	109.4	27716.0
2010-05-26	AIA	ETF	36.4	36.41	35.575	35.63	36306.0
2010-05-26	AIQ	ETF	26.15	26.95	26.1	26.2	19679.0
2010-05-26	AIS	ETF	1.54	1.55	1.51	1.52	183449.0
2010-05-26	AIVI	ETF	36.31	36.68	35.8	35.8	27200.0
2010-05-26	AMJ	ETF	28.49	28.81	28.28	28.49	665493.0
2010-05-26	AOA	ETF	28.89	29.14	28.59	28.59	3700.0
2010-05-26	AOK	ETF	27.39	27.49	27.3	27.3	36073.0
2010-05-26	AOM	ETF	27.77	27.8799	27.736	27.76	15403.0
2010-05-26	AOR	ETF	28.18	28.3895	28.06	28.06	11860.0
2010-05-26	ARB	ETF	29.33	30.44	29.33	29.71	166285.0
2010-05-26	BAB	ETF	26.09	26.12	25.85	25.95	685323.0
2010-05-26	BAL	ETF	39.03	39.06	38.97	38.97	1950.0
2010-05-26	BALT	ETF	12.01	12.37	11.92	12.1	148614.0
2010-05-26	BBH	ETF	29.3467	29.5967	28.63	28.6433	202800.0
2010-05-26	BIB	ETF	5.6887	5.7325	5.5263	5.5312	21312.0
2010-05-26	BICK	ETF	26.2	26.25	25.85	25.85	4362.0
2010-05-26	BIL	ETF	91.72	91.74	91.7	91.74	662100.0
2010-05-26	BIS	ETF	11979.2	12468.8	11945.6	12464.0	16.9
2010-05-26	BITS	ETF	28.68	28.68	27.8004	28.2	2318.0
2010-05-26	BIV	ETF	82.47	82.47	82.0	82.37	253900.0
2010-05-26	BJK	ETF	23.42	23.6	22.96	22.98	16000.0
2010-05-26	BKF	ETF	39.5	40.5	39.24	39.4099	157334.0
2010-05-26	BLV	ETF	80.92	80.93	80.16	80.73	68200.0
2010-05-26	BMVP	ETF	12.2767	12.4385	12.1833	12.1833	29303.0
2010-05-26	BND	ETF	80.58	80.62	80.37	80.61	700200.0
2010-05-26	BNE	ETF	11.01	11.04	10.99	11.01	580517.0
2010-05-26	BRF	ETF	39.95	40.88	39.6	39.86	239618.0
2010-05-26	BSV	ETF	80.46	80.47	80.3	80.44	403700.0
2010-05-26	BTF	ETF	65.44999999999999	65.8	64.35	64.35	6341.0
2010-05-26	BWX	ETF	26.35	26.5925	26.01	26.31	468446.0
2010-05-26	BWZ	ETF	33.1	33.52	33.09	33.275	106332.0
2010-05-26	BZQ	ETF	4838.4	5051.2	4580.8	4956.8	1381.0
2010-05-26	CEF	ETF	14.93	15.03	14.88	14.9	1351700.0
2010-05-26	CEW	ETF	21.11	21.1881	21.0055	21.08	85075.0
2010-05-26	CGO	ETF	12.61	12.74	12.58	12.67	38135.0
2010-05-26	CGW	ETF	16.42	16.464	16.15	16.15	39075.0

> showing 50 of 755 rows — these rows as CSV

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