PREVIEW / etf_daily / 2006-06-23

all etf daily files

  file:    by_date/etf_daily/2006/2006-06-23.parquet
  size:    18 KB
  rows:    353

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
2006-06-23	SPY	ETF	124.33	125.3	124.03	124.44	54107000.0
2006-06-23	QQQ	ETF	38.16	38.53	37.93	38.15	88050200.0
2006-06-23	IWM	ETF	68.23	69.05	67.72	68.65	42901800.0
2006-06-23	DIA	ETF	110.01	110.69	109.66	109.97	6711600.0
2006-06-23	GLD	ETF	57.27	58.3	57.27	57.99	6106700.0
2006-06-23	TLT	ETF	83.62	83.73	83.35	83.42	675500.0
2006-06-23	AAA	ETF	53.95	54.2899	53.94	54.16	5900.0
2006-06-23	ADRE	ETF	115.14	117.52	115.0	117.22	27876.0
2006-06-23	AFK	ETF	24.8	24.85	24.74	24.77	3900.0
2006-06-23	AGG	ETF	97.23	97.31	97.11	97.22	331800.0
2006-06-23	AIQ	ETF	30.0	31.65	28.775	31.05	13860.0
2006-06-23	AIS	ETF	1.16	1.2	1.14	1.1999	35100.0
2006-06-23	AOM	ETF	6.25	6.25	6.2	6.2	6400.0
2006-06-23	ARB	ETF	36.9	37.32	36.76	37.01	232400.0
2006-06-23	BAB	ETF	63.06	63.7	62.99	63.4	60100.0
2006-06-23	BBC	ETF	12.2	12.27	11.75	12.27	348800.0
2006-06-23	BBH	ETF	56.3667	57.11	56.3667	56.8333	416400.0
2006-06-23	BCM	ETF	66.85	68.19	66.85	67.62	54000.0
2006-06-23	BITS	ETF	18.68	19.68	18.6	19.08	23223.0
2006-06-23	BKF	ETF	6.18	6.18	6.02	6.02	96600.0
2006-06-23	BNE	ETF	13.71	13.8	13.3	13.58	109500.0
2006-06-23	BRF	ETF	13.96	13.96	13.91	13.96	3000.0
2006-06-23	BTF	ETF	89.19999999999999	89.25	89.19999999999999	89.25	40.0
2006-06-23	CBON	ETF	29.16	29.22	28.93	29.06	21601.0
2006-06-23	CDL	ETF	8.8	8.91	8.75	8.86	181200.0
2006-06-23	CEF	ETF	8.52	8.52	8.35	8.47	373400.0
2006-06-23	CEW	ETF	26.0	26.0	25.9	25.9	500.0
2006-06-23	CFO	ETF	9.65	9.65	9.57	9.57	2000.0
2006-06-23	CGO	ETF	14.05	14.25	14.05	14.25	33400.0
2006-06-23	CHB	ETF	10.31	10.55	10.23	10.33	566000.0
2006-06-23	CHI	ETF	19.16	19.22	19.06	19.15	55000.0
2006-06-23	CHIC	ETF	20.57	21.78	20.46	21.58	653054.0
2006-06-23	CHY	ETF	16.03	16.06	16.0	16.0	180200.0
2006-06-23	CIL	ETF	25.04	25.04	25.04	25.04	200.0
2006-06-23	CIZ	ETF	23.0	23.0	23.0	23.0	200.0
2006-06-23	CN	ETF	32.55	33.33	32.53	33.25	75500.0
2006-06-23	CNXT	ETF	2.335	2.37	2.3	2.31	7629201.0
2006-06-23	COMB	ETF	9.8	9.8	9.64	9.77	12743.0
2006-06-23	CPI	ETF	30.2	30.2	29.27	29.27	3200.0
2006-06-23	CPST	ETF	2.57	2.65	2.55	2.58	755886.0
2006-06-23	CSA	ETF	19.24	20.15	18.9	19.95	13100.0
2006-06-23	CSB	ETF	27.0	27.01	26.75	26.81	7700.0
2006-06-23	CSQ	ETF	13.84	13.9	13.77	13.86	314600.0
2006-06-23	CTEC	ETF	63.550000000000004	64.8	62.64999999999999	63.550000000000004	13276.0
2006-06-23	CYB	ETF	5.76	6.16	5.76	6.13	54400.0
2006-06-23	DBC	ETF	24.22	24.5	24.22	24.39	151400.0
2006-06-23	DDM	ETF	5.9058	5.9658	5.8842	5.9092	967200.0
2006-06-23	DES	ETF	16.58	16.74	16.58	16.6533	33900.0
2006-06-23	DFJ	ETF	50.13	50.13	50.13	50.13	100.0
2006-06-23	DGT	ETF	65.29	65.55	65.29	65.33	2500.0

> showing 50 of 353 rows — these rows as CSV

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