PREVIEW / etf_daily / 2006-08-09

all etf daily files

  file:    by_date/etf_daily/2006/2006-08-09.parquet
  size:    18 KB
  rows:    358

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-09	SPY	ETF	128.18	128.6	126.61	126.98	78910600.0
2006-08-09	QQQ	ETF	37.01	37.31	36.43	36.53	145388244.0
2006-08-09	IWM	ETF	68.99	69.28	67.6	67.7	58126400.0
2006-08-09	DIA	ETF	112.4	112.51	110.72	110.95	8368700.0
2006-08-09	GLD	ETF	64.56	65.13	64.39	64.63	4369600.0
2006-08-09	TLT	ETF	85.75	86.02	85.71	85.9	372400.0
2006-08-09	AAA	ETF	57.23	57.3899	57.07	57.12	24100.0
2006-08-09	ADRE	ETF	32.49	32.6	32.0	32.01	233605.0
2006-08-09	AFK	ETF	25.2	25.3	25.2	25.29	2700.0
2006-08-09	AGG	ETF	98.45	98.71	98.45	98.69	131700.0
2006-08-09	AIQ	ETF	32.45	32.5	31.95	32.3	11780.0
2006-08-09	AIS	ETF	1.02	1.02	0.98	0.99	132700.0
2006-08-09	AOM	ETF	6.11	6.18	6.02	6.02	15900.0
2006-08-09	ARB	ETF	35.8	35.98	35.16	35.32	229400.0
2006-08-09	BAB	ETF	74.99	75.01	73.21	73.33	87600.0
2006-08-09	BBC	ETF	13.45	13.45	13.01	13.14	113400.0
2006-08-09	BBH	ETF	58.5333	59.45	58.38	58.4333	756900.0
2006-08-09	BITS	ETF	23.8	24.2	22.6	23.08	92448.0
2006-08-09	BKF	ETF	3.92	4.02	3.92	4.0	10000.0
2006-08-09	BNE	ETF	14.02	14.22	13.69	13.75	175100.0
2006-08-09	BRF	ETF	14.06	14.1	14.05	14.05	24300.0
2006-08-09	BTF	ETF	88.55	89.0	88.55	88.9	520.0
2006-08-09	CBON	ETF	33.78	33.87	33.13	33.21	40305.0
2006-08-09	CDL	ETF	8.75	9.22	8.75	8.87	853800.0
2006-08-09	CEF	ETF	9.02	9.24	9.02	9.09	459600.0
2006-08-09	CEW	ETF	26.01	26.01	25.82	25.95	3000.0
2006-08-09	CFO	ETF	10.1	10.15	10.05	10.05	60700.0
2006-08-09	CGO	ETF	15.07	15.08	14.8	14.95	25200.0
2006-08-09	CHB	ETF	5.97	6.0	5.11	5.2	2342100.0
2006-08-09	CHI	ETF	20.14	20.32	20.14	20.23	80100.0
2006-08-09	CHIC	ETF	25.42	26.0	25.41	25.57	461840.0
2006-08-09	CHY	ETF	16.3	16.33	16.1601	16.21	200700.0
2006-08-09	CIL	ETF	25.32	25.32	25.31	25.32	13200.0
2006-08-09	CN	ETF	36.42	36.98	36.12	36.2	57800.0
2006-08-09	CNXT	ETF	1.65	1.71	1.6299	1.66	15801084.0
2006-08-09	COMB	ETF	9.88	10.0	9.75	9.76	14146.0
2006-08-09	CPST	ETF	1.84	1.89	1.8099	1.83	687498.0
2006-08-09	CSA	ETF	18.3	18.55	18.3	18.44	2900.0
2006-08-09	CSB	ETF	25.81	25.84	25.56	25.59	8400.0
2006-08-09	CSQ	ETF	13.98	14.13	13.98	14.12	283900.0
2006-08-09	CTEC	ETF	56.25	57.05	54.55	54.85	15337.0
2006-08-09	CYB	ETF	5.4	5.5	5.27	5.27	31500.0
2006-08-09	DBC	ETF	26.13	26.34	26.0	26.13	217000.0
2006-08-09	DDM	ETF	6.1067	6.1133	5.9233	5.9317	976800.0
2006-08-09	DES	ETF	17.2433	17.2433	16.93	16.93	20400.0
2006-08-09	DFE	ETF	54.3	54.3	54.2	54.2	1000.0
2006-08-09	DFJ	ETF	49.86	50.06	49.69	49.69	1900.0
2006-08-09	DGT	ETF	69.9	70.3	69.5	69.5	60400.0
2006-08-09	DHS	ETF	52.95	53.22	52.52	52.52	5900.0
2006-08-09	DIM	ETF	53.83	54.06	53.83	54.06	1200.0

> showing 50 of 358 rows — these rows as CSV

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