PREVIEW / etf_daily / 2005-03-23

all etf daily files

  file:    by_date/etf_daily/2005/2005-03-23.parquet
  size:    14 KB
  rows:    259

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-23	SPY	ETF	116.95	117.72	116.75	117.0	70817300.0
2005-03-23	QQQ	ETF	36.09	36.494	36.07	36.26	97523974.0
2005-03-23	IWM	ETF	61.5	61.515	61.005	61.1	21073800.0
2005-03-23	DIA	ETF	104.49	105.55	104.21	104.41	7267500.0
2005-03-23	GLD	ETF	42.6	42.67	42.35	42.42	2618600.0
2005-03-23	TLT	ETF	87.53	88.16	87.53	88.09	1951700.0
2005-03-23	AAA	ETF	62.92	63.22	62.75	63.14	22100.0
2005-03-23	ADRE	ETF	84.85	84.85	83.52	83.834	9472.0
2005-03-23	AFK	ETF	25.63	25.7	25.31	25.31	6500.0
2005-03-23	AGG	ETF	100.61	100.78	100.25	100.78	158800.0
2005-03-23	AIQ	ETF	47.5	47.5	45.0	46.2	37280.0
2005-03-23	ARB	ETF	42.29	42.57	42.1	42.4	170000.0
2005-03-23	BAB	ETF	49.26	49.93	49.26	49.9	64800.0
2005-03-23	BBH	ETF	47.3667	48.0233	47.2733	47.9133	1821000.0
2005-03-23	BCM	ETF	58.81	58.95	58.46	58.48	18600.0
2005-03-23	BIS	ETF	656.0	720.0	656.0	720.0	43.75
2005-03-23	BITS	ETF	12.76	14.04	12.72	13.4	28555.0
2005-03-23	BKF	ETF	40.0	40.69	39.96	39.97	36100.0
2005-03-23	BNE	ETF	14.9	14.93	14.77	14.84	353900.0
2005-03-23	BRF	ETF	15.52	15.53	15.49	15.5	25900.0
2005-03-23	BTF	ETF	88.24999999999999	88.24999999999999	86.5	87.24999999999999	3100.0
2005-03-23	CBON	ETF	26.35	26.35	25.4499	25.45	25265.0
2005-03-23	CDC	ETF	7.77	8.3	7.77	8.3	3200.0
2005-03-23	CDL	ETF	13.85	13.96	13.82	13.86	268500.0
2005-03-23	CEF	ETF	5.42	5.46	5.34	5.38	523700.0
2005-03-23	CGW	ETF	29.99	29.99	29.99	29.99	100.0
2005-03-23	CHB	ETF	9.5	9.66	9.38	9.39	1103600.0
2005-03-23	CHIC	ETF	12.03	12.3	12.01	12.03	119344.0
2005-03-23	CHIR	ETF	35.6499	36.0	35.4999	35.7099	922313.0
2005-03-23	CIL	ETF	26.1	26.1	26.07	26.07	1000.0
2005-03-23	CN	ETF	27.95	27.95	27.55	27.65	9300.0
2005-03-23	CNXT	ETF	1.54	1.56	1.43	1.46	10671994.0
2005-03-23	CPI	ETF	18.75	18.75	18.75	18.75	100.0
2005-03-23	CSB	ETF	32.97	33.1	32.55	32.82	13800.0
2005-03-23	CTEC	ETF	49.65	52.8	49.65	50.949999999999996	7541.200000000001
2005-03-23	CURE	ETF	0.37	0.3725	0.3513	0.3525	961832.0
2005-03-23	CYA	ETF	160.0	168.8	160.0	164.0	695.0
2005-03-23	CYB	ETF	3.78	3.9	3.78	3.9	10400.0
2005-03-23	DGT	ETF	63.03	63.21	62.92	63.08	1700.0
2005-03-23	DIG	ETF	12.5625	12.5625	12.5625	12.5625	800.0
2005-03-23	DIV	ETF	12.94	12.94	12.25	12.4	94500.0
2005-03-23	DJP	ETF	27.03	27.03	27.03	27.03	1400.0
2005-03-23	DRIV	ETF	30.84	30.99	30.021	30.32	1273972.0
2005-03-23	DSI	ETF	5.895	5.9	5.84	5.9	3400.0
2005-03-23	DUSA	ETF	9.18	9.36	8.9	9.26	377294.0
2005-03-23	DVY	ETF	59.84	59.88	59.42	59.69	564200.0
2005-03-23	EDEN	ETF	0.8	0.8	0.75	0.789	32366.0
2005-03-23	EDV	ETF	25.75	25.88	25.63	25.64	15000.0
2005-03-23	EEM	ETF	22.2333	22.5767	22.2222	22.2478	9893700.0
2005-03-23	EFA	ETF	53.33	53.33	53.01	53.11	3244800.0

> showing 50 of 259 rows — these rows as CSV

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