PREVIEW / etf_daily / 2006-07-05

all etf daily files

  file:    by_date/etf_daily/2006/2006-07-05.parquet
  size:    18 KB
  rows:    354

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-07-05	SPY	ETF	127.29	127.45	126.52	127.07	69653400.0
2006-07-05	QQQ	ETF	38.64	38.68	38.09	38.15	93732118.0
2006-07-05	IWM	ETF	71.84	71.95	70.99	71.57	38621400.0
2006-07-05	DIA	ETF	111.73	111.85	111.18	111.47	3459400.0
2006-07-05	GLD	ETF	62.48	62.63	61.44	62.5	8178400.0
2006-07-05	TLT	ETF	83.4	83.42	82.95	83.24	1289200.0
2006-07-05	AAA	ETF	55.64	55.9	55.29	55.63	3500.0
2006-07-05	ADRE	ETF	126.35	126.35	122.5172	123.93	45736.0
2006-07-05	AFK	ETF	24.83	24.83	24.63	24.64	14400.0
2006-07-05	AGG	ETF	97.22	97.22	96.71	96.91	260100.0
2006-07-05	AIQ	ETF	31.85	34.0	31.45	33.95	25400.0
2006-07-05	AIS	ETF	1.18	1.18	1.1	1.13	233300.0
2006-07-05	AOM	ETF	5.68	5.8	5.65	5.8	19000.0
2006-07-05	ARB	ETF	38.34	38.52	38.0	38.35	228600.0
2006-07-05	BAB	ETF	64.25	64.37	63.55	64.09	34700.0
2006-07-05	BBC	ETF	14.0	14.48	13.7	14.29	1186200.0
2006-07-05	BBH	ETF	58.8933	59.46	58.7867	59.2	760500.0
2006-07-05	BCM	ETF	67.53	67.53	66.94	67.2	39900.0
2006-07-05	BITS	ETF	19.36	20.44	19.0	19.32	35144.0
2006-07-05	BKF	ETF	6.15	6.15	5.83	6.08	54600.0
2006-07-05	BNE	ETF	14.06	14.06	13.3	13.83	174400.0
2006-07-05	BOSS	ETF	33.4	33.4	32.98	32.98	200.0
2006-07-05	BRF	ETF	14.07	14.07	13.99	13.99	6200.0
2006-07-05	BTF	ETF	90.0	90.0	89.35	89.35	580.0
2006-07-05	CBON	ETF	31.63	32.38	31.14	32.16	46825.0
2006-07-05	CDL	ETF	8.92	9.01	8.73	8.94	394700.0
2006-07-05	CEF	ETF	9.0	9.0	8.7	8.92	601100.0
2006-07-05	CEW	ETF	26.0	26.23	26.0	26.23	700.0
2006-07-05	CFO	ETF	10.05	10.05	10.01	10.01	4400.0
2006-07-05	CGO	ETF	14.5	14.65	14.48	14.55	15000.0
2006-07-05	CHB	ETF	9.43	10.49	9.43	10.43	1367900.0
2006-07-05	CHI	ETF	19.27	19.41	19.27	19.41	72200.0
2006-07-05	CHIC	ETF	24.42	24.45	23.56	23.77	359459.0
2006-07-05	CHY	ETF	16.1	16.1	16.03	16.1	94200.0
2006-07-05	CIZ	ETF	22.65	22.65	22.65	22.65	100.0
2006-07-05	CN	ETF	35.05	35.21	34.49	34.75	55200.0
2006-07-05	CNXT	ETF	2.38	2.42	2.27	2.41	11004728.0
2006-07-05	COMB	ETF	9.94	9.94	9.94	9.94	200.0
2006-07-05	CPI	ETF	29.71	29.71	29.71	29.71	500.0
2006-07-05	CPST	ETF	2.39	2.39	2.31	2.35	1511259.0
2006-07-05	CSA	ETF	19.05	19.05	18.7	18.7	5700.0
2006-07-05	CSB	ETF	28.0	28.0	27.67	27.82	7000.0
2006-07-05	CSQ	ETF	13.88	13.93	13.79	13.93	235000.0
2006-07-05	CTEC	ETF	64.6	64.74999999999999	63.099999999999994	63.65	14863.2
2006-07-05	CYB	ETF	6.55	6.55	6.2	6.23	64400.0
2006-07-05	DBC	ETF	25.55	25.79	25.5001	25.77	998200.0
2006-07-05	DDM	ETF	6.0617	6.0733	6.025	6.0492	584400.0
2006-07-05	DES	ETF	17.2167	17.3467	17.1167	17.2133	57900.0
2006-07-05	DFE	ETF	53.02	53.02	53.02	53.02	100.0
2006-07-05	DFJ	ETF	50.84	50.9	50.8	50.9	800.0

> showing 50 of 354 rows — these rows as CSV

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