PREVIEW / etf_daily / 2006-11-13

all etf daily files

  file:    by_date/etf_daily/2006/2006-11-13.parquet
  size:    19 KB
  rows:    380

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-13	SPY	ETF	138.18	139.04	138.07	138.58	59398200.0
2006-11-13	QQQ	ETF	43.06	43.54	43.0	43.46	89171939.0
2006-11-13	IWM	ETF	76.43	76.99	76.2	76.63	39373200.0
2006-11-13	DIA	ETF	121.12	121.82	120.98	121.35	5695200.0
2006-11-13	GLD	ETF	61.93	62.25	61.77	62.19	3408800.0
2006-11-13	TLT	ETF	89.84	89.84	89.47	89.84	462400.0
2006-11-13	AAA	ETF	56.83	56.9	56.69	56.8301	3100.0
2006-11-13	ADRE	ETF	35.4	35.49	35.18	35.45	95468.0
2006-11-13	AGG	ETF	100.17	100.25	100.05	100.2	187800.0
2006-11-13	AIQ	ETF	37.5	38.0	36.65	37.45	20100.0
2006-11-13	AIS	ETF	1.21	1.29	1.21	1.29	104700.0
2006-11-13	ARB	ETF	43.64	44.1	43.51	44.08	217100.0
2006-11-13	BAB	ETF	87.57	88.52	87.47	88.47	37500.0
2006-11-13	BBC	ETF	9.0	9.28	8.25	8.51	1654400.0
2006-11-13	BBH	ETF	62.3833	62.9167	62.0533	62.1333	1205100.0
2006-11-13	BITS	ETF	38.52	39.48	38.04	39.04	27700.0
2006-11-13	BNE	ETF	15.05	15.5	15.03	15.46	190600.0
2006-11-13	BRF	ETF	14.29	14.29	14.21	14.23	29800.0
2006-11-13	BTF	ETF	105.5	105.5	104.89999999999999	105.05	8060.0
2006-11-13	CBON	ETF	29.76	30.35	29.63	30.29	46209.0
2006-11-13	CDL	ETF	10.43	10.5	10.34	10.35	139700.0
2006-11-13	CEF	ETF	9.15	9.19	9.05	9.19	935800.0
2006-11-13	CEW	ETF	25.53	25.53	25.53	25.53	100.0
2006-11-13	CFO	ETF	10.61	10.61	10.61	10.61	1500.0
2006-11-13	CGO	ETF	15.67	15.69	15.58	15.62	13300.0
2006-11-13	CHB	ETF	8.56	8.57	8.35	8.46	1102200.0
2006-11-13	CHI	ETF	19.56	19.65	19.5	19.54	120200.0
2006-11-13	CHIC	ETF	28.58	28.71	27.47	27.75	510582.0
2006-11-13	CHY	ETF	16.89	16.9	16.75	16.75	132400.0
2006-11-13	CIL	ETF	25.9	25.95	25.84	25.84	1800.0
2006-11-13	CN	ETF	40.24	40.52	40.18	40.5	66500.0
2006-11-13	CNXT	ETF	2.19	2.22	2.14	2.2	19980146.0
2006-11-13	CPST	ETF	1.42	1.45	1.38	1.4	1930775.0
2006-11-13	CSA	ETF	19.97	20.33	19.97	20.33	13300.0
2006-11-13	CSB	ETF	31.19	31.57	31.19	31.51	5900.0
2006-11-13	CSM	ETF	1.3	1.305	1.3	1.305	18000.0
2006-11-13	CSQ	ETF	14.83	14.86	14.76	14.85	344100.0
2006-11-13	CTEC	ETF	86.75	87.05	85.1	85.6	38037.200000000004
2006-11-13	CVY	ETF	26.0	26.0	25.78	25.88	18500.0
2006-11-13	CYB	ETF	6.64	6.73	6.25	6.47	73300.0
2006-11-13	DBC	ETF	24.65	24.68	24.5	24.58	222600.0
2006-11-13	DBV	ETF	25.23	25.27	25.19	25.25	58000.0
2006-11-13	DDM	ETF	7.0342	7.1275	7.0342	7.0792	1288800.0
2006-11-13	DES	ETF	18.6633	18.76	18.6633	18.73	41100.0
2006-11-13	DEW	ETF	59.26	59.4	59.14	59.28	5800.0
2006-11-13	DFE	ETF	60.2	60.29	60.12	60.15	4900.0
2006-11-13	DFJ	ETF	47.7	47.7	47.54	47.6	6900.0
2006-11-13	DGT	ETF	74.0	74.5	74.0	74.3	8400.0
2006-11-13	DHS	ETF	55.95	56.23	55.92	56.1	24300.0
2006-11-13	DIM	ETF	59.68	59.8	59.59	59.67	14700.0

> showing 50 of 380 rows — these rows as CSV

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