PREVIEW / etf_daily / 2009-08-17

all etf daily files

  file:    by_date/etf_daily/2009/2009-08-17.parquet
  size:    29 KB
  rows:    672

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
2009-08-17	SPY	ETF	98.85	98.95	98.11	98.31	237667500.0
2009-08-17	QQQ	ETF	38.97	39.01	38.46	38.48	131797185.0
2009-08-17	IWM	ETF	55.26	55.37	54.68	54.82	48853300.0
2009-08-17	DIA	ETF	91.87	91.98	91.4	91.61	12121400.0
2009-08-17	GLD	ETF	91.49	91.86	91.28	91.61	6830800.0
2009-08-17	TLT	ETF	93.95	94.75	93.87	94.73	3569700.0
2009-08-17	AAXJ	ETF	47.7	47.99	42.02	47.29	831800.0
2009-08-17	ACWI	ETF	37.58	37.99	37.0	37.15	147400.0
2009-08-17	ACWX	ETF	36.16	36.16	35.89	36.0	45018.0
2009-08-17	ADRE	ETF	37.3	37.3	36.77	36.9499	144688.0
2009-08-17	AFK	ETF	27.01	27.22	26.89	27.011	30968.0
2009-08-17	AGG	ETF	103.33	103.59	103.04	103.56	631300.0
2009-08-17	AGQ	ETF	83.78	84.2	81.3	83.42	161400.0
2009-08-17	AGZ	ETF	107.85	108.04	107.6474	107.6601	15276.0
2009-08-17	AIA	ETF	35.05	35.05	34.06	34.52	36058.0
2009-08-17	AIQ	ETF	25.5	26.15	25.5	25.75	70163.0
2009-08-17	AIS	ETF	0.94	0.96	0.9	0.95	243276.0
2009-08-17	AIVI	ETF	38.34	38.34	37.78	38.06	21700.0
2009-08-17	AMJ	ETF	24.29	24.98	23.58	23.95	182878.0
2009-08-17	AOA	ETF	27.04	27.04	26.62	26.9	6100.0
2009-08-17	AOK	ETF	26.34	26.34	26.18	26.196	4650.0
2009-08-17	AOM	ETF	26.53	26.59	26.45	26.5682	2697.0
2009-08-17	AOR	ETF	26.96	26.96	26.72	26.76	3487.0
2009-08-17	ARB	ETF	15.89	16.48	15.84	16.38	203417.0
2009-08-17	BAL	ETF	31.11	31.11	30.4	30.9	7755.0
2009-08-17	BBH	ETF	32.78	32.78	32.4967	32.5767	417300.0
2009-08-17	BIL	ETF	91.72	91.74	91.7	91.7	115200.0
2009-08-17	BITS	ETF	21.04	21.56	20.8	21.56	4751.0
2009-08-17	BIV	ETF	78.95	79.01	78.65	79.0	62300.0
2009-08-17	BJK	ETF	23.0	23.0	22.0	22.42	28900.0
2009-08-17	BKF	ETF	37.21	37.37	36.6	36.96	437361.0
2009-08-17	BLV	ETF	76.88	77.0	76.59	77.0	24200.0
2009-08-17	BMVP	ETF	11.43	11.43	11.25	11.4	30465.0
2009-08-17	BND	ETF	78.62	78.62	78.25	78.58	483900.0
2009-08-17	BNE	ETF	6.06	6.06	5.53	5.98	290505.0
2009-08-17	BOSS	ETF	18.96	18.96	18.28	18.3	100.0
2009-08-17	BRF	ETF	33.54	34.0399	32.18	33.87	389140.0
2009-08-17	BSV	ETF	79.61	79.74	79.54	79.56	221200.0
2009-08-17	BTF	ETF	57.85	58.000499999999995	56.25	56.95	19240.2
2009-08-17	BWX	ETF	28.08	28.08	27.725	27.925	268570.0
2009-08-17	BWZ	ETF	36.08	36.08	35.65	35.79	14144.0
2009-08-17	BZQ	ETF	7593.6	7675.2	7443.2	7526.4	55.0
2009-08-17	CBON	ETF	0.28	0.43	0.23	0.36	6258996.0
2009-08-17	CEF	ETF	11.63	11.86	11.6	11.72	1098200.0
2009-08-17	CEW	ETF	21.05	21.09	21.0	21.0	29409.0
2009-08-17	CGO	ETF	13.15	13.15	12.66	12.69	32643.0
2009-08-17	CGW	ETF	16.06	16.13	15.77	15.84	51852.0
2009-08-17	CHB	ETF	0.45	0.45	0.39	0.42	2191765.0
2009-08-17	CHI	ETF	11.1	11.13	10.82	10.82	195739.0
2009-08-17	CHIC	ETF	13.85	13.94	13.56	13.66	202310.0

> showing 50 of 672 rows — these rows as CSV

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