PREVIEW / etf_daily / 2005-06-17

all etf daily files

  file:    by_date/etf_daily/2005/2005-06-17.parquet
  size:    15 KB
  rows:    270

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
2005-06-17	SPY	ETF	121.54	121.9	121.22	121.36	51529400.0
2005-06-17	QQQ	ETF	38.11	38.21	37.75	37.87	89171244.0
2005-06-17	IWM	ETF	64.32	64.65	63.88	64.02	20964800.0
2005-06-17	DIA	ETF	106.21	106.51	105.89	106.04	7295800.0
2005-06-17	GLD	ETF	43.78	43.85	43.61	43.63	1816500.0
2005-06-17	TLT	ETF	94.11	94.47	94.02	94.33	555900.0
2005-06-17	AAA	ETF	58.49	58.65	58.4	58.52	1200.0
2005-06-17	ADRE	ETF	95.99	95.99	91.79	92.23	9992.0
2005-06-17	AFK	ETF	26.05	26.05	25.94	26.008	14200.0
2005-06-17	AGG	ETF	102.51	102.66	102.4	102.63	76100.0
2005-06-17	AIQ	ETF	51.85	52.1	51.35	51.9	19440.0
2005-06-17	AIS	ETF	1.04	1.1	1.0	1.06	169100.0
2005-06-17	ARB	ETF	44.27	44.76	44.1	44.38	259700.0
2005-06-17	BAB	ETF	50.85	51.13	50.6	50.75	19400.0
2005-06-17	BBH	ETF	56.8833	57.1767	56.53	56.9933	1373100.0
2005-06-17	BCM	ETF	60.95	61.5	60.75	61.46	15400.0
2005-06-17	BIS	ETF	622.4	622.4	614.4	616.0	14.4
2005-06-17	BITS	ETF	12.52	13.56	12.4	13.56	9916.0
2005-06-17	BKF	ETF	38.5	39.5	38.5	39.25	133800.0
2005-06-17	BNE	ETF	14.0	14.18	13.95	13.95	227000.0
2005-06-17	BRF	ETF	15.44	15.5	15.42	15.42	6900.0
2005-06-17	BTF	ETF	86.25	86.8	86.25	86.8	3900.0
2005-06-17	CBON	ETF	29.85	30.83	29.648	30.83	50374.0
2005-06-17	CDC	ETF	7.0	7.2	6.97	7.15	5100.0
2005-06-17	CDL	ETF	12.04	12.04	11.89	11.95	607700.0
2005-06-17	CEF	ETF	5.42	5.43	5.34	5.37	397900.0
2005-06-17	CEW	ETF	26.55	26.55	26.55	26.55	100.0
2005-06-17	CHB	ETF	11.13	11.2	10.3	10.5	707800.0
2005-06-17	CHI	ETF	19.4	19.6	19.39	19.56	90600.0
2005-06-17	CHIC	ETF	12.41	12.41	12.09	12.35	204027.0
2005-06-17	CHIR	ETF	36.1101	36.3399	35.55	35.8401	1721079.0
2005-06-17	CHY	ETF	16.1	16.17	16.06	16.17	87000.0
2005-06-17	CIL	ETF	25.7	25.8	25.7	25.75	700.0
2005-06-17	CIZ	ETF	22.35	22.5	22.35	22.5	500.0
2005-06-17	CN	ETF	27.06	27.49	27.0	27.49	26200.0
2005-06-17	CNXT	ETF	1.48	1.52	1.46	1.51	3011904.0
2005-06-17	CPI	ETF	23.9	23.9	23.83	23.83	300.0
2005-06-17	CPST	ETF	1.14	1.29	1.12	1.28	1967705.0
2005-06-17	CSB	ETF	30.7	30.95	30.62	30.9	11600.0
2005-06-17	CSM	ETF	2.4025	2.4025	2.4025	2.4025	11200.0
2005-06-17	CSQ	ETF	13.82	13.97	13.82	13.9	345600.0
2005-06-17	CTEC	ETF	49.45	49.85	49.15	49.5	3174.8
2005-06-17	CURE	ETF	0.2637	0.2637	0.25	0.25	884776.0
2005-06-17	CYA	ETF	154.8	154.8	145.0	145.0	460.0
2005-06-17	CYB	ETF	3.0	3.19	2.99	3.19	36400.0
2005-06-17	DGT	ETF	64.55	64.57	64.2	64.43	14400.0
2005-06-17	DIG	ETF	12.5	12.5	12.5	12.5	4000.0
2005-06-17	DIV	ETF	13.79	13.88	13.72	13.72	22400.0
2005-06-17	DRIV	ETF	29.3	29.77	28.71	29.38	721746.0
2005-06-17	DSI	ETF	5.925	5.98	5.925	5.98	34800.0

> showing 50 of 270 rows — these rows as CSV

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