PREVIEW / etf_daily / 2005-11-01

all etf daily files

  file:    by_date/etf_daily/2005/2005-11-01.parquet
  size:    15 KB
  rows:    280

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
2005-11-01	SPY	ETF	120.58	120.9	120.22	120.49	66365100.0
2005-11-01	QQQ	ETF	38.76	39.01	38.71	38.84	73633507.0
2005-11-01	IWM	ETF	64.05	64.37	63.6	64.1	30221400.0
2005-11-01	DIA	ETF	104.25	104.48	103.97	104.14	5384200.0
2005-11-01	GLD	ETF	46.07	46.07	45.65	45.73	3483400.0
2005-11-01	TLT	ETF	89.43	89.65	89.09	89.28	647100.0
2005-11-01	AAA	ETF	57.66	57.94	57.57	57.94	9900.0
2005-11-01	ADRE	ETF	103.25	105.0	103.25	104.8	13580.0
2005-11-01	AFK	ETF	25.5	25.52	25.39	25.5	3200.0
2005-11-01	AGG	ETF	100.08	100.11	99.77	99.88	428000.0
2005-11-01	AIQ	ETF	34.3	35.0995	33.55	34.4	20240.0
2005-11-01	AIS	ETF	1.17	1.2	1.13	1.1401	154200.0
2005-11-01	ARB	ETF	37.26	37.6	37.04	37.4	209700.0
2005-11-01	BAB	ETF	54.59	54.77	53.7701	54.0	13400.0
2005-11-01	BBC	ETF	6.7001	6.79	6.59	6.65	21900.0
2005-11-01	BBH	ETF	64.0833	64.99	63.7867	64.5067	2026800.0
2005-11-01	BCM	ETF	61.41	62.13	61.2	62.13	21400.0
2005-11-01	BITS	ETF	10.6	10.8	10.32	10.44	3124.0
2005-11-01	BKF	ETF	21.4	21.4	18.5	19.0	666800.0
2005-11-01	BNE	ETF	14.28	14.5	14.17	14.5	394400.0
2005-11-01	BRF	ETF	15.38	15.38	15.28	15.32	5800.0
2005-11-01	BTF	ETF	84.74999999999999	84.74999999999999	84.3	84.64999999999999	4080.0
2005-11-01	CBON	ETF	32.3	32.72	32.25	32.38	10369.0
2005-11-01	CDL	ETF	13.74	13.85	13.6	13.73	300400.0
2005-11-01	CEF	ETF	5.72	5.75	5.62	5.63	525700.0
2005-11-01	CEW	ETF	25.75	25.75	25.75	25.75	100.0
2005-11-01	CGO	ETF	15.01	15.01	15.0	15.01	28400.0
2005-11-01	CHB	ETF	13.7	13.92	13.31	13.55	471900.0
2005-11-01	CHI	ETF	19.6	19.74	19.56	19.72	100100.0
2005-11-01	CHIC	ETF	17.66	17.81	17.15	17.35	493874.0
2005-11-01	CHIR	ETF	44.1501	44.2599	44.13	44.2299	5024452.0
2005-11-01	CHY	ETF	15.44	15.62	15.41	15.51	90700.0
2005-11-01	CIL	ETF	25.95	25.95	25.95	25.95	400.0
2005-11-01	CN	ETF	32.95	32.95	32.32	32.4	21700.0
2005-11-01	CNXT	ETF	1.93	1.97	1.92	1.97	5035193.0
2005-11-01	CPST	ETF	2.45	2.62	2.45	2.54	2410570.0
2005-11-01	CSA	ETF	17.25	17.4	17.2	17.2	93500.0
2005-11-01	CSB	ETF	28.69	28.94	28.58	28.61	4400.0
2005-11-01	CSQ	ETF	13.63	13.69	13.54	13.62	211200.0
2005-11-01	CTEC	ETF	43.449999999999996	43.449999999999996	42.449999999999996	42.5	12127.6
2005-11-01	CURE	ETF	0.0862	0.0875	0.0737	0.075	3876912.0
2005-11-01	CYB	ETF	3.21	3.26	3.21	3.26	400.0
2005-11-01	DGT	ETF	63.65	63.77	63.57	63.6	2600.0
2005-11-01	DIV	ETF	12.01	12.4	12.01	12.32	109100.0
2005-11-01	DRIV	ETF	27.901	29.04	27.901	28.62	1589866.0
2005-11-01	DSI	ETF	5.81	5.81	5.81	5.81	3000.0
2005-11-01	DUSA	ETF	9.75	9.77	9.53	9.68	167921.0
2005-11-01	DVY	ETF	61.25	61.3	60.91	61.07	354600.0
2005-11-01	EDEN	ETF	0.59	0.64	0.57	0.64	63804.0
2005-11-01	EDV	ETF	25.39	25.49	25.39	25.42	7000.0

> showing 50 of 280 rows — these rows as CSV

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