PREVIEW / etf_daily / 2005-09-19

all etf daily files

  file:    by_date/etf_daily/2005/2005-09-19.parquet
  size:    15 KB
  rows:    275

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-09-19	SPY	ETF	123.47	123.55	122.64	123.09	53355300.0
2005-09-19	QQQ	ETF	39.32	39.38	38.91	39.09	73395504.0
2005-09-19	IWM	ETF	66.86	66.98	66.3	66.62	24514400.0
2005-09-19	DIA	ETF	106.12	106.15	105.13	105.54	8614000.0
2005-09-19	GLD	ETF	46.27	46.73	46.22	46.25	6072100.0
2005-09-19	TLT	ETF	92.18	92.44	92.1	92.3	886100.0
2005-09-19	AAA	ETF	55.65	55.65	55.3	55.45	23200.0
2005-09-19	ADRE	ETF	105.09	106.0	104.71	104.7701	16280.0
2005-09-19	AFK	ETF	25.53	25.53	25.42	25.42	2500.0
2005-09-19	AGG	ETF	101.68	101.88	101.57	101.8	96000.0
2005-09-19	AIQ	ETF	44.85	44.85	43.6	43.95	31400.0
2005-09-19	AIS	ETF	0.84	0.85	0.81	0.85	193400.0
2005-09-19	ARB	ETF	41.96	41.96	41.06	41.3	54700.0
2005-09-19	BAB	ETF	52.95	52.95	52.27	52.35	34600.0
2005-09-19	BBC	ETF	7.55	7.55	7.4	7.51	62000.0
2005-09-19	BBH	ETF	66.3167	66.3533	65.3667	65.8167	1495500.0
2005-09-19	BCM	ETF	62.33	63.17	62.33	62.98	50700.0
2005-09-19	BIS	ETF	672.0	672.0	672.0	672.0	0.625
2005-09-19	BITS	ETF	12.0	12.28	12.0	12.24	825.0
2005-09-19	BKF	ETF	30.4	31.0	29.99	30.0	23200.0
2005-09-19	BNE	ETF	14.1	14.1	13.9	14.1	340900.0
2005-09-19	BRF	ETF	15.36	15.36	15.35	15.36	7000.0
2005-09-19	BTF	ETF	86.69999999999999	86.75	85.99999999999999	86.69999999999999	2100.0
2005-09-19	CBON	ETF	32.91	32.91	32.5	32.585	1500.0
2005-09-19	CDC	ETF	3.48	3.54	3.45	3.5	1800.0
2005-09-19	CDL	ETF	13.37	13.53	13.37	13.52	265300.0
2005-09-19	CEF	ETF	5.65	5.67	5.55	5.59	820500.0
2005-09-19	CHB	ETF	14.4	14.5	13.6	13.89	558500.0
2005-09-19	CHI	ETF	20.4	20.47	20.28	20.44	68900.0
2005-09-19	CHIC	ETF	14.6	15.0	14.41	14.62	260120.0
2005-09-19	CHIR	ETF	43.77	44.01	43.5399	43.8801	1441747.0
2005-09-19	CHY	ETF	16.5	16.64	16.46	16.48	64600.0
2005-09-19	CIL	ETF	25.97	25.97	25.97	25.97	1600.0
2005-09-19	CN	ETF	35.51	35.69	35.51	35.56	5500.0
2005-09-19	CNXT	ETF	1.66	1.69	1.62	1.63	8951641.0
2005-09-19	CPST	ETF	4.83	4.85	4.2599	4.39	14610002.0
2005-09-19	CSB	ETF	30.4	30.64	30.4	30.57	8000.0
2005-09-19	CSM	ETF	2.425	2.425	2.425	2.425	40000.0
2005-09-19	CSQ	ETF	14.06	14.09	13.97	13.98	357400.0
2005-09-19	CTEC	ETF	54.65	54.9	54.1	54.45	4779.6
2005-09-19	CURE	ETF	0.25	0.25	0.2288	0.235	536400.0
2005-09-19	CYA	ETF	63.8	63.8	62.0	62.0	1000.0
2005-09-19	CYB	ETF	4.1	4.15	4.06	4.15	15400.0
2005-09-19	DGT	ETF	65.19	65.29	65.09	65.1	18900.0
2005-09-19	DIG	ETF	14.625	14.6875	14.4875	14.4875	11680.0
2005-09-19	DIV	ETF	13.62	13.62	13.45	13.45	16500.0
2005-09-19	DRIV	ETF	38.2	38.22	36.75	36.98	808218.0
2005-09-19	DSI	ETF	5.76	5.76	5.76	5.76	12000.0
2005-09-19	DUSA	ETF	9.58	10.0	9.55	9.86	108166.0
2005-09-19	DVY	ETF	63.63	63.75	63.29	63.49	303600.0

> showing 50 of 275 rows — these rows as CSV

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