PREVIEW / etf_daily / 2009-04-08

all etf daily files

  file:    by_date/etf_daily/2009/2009-04-08.parquet
  size:    28 KB
  rows:    641

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-04-08	SPY	ETF	82.06	82.94	81.54	82.53	230402800.0
2009-04-08	QQQ	ETF	31.72	32.15	31.49	31.95	126125970.0
2009-04-08	IWM	ETF	43.51	44.23	43.19	44.06	60265100.0
2009-04-08	DIA	ETF	78.18	78.94	77.57	78.37	15719000.0
2009-04-08	GLD	ETF	87.18	87.52	86.26	86.61	12226200.0
2009-04-08	TLT	ETF	103.07	103.86	102.95	103.65	1007800.0
2009-04-08	AAXJ	ETF	35.6	35.69	35.1	35.64	49200.0
2009-04-08	ACWI	ETF	29.7	29.97	29.55	29.73	42900.0
2009-04-08	ACWX	ETF	27.92	28.16	27.7784	28.03	57259.0
2009-04-08	ADRE	ETF	29.3	29.47	28.93	29.25	197733.0
2009-04-08	AFK	ETF	20.4	20.72	20.37	20.48	1679.0
2009-04-08	AGG	ETF	100.43	100.72	100.3	100.57	528400.0
2009-04-08	AGQ	ETF	71.2	71.46	68.7	69.62	89900.0
2009-04-08	AGZ	ETF	108.15	108.38	107.6849	108.38	11779.0
2009-04-08	AIA	ETF	26.72	26.72	26.4184	26.4184	6699.0
2009-04-08	AIQ	ETF	35.65	37.3	35.5	37.25	31940.0
2009-04-08	AIS	ETF	0.42	0.44	0.4	0.42	81820.0
2009-04-08	AIVI	ETF	29.84	30.12	29.62	29.82	5600.0
2009-04-08	AMJ	ETF	19.4	19.55	19.4	19.55	17801.0
2009-04-08	AOA	ETF	22.43	22.51	22.39	22.49	6100.0
2009-04-08	AOK	ETF	24.8594	24.93	24.8594	24.93	1140.0
2009-04-08	AOM	ETF	24.1994	24.22	24.08	24.0801	2869.0
2009-04-08	AOR	ETF	23.53	23.53	23.41	23.41	5473.0
2009-04-08	ARB	ETF	16.13	16.53	15.89	16.5	238118.0
2009-04-08	BAL	ETF	27.12	27.64	27.12	27.5512	4300.0
2009-04-08	BBH	ETF	29.8833	30.3633	29.77	30.3633	393900.0
2009-04-08	BIL	ETF	91.74	91.76	91.68	91.74	150150.0
2009-04-08	BITS	ETF	18.28	18.2804	17.4	18.28	5675.0
2009-04-08	BIV	ETF	75.95	76.18	75.7	76.15	54600.0
2009-04-08	BJK	ETF	16.87	17.86	16.08	16.22	6300.0
2009-04-08	BKF	ETF	27.31	27.76	27.2899	27.67	105902.0
2009-04-08	BLV	ETF	72.15	72.77	72.15	72.62	12700.0
2009-04-08	BMVP	ETF	10.0267	10.1933	10.0061	10.1567	25210.0
2009-04-08	BND	ETF	76.84	77.06	76.75	77.06	260600.0
2009-04-08	BNE	ETF	3.08	3.39	3.03	3.36	247449.0
2009-04-08	BOSS	ETF	11.3	11.47	11.2	11.3	100.0
2009-04-08	BSV	ETF	78.48	78.54	78.27	78.48	276700.0
2009-04-08	BTF	ETF	43.15	45.05	43.05	43.949999999999996	8179.200000000001
2009-04-08	BWX	ETF	25.5	25.6	25.4454	25.5437	104164.0
2009-04-08	BWZ	ETF	32.99	32.99	32.99	32.99	545.0
2009-04-08	CBON	ETF	2.4	2.43	2.16	2.17	19430.0
2009-04-08	CEF	ETF	10.56	11.09	10.45	10.94	7494000.0
2009-04-08	CGO	ETF	9.1988	9.2837	9.12	9.19	9252.0
2009-04-08	CGW	ETF	12.56	12.6409	12.4508	12.55	21886.0
2009-04-08	CHB	ETF	0.53	0.54	0.48	0.51	1007764.0
2009-04-08	CHI	ETF	8.71	8.77	8.6	8.73	95504.0
2009-04-08	CHIC	ETF	8.94	9.22	8.94	9.16	481524.0
2009-04-08	CHW	ETF	5.71	5.78	5.53	5.77	202142.0
2009-04-08	CHY	ETF	8.3	8.5	8.24	8.5	144758.0
2009-04-08	CMF	ETF	51.56	51.885	51.56	51.75	11068.0

> showing 50 of 641 rows — these rows as CSV

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