PREVIEW / etf_daily / 2006-08-04

all etf daily files

  file:    by_date/etf_daily/2006/2006-08-04.parquet
  size:    18 KB
  rows:    356

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-04	SPY	ETF	129.08	129.43	127.48	128.2	96294200.0
2006-08-04	QQQ	ETF	37.42	37.63	36.62	36.95	123504696.0
2006-08-04	IWM	ETF	71.13	71.31	68.97	69.62	76609200.0
2006-08-04	DIA	ETF	113.14	113.37	111.82	112.48	7698000.0
2006-08-04	GLD	ETF	64.87	64.98	64.0	64.28	4811100.0
2006-08-04	TLT	ETF	86.4	86.48	86.29	86.32	1246000.0
2006-08-04	AAA	ETF	58.02	58.35	57.83	57.91	5300.0
2006-08-04	ADRE	ETF	32.43	32.68	32.0	32.08	130144.0
2006-08-04	AFK	ETF	25.2	25.22	25.15	25.22	2500.0
2006-08-04	AGG	ETF	98.55	98.71	98.55	98.6	136000.0
2006-08-04	AIQ	ETF	34.0	34.95	31.85	32.5	35380.0
2006-08-04	AIS	ETF	1.06	1.1	1.05	1.0999	6300.0
2006-08-04	AOM	ETF	5.95	6.01	5.95	6.01	2200.0
2006-08-04	ARB	ETF	36.74	37.19	35.92	36.38	100100.0
2006-08-04	BAB	ETF	71.71	72.07	70.59	71.25	108300.0
2006-08-04	BBC	ETF	13.1	13.28	12.88	13.05	96000.0
2006-08-04	BBH	ETF	59.6667	60.37	58.86	59.3067	762600.0
2006-08-04	BITS	ETF	17.92	18.52	16.4	17.16	19606.0
2006-08-04	BKF	ETF	3.96	3.963	3.91	3.92	17500.0
2006-08-04	BNE	ETF	14.3	14.37	13.78	14.04	116600.0
2006-08-04	BRF	ETF	14.12	14.12	14.06	14.1	1200.0
2006-08-04	BTF	ETF	87.65	87.9495	87.65	87.75	900.0
2006-08-04	CBON	ETF	33.99	33.99	33.83	33.99	20648.0
2006-08-04	CDL	ETF	9.09	9.1	8.71	8.76	544900.0
2006-08-04	CEF	ETF	9.14	9.32	8.93	9.17	524700.0
2006-08-04	CEW	ETF	25.95	25.95	25.95	25.95	100.0
2006-08-04	CFO	ETF	10.02	10.02	10.0	10.0	4000.0
2006-08-04	CGO	ETF	15.5	15.5	14.95	15.15	35100.0
2006-08-04	CHB	ETF	6.44	6.5	6.11	6.23	1975400.0
2006-08-04	CHI	ETF	19.99	20.2	19.99	20.2	79500.0
2006-08-04	CHIC	ETF	26.25	26.4	25.03	25.56	341857.0
2006-08-04	CHY	ETF	16.25	16.33	16.23	16.32	166000.0
2006-08-04	CN	ETF	35.54	35.7	34.88	34.88	49500.0
2006-08-04	CNXT	ETF	1.77	1.77	1.66	1.66	10144859.0
2006-08-04	COMB	ETF	9.79	9.79	9.78	9.79	1200.0
2006-08-04	CPST	ETF	2.04	2.1	1.91	2.01	1326206.0
2006-08-04	CSA	ETF	18.55	18.55	18.45	18.46	62700.0
2006-08-04	CSB	ETF	26.47	26.68	26.36	26.43	29500.0
2006-08-04	CSQ	ETF	14.25	14.29	14.2	14.25	287200.0
2006-08-04	CTEC	ETF	55.25	57.55	55.25	56.199999999999996	12195.2
2006-08-04	CYB	ETF	5.82	5.95	5.73	5.77	144200.0
2006-08-04	DBC	ETF	26.15	26.17	25.81	26.05	136900.0
2006-08-04	DDM	ETF	6.18	6.2375	6.0575	6.1158	1795200.0
2006-08-04	DES	ETF	17.55	17.55	17.3167	17.3333	6000.0
2006-08-04	DEW	ETF	54.05	54.07	53.98	53.98	900.0
2006-08-04	DFE	ETF	54.31	54.5	54.31	54.36	1800.0
2006-08-04	DFJ	ETF	50.48	50.48	50.09	50.09	1000.0
2006-08-04	DGT	ETF	69.8	70.0	69.3	69.53	10900.0
2006-08-04	DHS	ETF	53.27	53.51	53.13	53.21	36300.0
2006-08-04	DIM	ETF	54.05	54.22	53.96	53.96	1500.0

> showing 50 of 356 rows — these rows as CSV

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