PREVIEW / etf_daily / 2005-03-16

all etf daily files

  file:    by_date/etf_daily/2005/2005-03-16.parquet
  size:    15 KB
  rows:    262

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-16	SPY	ETF	119.7	120.16	118.9	119.12	74874200.0
2005-03-16	QQQ	ETF	36.91	37.18	36.53	36.615	159757441.0
2005-03-16	IWM	ETF	62.37	62.64	61.975	62.235	21527600.0
2005-03-16	DIA	ETF	106.95	107.11	106.19	106.35	6444500.0
2005-03-16	GLD	ETF	44.29	44.35	44.2	44.31	2223300.0
2005-03-16	TLT	ETF	88.54	89.36	88.54	88.94	2097800.0
2005-03-16	AAA	ETF	63.76	64.25	63.5	63.6	8300.0
2005-03-16	ADRE	ETF	86.11	87.18	86.11	86.89	37096.0
2005-03-16	AFK	ETF	25.6	25.62	25.5	25.52	16400.0
2005-03-16	AGG	ETF	101.22	101.49	101.04	101.29	94600.0
2005-03-16	AIQ	ETF	53.3	53.3	50.1	50.85	34420.0
2005-03-16	ARB	ETF	41.05	41.28	40.93	41.05	253700.0
2005-03-16	BAB	ETF	52.13	52.3	51.0	51.35	23700.0
2005-03-16	BBH	ETF	46.35	47.1867	46.1667	46.4667	5180100.0
2005-03-16	BCM	ETF	60.45	60.57	60.0	60.14	22600.0
2005-03-16	BIS	ETF	657.6	667.2	656.0	656.0	18.1
2005-03-16	BITS	ETF	12.92	13.8	12.8	13.08	16905.0
2005-03-16	BKF	ETF	40.75	40.75	40.16	40.16	16200.0
2005-03-16	BNE	ETF	15.13	15.19	15.0	15.03	128100.0
2005-03-16	BRF	ETF	15.65	15.65	15.6	15.6	500.0
2005-03-16	BTF	ETF	90.95	90.95	88.75	89.39999999999999	3620.0
2005-03-16	CBON	ETF	26.55	26.76	26.46	26.75	38000.0
2005-03-16	CDC	ETF	8.37	8.37	8.03	8.1	8200.0
2005-03-16	CDL	ETF	14.06	14.25	13.88	14.01	263400.0
2005-03-16	CEF	ETF	5.7	5.73	5.64	5.64	246800.0
2005-03-16	CGW	ETF	29.53	29.64	29.37	29.55	5400.0
2005-03-16	CHB	ETF	9.77	9.83	9.52	9.61	458700.0
2005-03-16	CHIC	ETF	12.4	12.55	12.17	12.17	229314.0
2005-03-16	CHIR	ETF	36.5499	36.6699	35.85	36.0099	1854893.0
2005-03-16	CID	ETF	9.32	9.34	9.3	9.34	10400.0
2005-03-16	CIL	ETF	26.15	26.3	26.0	26.15	4200.0
2005-03-16	CN	ETF	28.5	28.55	28.21	28.31	32300.0
2005-03-16	CNXT	ETF	1.57	1.59	1.53	1.54	4111790.0
2005-03-16	CPI	ETF	18.1	18.1	18.1	18.1	100.0
2005-03-16	CSB	ETF	34.76	34.84	34.66	34.74	4700.0
2005-03-16	CSM	ETF	2.375	2.375	2.375	2.375	3600.0
2005-03-16	CTEC	ETF	50.0	51.25	49.5	49.85	10325.2
2005-03-16	CURE	ETF	0.4163	0.4412	0.415	0.425	1392152.0
2005-03-16	CYA	ETF	174.8	174.8	168.0	168.0	30.0
2005-03-16	CYB	ETF	3.35	3.45	3.3	3.39	9500.0
2005-03-16	DGT	ETF	64.87	64.87	64.61	64.61	2900.0
2005-03-16	DIG	ETF	12.9375	13.025	12.9375	13.025	2800.0
2005-03-16	DIV	ETF	13.35	13.35	12.83	13.08	93900.0
2005-03-16	DJP	ETF	27.04	27.04	27.04	27.04	1800.0
2005-03-16	DRIV	ETF	29.81	30.6	29.75	30.23	827265.0
2005-03-16	DUSA	ETF	10.01	10.4	10.0	10.06	109595.0
2005-03-16	DVY	ETF	61.3	61.34	60.48	60.6	626000.0
2005-03-16	EDEN	ETF	0.76	0.76	0.73	0.75	96748.0
2005-03-16	EDV	ETF	25.96	26.04	25.82	25.9	20900.0
2005-03-16	EEM	ETF	23.0556	23.2756	22.8911	22.9811	9432900.0

> showing 50 of 262 rows — these rows as CSV

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