PREVIEW / etf_daily / 2006-09-07

all etf daily files

  file:    by_date/etf_daily/2006/2006-09-07.parquet
  size:    18 KB
  rows:    360

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-07	SPY	ETF	130.06	130.57	129.35	129.91	86269400.0
2006-09-07	QQQ	ETF	38.57	38.9	38.36	38.4799	115901235.0
2006-09-07	IWM	ETF	70.53	71.12	70.06	70.3	44611800.0
2006-09-07	DIA	ETF	113.68	113.95	113.23	113.56	7050000.0
2006-09-07	GLD	ETF	61.87	61.92	60.99	61.25	5402300.0
2006-09-07	TLT	ETF	86.93	87.32	86.74	87.26	1716100.0
2006-09-07	AAA	ETF	59.23	60.34	59.23	59.46	18300.0
2006-09-07	ADRE	ETF	31.9	32.13	30.7	31.96	248302.0
2006-09-07	AFK	ETF	25.35	25.37	25.34	25.37	3900.0
2006-09-07	AGG	ETF	99.05	99.24	98.96	99.04	273300.0
2006-09-07	AIQ	ETF	38.75	41.2	38.7	40.15	77400.0
2006-09-07	AIS	ETF	1.09	1.1	1.0501	1.07	63700.0
2006-09-07	AOM	ETF	9.95	9.98	9.87	9.9	247300.0
2006-09-07	ARB	ETF	36.6	37.0	36.49	36.5	80300.0
2006-09-07	BAB	ETF	77.7	78.16	77.18	77.83	66900.0
2006-09-07	BBC	ETF	11.65	11.99	11.6	11.61	89000.0
2006-09-07	BBH	ETF	59.3767	59.9033	59.3767	59.4867	956700.0
2006-09-07	BITS	ETF	26.0	28.56	25.08	28.24	40407.0
2006-09-07	BNE	ETF	15.25	15.28	14.66	14.67	115500.0
2006-09-07	BRF	ETF	14.1	14.16	14.1	14.16	10700.0
2006-09-07	BTF	ETF	91.99999999999999	92.10000000000001	91.89999999999999	91.89999999999999	3160.0
2006-09-07	CBON	ETF	33.4	33.4	32.67	32.92	35214.0
2006-09-07	CDL	ETF	8.97	9.32	8.91	9.3	937000.0
2006-09-07	CEF	ETF	9.08	9.08	8.93	8.94	630700.0
2006-09-07	CEW	ETF	25.35	25.35	25.25	25.28	1200.0
2006-09-07	CFO	ETF	10.2	10.2	10.18	10.18	5200.0
2006-09-07	CGO	ETF	15.5	15.73	15.33	15.45	37400.0
2006-09-07	CHB	ETF	6.35	6.47	6.06	6.31	1928600.0
2006-09-07	CHI	ETF	19.77	19.8	19.6	19.73	105300.0
2006-09-07	CHIC	ETF	27.46	28.08	27.04	27.93	1415746.0
2006-09-07	CHY	ETF	16.33	16.43	16.25	16.38	178800.0
2006-09-07	CIL	ETF	25.5	25.5	25.5	25.5	300.0
2006-09-07	CN	ETF	34.75	34.75	34.3	34.64	45800.0
2006-09-07	CNXT	ETF	1.82	1.86	1.78	1.82	15203048.0
2006-09-07	COMB	ETF	10.19	10.19	10.19	10.19	300.0
2006-09-07	CPI	ETF	27.51	27.51	27.51	27.51	200.0
2006-09-07	CPST	ETF	1.82	1.85	1.75	1.78	1145698.0
2006-09-07	CSA	ETF	20.2	20.25	20.0	20.15	21900.0
2006-09-07	CSB	ETF	27.47	27.57	27.31	27.34	9400.0
2006-09-07	CSQ	ETF	14.21	14.31	14.2	14.3	351500.0
2006-09-07	CTEC	ETF	60.949999999999996	62.4	59.599999999999994	62.4	17134.0
2006-09-07	CYB	ETF	6.65	6.65	6.55	6.61	56300.0
2006-09-07	DBC	ETF	24.7	24.79	24.55	24.7	97400.0
2006-09-07	DDM	ETF	6.2533	6.275	6.2	6.2117	914400.0
2006-09-07	DES	ETF	17.4233	17.5067	17.3667	17.39	40800.0
2006-09-07	DEW	ETF	54.2	54.2	53.48	53.69	12600.0
2006-09-07	DFE	ETF	54.04	54.17	54.04	54.17	10200.0
2006-09-07	DFJ	ETF	51.27	51.27	50.34	50.68	7100.0
2006-09-07	DGT	ETF	70.65	70.69	70.2	70.38	25700.0
2006-09-07	DHS	ETF	54.0	54.0	53.69	53.7	23800.0

> showing 50 of 360 rows — these rows as CSV

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