PREVIEW / etf_daily / 2005-03-31

all etf daily files

  file:    by_date/etf_daily/2005/2005-03-31.parquet
  size:    14 KB
  rows:    257

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-31	SPY	ETF	118.19	118.46	117.87	117.96	64575400.0
2005-03-31	QQQ	ETF	36.73	36.75	36.44	36.57	86651191.0
2005-03-31	IWM	ETF	61.175	61.185	60.75	61.075	20469400.0
2005-03-31	DIA	ETF	105.17	105.32	104.8	104.99	7374200.0
2005-03-31	GLD	ETF	42.87	42.87	42.7	42.82	1363200.0
2005-03-31	TLT	ETF	89.2	89.39	88.86	89.33	2410900.0
2005-03-31	AAA	ETF	63.74	63.96	63.31	63.5	28800.0
2005-03-31	ADRE	ETF	87.25	87.25	82.071	84.78	4040.0
2005-03-31	AFK	ETF	25.52	25.8	25.52	25.59	8600.0
2005-03-31	AGG	ETF	101.23	101.27	100.8	100.93	128100.0
2005-03-31	AIQ	ETF	47.05	47.75	46.8	47.75	31380.0
2005-03-31	ARB	ETF	42.75	43.08	42.63	42.9	193500.0
2005-03-31	BAB	ETF	50.6	50.64	50.1	50.23	28600.0
2005-03-31	BBH	ETF	47.0667	47.2767	46.6667	46.93	1768500.0
2005-03-31	BCM	ETF	59.9	60.82	59.9	60.6	23400.0
2005-03-31	BIS	ETF	577.6	600.0	576.0	600.0	222.5
2005-03-31	BITS	ETF	12.44	13.0	12.2	12.2	12434.0
2005-03-31	BKF	ETF	40.0	40.12	39.8	40.01	27000.0
2005-03-31	BNE	ETF	14.65	15.13	14.6	15.04	451400.0
2005-03-31	BRF	ETF	15.6	15.6	15.49	15.49	2200.0
2005-03-31	BTF	ETF	87.44999999999999	87.89999999999999	86.75	87.24999999999999	1620.0
2005-03-31	CBON	ETF	26.25	26.25	25.19	25.19	47440.0
2005-03-31	CDC	ETF	8.29	8.3	8.28	8.29	1700.0
2005-03-31	CDL	ETF	13.97	14.03	13.59	13.73	553800.0
2005-03-31	CEF	ETF	5.39	5.47	5.37	5.37	252400.0
2005-03-31	CGW	ETF	29.53	30.0	29.53	29.85	2200.0
2005-03-31	CHB	ETF	9.51	9.57	9.27	9.4	382400.0
2005-03-31	CHIC	ETF	12.46	12.95	12.45	12.92	351604.0
2005-03-31	CHIR	ETF	35.52	35.73	35.0499	35.0601	1045499.0
2005-03-31	CID	ETF	9.95	10.03	9.95	10.03	27000.0
2005-03-31	CIL	ETF	25.81	26.0	25.8	25.9	2000.0
2005-03-31	CIZ	ETF	20.55	20.6	20.55	20.6	2500.0
2005-03-31	CN	ETF	27.75	28.05	27.62	27.99	9400.0
2005-03-31	CNXT	ETF	1.485	1.51	1.44	1.5	3071369.0
2005-03-31	CSB	ETF	32.52	32.7	32.32	32.34	7900.0
2005-03-31	CSM	ETF	2.375	2.375	2.375	2.375	6000.0
2005-03-31	CTEC	ETF	50.75	51.39999999999999	49.45	50.4	14944.0
2005-03-31	CURE	ETF	0.4163	0.4288	0.4113	0.425	2113680.0
2005-03-31	CYA	ETF	168.0	171.0	165.0	169.6	330.0
2005-03-31	CYB	ETF	3.99	4.04	3.95	4.03	18800.0
2005-03-31	DGT	ETF	63.45	63.45	63.09	63.12	7600.0
2005-03-31	DIV	ETF	12.69	12.81	12.66	12.74	22800.0
2005-03-31	DJP	ETF	27.05	27.05	27.05	27.05	3800.0
2005-03-31	DRIV	ETF	31.33	31.58	30.65	31.16	518058.0
2005-03-31	DUSA	ETF	8.9	8.95	8.7	8.73	104414.0
2005-03-31	DVY	ETF	59.69	60.0	59.6	59.95	409300.0
2005-03-31	EDEN	ETF	0.66	0.7	0.6	0.65	105280.0
2005-03-31	EDV	ETF	25.89	25.9	25.68	25.76	6200.0
2005-03-31	EEM	ETF	22.2344	22.6111	22.2344	22.5333	8780400.0
2005-03-31	EFA	ETF	53.33	53.3667	52.8767	52.9567	5814300.0

> showing 50 of 257 rows — these rows as CSV

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