PREVIEW / etf_daily / 2005-11-09

all etf daily files

  file:    by_date/etf_daily/2005/2005-11-09.parquet
  size:    15 KB
  rows:    284

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-11-09	SPY	ETF	122.08	122.95	121.86	122.39	57666800.0
2005-11-09	QQQ	ETF	40.12	40.33	40.03	40.159	72458775.0
2005-11-09	IWM	ETF	65.42	66.1	65.11	65.7	29761700.0
2005-11-09	DIA	ETF	105.42	106.11	105.27	105.6	4387700.0
2005-11-09	GLD	ETF	46.12	46.65	46.03	46.56	1382700.0
2005-11-09	TLT	ETF	88.78	88.93	88.36	88.36	1140300.0
2005-11-09	AAA	ETF	56.62	56.62	56.083	56.6	1800.0
2005-11-09	ADRE	ETF	105.51	107.4	105.51	107.07	51780.0
2005-11-09	AFK	ETF	25.4	25.4	25.39	25.39	3000.0
2005-11-09	AGG	ETF	99.88	99.89	99.57	99.64	132600.0
2005-11-09	AIQ	ETF	31.7	31.7	29.35	29.6	30240.0
2005-11-09	AIS	ETF	1.28	1.29	1.2	1.26	271100.0
2005-11-09	AOM	ETF	3.54	3.54	3.4	3.44	62200.0
2005-11-09	ARB	ETF	37.53	38.09	37.489	37.9	239800.0
2005-11-09	BAB	ETF	54.8	55.36	54.469	55.29	10000.0
2005-11-09	BBC	ETF	6.56	6.57	6.12	6.4	76400.0
2005-11-09	BBH	ETF	67.3333	67.6567	66.9633	67.3833	1095600.0
2005-11-09	BCM	ETF	61.22	62.07	61.09	61.95	91300.0
2005-11-09	BITS	ETF	14.88	15.52	13.84	14.24	38023.0
2005-11-09	BKF	ETF	20.01	21.9	20.01	21.01	100200.0
2005-11-09	BNE	ETF	15.0	15.35	14.98	15.09	169400.0
2005-11-09	BRF	ETF	15.38	15.38	15.23	15.27	11800.0
2005-11-09	BTF	ETF	86.9005	86.99999999999999	86.69999999999999	86.8	1820.0
2005-11-09	CBON	ETF	32.85	33.15	32.7001	33.0	1394.0
2005-11-09	CDL	ETF	13.83	13.87	13.67	13.68	189900.0
2005-11-09	CEF	ETF	5.74	5.77	5.71	5.76	302400.0
2005-11-09	CEW	ETF	25.8	26.0	25.8	26.0	900.0
2005-11-09	CGO	ETF	15.0	15.01	15.0	15.01	37100.0
2005-11-09	CHB	ETF	14.46	14.8	14.21	14.52	364600.0
2005-11-09	CHI	ETF	20.16	20.38	20.16	20.26	73800.0
2005-11-09	CHIC	ETF	17.0	17.15	16.55	16.9	617677.0
2005-11-09	CHIR	ETF	44.1801	44.1999	44.07	44.1099	1865462.0
2005-11-09	CHY	ETF	16.08	16.11	15.99	16.06	93100.0
2005-11-09	CN	ETF	33.4	33.4	33.0	33.17	12700.0
2005-11-09	CNXT	ETF	2.19	2.28	2.15	2.28	6329819.0
2005-11-09	CPI	ETF	24.2	24.25	24.05	24.25	5400.0
2005-11-09	CPST	ETF	2.69	2.76	2.55	2.61	1912874.0
2005-11-09	CSA	ETF	17.01	17.02	17.0	17.01	59100.0
2005-11-09	CSB	ETF	28.51	28.64	28.39	28.61	4300.0
2005-11-09	CSM	ETF	2.4325	2.4325	2.43	2.43	10000.0
2005-11-09	CSQ	ETF	13.34	13.36	13.2	13.24	361200.0
2005-11-09	CTEC	ETF	40.99999999999999	41.15	39.949999999999996	40.25	17831.4
2005-11-09	CURE	ETF	0.0825	0.0825	0.0725	0.075	743992.0
2005-11-09	CYB	ETF	3.29	3.35	3.25	3.35	16900.0
2005-11-09	DGT	ETF	64.29	64.49	64.29	64.49	5700.0
2005-11-09	DIG	ETF	13.75	13.775	13.75	13.775	2240.0
2005-11-09	DIV	ETF	12.03	12.07	12.0	12.04	9900.0
2005-11-09	DRIV	ETF	25.84	26.24	25.76	26.01	1154529.0
2005-11-09	DUSA	ETF	10.0	10.34	9.99	10.1	114354.0
2005-11-09	DVY	ETF	60.97	61.54	60.91	61.26	251400.0

> showing 50 of 284 rows — these rows as CSV

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