PREVIEW / etf_daily / 2006-07-20

all etf daily files

  file:    by_date/etf_daily/2006/2006-07-20.parquet
  size:    18 KB
  rows:    351

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-20	SPY	ETF	126.12	126.3	124.66	124.83	112259800.0
2006-07-20	QQQ	ETF	36.74	36.8	36.04	36.08	152346656.0
2006-07-20	IWM	ETF	70.04	70.37	67.62	67.72	73657100.0
2006-07-20	DIA	ETF	110.3	110.45	109.24	109.42	7764700.0
2006-07-20	GLD	ETF	63.4	63.97	62.4	62.54	6402700.0
2006-07-20	TLT	ETF	84.97	85.63	84.97	85.49	1320200.0
2006-07-20	AAA	ETF	54.17	54.39	54.17	54.26	6200.0
2006-07-20	ADRE	ETF	31.23	31.35	30.33	30.33	603112.0
2006-07-20	AFK	ETF	25.0	25.05	24.94	24.98	90800.0
2006-07-20	AGG	ETF	97.84	98.16	97.81	98.08	91500.0
2006-07-20	AIQ	ETF	31.1	31.1	29.0	29.45	41940.0
2006-07-20	AIS	ETF	1.24	1.24	1.1	1.16	122400.0
2006-07-20	AOM	ETF	6.6	6.6	6.48	6.48	1900.0
2006-07-20	ARB	ETF	37.3	37.35	35.8	36.31	246300.0
2006-07-20	BAB	ETF	67.91	68.11	67.0	67.3	74700.0
2006-07-20	BBC	ETF	12.6	12.8	12.18	12.35	149000.0
2006-07-20	BBH	ETF	57.4667	57.7867	56.9367	57.0333	927300.0
2006-07-20	BITS	ETF	18.28	21.0	18.28	19.28	32348.0
2006-07-20	BKF	ETF	5.35	5.56	5.32	5.48	28800.0
2006-07-20	BNE	ETF	13.55	13.8	13.11	13.2	152300.0
2006-07-20	BRF	ETF	13.92	14.0	13.92	14.0	6500.0
2006-07-20	BTF	ETF	87.3	87.3	86.54999999999998	86.54999999999998	340.0
2006-07-20	CBON	ETF	32.15	32.4	31.97	32.21	52696.0
2006-07-20	CDL	ETF	9.15	9.15	8.94	9.01	242600.0
2006-07-20	CEF	ETF	8.96	9.02	8.79	8.83	242900.0
2006-07-20	CFO	ETF	9.9	9.9	9.9	9.9	11000.0
2006-07-20	CGO	ETF	14.6	14.84	14.53	14.84	20200.0
2006-07-20	CHB	ETF	8.91	9.03	8.48	8.55	1209500.0
2006-07-20	CHI	ETF	19.45	19.59	19.44	19.59	52500.0
2006-07-20	CHIC	ETF	24.0	25.1	23.71	24.31	1718750.0
2006-07-20	CHY	ETF	16.08	16.1	16.0	16.1	118100.0
2006-07-20	CIZ	ETF	22.3	22.3	22.2	22.2	500.0
2006-07-20	CN	ETF	36.03	36.2	35.61	35.66	74800.0
2006-07-20	CNXT	ETF	2.16	2.18	2.04	2.06	6844679.0
2006-07-20	COMB	ETF	9.82	9.82	9.7465	9.79	4035.0
2006-07-20	CPST	ETF	2.12	2.19	2.01	2.02	1214590.0
2006-07-20	CSA	ETF	18.8	18.882	18.8	18.802	800.0
2006-07-20	CSB	ETF	27.26	27.26	27.01	27.04	6800.0
2006-07-20	CSQ	ETF	14.01	14.04	13.97	14.04	299900.0
2006-07-20	CTEC	ETF	58.849999999999994	59.24999999999999	57.949999999999996	58.75	10791.2
2006-07-20	CYB	ETF	5.95	5.95	5.75	5.83	21400.0
2006-07-20	DBC	ETF	25.99	26.1	25.44	25.56	293100.0
2006-07-20	DDM	ETF	5.9058	5.9125	5.785	5.7958	878400.0
2006-07-20	DES	ETF	17.3833	17.3833	17.1667	17.17	39600.0
2006-07-20	DEW	ETF	51.2	51.28	51.2	51.24	13800.0
2006-07-20	DFE	ETF	51.91	51.91	51.91	51.91	300.0
2006-07-20	DFJ	ETF	48.37	48.37	47.92	47.92	2100.0
2006-07-20	DGT	ETF	66.93	66.93	66.53	66.58	400.0
2006-07-20	DHS	ETF	51.64	51.78	51.47	51.47	8300.0
2006-07-20	DIM	ETF	51.8	51.8	51.38	51.38	12000.0

> showing 50 of 351 rows — these rows as CSV

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