PREVIEW / etf_daily / 2006-09-06

all etf daily files

  file:    by_date/etf_daily/2006/2006-09-06.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-06	SPY	ETF	131.11	131.16	130.33	130.51	53795600.0
2006-09-06	QQQ	ETF	39.08	39.19	38.61	38.67	97898589.0
2006-09-06	IWM	ETF	71.92	71.93	70.84	70.93	39718500.0
2006-09-06	DIA	ETF	114.27	114.44	113.97	114.14	4347600.0
2006-09-06	GLD	ETF	63.22	63.52	62.83	62.86	3210900.0
2006-09-06	TLT	ETF	86.89	87.09	86.72	87.09	1853400.0
2006-09-06	AAA	ETF	59.6	59.77	59.35	59.43	3000.0
2006-09-06	ADRE	ETF	33.05	33.05	32.17	32.17	207008.0
2006-09-06	AFK	ETF	25.37	25.38	25.33	25.35	1400.0
2006-09-06	AGG	ETF	99.01	99.12	98.94	99.07	142200.0
2006-09-06	AIQ	ETF	35.7	38.9	35.7	38.2	75560.0
2006-09-06	AIS	ETF	1.12	1.12	1.08	1.09	200100.0
2006-09-06	AOM	ETF	10.0	10.21	9.96	10.0	443100.0
2006-09-06	ARB	ETF	37.2	37.2	36.7	36.7	84100.0
2006-09-06	BAB	ETF	79.1	79.15	78.31	78.88	113700.0
2006-09-06	BBC	ETF	11.98	12.14	11.7	11.73	96000.0
2006-09-06	BBH	ETF	60.4	60.4	59.3333	59.5667	1486500.0
2006-09-06	BITS	ETF	27.32	27.84	26.0	26.16	31738.0
2006-09-06	BNE	ETF	15.41	15.9	15.3	15.35	122000.0
2006-09-06	BRF	ETF	14.15	14.18	14.13	14.16	19000.0
2006-09-06	BTF	ETF	92.65	92.65	91.99999999999999	92.14999999999999	4220.0
2006-09-06	CBON	ETF	33.58	33.93	33.51	33.68	14571.0
2006-09-06	CDL	ETF	9.19	9.19	8.94	8.98	487500.0
2006-09-06	CEF	ETF	9.17	9.27	9.13	9.18	385200.0
2006-09-06	CEW	ETF	25.54	25.55	25.3	25.3	1200.0
2006-09-06	CFO	ETF	10.2	10.2	10.2	10.2	1000.0
2006-09-06	CGO	ETF	15.48	15.72	15.36	15.6099	43700.0
2006-09-06	CHB	ETF	6.94	6.94	6.3	6.45	1359900.0
2006-09-06	CHI	ETF	19.92	20.0	19.92	19.99	105600.0
2006-09-06	CHIC	ETF	27.06	27.06	26.5	26.62	149583.0
2006-09-06	CHY	ETF	16.64	16.66	16.5401	16.56	170900.0
2006-09-06	CIZ	ETF	21.4	21.4	21.4	21.4	500.0
2006-09-06	CN	ETF	35.18	35.3	34.92	34.92	14300.0
2006-09-06	CNXT	ETF	1.95	1.97	1.83	1.84	24039757.0
2006-09-06	COMB	ETF	10.3	10.4	10.19	10.19	10878.0
2006-09-06	CPI	ETF	28.2	28.2	27.1	27.1	1900.0
2006-09-06	CPST	ETF	1.89	1.9	1.82	1.83	1195807.0
2006-09-06	CSA	ETF	20.19	20.3	20.1	20.25	6500.0
2006-09-06	CSB	ETF	27.85	27.94	27.78	27.82	5400.0
2006-09-06	CSQ	ETF	14.46	14.46	14.35	14.38	296100.0
2006-09-06	CTEC	ETF	55.05	62.5	53.699999999999996	61.25	38919.8
2006-09-06	CYB	ETF	6.68	6.7	6.56	6.6	83700.0
2006-09-06	DBC	ETF	24.8	24.98	24.6	24.8	147000.0
2006-09-06	DDM	ETF	6.3175	6.3292	6.28	6.2892	590400.0
2006-09-06	DES	ETF	17.6233	17.6233	17.5033	17.5133	52200.0
2006-09-06	DEW	ETF	56.05	56.05	54.3	54.35	31600.0
2006-09-06	DFE	ETF	54.95	54.95	54.75	54.75	1600.0
2006-09-06	DFJ	ETF	52.03	52.06	51.03	51.03	12500.0
2006-09-06	DGT	ETF	71.3	71.3	70.61	70.75	74000.0
2006-09-06	DHS	ETF	54.08	54.15	53.97	54.0	48600.0

> showing 50 of 361 rows — these rows as CSV

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