PREVIEW / etf_daily / 2006-09-15

all etf daily files

  file:    by_date/etf_daily/2006/2006-09-15.parquet
  size:    18 KB
  rows:    361

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-09-15	SPY	ETF	132.31	132.39	131.68	131.96	76703100.0
2006-09-15	QQQ	ETF	40.35	40.46	40.0	40.11	137846021.0
2006-09-15	IWM	ETF	73.0	73.02	72.17	72.66	40826200.0
2006-09-15	DIA	ETF	115.84	116.03	115.45	115.59	7672200.0
2006-09-15	GLD	ETF	57.2	57.79	56.66	57.4	6454800.0
2006-09-15	TLT	ETF	87.76	87.95	87.45	87.46	1047200.0
2006-09-15	AAA	ETF	57.2	57.33	57.0	57.05	4000.0
2006-09-15	ADRE	ETF	32.39	32.39	31.6425	31.7775	169603.0
2006-09-15	AFK	ETF	25.04	25.08	25.0	25.0	6000.0
2006-09-15	AGG	ETF	99.45	99.45	99.25	99.25	122500.0
2006-09-15	AIQ	ETF	41.2	41.3	39.35	39.6	54980.0
2006-09-15	AIS	ETF	1.1	1.1	1.05	1.07	97200.0
2006-09-15	ARB	ETF	38.24	38.56	37.95	38.23	258800.0
2006-09-15	BAB	ETF	81.02	81.6	80.7	80.95	50600.0
2006-09-15	BBC	ETF	10.9	10.9	10.66	10.86	156500.0
2006-09-15	BBH	ETF	59.7833	59.7967	59.4	59.7733	1010100.0
2006-09-15	BITS	ETF	28.24	28.4404	27.64	28.04	9803.0
2006-09-15	BNE	ETF	14.65	14.66	14.31	14.39	290200.0
2006-09-15	BOSS	ETF	33.3	34.54	33.3	34.54	100.0
2006-09-15	BRF	ETF	14.14	14.18	14.14	14.18	2200.0
2006-09-15	BTF	ETF	93.85	94.55	93.85	94.1	5640.0
2006-09-15	CBON	ETF	33.13	33.14	32.59	32.59	35360.0
2006-09-15	CDL	ETF	9.13	9.26	9.13	9.16	344300.0
2006-09-15	CEF	ETF	7.95	8.15	7.93	8.15	601700.0
2006-09-15	CEW	ETF	25.33	25.35	25.29	25.29	900.0
2006-09-15	CFO	ETF	9.85	9.85	9.8	9.8	2900.0
2006-09-15	CGO	ETF	15.41	15.6	15.4	15.57	23700.0
2006-09-15	CHB	ETF	6.6	6.79	6.46	6.75	2447800.0
2006-09-15	CHI	ETF	19.46	19.56	19.41	19.47	140800.0
2006-09-15	CHIC	ETF	26.02	26.42	25.88	26.0	5897073.0
2006-09-15	CHY	ETF	16.73	16.73	16.61	16.68	148800.0
2006-09-15	CIL	ETF	25.6	25.6	25.6	25.6	400.0
2006-09-15	CIZ	ETF	22.2	22.35	22.2	22.35	900.0
2006-09-15	CN	ETF	35.29	35.3	35.02	35.2	28900.0
2006-09-15	CNXT	ETF	1.91	1.92	1.85	1.85	11095001.0
2006-09-15	COMB	ETF	10.0	10.1	9.96	9.96	7700.0
2006-09-15	CPI	ETF	24.7	25.0	24.7	24.9	800.0
2006-09-15	CPST	ETF	1.66	1.66	1.46	1.52	4123766.0
2006-09-15	CSA	ETF	20.65	20.7	20.6	20.6	22900.0
2006-09-15	CSB	ETF	28.46	28.8	28.46	28.79	22200.0
2006-09-15	CSQ	ETF	14.49	14.51	14.42	14.5	410000.0
2006-09-15	CTEC	ETF	63.49999999999999	64.45	62.9995	64.3	23467.4
2006-09-15	CYB	ETF	6.28	6.37	6.28	6.35	58700.0
2006-09-15	DBC	ETF	23.3	23.5002	23.07	23.3	616300.0
2006-09-15	DDM	ETF	6.5083	6.5167	6.4742	6.4983	902400.0
2006-09-15	DES	ETF	17.9167	17.9967	17.9033	17.9933	50400.0
2006-09-15	DEW	ETF	54.48	54.57	54.2	54.4	14200.0
2006-09-15	DFE	ETF	54.88	54.88	54.86	54.88	1000.0
2006-09-15	DFJ	ETF	49.63	49.63	49.28	49.42	4500.0
2006-09-15	DGT	ETF	70.65	70.67	70.16	70.3	6700.0

> showing 50 of 361 rows — these rows as CSV

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