PREVIEW / etf_daily / 2005-11-16

all etf daily files

  file:    by_date/etf_daily/2005/2005-11-16.parquet
  size:    16 KB
  rows:    294

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-16	SPY	ETF	123.37	123.55	122.98	123.49	51133000.0
2005-11-16	QQQ	ETF	40.645	40.78	40.46	40.768	65912623.0
2005-11-16	IWM	ETF	65.33	65.5	64.58	65.25	28408200.0
2005-11-16	DIA	ETF	107.16	107.35	106.73	107.04	6907300.0
2005-11-16	GLD	ETF	47.29	47.78	47.22	47.78	2355200.0
2005-11-16	TLT	ETF	89.8	90.44	89.75	90.34	1822300.0
2005-11-16	AAA	ETF	53.4	53.4	52.94	53.11	8100.0
2005-11-16	ADRE	ETF	107.23	108.28	107.23	108.28	27656.0
2005-11-16	AFK	ETF	25.42	25.45	25.41	25.45	600.0
2005-11-16	AGG	ETF	100.09	100.31	99.9	100.12	150000.0
2005-11-16	AIQ	ETF	27.3	27.6	24.75	24.85	69600.0
2005-11-16	AIS	ETF	1.18	1.21	1.15	1.1999	84200.0
2005-11-16	AOM	ETF	3.55	3.65	3.5	3.57	17500.0
2005-11-16	ARB	ETF	37.24	38.2	37.22	38.0	300100.0
2005-11-16	BAB	ETF	53.81	54.4099	53.56	54.02	19700.0
2005-11-16	BBC	ETF	6.6	6.65	6.37	6.38	107200.0
2005-11-16	BBH	ETF	68.8333	68.98	68.3467	68.9667	1323300.0
2005-11-16	BCM	ETF	62.47	62.89	62.38	62.81	71300.0
2005-11-16	BITS	ETF	14.04	14.68	13.6	13.64	14709.0
2005-11-16	BKF	ETF	21.94	22.75	21.84	21.9	108000.0
2005-11-16	BNE	ETF	15.14	15.25	14.94	15.18	77500.0
2005-11-16	BRF	ETF	15.07	15.1	15.0	15.07	15900.0
2005-11-16	BTF	ETF	87.75	87.75	87.44999999999999	87.5	1080.0
2005-11-16	CBON	ETF	32.9	33.22	32.9	33.22	18593.0
2005-11-16	CDL	ETF	13.56	13.6	13.34	13.46	385300.0
2005-11-16	CEF	ETF	5.79	5.93	5.77	5.92	686100.0
2005-11-16	CEW	ETF	25.9	25.9	25.9	25.9	500.0
2005-11-16	CGO	ETF	15.0	15.01	15.0	15.01	41000.0
2005-11-16	CHB	ETF	14.3	14.52	14.05	14.5	413000.0
2005-11-16	CHI	ETF	20.31	20.31	19.85	19.86	150900.0
2005-11-16	CHIC	ETF	16.83	17.23	16.63	16.99	228670.0
2005-11-16	CHIR	ETF	44.1501	44.22	44.1501	44.1999	791767.0
2005-11-16	CHY	ETF	15.96	15.96	15.45	15.52	224300.0
2005-11-16	CIL	ETF	26.12	26.12	26.06	26.07	500.0
2005-11-16	CN	ETF	33.8	33.8	33.4985	33.51	6400.0
2005-11-16	CNXT	ETF	2.1	2.2001	2.08	2.16	7404062.0
2005-11-16	COMB	ETF	8.4	8.4	8.4	8.4	3500.0
2005-11-16	CPI	ETF	25.3	25.35	25.3	25.35	300.0
2005-11-16	CPST	ETF	4.03	4.08	3.78	3.81	21175778.0
2005-11-16	CSA	ETF	17.0	17.02	17.0	17.0	29400.0
2005-11-16	CSB	ETF	28.0	28.2399	27.94	28.08	8400.0
2005-11-16	CSM	ETF	2.43	2.43	2.43	2.43	2400.0
2005-11-16	CSQ	ETF	12.98	13.08	12.95	13.04	476400.0
2005-11-16	CTEC	ETF	45.199999999999996	47.15	42.0	42.85	12439.6
2005-11-16	CURE	ETF	0.06	0.065	0.0575	0.0612	3558712.0
2005-11-16	CYB	ETF	3.51	3.55	3.5	3.5	39200.0
2005-11-16	DGT	ETF	64.1	64.39	64.1	64.34	2600.0
2005-11-16	DIG	ETF	14.25	14.5	14.25	14.5	5120.0
2005-11-16	DIV	ETF	11.83	11.83	11.79	11.82	44600.0
2005-11-16	DRIV	ETF	24.28	24.57	24.06	24.18	776826.0

> showing 50 of 294 rows — these rows as CSV

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