PREVIEW / etf_daily / 2006-11-09

all etf daily files

  file:    by_date/etf_daily/2006/2006-11-09.parquet
  size:    19 KB
  rows:    382

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-11-09	SPY	ETF	139.01	139.14	137.9	138.18	95916300.0
2006-11-09	QQQ	ETF	43.27	43.35	42.67	42.8	124303206.0
2006-11-09	IWM	ETF	76.74	76.8	75.33	75.89	49553600.0
2006-11-09	DIA	ETF	121.78	121.9	120.91	121.16	5962600.0
2006-11-09	GLD	ETF	62.12	63.13	61.94	62.95	6634800.0
2006-11-09	TLT	ETF	89.47	89.59	89.38	89.47	729600.0
2006-11-09	AAA	ETF	56.42	56.93	56.29	56.31	7700.0
2006-11-09	ADRE	ETF	35.62	35.8	35.37	35.445	176276.0
2006-11-09	AGG	ETF	100.03	100.12	99.95	100.1	127200.0
2006-11-09	AIQ	ETF	38.8	38.8	37.75	38.05	14180.0
2006-11-09	AIS	ETF	1.27	1.3	1.2	1.21	189600.0
2006-11-09	ARB	ETF	43.15	43.53	42.6	42.69	407300.0
2006-11-09	BAB	ETF	86.96	87.71	86.7	87.13	29000.0
2006-11-09	BBC	ETF	10.1	10.75	10.0	10.58	315600.0
2006-11-09	BBH	ETF	64.42	64.42	62.2333	62.4333	1662300.0
2006-11-09	BITS	ETF	38.4	39.92	37.64	38.36	85528.0
2006-11-09	BNE	ETF	15.3	15.38	14.75	14.8	204700.0
2006-11-09	BRF	ETF	14.3	14.3	14.25	14.3	25900.0
2006-11-09	BTF	ETF	104.8	105.55	104.8	105.25	4520.0
2006-11-09	CBON	ETF	29.92	29.97	29.29	29.84	81230.0
2006-11-09	CDL	ETF	10.6	10.6	10.39	10.53	288000.0
2006-11-09	CEF	ETF	8.81	9.09	8.81	9.09	547300.0
2006-11-09	CEW	ETF	25.52	25.52	25.52	25.52	1200.0
2006-11-09	CFO	ETF	10.65	10.8	10.45	10.8	5400.0
2006-11-09	CGO	ETF	15.83	15.83	15.61	15.64	39800.0
2006-11-09	CHB	ETF	8.65	8.7	8.42	8.49	1201500.0
2006-11-09	CHI	ETF	19.59	19.66	19.39	19.55	150900.0
2006-11-09	CHIC	ETF	26.48	27.53	25.97	27.22	1654641.0
2006-11-09	CHY	ETF	16.83	16.88	16.75	16.77	157300.0
2006-11-09	CIL	ETF	25.82	25.82	25.82	25.82	200.0
2006-11-09	CIZ	ETF	21.95	21.95	21.85	21.85	2200.0
2006-11-09	CN	ETF	40.78	41.15	40.43	40.85	62000.0
2006-11-09	CNXT	ETF	2.12	2.14	2.01	2.06	9638457.0
2006-11-09	CPST	ETF	1.64	1.65	1.58	1.62	2040846.0
2006-11-09	CSA	ETF	19.71	19.75	19.22	19.71	55100.0
2006-11-09	CSB	ETF	31.18	31.43	31.078	31.3	10400.0
2006-11-09	CSM	ETF	1.31	1.375	1.31	1.375	22000.0
2006-11-09	CSQ	ETF	14.87	14.88	14.76	14.79	432700.0
2006-11-09	CTEC	ETF	87.75	89.85	87.2	89.0	70447.6
2006-11-09	CVY	ETF	26.0	26.02	25.87	25.87	87800.0
2006-11-09	CYB	ETF	6.65	6.71	6.575	6.59	28900.0
2006-11-09	DBC	ETF	25.4	25.4	25.0	25.29	393900.0
2006-11-09	DBV	ETF	25.41	25.41	25.25	25.34	48700.0
2006-11-09	DDM	ETF	7.1342	7.1417	7.03	7.0567	1764000.0
2006-11-09	DES	ETF	18.6733	18.6733	18.46	18.5	36000.0
2006-11-09	DEW	ETF	59.22	59.43	58.99	59.08	8700.0
2006-11-09	DFE	ETF	60.02	60.33	59.93	59.93	5300.0
2006-11-09	DFJ	ETF	48.24	48.53	48.24	48.28	3500.0
2006-11-09	DGT	ETF	74.56	74.56	74.02	74.2	28500.0
2006-11-09	DHS	ETF	56.45	56.45	55.88	55.88	16100.0

> showing 50 of 382 rows — these rows as CSV

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