PREVIEW / etf_daily / 2006-09-25

all etf daily files

  file:    by_date/etf_daily/2006/2006-09-25.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-25	SPY	ETF	131.73	132.85	131.05	132.48	92299100.0
2006-09-25	QQQ	ETF	40.05	40.66	39.68	40.57	136555523.0
2006-09-25	IWM	ETF	71.78	72.65	71.11	72.39	61688400.0
2006-09-25	DIA	ETF	115.19	116.1	114.77	115.6	7954400.0
2006-09-25	GLD	ETF	58.15	58.76	57.78	58.5	3797300.0
2006-09-25	TLT	ETF	89.84	90.31	89.81	90.31	2607600.0
2006-09-25	AAA	ETF	57.549	57.69	57.2	57.48	10900.0
2006-09-25	ADRE	ETF	31.4	31.7299	31.01	31.71	169778.0
2006-09-25	AFK	ETF	25.01	25.01	25.0	25.01	1300.0
2006-09-25	AGG	ETF	100.26	100.42	100.22	100.26	177400.0
2006-09-25	AIQ	ETF	41.25	41.4	40.35	40.6	14820.0
2006-09-25	AIS	ETF	1.15	1.15	1.09	1.1199	115300.0
2006-09-25	ARB	ETF	37.28	37.39	37.01	37.32	192000.0
2006-09-25	BAB	ETF	81.04	82.01	80.38	81.92	36800.0
2006-09-25	BBC	ETF	10.65	10.8	10.12	10.57	276000.0
2006-09-25	BBH	ETF	59.5167	59.8833	59.19	59.8267	490800.0
2006-09-25	BITS	ETF	34.4	34.6	32.44	33.6	64824.0
2006-09-25	BNE	ETF	14.67	14.9	14.56	14.83	357200.0
2006-09-25	BRF	ETF	14.26	14.27	14.22	14.24	4300.0
2006-09-25	BTF	ETF	94.60000000000001	94.7	94.39999999999999	94.55	4600.0
2006-09-25	CBON	ETF	31.4	31.4	31.06	31.16	64108.0
2006-09-25	CDL	ETF	9.57	9.59	9.47	9.48	167400.0
2006-09-25	CEF	ETF	8.08	8.12	7.95	8.1	228200.0
2006-09-25	CEW	ETF	25.45	25.45	25.45	25.45	600.0
2006-09-25	CFO	ETF	9.62	9.62	9.5	9.6	5500.0
2006-09-25	CGO	ETF	15.23	15.27	15.15	15.24	9800.0
2006-09-25	CHB	ETF	7.06	7.27	6.91	7.2	1073200.0
2006-09-25	CHI	ETF	19.65	19.72	19.62	19.7	97500.0
2006-09-25	CHIC	ETF	25.95	26.44	25.58	26.32	957573.0
2006-09-25	CHY	ETF	16.61	16.7	16.57	16.7	147500.0
2006-09-25	CIZ	ETF	21.85	21.85	21.4	21.4	2000.0
2006-09-25	CN	ETF	35.1	35.8	34.96	35.8	24600.0
2006-09-25	CNXT	ETF	1.8	1.92	1.77	1.92	20629528.0
2006-09-25	COMB	ETF	9.88	9.9535	9.88	9.95	15021.0
2006-09-25	CPI	ETF	24.35	24.35	24.15	24.3465	1600.0
2006-09-25	CPST	ETF	1.26	1.33	1.24	1.28	1986214.0
2006-09-25	CSA	ETF	20.97	21.01	20.8	20.97	12700.0
2006-09-25	CSB	ETF	29.96	30.23	29.83	30.23	23000.0
2006-09-25	CSQ	ETF	14.6	14.75	14.58	14.75	421400.0
2006-09-25	CTEC	ETF	61.9	62.199999999999996	60.4	60.9	7100.8
2006-09-25	CVY	ETF	24.78	24.93	24.64	24.92	7100.0
2006-09-25	CYB	ETF	6.45	6.63	6.37	6.5	45700.0
2006-09-25	DBC	ETF	22.9	23.37	22.87	23.25	1036900.0
2006-09-25	DBV	ETF	24.95	25.0	24.9	25.0	13600.0
2006-09-25	DDM	ETF	6.4458	6.5175	6.3783	6.4808	511200.0
2006-09-25	DES	ETF	17.8467	18.04	17.7933	18.0167	15900.0
2006-09-25	DEW	ETF	55.12	55.35	54.85	55.35	3400.0
2006-09-25	DFE	ETF	55.65	55.65	55.46	55.55	1300.0
2006-09-25	DFJ	ETF	49.44	49.74	49.44	49.74	3100.0
2006-09-25	DGT	ETF	70.75	71.17	70.17	70.88	21800.0

> showing 50 of 363 rows — these rows as CSV

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