PREVIEW / etf_daily / 2005-07-20

all etf daily files

  file:    by_date/etf_daily/2005/2005-07-20.parquet
  size:    15 KB
  rows:    275

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-07-20	SPY	ETF	122.59	123.73	122.3	123.44	69477000.0
2005-07-20	QQQ	ETF	38.93	39.57	38.9	39.46	91982299.0
2005-07-20	IWM	ETF	66.25	67.55	66.19	67.35	23859900.0
2005-07-20	DIA	ETF	105.86	106.89	105.75	106.69	5790600.0
2005-07-20	GLD	ETF	42.16	42.25	42.05	42.2	2266800.0
2005-07-20	TLT	ETF	93.51	94.24	93.18	94.11	1884500.0
2005-07-20	AAA	ETF	51.11	51.98	51.11	51.97	6900.0
2005-07-20	ADRE	ETF	93.9	94.78	93.9	94.78	5912.0
2005-07-20	AFK	ETF	25.73	25.9	25.73	25.89	4500.0
2005-07-20	AGG	ETF	102.01	102.38	101.92	102.33	159200.0
2005-07-20	AIQ	ETF	54.2	55.7	52.35	52.85	27880.0
2005-07-20	AIS	ETF	1.03	1.12	1.03	1.0885	64800.0
2005-07-20	ARB	ETF	42.95	43.51	42.56	43.5	178500.0
2005-07-20	BAB	ETF	48.34	48.5	47.63	48.5	28200.0
2005-07-20	BBH	ETF	63.2667	64.79	63.0667	64.47	4193400.0
2005-07-20	BCM	ETF	63.56	63.99	63.25	63.66	13000.0
2005-07-20	BIS	ETF	675.2	678.4	664.0	678.4	34.4
2005-07-20	BITS	ETF	13.8	14.12	13.48	13.48	4608.0
2005-07-20	BKF	ETF	34.32	34.84	34.32	34.84	45000.0
2005-07-20	BNE	ETF	14.16	14.36	14.15	14.26	183200.0
2005-07-20	BRF	ETF	15.58	15.58	15.35	15.4	13500.0
2005-07-20	BTF	ETF	86.75	87.35	86.69999999999999	87.35	1900.0
2005-07-20	CBON	ETF	31.95	32.4	30.75	31.91	10327.0
2005-07-20	CDC	ETF	7.05	7.3	7.05	7.06	7300.0
2005-07-20	CDL	ETF	11.42	11.65	11.36	11.59	955700.0
2005-07-20	CEF	ETF	5.17	5.22	5.15	5.18	342100.0
2005-07-20	CHB	ETF	11.1	11.97	11.08	11.87	1137500.0
2005-07-20	CHI	ETF	19.96	20.0	19.91	19.95	64700.0
2005-07-20	CHIC	ETF	14.4	14.56	14.3	14.38	338307.0
2005-07-20	CHIR	ETF	35.4999	36.0	35.49	35.8899	1224558.0
2005-07-20	CHY	ETF	16.55	16.61	16.49	16.61	85900.0
2005-07-20	CIL	ETF	25.75	25.75	25.73	25.73	2800.0
2005-07-20	CIZ	ETF	22.8	22.85	22.75	22.75	700.0
2005-07-20	CN	ETF	30.65	30.65	30.39	30.4	20100.0
2005-07-20	CNXT	ETF	1.83	1.87	1.79	1.86	5714559.0
2005-07-20	CPST	ETF	1.83	1.83	1.74	1.74	849390.0
2005-07-20	CSB	ETF	29.7	29.91	29.7	29.89	3200.0
2005-07-20	CSQ	ETF	14.32	14.36	14.25	14.27	310900.0
2005-07-20	CTEC	ETF	51.699999999999996	55.0	51.699999999999996	54.699999999999996	4401.8
2005-07-20	CURE	ETF	0.3375	0.3375	0.3113	0.3113	821184.0
2005-07-20	CYA	ETF	139.2	141.2	138.0	140.0	220.0
2005-07-20	CYB	ETF	2.9	2.92	2.86	2.87	9800.0
2005-07-20	DGT	ETF	63.8	64.49	63.53	63.8	2600.0
2005-07-20	DIG	ETF	12.1125	12.1125	12.075	12.075	1840.0
2005-07-20	DIV	ETF	13.94	13.95	13.79	13.82	30000.0
2005-07-20	DRIV	ETF	36.22	37.14	35.91	36.91	945003.0
2005-07-20	DSI	ETF	5.83	5.84	5.83	5.84	18000.0
2005-07-20	DUSA	ETF	8.72	8.89	8.51	8.88	103174.0
2005-07-20	DVY	ETF	63.45	64.04	63.35	63.97	452800.0
2005-07-20	EDEN	ETF	0.85	0.93	0.82	0.88	15100.0

> showing 50 of 275 rows — these rows as CSV

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