PREVIEW / etf_daily / 2005-03-21

all etf daily files

  file:    by_date/etf_daily/2005/2005-03-21.parquet
  size:    15 KB
  rows:    264

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-03-21	SPY	ETF	118.71	118.78	117.76	118.1	61244300.0
2005-03-21	QQQ	ETF	36.6	36.75	36.25	36.58	92838632.0
2005-03-21	IWM	ETF	62.04	62.135	61.575	61.975	16590200.0
2005-03-21	DIA	ETF	106.04	106.12	105.23	105.42	7322400.0
2005-03-21	GLD	ETF	43.21	43.25	42.87	43.09	3814400.0
2005-03-21	TLT	ETF	88.67	88.67	88.38	88.42	893100.0
2005-03-21	AAA	ETF	64.49	64.6	64.43	64.51	31300.0
2005-03-21	ADRE	ETF	90.2	90.2	86.5	87.239	102232.0
2005-03-21	AFK	ETF	25.57	25.63	25.47	25.47	8700.0
2005-03-21	AGG	ETF	101.33	101.33	101.09	101.2	106700.0
2005-03-21	AIQ	ETF	49.15	49.25	48.0	48.45	18280.0
2005-03-21	ARB	ETF	42.0	42.08	41.61	42.06	235000.0
2005-03-21	BAB	ETF	50.75	50.79	50.11	50.46	27700.0
2005-03-21	BBH	ETF	48.0	48.0	47.27	47.62	2523300.0
2005-03-21	BCM	ETF	59.37	59.5	58.85	59.02	12400.0
2005-03-21	BIS	ETF	662.4	664.0	656.0	656.0	71.0
2005-03-21	BITS	ETF	13.0	13.76	12.536	13.76	17176.0
2005-03-21	BKF	ETF	39.41	39.69	39.29	39.67	17700.0
2005-03-21	BNE	ETF	15.24	15.26	15.08	15.15	59400.0
2005-03-21	BRF	ETF	15.55	15.6	15.5	15.52	5600.0
2005-03-21	BTF	ETF	89.0	89.0	87.79999999999998	88.85	1720.0
2005-03-21	CBON	ETF	26.75	27.0	26.75	27.0	14600.0
2005-03-21	CDC	ETF	8.0	8.0	7.4	7.55	4800.0
2005-03-21	CDL	ETF	13.8	14.25	13.62	14.13	193200.0
2005-03-21	CEF	ETF	5.54	5.61	5.5	5.55	209600.0
2005-03-21	CEW	ETF	26.7	26.7	26.7	26.7	100.0
2005-03-21	CHB	ETF	9.54	9.75	9.48	9.59	323700.0
2005-03-21	CHIC	ETF	11.8	11.85	11.61	11.77	178726.0
2005-03-21	CHIR	ETF	35.85	36.48	35.5701	35.9499	1002518.0
2005-03-21	CID	ETF	9.38	9.38	9.36	9.36	2600.0
2005-03-21	CIL	ETF	26.28	26.48	26.16	26.16	2600.0
2005-03-21	CN	ETF	27.7	27.75	27.52	27.75	37500.0
2005-03-21	CNXT	ETF	1.59	1.61	1.549	1.56	2624128.0
2005-03-21	CPI	ETF	18.2	19.0	18.2	19.0	700.0
2005-03-21	CSB	ETF	33.55	33.6	33.27	33.51	11400.0
2005-03-21	CSM	ETF	2.3825	2.3825	2.375	2.375	7600.0
2005-03-21	CTEC	ETF	50.599999999999994	50.599999999999994	48.699999999999996	49.65	14111.0
2005-03-21	CURE	ETF	0.4062	0.4088	0.37	0.3812	2377240.0
2005-03-21	CYA	ETF	160.0	160.0	141.0	155.0	800.0
2005-03-21	CYB	ETF	3.63	3.72	3.55	3.65	2000.0
2005-03-21	CZA	ETF	10.41	10.41	10.41	10.41	3300.0
2005-03-21	DGT	ETF	63.86	63.94	63.63	63.78	8300.0
2005-03-21	DIG	ETF	12.9375	12.9375	12.75	12.75	11120.0
2005-03-21	DIV	ETF	13.13	13.13	12.92	13.0	25200.0
2005-03-21	DJP	ETF	27.04	27.04	27.04	27.04	1500.0
2005-03-21	DRIV	ETF	30.74	31.15	29.0	29.94	2762323.0
2005-03-21	DSI	ETF	5.92	5.935	5.9	5.925	8000.0
2005-03-21	DUSA	ETF	9.86	9.96	9.56	9.8	92301.0
2005-03-21	DVY	ETF	60.65	60.65	60.13	60.45	442500.0
2005-03-21	EDEN	ETF	0.8	0.8	0.74	0.776	27935.0

> showing 50 of 264 rows — these rows as CSV

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