PREVIEW / etf_daily / 2008-04-28

all etf daily files

  file:    by_date/etf_daily/2008/2008-04-28.parquet
  size:    26 KB
  rows:    584

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
2008-04-28	SPY	ETF	139.88	140.25	139.38	139.63	105610200.0
2008-04-28	QQQ	ETF	47.25	47.62	47.13	47.24	71243949.0
2008-04-28	IWM	ETF	71.93	72.7	71.59	72.38	35470700.0
2008-04-28	DIA	ETF	128.88	129.28	127.69	128.79	7899600.0
2008-04-28	GLD	ETF	87.88	88.4	87.67	87.69	8071700.0
2008-04-28	TLT	ETF	91.53	92.35	91.41	92.1	1883900.0
2008-04-28	ACWI	ETF	53.5	53.5	52.96	53.15	16100.0
2008-04-28	ACWX	ETF	54.04	55.2	54.04	54.56	4862.0
2008-04-28	ADRE	ETF	54.2	54.2	53.63	53.63	303074.0
2008-04-28	AGG	ETF	101.54	101.86	101.43	101.83	513500.0
2008-04-28	AIA	ETF	47.97	48.2899	47.5199	47.836	11163.0
2008-04-28	AIQ	ETF	40.5	41.05	40.1505	40.65	29802.0
2008-04-28	AIS	ETF	0.86	0.88	0.83	0.87	128685.0
2008-04-28	AIVI	ETF	67.02	67.34	66.96	66.96	12900.0
2008-04-28	ARB	ETF	48.63	49.31	48.48	48.68	147023.0
2008-04-28	BBH	ETF	55.9133	56.4033	55.8533	56.1767	244800.0
2008-04-28	BIL	ETF	91.76	91.8	91.68	91.7	35900.0
2008-04-28	BITS	ETF	24.04	24.12	23.8	24.0	3875.0
2008-04-28	BIV	ETF	77.98	78.17	77.86	78.1	22100.0
2008-04-28	BJK	ETF	38.31	38.31	38.31	38.31	100.0
2008-04-28	BKF	ETF	56.6	56.6	55.29	55.36	72808.0
2008-04-28	BLV	ETF	75.17	76.02	75.17	75.97	7000.0
2008-04-28	BMVP	ETF	16.1933	16.2207	16.1	16.16	29055.0
2008-04-28	BND	ETF	76.76	77.0	76.65	77.0	129600.0
2008-04-28	BNE	ETF	16.43	17.04	16.35	16.97	88310.0
2008-04-28	BRF	ETF	14.66	14.69	14.66	14.69	5300.0
2008-04-28	BSV	ETF	77.78	78.04	77.78	77.98	45200.0
2008-04-28	BTF	ETF	101.64999999999999	102.85	101.64999999999999	102.85	3609.8
2008-04-28	BWX	ETF	27.975	28.365	27.125	28.064	231128.0
2008-04-28	CBON	ETF	12.33	12.33	11.7	11.82	73225.0
2008-04-28	CDL	ETF	1.26	1.33	1.25	1.31	883084.0
2008-04-28	CEF	ETF	12.21	12.37	12.21	12.25	794400.0
2008-04-28	CGO	ETF	16.84	16.84	16.64	16.7	21610.0
2008-04-28	CGW	ETF	24.63	24.96	24.6	24.88	79227.0
2008-04-28	CHB	ETF	10.4	11.1	10.21	10.95	2032547.0
2008-04-28	CHI	ETF	15.39	15.4599	15.29	15.3001	74689.0
2008-04-28	CHIC	ETF	16.14	16.21	15.6	16.02	599500.0
2008-04-28	CHW	ETF	11.78	11.92	11.78	11.9	82453.0
2008-04-28	CHY	ETF	14.23	14.24	14.01	14.05	120473.0
2008-04-28	CMF	ETF	52.5	52.66	52.332	52.5	12620.0
2008-04-28	CN	ETF	59.48	60.38	59.06	59.57	260132.0
2008-04-28	CNXT	ETF	0.46	0.479	0.44	0.46	3344642.0
2008-04-28	COW	ETF	43.92	43.95	43.4899	43.76	67261.0
2008-04-28	CPI	ETF	18.7	18.75	18.5	18.5	700.0
2008-04-28	CPST	ETF	2.77	2.82	2.75	2.79	1986106.0
2008-04-28	CSA	ETF	16.43	17.28	16.41	17.21	36250.0
2008-04-28	CSB	ETF	22.9	22.99	22.0	22.0	20800.0
2008-04-28	CSD	ETF	23.61	23.69	23.53	23.6	8700.0
2008-04-28	CSQ	ETF	12.55	12.75	12.55	12.72	246654.0
2008-04-28	CUT	ETF	21.62	21.91	21.62	21.8	25100.0

> showing 50 of 584 rows — these rows as CSV

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