PREVIEW / etf_daily / 2005-09-28

all etf daily files

  file:    by_date/etf_daily/2005/2005-09-28.parquet
  size:    15 KB
  rows:    282

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-09-28	SPY	ETF	121.93	122.12	121.2	121.67	58620500.0
2005-09-28	QQQ	ETF	38.77	38.95	38.558	38.68	72059497.0
2005-09-28	IWM	ETF	65.57	65.64	64.74	65.31	21575500.0
2005-09-28	DIA	ETF	104.8	105.04	104.16	104.7	6376500.0
2005-09-28	GLD	ETF	46.3	46.89	46.16	46.8	3448000.0
2005-09-28	TLT	ETF	92.39	93.02	92.26	92.94	712800.0
2005-09-28	AAA	ETF	55.59	55.59	55.4	55.58	1400.0
2005-09-28	ADRE	ETF	107.76	107.87	107.2	107.67	19924.0
2005-09-28	AFK	ETF	25.53	25.53	25.46	25.46	1700.0
2005-09-28	AGG	ETF	101.64	101.86	101.46	101.83	233800.0
2005-09-28	AIQ	ETF	43.0	43.5	41.55	42.55	27960.0
2005-09-28	AIS	ETF	0.93	0.95	0.88	0.92	142500.0
2005-09-28	ARB	ETF	39.96	40.0	39.14	39.5	189400.0
2005-09-28	BAB	ETF	51.36	51.81	51.36	51.81	23000.0
2005-09-28	BBC	ETF	7.45	7.45	7.37	7.41	13100.0
2005-09-28	BBH	ETF	62.0	63.1967	62.0	62.88	1975800.0
2005-09-28	BCM	ETF	62.56	62.76	61.76	62.1	32600.0
2005-09-28	BIS	ETF	635.2	635.2	635.2	635.2	34.4
2005-09-28	BITS	ETF	11.12	11.6	11.0	11.258	1435.0
2005-09-28	BKF	ETF	32.19	32.36	32.05	32.16	81400.0
2005-09-28	BNE	ETF	14.03	14.12	13.95	14.0	178300.0
2005-09-28	BRF	ETF	15.21	15.37	15.21	15.37	7200.0
2005-09-28	BTF	ETF	85.39999999999999	85.7	85.1	85.5	3180.0
2005-09-28	CBON	ETF	32.5	32.6	32.3	32.5	27025.0
2005-09-28	CDC	ETF	4.2	4.35	4.2	4.25	3900.0
2005-09-28	CDL	ETF	13.57	13.6	13.4	13.48	171500.0
2005-09-28	CEF	ETF	5.59	5.69	5.58	5.66	335800.0
2005-09-28	CEW	ETF	25.95	25.95	25.9	25.9	300.0
2005-09-28	CHB	ETF	14.16	14.18	13.72	14.01	573500.0
2005-09-28	CHI	ETF	19.82	19.85	19.64	19.8	127600.0
2005-09-28	CHIC	ETF	14.05	14.1	13.25	13.42	637215.0
2005-09-28	CHIR	ETF	43.35	43.5399	43.2	43.2501	1053873.0
2005-09-28	CHY	ETF	16.2	16.24	16.0	16.12	123100.0
2005-09-28	CIL	ETF	25.93	25.93	25.9	25.9	700.0
2005-09-28	CIZ	ETF	21.5	21.5	21.4	21.47	700.0
2005-09-28	CN	ETF	33.87	34.1	33.8	33.94	361000.0
2005-09-28	CNXT	ETF	1.89	1.91	1.82	1.85	8224773.0
2005-09-28	COMB	ETF	8.05	8.1	8.05	8.1	20500.0
2005-09-28	CPI	ETF	24.0	24.0	24.0	24.0	200.0
2005-09-28	CPST	ETF	3.75	3.85	3.38	3.46	11392962.0
2005-09-28	CSB	ETF	29.11	29.13	28.9	28.95	14600.0
2005-09-28	CSM	ETF	2.425	2.435	2.425	2.435	5600.0
2005-09-28	CSQ	ETF	13.51	13.87	13.49	13.87	424100.0
2005-09-28	CTEC	ETF	49.55	51.050000000000004	49.5	50.05	8942.4
2005-09-28	CURE	ETF	0.1888	0.1888	0.1163	0.1212	14394480.0
2005-09-28	CYA	ETF	83.6	83.6	78.0	78.0	215.0
2005-09-28	CYB	ETF	3.87	3.9	3.87	3.9	9600.0
2005-09-28	DGT	ETF	64.72	64.92	64.65	64.92	2100.0
2005-09-28	DIG	ETF	14.4625	14.5875	14.325	14.5875	7680.0
2005-09-28	DIV	ETF	13.15	13.18	13.1	13.12	12100.0

> showing 50 of 282 rows — these rows as CSV

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