PREVIEW / etf_daily / 2006-10-20

all etf daily files

  file:    by_date/etf_daily/2006/2006-10-20.parquet
  size:    19 KB
  rows:    377

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-20	SPY	ETF	136.84	136.95	136.33	136.84	48094500.0
2006-10-20	QQQ	ETF	42.05	42.084	41.64	42.0	105456536.0
2006-10-20	IWM	ETF	76.37	76.41	75.48	75.6	39507600.0
2006-10-20	DIA	ETF	119.75	120.01	119.38	119.93	8226900.0
2006-10-20	GLD	ETF	59.45	59.48	58.65	58.78	3190500.0
2006-10-20	TLT	ETF	87.61	87.7	87.55	87.55	280700.0
2006-10-20	AAA	ETF	54.8	54.8	54.59	54.66	2300.0
2006-10-20	ADRE	ETF	34.17	34.17	33.87	33.98	62337.0
2006-10-20	AGG	ETF	99.48	99.5	99.36	99.44	143300.0
2006-10-20	AIQ	ETF	41.2	41.4	40.5	40.7	21740.0
2006-10-20	AIS	ETF	1.37	1.37	1.26	1.34	129100.0
2006-10-20	ARB	ETF	40.0	41.24	39.52	40.12	423300.0
2006-10-20	BAB	ETF	84.83	85.35	83.93	85.31	59100.0
2006-10-20	BBC	ETF	9.75	9.82	9.33	9.35	420700.0
2006-10-20	BBH	ETF	62.9333	62.9333	62.4	62.7667	1133100.0
2006-10-20	BITS	ETF	39.8	39.88	38.64	39.8	33744.0
2006-10-20	BNE	ETF	15.73	15.73	15.42	15.52	79900.0
2006-10-20	BRF	ETF	14.33	14.35	14.29	14.29	13900.0
2006-10-20	BTF	ETF	100.3505	100.39999999999999	100.19999999999999	100.39999999999999	2840.0
2006-10-20	CBON	ETF	30.51	30.51	29.74	29.82	87038.0
2006-10-20	CDL	ETF	9.7	9.73	9.45	9.68	593700.0
2006-10-20	CEF	ETF	8.54	8.55	8.37	8.38	326400.0
2006-10-20	CEW	ETF	25.42	25.42	25.41	25.41	800.0
2006-10-20	CFO	ETF	10.1	10.1	10.06	10.06	1500.0
2006-10-20	CGO	ETF	15.72	15.8	15.61	15.8	35500.0
2006-10-20	CHB	ETF	7.97	7.97	7.75	7.86	889100.0
2006-10-20	CHI	ETF	19.3	19.42	19.26	19.4	84400.0
2006-10-20	CHIC	ETF	28.11	28.19	27.46	28.05	251074.0
2006-10-20	CHY	ETF	16.94	17.02	16.9	17.0	111300.0
2006-10-20	CIZ	ETF	22.6001	22.6001	22.6	22.6	3200.0
2006-10-20	CN	ETF	35.7	35.73	35.4	35.55	47300.0
2006-10-20	CNXT	ETF	2.02	2.02	1.98	2.0	11822833.0
2006-10-20	COMB	ETF	10.19	10.19	10.04	10.18	5994.0
2006-10-20	CPST	ETF	1.58	1.6	1.53	1.57	742255.0
2006-10-20	CSA	ETF	21.46	21.6	21.25	21.38	34500.0
2006-10-20	CSB	ETF	30.2	30.23	30.05	30.22	9800.0
2006-10-20	CSQ	ETF	15.0	15.0	14.91	14.95	318800.0
2006-10-20	CTEC	ETF	62.4	63.25	62.099999999999994	62.949999999999996	31309.2
2006-10-20	CVY	ETF	25.8	25.8	25.6	25.71	47000.0
2006-10-20	CYB	ETF	7.34	7.37	7.2601	7.35	28900.0
2006-10-20	DBC	ETF	24.4	24.4	23.8	24.05	514900.0
2006-10-20	DBV	ETF	25.5	25.54	25.43	25.52	42000.0
2006-10-20	DDM	ETF	6.9175	6.9475	6.8792	6.9333	696000.0
2006-10-20	DES	ETF	18.6	18.6033	18.49	18.5233	89700.0
2006-10-20	DEW	ETF	57.22	57.23	57.05	57.23	3800.0
2006-10-20	DFE	ETF	57.75	57.93	57.67	57.83	1700.0
2006-10-20	DFJ	ETF	50.0	50.0	49.74	49.82	13500.0
2006-10-20	DGT	ETF	73.32	73.48	73.0	73.48	31300.0
2006-10-20	DHS	ETF	56.0	56.06	55.76	56.06	15900.0
2006-10-20	DIM	ETF	58.25	58.29	58.02	58.29	5400.0

> showing 50 of 377 rows — these rows as CSV

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