PREVIEW / etf_daily / 2006-06-27

all etf daily files

  file:    by_date/etf_daily/2006/2006-06-27.parquet
  size:    18 KB
  rows:    360

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-06-27	SPY	ETF	125.01	125.29	123.77	123.91	69780200.0
2006-06-27	QQQ	ETF	38.28	38.33	37.49	37.53	128227495.0
2006-06-27	IWM	ETF	69.54	69.83	68.02	68.3	61567100.0
2006-06-27	DIA	ETF	110.41	110.59	109.14	109.26	6514800.0
2006-06-27	GLD	ETF	58.71	59.26	57.68	57.68	6515900.0
2006-06-27	TLT	ETF	83.38	83.74	83.38	83.67	429100.0
2006-06-27	AAA	ETF	54.75	54.75	54.05	54.06	9400.0
2006-06-27	ADRE	ETF	117.99	118.59	115.46	115.4952	89412.0
2006-06-27	AFK	ETF	24.72	24.83	24.7	24.76	7300.0
2006-06-27	AGG	ETF	97.28	97.3	97.01	97.21	746000.0
2006-06-27	AIQ	ETF	30.4	31.3	29.75	30.0	23140.0
2006-06-27	AIS	ETF	1.2	1.2	1.1	1.2	87200.0
2006-06-27	AOM	ETF	6.15	6.25	6.12	6.2	17200.0
2006-06-27	ARB	ETF	37.31	37.34	36.6	36.84	308400.0
2006-06-27	BAB	ETF	62.77	62.85	61.6	61.69	43400.0
2006-06-27	BBC	ETF	13.15	14.15	13.15	14.0	1038400.0
2006-06-27	BBH	ETF	57.16	57.2467	56.4967	56.66	1972500.0
2006-06-27	BCM	ETF	66.89	66.9	65.89	65.97	19900.0
2006-06-27	BITS	ETF	18.28	19.04	17.6	17.84	26414.0
2006-06-27	BKF	ETF	6.0	6.32	6.0	6.2	58100.0
2006-06-27	BNE	ETF	13.7	13.8	13.31	13.41	263300.0
2006-06-27	BOSS	ETF	33.68	33.68	33.1	33.1	100.0
2006-06-27	BRF	ETF	13.96	14.0	13.9	13.93	11200.0
2006-06-27	BTF	ETF	88.49999999999999	89.19999999999999	88.3505	88.50049999999999	1160.0
2006-06-27	CBON	ETF	29.68	30.36	29.49	30.29	11153.0
2006-06-27	CDL	ETF	8.92	9.07	8.84	8.85	536100.0
2006-06-27	CEF	ETF	8.37	8.44	8.21	8.23	293100.0
2006-06-27	CEW	ETF	25.7	25.7	25.66	25.68	1000.0
2006-06-27	CFO	ETF	9.7	9.8	9.7	9.7	8400.0
2006-06-27	CGO	ETF	14.22	14.34	14.15	14.26	18500.0
2006-06-27	CHB	ETF	10.66	10.71	10.46	10.46	991000.0
2006-06-27	CHI	ETF	18.95	19.0	18.87	18.9101	86400.0
2006-06-27	CHIC	ETF	21.2	21.56	21.07	21.32	254395.0
2006-06-27	CHY	ETF	15.9	15.94	15.85	15.87	171100.0
2006-06-27	CIL	ETF	25.11	25.14	25.11	25.14	900.0
2006-06-27	CIZ	ETF	22.5	22.5	22.5	22.5	200.0
2006-06-27	CN	ETF	33.3	33.67	33.3	33.51	44300.0
2006-06-27	CNXT	ETF	2.315	2.34	2.16	2.22	22884743.0
2006-06-27	COMB	ETF	9.85	9.9	9.68	9.89	15996.0
2006-06-27	CPST	ETF	2.5	2.51	2.33	2.42	1325876.0
2006-06-27	CSA	ETF	19.85	20.5	19.85	19.85	7600.0
2006-06-27	CSB	ETF	26.95	27.01	26.69	26.75	15200.0
2006-06-27	CSQ	ETF	13.89	13.92	13.8101	13.9	290000.0
2006-06-27	CTEC	ETF	62.24999999999999	64.35	62.05	63.75	15329.800000000001
2006-06-27	CYB	ETF	6.19	6.3	6.1	6.25	50700.0
2006-06-27	DBC	ETF	24.68	24.87	24.52	24.75	227800.0
2006-06-27	DDM	ETF	5.9442	5.9442	5.8033	5.81	946800.0
2006-06-27	DES	ETF	16.7833	16.8567	16.7367	16.7367	5100.0
2006-06-27	DEW	ETF	49.61	49.61	49.56	49.56	1500.0
2006-06-27	DFE	ETF	50.99	50.99	50.93	50.93	200.0

> showing 50 of 360 rows — these rows as CSV

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