PREVIEW / etf_daily / 2006-07-07

all etf daily files

  file:    by_date/etf_daily/2006/2006-07-07.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-07	SPY	ETF	127.19	127.56	126.29	126.61	81626500.0
2006-07-07	QQQ	ETF	37.89	38.17	37.57	37.69	108071595.0
2006-07-07	IWM	ETF	71.45	71.64	70.35	70.49	45330300.0
2006-07-07	DIA	ETF	111.65	112.4	110.69	110.96	7181800.0
2006-07-07	GLD	ETF	62.84	63.05	62.46	62.63	5328700.0
2006-07-07	TLT	ETF	84.2	84.46	84.08	84.29	1356900.0
2006-07-07	AAA	ETF	56.32	56.55	56.25	56.34	2000.0
2006-07-07	ADRE	ETF	125.49	125.67	123.22	123.25	116536.0
2006-07-07	AFK	ETF	24.68	24.82	24.68	24.82	54700.0
2006-07-07	AGG	ETF	97.13	97.54	97.11	97.36	427600.0
2006-07-07	AIQ	ETF	33.95	35.0	33.65	34.4	36460.0
2006-07-07	AIS	ETF	1.15	1.19	1.11	1.16	105200.0
2006-07-07	AOM	ETF	5.8	5.8	5.7401	5.79	2900.0
2006-07-07	ARB	ETF	37.92	38.34	37.61	37.97	217500.0
2006-07-07	BAB	ETF	66.25	66.88	65.58	65.85	103400.0
2006-07-07	BBC	ETF	13.9	14.04	13.0	13.15	373200.0
2006-07-07	BBH	ETF	59.9667	60.6067	59.52	59.78	2348100.0
2006-07-07	BCM	ETF	67.85	69.09	67.65	68.98	51900.0
2006-07-07	BITS	ETF	19.12	19.92	18.6	18.68	13226.0
2006-07-07	BKF	ETF	5.92	6.0	5.8	5.81	13000.0
2006-07-07	BNE	ETF	14.05	14.19	13.99	14.0	146300.0
2006-07-07	BRF	ETF	13.99	14.02	13.96	13.96	4300.0
2006-07-07	BTF	ETF	88.9	89.19999999999999	88.9	89.19999999999999	60.0
2006-07-07	CBON	ETF	31.72	32.62	31.72	32.36	30751.0
2006-07-07	CDL	ETF	8.89	9.04	8.84	8.84	200000.0
2006-07-07	CEF	ETF	9.03	9.05	8.77	8.83	257200.0
2006-07-07	CEW	ETF	26.1	26.1	26.1	26.1	200.0
2006-07-07	CFO	ETF	10.0	10.0	10.0	10.0	50000.0
2006-07-07	CGO	ETF	14.72	14.85	14.61	14.68	20900.0
2006-07-07	CHB	ETF	10.46	10.6064	10.13	10.25	864700.0
2006-07-07	CHI	ETF	19.58	19.58	19.4	19.48	74400.0
2006-07-07	CHIC	ETF	23.81	23.81	22.75	23.01	304115.0
2006-07-07	CHY	ETF	16.1	16.1	16.06	16.1	110300.0
2006-07-07	CIL	ETF	25.11	25.12	25.11	25.12	500.0
2006-07-07	CIZ	ETF	22.45	22.45	22.45	22.45	300.0
2006-07-07	CN	ETF	36.1	36.18	35.82	36.07	32500.0
2006-07-07	CNXT	ETF	2.31	2.32	2.17	2.19	14756601.0
2006-07-07	CPI	ETF	29.85	29.85	29.85	29.85	800.0
2006-07-07	CPST	ETF	2.39	2.45	2.34	2.36	936744.0
2006-07-07	CSA	ETF	18.7	18.7	18.31	18.7	5900.0
2006-07-07	CSB	ETF	27.53	27.74	27.5	27.5	8400.0
2006-07-07	CSQ	ETF	14.0	14.0	13.94	13.99	250600.0
2006-07-07	CTEC	ETF	63.949999999999996	65.25	62.449999999999996	65.0	20677.4
2006-07-07	CYB	ETF	6.12	6.25	6.08	6.16	28700.0
2006-07-07	DBC	ETF	25.94	25.94	25.65	25.75	391300.0
2006-07-07	DDM	ETF	6.0625	6.0733	5.9617	5.9875	2456400.0
2006-07-07	DES	ETF	17.2467	17.3533	17.1567	17.1567	11700.0
2006-07-07	DEW	ETF	52.52	52.52	52.52	52.52	600.0
2006-07-07	DFE	ETF	53.47	53.47	53.41	53.41	500.0
2006-07-07	DFJ	ETF	51.93	51.93	50.99	50.99	600.0

> showing 50 of 354 rows — these rows as CSV

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