PREVIEW / etf_daily / 2006-08-17

all etf daily files

  file:    by_date/etf_daily/2006/2006-08-17.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-08-17	SPY	ETF	129.58	130.37	129.49	130.03	70992800.0
2006-08-17	QQQ	ETF	38.47	38.98	38.44	38.73	129697874.0
2006-08-17	IWM	ETF	70.22	71.1	70.13	70.53	44642200.0
2006-08-17	DIA	ETF	113.3	113.88	113.19	113.46	5959600.0
2006-08-17	GLD	ETF	62.32	62.35	60.96	61.03	4215900.0
2006-08-17	TLT	ETF	86.77	86.77	86.42	86.52	922300.0
2006-08-17	AAA	ETF	57.25	57.4	57.11	57.11	1800.0
2006-08-17	ADRE	ETF	33.08	33.24	32.58	32.79	422359.0
2006-08-17	AFK	ETF	25.24	25.28	25.22	25.28	55000.0
2006-08-17	AGG	ETF	99.14	99.14	98.91	98.94	143200.0
2006-08-17	AIQ	ETF	32.3	32.9	32.2	32.45	16480.0
2006-08-17	AIS	ETF	0.89	0.9	0.86	0.88	178200.0
2006-08-17	AOM	ETF	5.94	5.94	5.81	5.84	6800.0
2006-08-17	ARB	ETF	36.01	36.31	35.99	36.27	119600.0
2006-08-17	BAB	ETF	74.09	74.45	73.56	74.0	105400.0
2006-08-17	BBC	ETF	12.28	12.95	12.15	12.56	85900.0
2006-08-17	BBH	ETF	59.5667	60.12	59.4167	59.7633	2028600.0
2006-08-17	BITS	ETF	27.16	27.2	25.6288	25.96	35091.0
2006-08-17	BKF	ETF	4.12	4.13	3.97	3.97	89300.0
2006-08-17	BNE	ETF	15.3	15.65	15.2101	15.58	102900.0
2006-08-17	BRF	ETF	14.07	14.07	14.07	14.07	100.0
2006-08-17	BTF	ETF	90.85000000000001	91.3	90.74999999999999	90.99999999999999	12500.0
2006-08-17	CBON	ETF	33.27	33.35	32.9	33.25	17968.0
2006-08-17	CDL	ETF	8.75	8.8394	8.75	8.76	200400.0
2006-08-17	CEF	ETF	9.02	9.02	8.8	8.81	370600.0
2006-08-17	CEW	ETF	26.0	26.15	26.0	26.15	1100.0
2006-08-17	CFO	ETF	9.95	9.95	9.95	9.95	2000.0
2006-08-17	CGO	ETF	15.71	15.79	15.3	15.54	58000.0
2006-08-17	CHB	ETF	5.89	6.18	5.87	6.16	2219200.0
2006-08-17	CHI	ETF	20.25	20.4	20.24	20.3599	92000.0
2006-08-17	CHIC	ETF	27.37	27.68	27.1	27.33	440148.0
2006-08-17	CHY	ETF	16.32	16.38	16.28	16.38	129400.0
2006-08-17	CIL	ETF	25.45	25.45	25.45	25.45	100.0
2006-08-17	CN	ETF	37.51	37.52	36.9	37.24	38500.0
2006-08-17	CNXT	ETF	1.88	2.12	1.86	2.09	30226406.0
2006-08-17	COMB	ETF	9.9	9.93	9.8993	9.9	14727.0
2006-08-17	CPI	ETF	28.7	29.0	28.7	29.0	1000.0
2006-08-17	CPST	ETF	1.92	2.03	1.9	2.03	1506315.0
2006-08-17	CSA	ETF	18.55	18.75	18.48	18.5	16400.0
2006-08-17	CSB	ETF	29.07	29.55	29.06	29.55	24600.0
2006-08-17	CSQ	ETF	14.31	14.44	14.31	14.43	406400.0
2006-08-17	CTEC	ETF	54.800000000000004	55.65	54.699999999999996	54.9	8945.0
2006-08-17	CYB	ETF	5.66	5.71	5.61	5.65	3900.0
2006-08-17	DBC	ETF	24.84	24.95	24.5	24.68	617000.0
2006-08-17	DDM	ETF	6.2	6.2608	6.02	6.2267	1952400.0
2006-08-17	DES	ETF	17.4067	17.55	17.3967	17.4667	48000.0
2006-08-17	DEW	ETF	54.4	54.48	54.25	54.29	2300.0
2006-08-17	DFE	ETF	55.1	55.22	55.1	55.22	1900.0
2006-08-17	DFJ	ETF	51.6	51.76	51.51	51.51	2400.0
2006-08-17	DGT	ETF	70.65	70.94	70.36	70.45	46200.0

> showing 50 of 361 rows — these rows as CSV

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