PREVIEW / etf_daily / 2006-10-05

all etf daily files

  file:    by_date/etf_daily/2006/2006-10-05.parquet
  size:    18 KB
  rows:    363

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-10-05	SPY	ETF	134.92	135.41	134.75	135.18	60505900.0
2006-10-05	QQQ	ETF	41.28	41.56	41.18	41.5	92189058.0
2006-10-05	IWM	ETF	72.87	73.9	72.85	73.88	48038000.0
2006-10-05	DIA	ETF	118.36	118.71	118.2	118.62	7159600.0
2006-10-05	GLD	ETF	56.94	57.02	56.32	56.92	3890700.0
2006-10-05	TLT	ETF	89.54	89.54	88.95	89.2	1241600.0
2006-10-05	AAA	ETF	55.21	55.45	55.151	55.4	3200.0
2006-10-05	ADRE	ETF	32.8	33.1	32.66	32.9861	391900.0
2006-10-05	AGG	ETF	100.11	100.11	99.9	99.9	207800.0
2006-10-05	AIQ	ETF	37.15	39.75	37.15	39.5	18600.0
2006-10-05	AIS	ETF	1.1	1.13	1.08	1.11	172000.0
2006-10-05	ARB	ETF	37.53	38.01	37.41	37.94	113200.0
2006-10-05	BAB	ETF	83.62	83.63	82.09	83.47	95500.0
2006-10-05	BBC	ETF	9.71	9.7112	9.2	9.21	170000.0
2006-10-05	BBH	ETF	61.5533	62.7	61.5533	62.4967	1504200.0
2006-10-05	BITS	ETF	37.4	37.96	36.24	37.32	42092.0
2006-10-05	BNE	ETF	15.16	15.27	14.98	15.19	87400.0
2006-10-05	BRF	ETF	14.3	14.35	14.24	14.24	15100.0
2006-10-05	BTF	ETF	96.54999999999998	97.5	96.54999999999998	97.5	2660.0
2006-10-05	CBON	ETF	31.1	31.36	31.1	31.18	49974.0
2006-10-05	CDL	ETF	9.68	9.84	9.56	9.8	380300.0
2006-10-05	CEF	ETF	8.2	8.21	8.09	8.14	263800.0
2006-10-05	CEW	ETF	25.4	25.44	25.4	25.44	500.0
2006-10-05	CFO	ETF	9.85	9.85	9.85	9.85	200.0
2006-10-05	CGO	ETF	15.63	15.75	15.52	15.55	29400.0
2006-10-05	CHB	ETF	7.09	7.31	7.04	7.3	1324700.0
2006-10-05	CHI	ETF	19.36	19.43	19.25	19.34	97200.0
2006-10-05	CHIC	ETF	28.01	28.04	27.22	27.97	300987.0
2006-10-05	CHY	ETF	16.75	16.8	16.68	16.8	99300.0
2006-10-05	CIL	ETF	25.7	25.7	25.7	25.7	200.0
2006-10-05	CIZ	ETF	22.4	22.4	22.0	22.01	4100.0
2006-10-05	CN	ETF	36.0	36.2	35.8	36.16	21700.0
2006-10-05	CNXT	ETF	1.8	1.86	1.78	1.84	11969108.0
2006-10-05	COMB	ETF	10.0	10.2	10.0	10.2	10386.0
2006-10-05	CPST	ETF	1.54	1.6	1.52	1.56	1586678.0
2006-10-05	CSA	ETF	21.6	21.6	21.43	21.49	13400.0
2006-10-05	CSB	ETF	30.24	30.45	30.1608	30.29	5100.0
2006-10-05	CSQ	ETF	14.79	14.84	14.72	14.83	336500.0
2006-10-05	CTEC	ETF	62.099999999999994	63.15	61.849999999999994	62.5	11153.2
2006-10-05	CVY	ETF	25.2	25.3	25.14	25.27	53400.0
2006-10-05	CYB	ETF	6.66	7.3	6.66	7.03	185900.0
2006-10-05	DBC	ETF	23.75	23.7888	23.38	23.6	348900.0
2006-10-05	DBV	ETF	25.18	25.18	25.12	25.15	41800.0
2006-10-05	DDM	ETF	6.7825	6.8242	6.75	6.8008	572400.0
2006-10-05	DES	ETF	18.0733	18.23	18.0567	18.23	31800.0
2006-10-05	DEW	ETF	56.53	56.63	56.4	56.52	13500.0
2006-10-05	DFE	ETF	56.56	56.8	56.56	56.8	1500.0
2006-10-05	DFJ	ETF	50.16	50.25	50.11	50.25	2000.0
2006-10-05	DGT	ETF	72.35	72.47	72.05	72.25	41900.0
2006-10-05	DHS	ETF	55.4	55.5	55.25	55.42	9200.0

> showing 50 of 363 rows — these rows as CSV

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