PREVIEW / etf_daily / 2006-10-06

all etf daily files

  file:    by_date/etf_daily/2006/2006-10-06.parquet
  size:    18 KB
  rows:    362

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-06	SPY	ETF	134.95	135.1	134.4	135.01	64983600.0
2006-10-06	QQQ	ETF	41.38	41.56	41.24	41.41	85454666.0
2006-10-06	IWM	ETF	73.61	73.86	73.0	73.5	34893700.0
2006-10-06	DIA	ETF	118.43	118.57	117.97	118.52	8877700.0
2006-10-06	GLD	ETF	56.28	57.02	55.63	56.99	4282700.0
2006-10-06	TLT	ETF	89.09	89.1	88.22	88.27	2472400.0
2006-10-06	AAA	ETF	54.26	54.49	54.06	54.48	4700.0
2006-10-06	ADRE	ETF	32.97	32.97	32.1	32.77	164394.0
2006-10-06	AGG	ETF	99.86	99.86	99.53	99.53	328500.0
2006-10-06	AIQ	ETF	39.55	39.8	39.05	39.55	9600.0
2006-10-06	AIS	ETF	1.14	1.14	1.1	1.11	97300.0
2006-10-06	ARB	ETF	37.82	38.2	37.72	37.88	97700.0
2006-10-06	BAB	ETF	81.06	82.27	80.78	82.27	51700.0
2006-10-06	BBC	ETF	9.21	9.48	9.15	9.42	91200.0
2006-10-06	BBH	ETF	62.7167	62.7167	61.7933	62.2033	900000.0
2006-10-06	BITS	ETF	37.0	37.64	36.0	36.32	35144.0
2006-10-06	BNE	ETF	15.12	15.27	14.92	14.96	175100.0
2006-10-06	BRF	ETF	14.21	14.24	14.21	14.24	4900.0
2006-10-06	BTF	ETF	97.35	97.55	97.24999999999999	97.55	2380.0
2006-10-06	CBON	ETF	31.22	31.67	31.04	31.56	58854.0
2006-10-06	CDL	ETF	9.65	9.84	9.61	9.71	292900.0
2006-10-06	CEF	ETF	8.08	8.1	7.96	8.09	345700.0
2006-10-06	CGO	ETF	15.45	15.7	15.4	15.41	28400.0
2006-10-06	CHB	ETF	7.26	7.32	7.11	7.24	619000.0
2006-10-06	CHI	ETF	19.24	19.3	19.0601	19.24	137700.0
2006-10-06	CHIC	ETF	27.9	27.999	26.98	27.27	383070.0
2006-10-06	CHY	ETF	16.79	16.87	16.75	16.85	114700.0
2006-10-06	CIL	ETF	25.7	25.78	25.7	25.7	1400.0
2006-10-06	CN	ETF	36.4	36.6	36.21	36.57	27600.0
2006-10-06	CNXT	ETF	1.83	1.88	1.79	1.85	11948033.0
2006-10-06	COMB	ETF	10.2	10.2	9.95	10.07	9405.0
2006-10-06	CPI	ETF	23.4	23.4	23.01	23.05	2600.0
2006-10-06	CPST	ETF	1.56	1.58	1.52	1.53	1276434.0
2006-10-06	CSA	ETF	21.41	21.65	21.41	21.51	22600.0
2006-10-06	CSB	ETF	30.17	30.36	30.11	30.35	9900.0
2006-10-06	CSQ	ETF	14.83	14.84	14.76	14.84	287100.0
2006-10-06	CTEC	ETF	62.24999999999999	63.75	61.15	62.300000000000004	34608.4
2006-10-06	CVY	ETF	25.27	25.27	25.13	25.22	36000.0
2006-10-06	CYB	ETF	7.3	7.49	7.02	7.1	214900.0
2006-10-06	DBC	ETF	23.6	23.7	23.33	23.69	360200.0
2006-10-06	DBV	ETF	25.29	25.29	25.234	25.28	131400.0
2006-10-06	DDM	ETF	6.7467	6.7825	6.7283	6.7825	489600.0
2006-10-06	DES	ETF	18.1467	18.22	18.0533	18.1567	106500.0
2006-10-06	DEW	ETF	56.05	56.24	55.99	56.05	7700.0
2006-10-06	DFE	ETF	56.4	56.48	56.3	56.48	900.0
2006-10-06	DFJ	ETF	49.27	49.29	49.12	49.23	2200.0
2006-10-06	DGT	ETF	72.2	72.24	71.8	72.17	16300.0
2006-10-06	DHS	ETF	55.2	55.32	55.1	55.19	15600.0
2006-10-06	DIM	ETF	56.78	56.93	56.65	56.83	5300.0
2006-10-06	DIV	ETF	12.77	12.81	12.75	12.75	33700.0

> showing 50 of 362 rows — these rows as CSV

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