PREVIEW / etf_daily / 2005-07-28

all etf daily files

  file:    by_date/etf_daily/2005/2005-07-28.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-28	SPY	ETF	123.96	124.64	123.64	124.57	47880700.0
2005-07-28	QQQ	ETF	39.75	39.921	39.64	39.91	67122748.0
2005-07-28	IWM	ETF	67.37	68.0	67.02	67.96	21416900.0
2005-07-28	DIA	ETF	106.62	107.13	106.33	107.07	6609300.0
2005-07-28	GLD	ETF	42.46	42.79	42.46	42.75	3673300.0
2005-07-28	TLT	ETF	93.38	94.17	93.38	94.04	578900.0
2005-07-28	AAA	ETF	52.42	52.74	52.31	52.63	4500.0
2005-07-28	ADRE	ETF	97.0	97.0	95.78	96.58	9440.0
2005-07-28	AFK	ETF	25.88	25.88	25.76	25.77	4800.0
2005-07-28	AGG	ETF	101.98	102.32	101.98	102.3	403000.0
2005-07-28	AIQ	ETF	50.25	52.0	50.1	51.4	18560.0
2005-07-28	AIS	ETF	1.1	1.1	1.05	1.07	46900.0
2005-07-28	ARB	ETF	42.72	42.99	42.51	42.61	222400.0
2005-07-28	BAB	ETF	49.1	49.45	48.9	49.28	9900.0
2005-07-28	BBH	ETF	64.0	64.5433	63.95	64.2533	732900.0
2005-07-28	BCM	ETF	65.15	65.77	65.15	65.7	16700.0
2005-07-28	BIS	ETF	662.4	662.4	660.8	660.8	9.4
2005-07-28	BITS	ETF	13.52	13.64	12.88	12.96	2067.0
2005-07-28	BKF	ETF	34.1	34.95	34.1	34.7	17100.0
2005-07-28	BNE	ETF	13.1	13.67	13.04	13.2	756400.0
2005-07-28	BRF	ETF	15.56	15.58	15.45	15.58	4300.0
2005-07-28	BTF	ETF	87.2	88.14999999999999	87.2	88.14999999999999	3880.0
2005-07-28	CBON	ETF	32.48	32.93	31.89	32.59	61732.0
2005-07-28	CDC	ETF	6.1	6.13	5.71	5.75	9900.0
2005-07-28	CDL	ETF	12.53	12.53	12.37	12.44	275300.0
2005-07-28	CEF	ETF	5.18	5.24	5.18	5.22	288400.0
2005-07-28	CEW	ETF	26.7	26.7	26.7	26.7	500.0
2005-07-28	CHB	ETF	12.45	12.7	12.2	12.7	318500.0
2005-07-28	CHI	ETF	20.1	20.2	20.03	20.2	102200.0
2005-07-28	CHIC	ETF	14.89	14.97	14.77	14.97	76150.0
2005-07-28	CHIR	ETF	36.2301	36.54	35.61	36.4899	920461.0
2005-07-28	CHY	ETF	16.51	16.61	16.5	16.6	69700.0
2005-07-28	CIL	ETF	25.82	25.82	25.82	25.82	1000.0
2005-07-28	CIZ	ETF	22.45	22.45	22.45	22.45	200.0
2005-07-28	CN	ETF	30.65	30.7	30.4	30.68	10300.0
2005-07-28	CNXT	ETF	2.07	2.17	1.93	1.96	26740781.0
2005-07-28	CPST	ETF	1.84	1.88	1.81	1.83	855245.0
2005-07-28	CSB	ETF	29.77	30.2	29.77	30.2	8600.0
2005-07-28	CSM	ETF	2.425	2.425	2.4175	2.42	12800.0
2005-07-28	CSQ	ETF	14.4	14.5	14.39	14.5	431900.0
2005-07-28	CTEC	ETF	57.24999999999999	57.24999999999999	56.15	56.65	14566.800000000001
2005-07-28	CURE	ETF	0.3	0.3125	0.2812	0.2875	1152800.0
2005-07-28	CYA	ETF	121.0	121.8	115.0	116.0	830.0
2005-07-28	CYB	ETF	3.35	3.43	3.26	3.37	25400.0
2005-07-28	DGT	ETF	64.5	64.8	64.25	64.5	10600.0
2005-07-28	DIG	ETF	12.275	12.275	12.275	12.275	240.0
2005-07-28	DIV	ETF	13.82	13.85	13.73	13.74	8900.0
2005-07-28	DRIV	ETF	40.26	41.75	39.26	40.35	6748850.0
2005-07-28	DSI	ETF	5.83	5.84	5.8	5.84	7400.0
2005-07-28	DUSA	ETF	9.13	9.55	9.13	9.49	115462.0

> showing 50 of 277 rows — these rows as CSV

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