PREVIEW / etf_daily / 2005-07-25

all etf daily files

  file:    by_date/etf_daily/2005/2005-07-25.parquet
  size:    15 KB
  rows:    277

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-07-25	SPY	ETF	123.41	123.95	122.85	123.19	57301600.0
2005-07-25	QQQ	ETF	39.46	39.626	39.2	39.27	52058534.0
2005-07-25	IWM	ETF	67.3	67.68	66.61	66.88	22514700.0
2005-07-25	DIA	ETF	106.52	106.85	105.86	106.13	5809400.0
2005-07-25	GLD	ETF	42.46	42.56	42.43	42.51	2122100.0
2005-07-25	TLT	ETF	93.4	93.71	93.14	93.21	305100.0
2005-07-25	AAA	ETF	51.61	51.69	51.35	51.37	3100.0
2005-07-25	ADRE	ETF	98.0	98.0	94.51	94.51	24752.0
2005-07-25	AFK	ETF	25.88	25.88	25.76	25.88	7600.0
2005-07-25	AGG	ETF	101.95	102.17	101.78	101.95	97400.0
2005-07-25	AIQ	ETF	51.75	51.9	51.0	51.25	27680.0
2005-07-25	AIS	ETF	1.06	1.14	1.06	1.14	156900.0
2005-07-25	ARB	ETF	42.3	42.49	41.86	41.96	223800.0
2005-07-25	BAB	ETF	47.75	47.99	47.6	47.7	39500.0
2005-07-25	BBH	ETF	63.0	63.3233	62.2333	62.4267	2071800.0
2005-07-25	BCM	ETF	63.5	64.11	63.5	64.05	14100.0
2005-07-25	BIS	ETF	688.0	688.0	672.0	672.0	6.25
2005-07-25	BITS	ETF	14.0	14.04	13.4	13.52	2935.0
2005-07-25	BKF	ETF	34.3	34.88	34.12	34.5	12000.0
2005-07-25	BNE	ETF	14.3	14.4	14.17	14.17	97600.0
2005-07-25	BRF	ETF	15.52	15.52	15.36	15.39	5100.0
2005-07-25	BTF	ETF	86.99999999999999	87.14999999999999	86.86999999999999	86.99999999999999	1420.0
2005-07-25	CBON	ETF	32.27	32.75	32.27	32.74	18050.0
2005-07-25	CDC	ETF	6.52	6.6	6.52	6.6	400.0
2005-07-25	CDL	ETF	12.0	12.12	11.98	12.03	188200.0
2005-07-25	CEF	ETF	5.24	5.28	5.21	5.25	194000.0
2005-07-25	CEW	ETF	26.75	26.77	26.75	26.77	300.0
2005-07-25	CHB	ETF	12.46	12.52	12.1	12.1	520400.0
2005-07-25	CHI	ETF	19.97	20.09	19.92	20.04	117700.0
2005-07-25	CHIC	ETF	14.99	15.21	14.85	14.94	375758.0
2005-07-25	CHIR	ETF	35.64	35.7501	35.2599	35.52	1413305.0
2005-07-25	CHY	ETF	16.59	16.6	16.52	16.53	97100.0
2005-07-25	CIL	ETF	25.8	25.8	25.77	25.77	3300.0
2005-07-25	CN	ETF	30.85	31.0	30.85	30.9	16600.0
2005-07-25	CNXT	ETF	1.88	1.95	1.87	1.91	6232166.0
2005-07-25	CPI	ETF	23.45	23.5	23.45	23.5	300.0
2005-07-25	CPST	ETF	1.78	1.88	1.75	1.87	1448780.0
2005-07-25	CSB	ETF	29.87	29.87	29.7	29.7	2700.0
2005-07-25	CSM	ETF	2.4175	2.4175	2.4175	2.4175	400.0
2005-07-25	CSQ	ETF	14.23	14.25	14.13	14.14	365800.0
2005-07-25	CTEC	ETF	52.99999999999999	55.449999999999996	52.449999999999996	54.45	9725.800000000001
2005-07-25	CURE	ETF	0.3125	0.3175	0.3088	0.3088	1055824.0
2005-07-25	CYA	ETF	131.6	131.8	131.0	131.0	305.0
2005-07-25	CYB	ETF	2.71	2.85	2.71	2.85	22600.0
2005-07-25	DGT	ETF	63.71	64.44	63.71	63.91	10200.0
2005-07-25	DIV	ETF	13.88	13.88	13.51	13.71	43000.0
2005-07-25	DRIV	ETF	36.52	37.25	36.29	36.52	642313.0
2005-07-25	DSI	ETF	5.79	5.81	5.79	5.81	1400.0
2005-07-25	DUSA	ETF	9.4	9.4	8.95	8.98	130676.0
2005-07-25	DVY	ETF	64.13	64.28	63.73	63.87	461200.0

> showing 50 of 277 rows — these rows as CSV

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