PREVIEW / etf_daily / 2008-09-05

all etf daily files

  file:    by_date/etf_daily/2008/2008-09-05.parquet
  size:    27 KB
  rows:    610

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-09-05	SPY	ETF	123.29	124.95	122.0	124.42	289503400.0
2008-09-05	QQQ	ETF	43.3	43.78	42.81	43.45	247977452.0
2008-09-05	IWM	ETF	71.54	72.11	70.14	71.64	122285000.0
2008-09-05	DIA	ETF	111.58	112.63	110.57	112.35	31555500.0
2008-09-05	GLD	ETF	80.08	80.27	78.17	78.98	10738700.0
2008-09-05	TLT	ETF	96.02	96.31	95.41	95.48	4167800.0
2008-09-05	AAXJ	ETF	45.23	46.0	45.08	46.0	6100.0
2008-09-05	ACWI	ETF	44.45	44.52	43.62	44.4	51600.0
2008-09-05	ACWX	ETF	42.65	42.74	42.096	42.73	40901.0
2008-09-05	ADRE	ETF	40.56	41.234	39.92	40.74	1009469.0
2008-09-05	AFK	ETF	37.7	37.7	36.31	36.31	5200.0
2008-09-05	AGG	ETF	101.24	101.38	100.74	100.74	667100.0
2008-09-05	AIA	ETF	35.53	35.58	35.0	35.562	399999.0
2008-09-05	AIQ	ETF	57.5	57.5	55.9	56.65	42387.0
2008-09-05	AIS	ETF	0.76	0.76	0.7205	0.75	32046.0
2008-09-05	AIVI	ETF	53.18	53.27	52.4	53.2	14700.0
2008-09-05	ARB	ETF	47.75	48.17	47.18	47.89	163963.0
2008-09-05	BAL	ETF	42.25	42.34	41.0	41.01	21350.0
2008-09-05	BBH	ETF	63.7433	64.28	63.18	64.0333	505500.0
2008-09-05	BIL	ETF	91.72	91.76	91.72	91.76	83600.0
2008-09-05	BITS	ETF	22.72	22.72	21.68	22.2	3278.0
2008-09-05	BIV	ETF	77.49	77.5	77.0	77.14	98700.0
2008-09-05	BJK	ETF	28.5	28.5	27.7	27.7	4700.0
2008-09-05	BKF	ETF	39.9	40.144	38.41	40.144	68375.0
2008-09-05	BLV	ETF	75.7	75.74	75.09	75.19	8000.0
2008-09-05	BMVP	ETF	14.43	14.47	14.223	14.467	17362.0
2008-09-05	BND	ETF	76.65	76.78	76.4	76.46	174100.0
2008-09-05	BNE	ETF	11.84	11.99	11.72	11.86	216352.0
2008-09-05	BRF	ETF	14.83	14.83	14.49	14.79	3200.0
2008-09-05	BSV	ETF	77.88	77.88	77.64	77.65	79200.0
2008-09-05	BTF	ETF	82.89999999999999	84.25	82.24999999999999	84.0	9070.2
2008-09-05	BWX	ETF	26.31	26.4	26.2	26.2	218280.0
2008-09-05	CBON	ETF	5.28	5.99	5.17	5.65	127356.0
2008-09-05	CDL	ETF	0.97	0.97	0.86	0.89	850339.0
2008-09-05	CEF	ETF	10.27	10.28	9.73	9.99	1092800.0
2008-09-05	CGO	ETF	13.96	13.96	13.8	13.92	21879.0
2008-09-05	CGW	ETF	21.5	22.05	21.34	21.57	1446403.0
2008-09-05	CHB	ETF	4.65	4.96	4.32	4.9	1092689.0
2008-09-05	CHI	ETF	12.91	12.94	12.75	12.81	116593.0
2008-09-05	CHIC	ETF	12.48	12.91	12.41	12.73	198920.0
2008-09-05	CHW	ETF	10.35	10.35	10.05	10.16	172578.0
2008-09-05	CHY	ETF	12.68	12.69	12.51	12.6	135291.0
2008-09-05	CMF	ETF	52.0554	52.145	52.055	52.0685	4122.0
2008-09-05	CN	ETF	47.87	48.52	46.94	48.44	399353.0
2008-09-05	CNXT	ETF	5.27	5.5	5.27	5.39	492685.0
2008-09-05	COW	ETF	41.82	41.96	41.6	41.77	125397.0
2008-09-05	CPI	ETF	24.65	24.65	23.9	24.3	1800.0
2008-09-05	CPST	ETF	2.01	2.15	1.91	2.09	6074889.0
2008-09-05	CSA	ETF	18.31	18.42	18.05	18.25	30179.0
2008-09-05	CSB	ETF	19.08	19.08	18.7	19.0	29855.0

> showing 50 of 610 rows — these rows as CSV

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