PREVIEW / etf_daily / 2005-09-16

all etf daily files

  file:    by_date/etf_daily/2005/2005-09-16.parquet
  size:    15 KB
  rows:    279

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-16	SPY	ETF	123.3	123.74	122.87	123.5	75424100.0
2005-09-16	QQQ	ETF	39.25	39.46	39.109	39.4	71052746.0
2005-09-16	IWM	ETF	66.57	67.02	66.34	66.94	24336600.0
2005-09-16	DIA	ETF	105.95	106.38	105.65	106.23	6797100.0
2005-09-16	GLD	ETF	45.8	45.88	45.55	45.82	2878900.0
2005-09-16	TLT	ETF	92.3	92.48	91.88	92.1	2145500.0
2005-09-16	AAA	ETF	56.46	56.53	56.24	56.49	3100.0
2005-09-16	ADRE	ETF	104.15	104.57	103.95	104.57	15460.0
2005-09-16	AFK	ETF	25.5	25.51	25.42	25.42	3700.0
2005-09-16	AGG	ETF	101.94	101.95	101.63	101.71	86400.0
2005-09-16	AIQ	ETF	44.9	45.1	44.0	45.1	17880.0
2005-09-16	AIS	ETF	0.9	0.9	0.84	0.86	66600.0
2005-09-16	ARB	ETF	41.15	42.18	41.09	41.96	230600.0
2005-09-16	BAB	ETF	52.96	53.9	52.96	53.7	44500.0
2005-09-16	BBC	ETF	7.45	7.6	7.34	7.35	41900.0
2005-09-16	BBH	ETF	65.74	66.2333	65.63	66.1467	725100.0
2005-09-16	BCM	ETF	62.55	62.6	61.85	62.28	53400.0
2005-09-16	BIS	ETF	672.0	673.6	667.2	673.6	10.0
2005-09-16	BITS	ETF	11.88	12.28	11.484	12.076	8938.0
2005-09-16	BKF	ETF	30.95	31.0	30.46	30.54	37600.0
2005-09-16	BNE	ETF	14.16	14.2	13.95	14.05	301600.0
2005-09-16	BRF	ETF	15.39	15.42	15.39	15.42	3800.0
2005-09-16	BTF	ETF	86.54999999999998	86.85	86.54999999999998	86.85	2820.0
2005-09-16	CBON	ETF	32.87	33.0	32.7	33.0	22308.0
2005-09-16	CDC	ETF	3.29	3.5	3.29	3.38	13800.0
2005-09-16	CDL	ETF	13.11	13.6	13.11	13.44	549800.0
2005-09-16	CEF	ETF	5.44	5.54	5.41	5.48	814600.0
2005-09-16	CEW	ETF	25.85	25.85	25.85	25.85	200.0
2005-09-16	CHB	ETF	14.45	14.45	14.05	14.3	1573000.0
2005-09-16	CHI	ETF	20.12	20.28	20.06	20.25	70800.0
2005-09-16	CHIC	ETF	14.34	14.8	14.34	14.63	295346.0
2005-09-16	CHIR	ETF	44.0001	44.1801	43.7499	43.7499	7278832.0
2005-09-16	CHY	ETF	16.46	16.51	16.39	16.49	53500.0
2005-09-16	CN	ETF	35.35	35.92	35.25	35.9	68000.0
2005-09-16	CNXT	ETF	1.65	1.71	1.64	1.67	8309351.0
2005-09-16	CPST	ETF	5.18	5.28	4.65	4.83	16072879.0
2005-09-16	CSB	ETF	30.97	30.97	30.77	30.86	13900.0
2005-09-16	CSM	ETF	2.425	2.425	2.425	2.425	12000.0
2005-09-16	CSQ	ETF	14.08	14.13	14.05	14.09	253100.0
2005-09-16	CTEC	ETF	54.0	55.449999999999996	53.65	53.75	4745.400000000001
2005-09-16	CURE	ETF	0.25	0.2512	0.2338	0.2425	1117936.0
2005-09-16	CYA	ETF	61.0	64.0	61.0	64.0	995.0
2005-09-16	CYB	ETF	4.1	4.1	4.0	4.1	60100.0
2005-09-16	DGT	ETF	64.85	65.18	64.85	65.01	3800.0
2005-09-16	DIG	ETF	14.1125	14.55	14.1125	14.5375	11920.0
2005-09-16	DIV	ETF	13.71	13.78	13.63	13.67	8200.0
2005-09-16	DRIV	ETF	38.17	38.3545	37.9	38.22	525407.0
2005-09-16	DSI	ETF	5.75	5.77	5.75	5.77	3800.0
2005-09-16	DUSA	ETF	9.63	9.63	9.3	9.53	112239.0
2005-09-16	DVY	ETF	63.4	63.85	63.35	63.8	300000.0

> showing 50 of 279 rows — these rows as CSV

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