PREVIEW / etf_daily / 2005-09-23

all etf daily files

  file:    by_date/etf_daily/2005/2005-09-23.parquet
  size:    15 KB
  rows:    278

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-23	SPY	ETF	121.24	121.89	120.9	121.44	59368100.0
2005-09-23	QQQ	ETF	38.506	38.88	38.41	38.75	70170150.0
2005-09-23	IWM	ETF	64.61	65.3	64.24	65.18	27178400.0
2005-09-23	DIA	ETF	103.92	104.5	103.67	104.1	4974300.0
2005-09-23	GLD	ETF	46.2	46.3	45.92	46.28	2352800.0
2005-09-23	TLT	ETF	93.05	93.1	92.61	92.61	656800.0
2005-09-23	AAA	ETF	55.4	55.43	54.97	55.0	7700.0
2005-09-23	ADRE	ETF	105.6	105.66	104.9695	105.65	11996.0
2005-09-23	AFK	ETF	25.53	25.53	25.46	25.46	1100.0
2005-09-23	AGG	ETF	102.04	102.04	101.8	101.87	85200.0
2005-09-23	AIQ	ETF	42.0	44.15	41.35	42.65	33120.0
2005-09-23	AIS	ETF	0.85	0.93	0.85	0.92	200300.0
2005-09-23	ARB	ETF	40.0	40.04	39.39	39.83	76600.0
2005-09-23	BAB	ETF	50.87	51.45	50.77	51.2	29300.0
2005-09-23	BBC	ETF	7.42	7.57	7.4	7.4	20200.0
2005-09-23	BBH	ETF	64.4867	64.7067	63.5067	64.1333	2844000.0
2005-09-23	BCM	ETF	62.61	63.38	62.59	63.21	16200.0
2005-09-23	BIS	ETF	651.2	651.2	651.2	651.2	7.5
2005-09-23	BITS	ETF	11.8	11.8	11.2	11.28	7119.0
2005-09-23	BKF	ETF	31.58	31.9	31.25	31.84	29800.0
2005-09-23	BNE	ETF	14.0	14.06	13.98	14.06	90800.0
2005-09-23	BRF	ETF	15.42	15.42	15.18	15.23	16800.0
2005-09-23	BTF	ETF	86.05	86.69999999999999	85.8	86.69999999999999	5080.0
2005-09-23	CBON	ETF	32.5	32.61	32.5	32.61	900.0
2005-09-23	CDC	ETF	3.57	4.05	3.57	4.04	22200.0
2005-09-23	CDL	ETF	12.99	13.34	12.84	13.34	332100.0
2005-09-23	CEF	ETF	5.57	5.58	5.5	5.56	336300.0
2005-09-23	CEW	ETF	25.89	25.9	25.89	25.9	700.0
2005-09-23	CHB	ETF	14.48	14.53	13.87	14.42	674800.0
2005-09-23	CHI	ETF	20.17	20.17	19.87	20.0	155400.0
2005-09-23	CHIC	ETF	13.89	14.0	13.75	13.93	192405.0
2005-09-23	CHIR	ETF	43.41	43.7199	43.3299	43.47	1288469.0
2005-09-23	CHY	ETF	16.27	16.32	16.15	16.24	101200.0
2005-09-23	CIL	ETF	25.95	25.95	25.95	25.95	100.0
2005-09-23	CIZ	ETF	22.0	22.0	21.75	21.75	1100.0
2005-09-23	CN	ETF	33.85	33.85	33.5	33.7	8400.0
2005-09-23	CNXT	ETF	1.79	1.85	1.76	1.84	8892071.0
2005-09-23	CPST	ETF	4.18	4.43	4.12	4.19	4445413.0
2005-09-23	CSB	ETF	29.06	29.11	28.84	28.95	19500.0
2005-09-23	CSM	ETF	2.4275	2.4275	2.4275	2.4275	400.0
2005-09-23	CSQ	ETF	13.7	13.8	13.59	13.8	340700.0
2005-09-23	CTEC	ETF	52.199999999999996	53.25	51.25	51.849999999999994	4025.2000000000003
2005-09-23	CURE	ETF	0.22	0.22	0.19	0.2062	4756304.0
2005-09-23	CYA	ETF	66.0	74.0	63.0	74.0	2180.0
2005-09-23	CYB	ETF	4.05	4.1	4.02	4.1	16800.0
2005-09-23	DGT	ETF	64.58	64.58	64.42	64.47	1000.0
2005-09-23	DIG	ETF	14.425	14.4375	14.425	14.4375	2320.0
2005-09-23	DIV	ETF	13.21	13.25	12.98	13.05	61500.0
2005-09-23	DRIV	ETF	35.25	35.53	34.91	35.38	536698.0
2005-09-23	DSI	ETF	5.625	5.635	5.62	5.63	6600.0

> showing 50 of 278 rows — these rows as CSV

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