PREVIEW / etf_daily / 2006-10-25

all etf daily files

  file:    by_date/etf_daily/2006/2006-10-25.parquet
  size:    19 KB
  rows:    376

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-25	SPY	ETF	137.74	138.41	137.51	138.35	78105400.0
2006-10-25	QQQ	ETF	42.14	42.52	42.05	42.43	125405984.0
2006-10-25	IWM	ETF	75.73	76.46	75.48	76.4	51574000.0
2006-10-25	DIA	ETF	121.05	121.4	120.69	121.39	8617200.0
2006-10-25	GLD	ETF	57.83	58.78	57.55	58.76	4384200.0
2006-10-25	TLT	ETF	87.27	87.97	87.23	87.89	558400.0
2006-10-25	AAA	ETF	54.9	55.37	54.9	55.27	7600.0
2006-10-25	ADRE	ETF	34.49	34.708	34.29	34.64	177836.0
2006-10-25	AGG	ETF	99.2	99.59	99.2	99.5	239900.0
2006-10-25	AIQ	ETF	41.25	42.35	40.5	40.75	45280.0
2006-10-25	AIS	ETF	1.25	1.25	1.2	1.24	106900.0
2006-10-25	ARB	ETF	41.15	41.78	41.15	41.5	178900.0
2006-10-25	BAB	ETF	86.53	86.83	85.87	86.39	72500.0
2006-10-25	BBC	ETF	9.19	9.4001	9.18	9.2	187200.0
2006-10-25	BBH	ETF	63.1	63.51	62.9533	63.5	467400.0
2006-10-25	BITS	ETF	41.6	42.56	41.0	41.72	49044.0
2006-10-25	BNE	ETF	15.51	15.82	15.48	15.65	579900.0
2006-10-25	BRF	ETF	14.22	14.26	14.22	14.24	10400.0
2006-10-25	BTF	ETF	100.89999999999999	100.89999999999999	100.7	100.85000000000001	1240.0
2006-10-25	CBON	ETF	29.2	29.52	28.92	29.08	74665.0
2006-10-25	CDL	ETF	9.56	9.84	9.56	9.83	209800.0
2006-10-25	CEF	ETF	8.16	8.34	8.1	8.28	663200.0
2006-10-25	CEW	ETF	25.49	25.49	25.46	25.46	1200.0
2006-10-25	CFO	ETF	10.26	10.55	10.25	10.55	6100.0
2006-10-25	CGO	ETF	15.67	15.752	15.63	15.73	26200.0
2006-10-25	CHB	ETF	7.56	8.55	7.32	8.47	2791200.0
2006-10-25	CHI	ETF	19.47	19.59	19.426	19.59	110400.0
2006-10-25	CHIC	ETF	28.44	28.86	27.8	28.12	258644.0
2006-10-25	CHY	ETF	17.11	17.16	17.01	17.16	155600.0
2006-10-25	CIZ	ETF	22.6	22.6	22.5	22.5	400.0
2006-10-25	CN	ETF	34.65	35.2	34.61	35.19	45600.0
2006-10-25	CNXT	ETF	1.89	1.93	1.8499	1.87	12417193.0
2006-10-25	COMB	ETF	9.91	9.91	9.7208	9.75	59811.0
2006-10-25	CPI	ETF	23.8	23.8	23.55	23.6	900.0
2006-10-25	CPST	ETF	1.52	1.55	1.49	1.5	648520.0
2006-10-25	CSA	ETF	21.95	22.23	21.9	22.14	35400.0
2006-10-25	CSB	ETF	30.43	30.72	30.43	30.66	11300.0
2006-10-25	CSM	ETF	1.2325	1.2325	1.2325	1.2325	20000.0
2006-10-25	CSQ	ETF	15.0	15.01	14.91	14.93	427300.0
2006-10-25	CTEC	ETF	65.0	71.89949999999999	65.0	67.85	84516.6
2006-10-25	CVY	ETF	25.85	25.99	25.81	25.99	37800.0
2006-10-25	CYB	ETF	7.4	7.48	7.35	7.4	39900.0
2006-10-25	DBC	ETF	24.27	24.75	24.16	24.7	200300.0
2006-10-25	DBV	ETF	25.6	25.61	25.54	25.56	51600.0
2006-10-25	DDM	ETF	7.0733	7.1	7.025	7.0792	1186800.0
2006-10-25	DES	ETF	18.5833	18.65	18.5233	18.65	58200.0
2006-10-25	DEW	ETF	57.58	57.83	57.49	57.64	9300.0
2006-10-25	DFE	ETF	57.9	58.27	57.9	58.27	800.0
2006-10-25	DFJ	ETF	49.85	50.19	49.85	50.19	1700.0
2006-10-25	DGT	ETF	73.68	74.16	73.57	74.13	16200.0

> showing 50 of 376 rows — these rows as CSV

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