PREVIEW / etf_daily / 2005-08-23

all etf daily files

  file:    by_date/etf_daily/2005/2005-08-23.parquet
  size:    15 KB
  rows:    273

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-23	SPY	ETF	122.5	122.61	121.15	122.24	55168600.0
2005-08-23	QQQ	ETF	38.84	38.92	38.61	38.73	57532051.0
2005-08-23	IWM	ETF	65.51	65.63	64.86	65.47	20650300.0
2005-08-23	DIA	ETF	105.64	105.73	104.91	105.28	6953900.0
2005-08-23	GLD	ETF	43.84	43.9	43.71	43.76	607700.0
2005-08-23	TLT	ETF	93.73	94.23	93.65	94.11	491800.0
2005-08-23	AAA	ETF	56.49	56.68	56.49	56.65	800.0
2005-08-23	ADRE	ETF	102.92	102.92	97.51	97.73	22528.0
2005-08-23	AFK	ETF	25.75	25.75	25.68	25.696	2100.0
2005-08-23	AGG	ETF	102.04	102.25	102.0	102.11	110900.0
2005-08-23	AIQ	ETF	46.25	46.25	44.75	45.45	8200.0
2005-08-23	AIS	ETF	0.84	0.87	0.8	0.87	226300.0
2005-08-23	ARB	ETF	42.7	42.75	42.28	42.47	136100.0
2005-08-23	BAB	ETF	51.4	51.67	51.32	51.55	19200.0
2005-08-23	BBH	ETF	63.4833	63.7	62.94	63.35	967500.0
2005-08-23	BCM	ETF	58.24	58.41	57.55	57.68	32400.0
2005-08-23	BIS	ETF	670.4	672.0	670.4	670.4	11.9
2005-08-23	BITS	ETF	11.72	12.4	11.72	12.32	9720.0
2005-08-23	BKF	ETF	31.26	33.68	31.26	33.3	113700.0
2005-08-23	BNE	ETF	13.92	14.0	13.72	13.9	72800.0
2005-08-23	BRF	ETF	15.5	15.5	15.46	15.46	3300.0
2005-08-23	BTF	ETF	86.4	86.4	85.74999999999999	85.99999999999999	2380.0
2005-08-23	CBON	ETF	32.51	32.75	32.5	32.75	10300.0
2005-08-23	CDC	ETF	3.4	3.8	3.31	3.8	10600.0
2005-08-23	CDL	ETF	13.58	13.77	13.58	13.72	360600.0
2005-08-23	CEF	ETF	5.37	5.38	5.35	5.37	163200.0
2005-08-23	CHB	ETF	11.4	11.48	11.25	11.43	265500.0
2005-08-23	CHI	ETF	20.2	20.26	20.07	20.112	67300.0
2005-08-23	CHIC	ETF	13.41	13.56	13.06	13.41	300253.0
2005-08-23	CHIR	ETF	35.43	35.76	35.25	35.4	864254.0
2005-08-23	CHY	ETF	16.31	16.33	16.22	16.26	68000.0
2005-08-23	CIL	ETF	25.86	25.86	25.85	25.85	400.0
2005-08-23	CN	ETF	33.31	33.31	32.77	32.97	10600.0
2005-08-23	CNXT	ETF	1.65	1.68	1.62	1.66	2837036.0
2005-08-23	CPST	ETF	2.9	3.23	2.9	3.14	2838567.0
2005-08-23	CSB	ETF	30.46	30.51	30.27	30.4	6800.0
2005-08-23	CSQ	ETF	14.19	14.23	14.07	14.11	396900.0
2005-08-23	CTEC	ETF	52.55	53.05	51.5	51.5	4048.0
2005-08-23	CURE	ETF	0.2375	0.2512	0.2313	0.2475	1654728.0
2005-08-23	CYA	ETF	70.0	71.0	69.0	69.8	655.0
2005-08-23	CYB	ETF	3.43	3.43	3.41	3.42	3900.0
2005-08-23	DGT	ETF	64.61	64.61	64.13	64.19	1100.0
2005-08-23	DIG	ETF	13.075	13.075	13.0625	13.0625	4000.0
2005-08-23	DIV	ETF	13.57	13.64	13.55	13.62	10700.0
2005-08-23	DRIV	ETF	38.94	39.27	38.67	39.01	469667.0
2005-08-23	DSI	ETF	5.745	5.76	5.745	5.76	8000.0
2005-08-23	DUSA	ETF	10.93	11.29	10.85	11.27	121960.0
2005-08-23	DVY	ETF	62.99	63.03	62.62	62.89	352100.0
2005-08-23	EDEN	ETF	0.85	0.9	0.824	0.86	42998.0
2005-08-23	EDV	ETF	25.81	25.81	25.71	25.81	8400.0

> showing 50 of 273 rows — these rows as CSV

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