PREVIEW / etf_daily / 2005-06-09

all etf daily files

  file:    by_date/etf_daily/2005/2005-06-09.parquet
  size:    15 KB
  rows:    270

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-06-09	SPY	ETF	119.74	120.58	119.44	120.48	56653300.0
2005-06-09	QQQ	ETF	37.66	38.06	37.5	37.95	99440618.0
2005-06-09	IWM	ETF	61.67	62.42	61.36	62.32	21813800.0
2005-06-09	DIA	ETF	104.72	105.24	104.38	104.98	4067300.0
2005-06-09	GLD	ETF	42.24	42.4	42.03	42.27	694700.0
2005-06-09	TLT	ETF	95.67	96.01	95.43	95.97	612700.0
2005-06-09	AAA	ETF	58.05	58.1	57.88	58.04	1100.0
2005-06-09	ADRE	ETF	89.48	89.48	87.86	88.518	9400.0
2005-06-09	AFK	ETF	26.45	26.59	26.4	26.47	3100.0
2005-06-09	AGG	ETF	102.94	103.02	102.56	103.0	107400.0
2005-06-09	AIQ	ETF	50.75	53.65	50.75	53.6	24560.0
2005-06-09	AIS	ETF	0.76	0.77	0.73	0.76	61600.0
2005-06-09	ARB	ETF	42.1	42.42	41.85	42.22	70500.0
2005-06-09	BAB	ETF	50.4	51.1	50.3	50.9	55500.0
2005-06-09	BBH	ETF	55.33	56.2167	55.2367	55.8667	1688700.0
2005-06-09	BCM	ETF	59.0	59.82	59.0	59.47	57400.0
2005-06-09	BIS	ETF	561.6	600.0	561.6	600.0	54.5
2005-06-09	BITS	ETF	12.0	12.2	11.68	11.9596	4225.0
2005-06-09	BKF	ETF	38.65	39.25	37.14	37.98	33600.0
2005-06-09	BNE	ETF	13.17	13.4	13.08	13.4	57000.0
2005-06-09	BRF	ETF	15.5	15.5	15.46	15.46	15200.0
2005-06-09	BTF	ETF	85.99999999999999	86.19999999999999	85.5	85.64999999999999	1580.0
2005-06-09	CBON	ETF	29.2	29.2	28.93	28.93	27386.0
2005-06-09	CDC	ETF	8.78	8.95	8.55	8.9	15200.0
2005-06-09	CDL	ETF	12.21	12.29	12.09	12.18	865300.0
2005-06-09	CEF	ETF	5.37	5.37	5.26	5.28	282600.0
2005-06-09	CGW	ETF	27.8	27.8	27.0	27.16	17300.0
2005-06-09	CHB	ETF	9.98	10.09	9.85	10.03	290900.0
2005-06-09	CHI	ETF	19.65	19.73	19.58	19.66	69400.0
2005-06-09	CHIC	ETF	12.56	12.94	12.51	12.71	137870.0
2005-06-09	CHIR	ETF	37.1301	37.8999	36.9399	37.4499	706785.0
2005-06-09	CHY	ETF	16.23	16.27	16.16	16.17	85900.0
2005-06-09	CIL	ETF	25.51	25.53	25.51	25.51	1700.0
2005-06-09	CN	ETF	27.0	27.0	26.9	26.9	5600.0
2005-06-09	CNXT	ETF	1.51	1.55	1.47	1.52	3991375.0
2005-06-09	CPI	ETF	23.0	23.0	23.0	23.0	3000.0
2005-06-09	CPST	ETF	0.91	0.99	0.89	0.99	778753.0
2005-06-09	CSB	ETF	31.0	31.48	30.98	31.2	36400.0
2005-06-09	CSQ	ETF	13.8	13.91	13.8	13.91	338700.0
2005-06-09	CTEC	ETF	46.050000000000004	46.849999999999994	46.050000000000004	46.849999999999994	3025.8
2005-06-09	CURE	ETF	0.3187	0.32	0.3025	0.3088	713608.0
2005-06-09	CYA	ETF	182.8	184.0	174.2	180.0	1030.0
2005-06-09	CYB	ETF	2.94	2.96	2.93	2.96	19000.0
2005-06-09	CZA	ETF	10.51	10.51	10.51	10.51	100.0
2005-06-09	DGT	ETF	63.85	64.19	63.85	64.19	1700.0
2005-06-09	DIV	ETF	13.8	13.84	13.71	13.78	9500.0
2005-06-09	DRIV	ETF	27.42	28.98	27.42	28.72	1149812.0
2005-06-09	DSI	ETF	5.915	5.915	5.905	5.915	8200.0
2005-06-09	DUSA	ETF	10.25	10.48	10.23	10.46	45209.0
2005-06-09	DVY	ETF	61.6	61.7	61.25	61.69	248500.0

> showing 50 of 270 rows — these rows as CSV

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