PREVIEW / etf_daily / 2006-08-15

all etf daily files

  file:    by_date/etf_daily/2006/2006-08-15.parquet
  size:    18 KB
  rows:    355

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-15	SPY	ETF	128.25	128.87	127.9	128.63	68143000.0
2006-08-15	QQQ	ETF	37.22	37.75	37.09	37.7	133719823.0
2006-08-15	IWM	ETF	69.0	69.45	68.69	69.42	48780200.0
2006-08-15	DIA	ETF	112.07	112.45	111.73	112.26	4695800.0
2006-08-15	GLD	ETF	61.95	62.27	61.68	62.01	4833600.0
2006-08-15	TLT	ETF	85.78	86.09	85.78	85.97	1093800.0
2006-08-15	AAA	ETF	56.9	57.26	56.9	57.26	3100.0
2006-08-15	ADRE	ETF	32.22	32.68	32.22	32.65	176346.0
2006-08-15	AFK	ETF	25.2499	25.25	25.16	25.24	7100.0
2006-08-15	AGG	ETF	98.66	98.74	98.53	98.6	269400.0
2006-08-15	AIQ	ETF	31.45	32.75	30.75	32.5	28720.0
2006-08-15	AIS	ETF	0.92	0.93	0.8599	0.89	138800.0
2006-08-15	AOM	ETF	5.97	5.97	5.9	5.9	5600.0
2006-08-15	ARB	ETF	36.1	36.69	35.9	36.52	159000.0
2006-08-15	BAB	ETF	71.74	71.92	70.9	71.25	40500.0
2006-08-15	BBC	ETF	12.35	12.45	12.0	12.05	333700.0
2006-08-15	BBH	ETF	58.1	58.5567	57.8567	58.3633	608700.0
2006-08-15	BITS	ETF	25.72	27.4	25.72	26.6	51621.0
2006-08-15	BKF	ETF	3.95	4.0	3.93	4.0	12300.0
2006-08-15	BNE	ETF	15.3	15.39	15.1	15.19	117400.0
2006-08-15	BRF	ETF	14.04	14.06	14.04	14.05	5800.0
2006-08-15	BTF	ETF	89.49999999999999	90.99999999999999	89.49999999999999	90.39999999999999	1580.0
2006-08-15	CBON	ETF	33.05	33.4	32.98	33.2	28800.0
2006-08-15	CDL	ETF	8.68	8.7	8.57	8.68	343600.0
2006-08-15	CEF	ETF	8.87	8.94	8.82	8.89	146900.0
2006-08-15	CGO	ETF	15.1	15.28	15.1	15.26	30400.0
2006-08-15	CHB	ETF	5.51	5.74	5.5	5.65	1339800.0
2006-08-15	CHI	ETF	20.18	20.24	20.16	20.2	92100.0
2006-08-15	CHIC	ETF	25.87	26.91	25.87	26.86	543227.0
2006-08-15	CHY	ETF	16.27	16.29	16.2	16.24	133200.0
2006-08-15	CN	ETF	36.73	37.35	36.73	37.05	74700.0
2006-08-15	CNXT	ETF	1.72	1.74	1.68	1.72	17961569.0
2006-08-15	COMB	ETF	9.8	10.05	9.8	9.96	7000.0
2006-08-15	CPI	ETF	28.5	28.5	28.5	28.5	200.0
2006-08-15	CPST	ETF	1.86	1.88	1.82	1.86	484006.0
2006-08-15	CSA	ETF	18.45	18.5	18.35	18.4	5400.0
2006-08-15	CSB	ETF	25.93	26.12	25.93	26.09	23100.0
2006-08-15	CSQ	ETF	14.29	14.35	14.25	14.34	358600.0
2006-08-15	CTEC	ETF	54.699999999999996	55.75	53.25	54.4	12642.2
2006-08-15	CYB	ETF	5.65	5.7399	5.57	5.6	43500.0
2006-08-15	DBC	ETF	25.31	25.39	25.17	25.34	247200.0
2006-08-15	DDM	ETF	6.0625	6.1275	6.0242	6.0892	1665600.0
2006-08-15	DES	ETF	17.2833	17.3167	17.2133	17.3167	59700.0
2006-08-15	DEW	ETF	53.86	54.03	53.86	54.03	4000.0
2006-08-15	DFE	ETF	54.45	54.55	54.45	54.55	3200.0
2006-08-15	DFJ	ETF	51.24	51.34	51.24	51.34	700.0
2006-08-15	DGT	ETF	70.3	70.47	70.05	70.35	24100.0
2006-08-15	DHS	ETF	53.14	53.2	52.98	53.2	19700.0
2006-08-15	DIM	ETF	54.3	54.55	54.3	54.55	5700.0
2006-08-15	DIV	ETF	12.4	12.5	12.36	12.45	27600.0

> showing 50 of 355 rows — these rows as CSV

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