PREVIEW / etf_daily / 2006-09-01

all etf daily files

  file:    by_date/etf_daily/2006/2006-09-01.parquet
  size:    18 KB
  rows:    361

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-01	SPY	ETF	131.14	131.58	130.84	131.42	48794500.0
2006-09-01	QQQ	ETF	39.07	39.21	38.9	39.08	69390571.0
2006-09-01	IWM	ETF	72.08	72.2	71.46	71.82	24118200.0
2006-09-01	DIA	ETF	114.21	114.77	113.95	114.7	4494400.0
2006-09-01	GLD	ETF	61.95	62.29	61.48	62.14	3210200.0
2006-09-01	TLT	ETF	87.62	87.9	87.47	87.76	893400.0
2006-09-01	AAA	ETF	58.8	59.3499	58.7	59.19	4000.0
2006-09-01	ADRE	ETF	32.23	32.81	32.23	32.72	121834.0
2006-09-01	AFK	ETF	25.32	25.32	25.31	25.32	5900.0
2006-09-01	AGG	ETF	99.15	99.29	99.06	99.17	125000.0
2006-09-01	AIQ	ETF	32.5	33.5	32.1	33.45	20820.0
2006-09-01	AIS	ETF	1.21	1.22	1.12	1.19	231800.0
2006-09-01	AOM	ETF	9.99	9.99	9.79	9.94	466200.0
2006-09-01	ARB	ETF	37.59	37.75	37.39	37.42	61900.0
2006-09-01	BAB	ETF	78.26	79.43	78.2	79.25	57800.0
2006-09-01	BBC	ETF	11.85	11.87	11.7	11.83	77500.0
2006-09-01	BBH	ETF	59.95	60.3933	59.89	60.1533	860400.0
2006-09-01	BITS	ETF	29.4	29.4	28.44	28.6	8452.0
2006-09-01	BKF	ETF	4.05	4.05	4.0104	4.04	18800.0
2006-09-01	BNE	ETF	15.4	15.54	15.17	15.38	114800.0
2006-09-01	BRF	ETF	14.16	14.16	14.11	14.11	6600.0
2006-09-01	BTF	ETF	92.14999999999999	92.44999999999999	92.05	92.3	7060.0
2006-09-01	CBON	ETF	34.07	34.27	33.79	33.91	18358.0
2006-09-01	CDL	ETF	9.26	9.37	9.15	9.29	203300.0
2006-09-01	CEF	ETF	9.02	9.1	8.98	9.06	276600.0
2006-09-01	CEW	ETF	25.5	25.5	25.5	25.5	200.0
2006-09-01	CFO	ETF	10.1	10.1	10.1	10.1	300.0
2006-09-01	CGO	ETF	15.55	15.55	15.15	15.3	33800.0
2006-09-01	CHB	ETF	6.82	7.47	6.8	7.04	1708600.0
2006-09-01	CHI	ETF	20.34	20.35	20.12	20.12	165900.0
2006-09-01	CHIC	ETF	26.96	27.01	26.32	26.86	557022.0
2006-09-01	CHY	ETF	16.68	16.72	16.6301	16.66	86800.0
2006-09-01	CN	ETF	34.82	35.13	34.79	34.92	36800.0
2006-09-01	CNXT	ETF	2.06	2.1	1.99	2.0	10970981.0
2006-09-01	COMB	ETF	10.2	10.2	9.85	9.86	471.0
2006-09-01	CPI	ETF	29.15	29.15	28.7	28.7	300.0
2006-09-01	CPST	ETF	1.9	1.97	1.9	1.93	629737.0
2006-09-01	CSA	ETF	19.81	20.29	19.81	19.98	19400.0
2006-09-01	CSB	ETF	28.35	28.61	28.29	28.44	9300.0
2006-09-01	CSQ	ETF	14.56	14.59	14.53	14.59	268300.0
2006-09-01	CTEC	ETF	55.449999999999996	55.65	53.8	54.5	35627.8
2006-09-01	CYB	ETF	6.6	6.74	6.6	6.65	106200.0
2006-09-01	DBC	ETF	25.03	25.06	24.77	24.95	240500.0
2006-09-01	DDM	ETF	6.3108	6.3717	6.2883	6.3575	546000.0
2006-09-01	DES	ETF	17.7	17.7033	17.6133	17.6333	26400.0
2006-09-01	DEW	ETF	55.31	55.79	55.3	55.77	2500.0
2006-09-01	DFE	ETF	55.12	55.12	55.12	55.12	200.0
2006-09-01	DFJ	ETF	51.41	51.71	51.24	51.39	3500.0
2006-09-01	DGT	ETF	71.3	71.77	71.3	71.57	26300.0
2006-09-01	DHS	ETF	54.0	54.18	54.0	54.15	20900.0

> showing 50 of 361 rows — these rows as CSV

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