PREVIEW / etf_daily / 2005-09-30

all etf daily files

  file:    by_date/etf_daily/2005/2005-09-30.parquet
  size:    15 KB
  rows:    282

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-30	SPY	ETF	122.62	123.04	121.74	123.04	47824200.0
2005-09-30	QQQ	ETF	39.16	39.48	39.13	39.46	79260099.0
2005-09-30	IWM	ETF	66.04	66.44	65.79	66.39	29016300.0
2005-09-30	DIA	ETF	105.36	105.79	105.2	105.75	4172600.0
2005-09-30	GLD	ETF	47.09	47.2	46.65	46.7	1194400.0
2005-09-30	TLT	ETF	92.58	92.69	92.0	92.2	1391800.0
2005-09-30	AAA	ETF	56.1	56.36	56.07	56.33	1300.0
2005-09-30	ADRE	ETF	110.76	110.76	108.3901	109.09	22328.0
2005-09-30	AFK	ETF	25.4	25.52	25.4	25.52	3600.0
2005-09-30	AGG	ETF	101.69	101.76	101.34	101.55	127300.0
2005-09-30	AIQ	ETF	43.25	43.65	42.5	42.75	10120.0
2005-09-30	AIS	ETF	0.89	1.0	0.87	1.0	349800.0
2005-09-30	ARB	ETF	40.35	40.35	39.4	39.84	164000.0
2005-09-30	BAB	ETF	51.44	52.1	51.09	51.72	33500.0
2005-09-30	BBC	ETF	7.11	7.11	6.75	6.9	48000.0
2005-09-30	BBH	ETF	63.2667	63.6867	63.0333	63.5733	1592100.0
2005-09-30	BCM	ETF	62.14	62.9	62.0	62.48	21800.0
2005-09-30	BIS	ETF	635.2	646.4	635.2	646.4	25.0
2005-09-30	BITS	ETF	10.84	11.4224	10.68	10.92	5016.0
2005-09-30	BKF	ETF	31.78	31.78	30.85	30.93	20200.0
2005-09-30	BNE	ETF	14.2	14.31	14.04	14.29	79100.0
2005-09-30	BRF	ETF	15.24	15.3	15.21	15.23	4100.0
2005-09-30	BTF	ETF	84.74999999999999	86.85	84.74999999999999	86.5	5980.0
2005-09-30	CBON	ETF	32.62	33.0	32.55	32.99	11189.0
2005-09-30	CDC	ETF	3.91	3.91	3.85	3.85	4100.0
2005-09-30	CDL	ETF	13.61	13.85	13.54	13.73	521200.0
2005-09-30	CEF	ETF	5.75	5.75	5.61	5.65	333500.0
2005-09-30	CEW	ETF	25.92	26.0	25.9	25.9	600.0
2005-09-30	CHB	ETF	14.86	14.97	14.3	14.78	853400.0
2005-09-30	CHI	ETF	20.0	20.13	19.96	20.05	69300.0
2005-09-30	CHIC	ETF	13.29	13.5	13.1	13.32	594708.0
2005-09-30	CHIR	ETF	43.5501	43.7001	43.38	43.65	1067794.0
2005-09-30	CHY	ETF	16.22	16.43	16.22	16.39	64300.0
2005-09-30	CIL	ETF	25.9	25.9	25.9	25.9	1000.0
2005-09-30	CIZ	ETF	21.47	21.5	21.47	21.5	400.0
2005-09-30	CN	ETF	34.35	34.4	34.15	34.34	23900.0
2005-09-30	CNXT	ETF	1.88	1.89	1.76	1.79	23798531.0
2005-09-30	COMB	ETF	8.121	8.16	7.75	8.16	600.0
2005-09-30	CPI	ETF	24.11	24.11	24.0	24.09	600.0
2005-09-30	CPST	ETF	3.63	3.73	3.51	3.55	7652380.0
2005-09-30	CSB	ETF	29.38	29.6	29.3	29.3	321000.0
2005-09-30	CSM	ETF	2.4325	2.435	2.4325	2.435	8000.0
2005-09-30	CSQ	ETF	14.08	14.11	13.92	13.99	296200.0
2005-09-30	CTEC	ETF	50.0	50.9	49.599999999999994	50.4	5057.6
2005-09-30	CURE	ETF	0.1125	0.1212	0.1125	0.1212	2428792.0
2005-09-30	CYA	ETF	71.0	74.0	70.0	73.4	1755.0
2005-09-30	CYB	ETF	3.75	3.85	3.61	3.84	6100.0
2005-09-30	DGT	ETF	65.1	65.17	64.91	64.93	1800.0
2005-09-30	DIG	ETF	14.9125	14.9125	14.9125	14.9125	2000.0
2005-09-30	DIV	ETF	13.2	13.28	13.116	13.28	14700.0

> showing 50 of 282 rows — these rows as CSV

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