PREVIEW / etf_daily / 2006-09-05

all etf daily files

  file:    by_date/etf_daily/2006/2006-09-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-09-05	SPY	ETF	131.51	131.85	131.2	131.67	52348300.0
2006-09-05	QQQ	ETF	39.11	39.48	38.85	39.46	85588633.0
2006-09-05	IWM	ETF	71.93	72.52	71.7	72.47	38075100.0
2006-09-05	DIA	ETF	114.62	114.9	114.38	114.73	5085300.0
2006-09-05	GLD	ETF	63.2	63.63	63.06	63.36	4219400.0
2006-09-05	TLT	ETF	87.51	87.64	87.16	87.21	2271300.0
2006-09-05	AAA	ETF	59.85	59.96	59.5	59.8	7400.0
2006-09-05	ADRE	ETF	32.75	33.13	32.75	33.04	92916.0
2006-09-05	AFK	ETF	25.31	25.38	25.31	25.36	6200.0
2006-09-05	AGG	ETF	99.2	99.29	99.04	99.05	137500.0
2006-09-05	AIQ	ETF	33.5	37.5	33.5	36.2	70640.0
2006-09-05	AIS	ETF	1.18	1.19	1.13	1.14	126700.0
2006-09-05	AOM	ETF	9.9	10.11	9.87	10.0	567500.0
2006-09-05	ARB	ETF	37.4	37.7	37.18	37.3	114200.0
2006-09-05	BAB	ETF	78.41	80.06	78.02	80.06	145300.0
2006-09-05	BBC	ETF	11.88	12.09	11.67	12.02	132200.0
2006-09-05	BBH	ETF	60.2	60.5667	59.7167	60.35	579300.0
2006-09-05	BITS	ETF	28.48	29.12	27.36	27.8	21901.0
2006-09-05	BNE	ETF	15.46	15.65	15.38	15.51	187700.0
2006-09-05	BRF	ETF	14.17	14.2	14.12	14.2	7600.0
2006-09-05	BTF	ETF	92.39999999999999	92.75	92.3	92.75	2860.0
2006-09-05	CBON	ETF	34.0	34.0	33.84	33.88	9965.0
2006-09-05	CDL	ETF	9.35	9.38	9.2	9.24	198000.0
2006-09-05	CEF	ETF	9.12	9.22	9.12	9.17	339100.0
2006-09-05	CEW	ETF	25.55	25.55	25.55	25.55	100.0
2006-09-05	CFO	ETF	10.15	10.2	10.15	10.2	400.0
2006-09-05	CGO	ETF	15.3	15.5	15.3	15.5	28100.0
2006-09-05	CHB	ETF	7.05	7.12	6.83	6.94	1341400.0
2006-09-05	CHI	ETF	20.02	20.04	19.91	19.95	257400.0
2006-09-05	CHIC	ETF	27.22	27.25	26.76	27.01	433098.0
2006-09-05	CHY	ETF	16.68	16.69	16.6001	16.63	104900.0
2006-09-05	CIL	ETF	25.62	25.62	25.4701	25.4701	1900.0
2006-09-05	CN	ETF	35.2	35.55	34.95	35.5	68200.0
2006-09-05	CNXT	ETF	2.0	2.02	1.93	1.98	15322148.0
2006-09-05	COMB	ETF	10.23	10.37	10.23	10.37	2912.0
2006-09-05	CPI	ETF	28.6	28.6	28.5	28.5	200.0
2006-09-05	CPST	ETF	1.92	1.93	1.88	1.9	892131.0
2006-09-05	CSA	ETF	19.95	20.13	19.95	20.05	7000.0
2006-09-05	CSB	ETF	28.03	28.18	28.03	28.14	8100.0
2006-09-05	CSQ	ETF	14.6	14.6	14.43	14.46	412300.0
2006-09-05	CTEC	ETF	53.89999999999999	55.35	51.1	55.05	34380.8
2006-09-05	CYB	ETF	6.79	6.79	6.61	6.63	52700.0
2006-09-05	DBC	ETF	24.87	25.1	24.74	24.91	264700.0
2006-09-05	DDM	ETF	6.3342	6.3808	6.3317	6.3667	924000.0
2006-09-05	DES	ETF	17.62	17.7633	17.62	17.7633	83400.0
2006-09-05	DEW	ETF	56.0	56.0	54.79	55.13	20000.0
2006-09-05	DFE	ETF	55.22	55.39	55.15	55.39	19100.0
2006-09-05	DFJ	ETF	52.35	52.35	51.72	52.07	15000.0
2006-09-05	DGT	ETF	71.6	71.77	71.39	71.39	56500.0
2006-09-05	DHS	ETF	54.18	54.28	54.12	54.22	35500.0

> showing 50 of 363 rows — these rows as CSV

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