PREVIEW / etf_daily / 2006-09-20

all etf daily files

  file:    by_date/etf_daily/2006/2006-09-20.parquet
  size:    18 KB
  rows:    359

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-20	SPY	ETF	132.25	132.77	132.06	132.51	75204100.0
2006-09-20	QQQ	ETF	40.2	40.54	40.19	40.43	116648440.0
2006-09-20	IWM	ETF	72.79	73.5	72.73	73.29	54786800.0
2006-09-20	DIA	ETF	115.68	116.21	115.63	116.08	8912900.0
2006-09-20	GLD	ETF	57.81	58.24	57.2	57.26	5385200.0
2006-09-20	TLT	ETF	88.38	88.48	88.14	88.43	827400.0
2006-09-20	AAA	ETF	56.53	56.83	56.4	56.67	10900.0
2006-09-20	ADRE	ETF	32.03	32.39	31.98	32.08	507586.0
2006-09-20	AFK	ETF	24.97	25.07	24.95	25.07	11000.0
2006-09-20	AGG	ETF	99.69	99.75	99.51	99.57	215500.0
2006-09-20	AIQ	ETF	41.4	41.9	41.0	41.5	19780.0
2006-09-20	AIS	ETF	1.17	1.21	1.16	1.2	249800.0
2006-09-20	ARB	ETF	37.85	38.12	37.54	37.86	114200.0
2006-09-20	BAB	ETF	81.66	83.17	81.55	83.0	56600.0
2006-09-20	BBC	ETF	10.12	10.65	10.12	10.49	176400.0
2006-09-20	BBH	ETF	59.6333	59.99	59.5367	59.77	463200.0
2006-09-20	BITS	ETF	27.8404	28.16	27.56	27.88	7412.0
2006-09-20	BNE	ETF	14.51	14.8	14.32	14.51	123800.0
2006-09-20	BTF	ETF	94.45	94.74999999999999	94.45	94.60000000000001	2480.0
2006-09-20	CBON	ETF	32.45	32.5	32.22	32.36	45376.0
2006-09-20	CDL	ETF	9.39	9.65	9.35	9.63	380700.0
2006-09-20	CEF	ETF	8.05	8.13	7.84	7.88	670700.0
2006-09-20	CEW	ETF	25.31	25.3501	25.31	25.35	2100.0
2006-09-20	CFO	ETF	9.75	9.85	9.75	9.85	1700.0
2006-09-20	CGO	ETF	15.29	15.42	15.05	15.08	71800.0
2006-09-20	CHB	ETF	7.1	7.13	6.96	7.09	770600.0
2006-09-20	CHI	ETF	19.41	19.66	19.39	19.63	152500.0
2006-09-20	CHIC	ETF	26.79	26.98	26.192	26.27	712226.0
2006-09-20	CHY	ETF	16.68	16.75	16.65	16.74	152700.0
2006-09-20	CIZ	ETF	22.1	22.1	22.1	22.1	100.0
2006-09-20	CN	ETF	35.35	35.66	35.35	35.66	42300.0
2006-09-20	CNXT	ETF	1.86	1.92	1.85	1.9	10530599.0
2006-09-20	COMB	ETF	10.01	10.01	9.9	9.9	10437.0
2006-09-20	CPI	ETF	24.45	24.45	23.8	23.9	2100.0
2006-09-20	CPST	ETF	1.44	1.48	1.36	1.38	2069999.0
2006-09-20	CSA	ETF	20.41	21.19	20.28	20.8	44500.0
2006-09-20	CSB	ETF	28.55	28.62	28.46	28.52	6800.0
2006-09-20	CSQ	ETF	14.7	14.7	14.55	14.7	340800.0
2006-09-20	CTEC	ETF	61.849999999999994	63.25	60.9	61.1	7519.400000000001
2006-09-20	CYB	ETF	6.69	6.72	6.5101	6.55	31900.0
2006-09-20	DBC	ETF	23.19	23.2	22.86	23.07	511000.0
2006-09-20	DBV	ETF	24.93	25.05	24.9249	25.0	107900.0
2006-09-20	DDM	ETF	6.5	6.5642	6.4825	6.5375	2360400.0
2006-09-20	DES	ETF	17.9833	18.1467	17.9833	18.09	76800.0
2006-09-20	DEW	ETF	54.64	54.98	54.64	54.86	25000.0
2006-09-20	DFE	ETF	55.33	55.33	55.29	55.29	2000.0
2006-09-20	DFJ	ETF	49.81	49.81	49.61	49.64	1500.0
2006-09-20	DGT	ETF	70.6	70.94	70.59	70.8	2500.0
2006-09-20	DHS	ETF	54.7	54.88	54.7	54.84	22000.0
2006-09-20	DIM	ETF	55.22	55.47	55.19	55.43	25400.0

> showing 50 of 359 rows — these rows as CSV

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