PREVIEW / etf_daily / 2010-04-09

all etf daily files

  file:    by_date/etf_daily/2010/2010-04-09.parquet
  size:    32 KB
  rows:    748

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-04-09	SPY	ETF	119.02	119.6	118.8	119.55	133006500.0
2010-04-09	QQQ	ETF	48.77	49.05	48.635	49.03	54227221.0
2010-04-09	IWM	ETF	69.94	70.26	69.5	70.25	53070100.0
2010-04-09	DIA	ETF	109.52	110.08	109.41	110.06	6013100.0
2010-04-09	GLD	ETF	113.09	114.07	112.74	113.64	16427800.0
2010-04-09	TLT	ETF	88.61	89.06	88.41	88.98	2311300.0
2010-04-09	AAXJ	ETF	58.88	58.95	58.58	58.86	558300.0
2010-04-09	ACWI	ETF	44.53	44.72	44.39	44.68	150100.0
2010-04-09	ACWX	ETF	42.45	42.78	42.448	42.75	115932.0
2010-04-09	ADRE	ETF	45.43	45.56	45.3	45.56	57421.0
2010-04-09	AFK	ETF	32.92	32.96	32.58	32.7	21710.0
2010-04-09	AGG	ETF	103.71	103.82	103.6	103.78	414200.0
2010-04-09	AGQ	ETF	126.28	128.44	126.28	127.52	246000.0
2010-04-09	AGZ	ETF	107.9079	107.96	107.77	107.82	22797.0
2010-04-09	AIA	ETF	42.0	42.09	41.65	42.09	17774.0
2010-04-09	AIQ	ETF	27.5	27.55	26.75	26.85	19400.0
2010-04-09	AIS	ETF	1.72	1.73	1.66	1.66	611030.0
2010-04-09	AIVI	ETF	43.39	43.64	43.24	43.64	17400.0
2010-04-09	AMJ	ETF	31.35	31.44	31.127	31.44	179848.0
2010-04-09	AOA	ETF	32.02	32.25	32.02	32.25	6800.0
2010-04-09	AOK	ETF	27.96	28.01	27.93	28.01	18125.0
2010-04-09	AOM	ETF	28.93	29.0099	28.924	29.0099	4537.0
2010-04-09	AOR	ETF	30.08	30.18	30.04	30.18	5727.0
2010-04-09	ARB	ETF	26.59	26.99	26.42	26.8	202992.0
2010-04-09	BAB	ETF	24.94	24.99	24.8	24.98	129416.0
2010-04-09	BAL	ETF	37.93	37.93	37.57	37.75	2574.0
2010-04-09	BALT	ETF	13.8	14.0	13.75	13.99	149569.0
2010-04-09	BBH	ETF	34.61	34.79	34.59	34.7767	40500.0
2010-04-09	BIB	ETF	7.5012	7.5088	7.485	7.5088	8544.0
2010-04-09	BIL	ETF	91.7	91.7	91.68	91.68	195150.0
2010-04-09	BIS	ETF	9616.0	9616.0	9616.0	9616.0	0.625
2010-04-09	BITS	ETF	31.88	32.64	31.64	32.64	1025.0
2010-04-09	BIV	ETF	79.81	79.97	79.67	79.97	135100.0
2010-04-09	BJK	ETF	27.0	27.24	26.95	27.24	34000.0
2010-04-09	BKF	ETF	47.97	48.45	47.97	48.45	339193.0
2010-04-09	BLV	ETF	76.55	76.74	76.23	76.66	18600.0
2010-04-09	BMVP	ETF	13.4	13.48	13.4	13.48	8683.0
2010-04-09	BND	ETF	78.86	78.98	78.79	78.94	338100.0
2010-04-09	BNE	ETF	11.17	11.19	11.12	11.13	971338.0
2010-04-09	BRF	ETF	46.03	46.35	45.85	46.07	303588.0
2010-04-09	BSV	ETF	79.73	79.76	79.64	79.76	360600.0
2010-04-09	BTF	ETF	74.05	75.35	74.05	74.89999999999999	6293.8
2010-04-09	BWX	ETF	27.77	27.86	27.7055	27.82	237350.0
2010-04-09	BWZ	ETF	35.5101	35.61	35.49	35.61	11029.0
2010-04-09	BZQ	ETF	3382.4	3444.8	3382.4	3392.0	156.0
2010-04-09	CEF	ETF	14.57	14.74	14.53	14.7	1146000.0
2010-04-09	CEW	ETF	22.4	22.46	22.38	22.45	69762.0
2010-04-09	CGO	ETF	15.15	15.15	14.9	15.0301	22033.0
2010-04-09	CGW	ETF	18.82	18.8845	18.73	18.85	175838.0
2010-04-09	CHI	ETF	12.7	12.7299	12.61	12.64	281153.0

> showing 50 of 748 rows — these rows as CSV

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