PREVIEW / etf_daily / 2006-10-16

all etf daily files

  file:    by_date/etf_daily/2006/2006-10-16.parquet
  size:    18 KB
  rows:    374

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-16	SPY	ETF	136.52	137.05	136.42	136.84	42273000.0
2006-10-16	QQQ	ETF	42.43	42.62	42.4	42.45	62050540.0
2006-10-16	IWM	ETF	75.88	76.54	75.69	76.35	46458400.0
2006-10-16	DIA	ETF	119.57	119.97	119.42	119.77	6899400.0
2006-10-16	GLD	ETF	58.93	59.18	58.72	59.17	1986300.0
2006-10-16	TLT	ETF	87.4	87.56	87.37	87.55	897600.0
2006-10-16	AAA	ETF	53.77	53.97	53.66	53.94	3000.0
2006-10-16	ADRE	ETF	34.29	34.38	34.15	34.31	188337.0
2006-10-16	AGG	ETF	99.34	99.34	99.15	99.25	192400.0
2006-10-16	AIQ	ETF	40.55	41.25	40.0	41.2	28440.0
2006-10-16	AIS	ETF	1.3	1.3192	1.18	1.22	252600.0
2006-10-16	ARB	ETF	38.68	39.04	38.58	38.94	142500.0
2006-10-16	BAB	ETF	83.61	84.31	83.49	84.3	35200.0
2006-10-16	BBC	ETF	8.7	8.78	8.49	8.7	131000.0
2006-10-16	BBH	ETF	62.1	62.6767	62.0033	62.6033	1063200.0
2006-10-16	BITS	ETF	39.24	40.96	38.0	40.96	165855.0
2006-10-16	BNE	ETF	15.15	15.53	15.15	15.53	113700.0
2006-10-16	BRF	ETF	14.27	14.27	14.22	14.22	2400.0
2006-10-16	BTF	ETF	100.19999999999999	100.5005	100.19999999999999	100.5	1160.0
2006-10-16	CBON	ETF	32.82	33.45	32.65	33.15	132242.0
2006-10-16	CDL	ETF	9.8	9.8	9.68	9.73	186200.0
2006-10-16	CEF	ETF	8.44	8.51	8.35	8.42	344400.0
2006-10-16	CEW	ETF	25.4	25.4889	25.4	25.4889	1500.0
2006-10-16	CFO	ETF	10.0	10.0	10.0	10.0	3500.0
2006-10-16	CGO	ETF	15.87	15.88	15.78	15.88	14100.0
2006-10-16	CHB	ETF	8.13	8.48	7.91	8.17	1511500.0
2006-10-16	CHI	ETF	19.22	19.32	19.1701	19.29	184100.0
2006-10-16	CHIC	ETF	28.8	28.84	28.19	28.48	652700.0
2006-10-16	CHY	ETF	16.97	17.06	16.91	17.05	117800.0
2006-10-16	CIZ	ETF	22.5	22.5	22.5	22.5	500.0
2006-10-16	CN	ETF	36.65	37.0	36.54	36.94	28800.0
2006-10-16	CNXT	ETF	1.96	2.09	1.95	2.06	21238089.0
2006-10-16	COMB	ETF	10.35	10.35	10.2	10.35	4397.0
2006-10-16	CPI	ETF	24.2	24.2	24.2	24.2	200.0
2006-10-16	CPST	ETF	1.73	1.74	1.7	1.71	1356604.0
2006-10-16	CSA	ETF	21.6	21.74	21.5	21.65	20400.0
2006-10-16	CSB	ETF	29.92	30.15	29.85	30.14	19600.0
2006-10-16	CSQ	ETF	14.9	14.93	14.85	14.93	359000.0
2006-10-16	CTEC	ETF	62.5	62.9	60.65	62.24999999999999	28730.4
2006-10-16	CVY	ETF	25.65	25.77	25.65	25.76	24500.0
2006-10-16	CYB	ETF	7.21	7.71	7.21	7.46	372300.0
2006-10-16	DBC	ETF	24.28	24.4	23.95	24.4	556400.0
2006-10-16	DBV	ETF	25.55	25.56	25.47	25.55	14900.0
2006-10-16	DDM	ETF	6.875	6.93	6.875	6.9108	475200.0
2006-10-16	DES	ETF	18.55	18.6467	18.55	18.6367	111300.0
2006-10-16	DEW	ETF	56.98	57.14	56.93	57.13	4300.0
2006-10-16	DFE	ETF	57.25	57.33	57.09	57.29	4900.0
2006-10-16	DFJ	ETF	49.11	49.2	49.07	49.19	6100.0
2006-10-16	DGT	ETF	72.85	73.16	72.65	72.94	64700.0
2006-10-16	DHS	ETF	55.85	55.86	55.54	55.75	20000.0

> showing 50 of 374 rows — these rows as CSV

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