PREVIEW / etf_daily / 2005-08-22

all etf daily files

  file:    by_date/etf_daily/2005/2005-08-22.parquet
  size:    15 KB
  rows:    276

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-08-22	SPY	ETF	122.58	123.23	121.88	122.47	69912000.0
2005-08-22	QQQ	ETF	38.88	39.18	38.597	38.84	93266714.0
2005-08-22	IWM	ETF	65.24	65.54	64.87	65.48	22168900.0
2005-08-22	DIA	ETF	105.87	106.38	105.17	105.66	6929700.0
2005-08-22	GLD	ETF	43.84	43.95	43.66	43.7	877200.0
2005-08-22	TLT	ETF	93.54	93.8	93.2	93.68	599300.0
2005-08-22	AAA	ETF	56.46	56.58	56.4	56.4	2700.0
2005-08-22	ADRE	ETF	98.0	99.35	97.96	99.2799	10736.0
2005-08-22	AFK	ETF	25.62	25.75	25.62	25.75	4700.0
2005-08-22	AGG	ETF	101.95	102.11	101.85	102.04	93800.0
2005-08-22	AIQ	ETF	45.25	46.25	44.5	46.2	16580.0
2005-08-22	AIS	ETF	0.86	0.87	0.78	0.82	230100.0
2005-08-22	ARB	ETF	42.58	42.8	42.58	42.78	248500.0
2005-08-22	BAB	ETF	51.9	52.32	51.9	52.1	18600.0
2005-08-22	BBH	ETF	63.4133	63.7533	63.0933	63.4333	1709700.0
2005-08-22	BCM	ETF	58.25	58.6	58.23	58.38	21300.0
2005-08-22	BIS	ETF	659.2	672.0	659.2	672.0	13.75
2005-08-22	BITS	ETF	11.2	11.8	11.2	11.72	7812.0
2005-08-22	BKF	ETF	30.88	31.31	30.88	31.15	33000.0
2005-08-22	BNE	ETF	13.8	14.0	13.8	13.95	222800.0
2005-08-22	BRF	ETF	15.51	15.57	15.51	15.52	6300.0
2005-08-22	BTF	ETF	85.99999999999999	86.44999999999999	85.99999999999999	86.44999999999999	2940.0
2005-08-22	CBON	ETF	32.5	32.74	32.5	32.63	18748.0
2005-08-22	CDC	ETF	3.78	3.78	3.26	3.45	25900.0
2005-08-22	CDL	ETF	13.4	13.68	13.35	13.61	630800.0
2005-08-22	CEF	ETF	5.39	5.4	5.34	5.35	347600.0
2005-08-22	CEW	ETF	27.22	27.22	27.22	27.22	900.0
2005-08-22	CHB	ETF	11.44	11.44	11.3	11.36	398100.0
2005-08-22	CHI	ETF	20.14	20.23	20.12	20.2	82700.0
2005-08-22	CHIC	ETF	13.53	13.68	13.3	13.4	140831.0
2005-08-22	CHIR	ETF	35.8101	36.1299	35.28	35.3799	1249285.0
2005-08-22	CHY	ETF	16.22	16.3	16.1745	16.3	88400.0
2005-08-22	CIL	ETF	25.85	25.85	25.85	25.85	100.0
2005-08-22	CN	ETF	34.0	34.09	33.8	33.81	37500.0
2005-08-22	CNXT	ETF	1.61	1.67	1.6	1.65	3085431.0
2005-08-22	CPST	ETF	2.88	3.01	2.78	2.9	853967.0
2005-08-22	CSB	ETF	30.5	30.61	30.31	30.34	7800.0
2005-08-22	CSM	ETF	2.42	2.42	2.42	2.42	400.0
2005-08-22	CSQ	ETF	14.1	14.29	14.1	14.19	308900.0
2005-08-22	CTEC	ETF	52.099999999999994	52.85	51.3	52.099999999999994	3299.2000000000003
2005-08-22	CURE	ETF	0.2263	0.2425	0.2225	0.2375	1258840.0
2005-08-22	CYA	ETF	69.6	70.0	66.0	70.0	1100.0
2005-08-22	CYB	ETF	3.44	3.47	3.32	3.47	4300.0
2005-08-22	DGT	ETF	64.75	64.78	64.53	64.61	1300.0
2005-08-22	DIG	ETF	13.0	13.0	13.0	13.0	80.0
2005-08-22	DIV	ETF	13.63	13.68	13.56	13.57	14100.0
2005-08-22	DRIV	ETF	38.68	39.15	38.59	39.11	477577.0
2005-08-22	DSI	ETF	5.765	5.765	5.715	5.765	8000.0
2005-08-22	DUSA	ETF	10.96	10.96	10.75	10.9	35430.0
2005-08-22	DVY	ETF	62.9	63.14	62.7	63.02	667900.0

> showing 50 of 276 rows — these rows as CSV

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