PREVIEW / etf_daily / 2005-06-14

all etf daily files

  file:    by_date/etf_daily/2005/2005-06-14.parquet
  size:    15 KB
  rows:    270

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-06-14	SPY	ETF	120.45	121.2	120.38	120.86	33857100.0
2005-06-14	QQQ	ETF	37.69	37.84	37.5	37.58	62764610.0
2005-06-14	IWM	ETF	62.7	63.27	62.47	63.27	14950400.0
2005-06-14	DIA	ETF	105.28	105.91	105.19	105.57	4180400.0
2005-06-14	GLD	ETF	42.66	42.7	42.58	42.6	825500.0
2005-06-14	TLT	ETF	94.05	94.16	93.57	93.7	1984500.0
2005-06-14	AAA	ETF	58.28	58.48	58.23	58.48	3400.0
2005-06-14	ADRE	ETF	89.57	90.439	89.531	90.439	3928.0
2005-06-14	AFK	ETF	26.15	26.29	26.0	26.2	4500.0
2005-06-14	AGG	ETF	102.48	102.49	102.27	102.38	129800.0
2005-06-14	AIQ	ETF	51.35	53.0	51.35	51.85	16200.0
2005-06-14	AIS	ETF	0.85	0.92	0.85	0.9	155600.0
2005-06-14	ARB	ETF	40.95	41.81	40.81	41.56	297700.0
2005-06-14	BAB	ETF	50.06	50.2	49.7	49.81	19600.0
2005-06-14	BBH	ETF	55.7667	55.9067	55.23	55.8	1291200.0
2005-06-14	BCM	ETF	59.53	59.82	59.41	59.49	10400.0
2005-06-14	BIS	ETF	576.0	600.0	576.0	600.0	7.5
2005-06-14	BITS	ETF	12.04	12.08	12.04	12.04	2203.0
2005-06-14	BKF	ETF	38.12	38.8	38.08	38.3	72700.0
2005-06-14	BNE	ETF	13.62	13.93	13.55	13.9	120900.0
2005-06-14	BRF	ETF	15.49	15.51	15.44	15.44	10700.0
2005-06-14	BTF	ETF	86.05499999999999	86.35	86.05499999999999	86.25	2940.0
2005-06-14	CBON	ETF	28.7	28.7	28.32	28.7	18875.0
2005-06-14	CDC	ETF	7.5	7.6	7.45	7.54	7100.0
2005-06-14	CDL	ETF	11.98	12.23	11.98	12.08	126400.0
2005-06-14	CEF	ETF	5.3	5.32	5.29	5.29	230500.0
2005-06-14	CEW	ETF	26.5	26.61	26.45	26.57	12100.0
2005-06-14	CGW	ETF	27.24	27.84	27.24	27.61	39500.0
2005-06-14	CHB	ETF	10.3	10.36	10.14	10.3	329300.0
2005-06-14	CHI	ETF	19.4	19.52	19.37	19.41	107400.0
2005-06-14	CHIC	ETF	12.7	12.85	12.36	12.53	134105.0
2005-06-14	CHIR	ETF	37.8801	38.4501	37.53	37.95	570143.0
2005-06-14	CHY	ETF	15.96	16.0	15.91	15.97	116200.0
2005-06-14	CIL	ETF	25.64	25.64	25.55	25.55	1800.0
2005-06-14	CIZ	ETF	22.25	22.25	22.25	22.25	200.0
2005-06-14	CN	ETF	26.6	26.7	26.5	26.52	56200.0
2005-06-14	CNXT	ETF	1.5	1.52	1.47	1.49	4634775.0
2005-06-14	CPI	ETF	22.82	23.94	22.82	23.94	4300.0
2005-06-14	CPST	ETF	0.99	1.19	0.99	1.18	2625477.0
2005-06-14	CSB	ETF	30.45	30.53	30.35	30.53	6400.0
2005-06-14	CSM	ETF	2.4025	2.4025	2.4025	2.4025	42400.0
2005-06-14	CSQ	ETF	13.89	13.9	13.77	13.84	330500.0
2005-06-14	CTEC	ETF	47.5	47.99999999999999	46.699999999999996	47.99999999999999	6335.6
2005-06-14	CURE	ETF	0.2525	0.285	0.2512	0.2762	1201752.0
2005-06-14	CYA	ETF	155.8	160.0	155.2	160.0	695.0
2005-06-14	CYB	ETF	2.88	2.88	2.8	2.87	9400.0
2005-06-14	DGT	ETF	64.06	64.22	64.06	64.12	700.0
2005-06-14	DIV	ETF	13.79	13.84	13.71	13.77	11500.0
2005-06-14	DRIV	ETF	29.12	29.3	28.35	28.83	584614.0
2005-06-14	DSI	ETF	5.895	5.92	5.895	5.895	1800.0

> showing 50 of 270 rows — these rows as CSV

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