PREVIEW / etf_daily / 2005-10-27

all etf daily files

  file:    by_date/etf_daily/2005/2005-10-27.parquet
  size:    15 KB
  rows:    282

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-10-27	SPY	ETF	119.2	119.37	117.93	118.1	66623100.0
2005-10-27	QQQ	ETF	38.78	38.8	38.03	38.03	135443141.0
2005-10-27	IWM	ETF	63.27	63.33	61.94	62.19	27349900.0
2005-10-27	DIA	ETF	103.32	103.42	102.2	102.34	5411400.0
2005-10-27	GLD	ETF	47.4	47.42	47.1	47.18	2464500.0
2005-10-27	TLT	ETF	89.6	89.79	89.3	89.6	1197400.0
2005-10-27	AAA	ETF	54.85	55.41	54.85	55.41	400.0
2005-10-27	ADRE	ETF	100.32	101.03	99.206	99.206	10484.0
2005-10-27	AFK	ETF	25.45	25.54	25.36	25.37	3400.0
2005-10-27	AGG	ETF	100.39	100.45	100.04	100.38	73100.0
2005-10-27	AIQ	ETF	34.75	35.2	33.3	34.25	17260.0
2005-10-27	AIS	ETF	1.19	1.2	1.1	1.11	120800.0
2005-10-27	ARB	ETF	37.73	37.79	37.12	37.41	108500.0
2005-10-27	BAB	ETF	52.05	52.08	51.14	51.28	15900.0
2005-10-27	BBC	ETF	6.85	7.05	6.6	6.7	28600.0
2005-10-27	BBH	ETF	62.5833	63.81	62.3633	62.3633	2913000.0
2005-10-27	BCM	ETF	60.77	61.29	60.76	60.95	20500.0
2005-10-27	BIS	ETF	620.8	620.8	620.8	620.8	62.5
2005-10-27	BITS	ETF	10.52	10.96	10.48	10.8	6988.0
2005-10-27	BKF	ETF	16.8	17.2	16.25	16.4	119800.0
2005-10-27	BNE	ETF	13.45	13.76	13.07	13.27	147100.0
2005-10-27	BRF	ETF	15.25	15.3	15.22	15.26	7700.0
2005-10-27	BTF	ETF	84.0	84.3	83.39999999999999	83.6	2420.0
2005-10-27	CBON	ETF	32.5	32.69	32.25	32.29	12048.0
2005-10-27	CDL	ETF	13.5	13.59	13.4	13.41	255200.0
2005-10-27	CEF	ETF	5.84	5.89	5.82	5.85	577400.0
2005-10-27	CEW	ETF	25.8	25.8	25.8	25.8	400.0
2005-10-27	CGO	ETF	15.0	15.01	15.0	15.0	380700.0
2005-10-27	CHB	ETF	13.4	13.4	12.9	12.95	662800.0
2005-10-27	CHI	ETF	19.8	19.92	19.758	19.83	69100.0
2005-10-27	CHIC	ETF	17.11	17.14	15.99	16.5	248302.0
2005-10-27	CHIR	ETF	43.3299	44.7099	42.6099	42.66	4230863.0
2005-10-27	CHY	ETF	15.8	15.82	15.67	15.68	66300.0
2005-10-27	CIL	ETF	25.88	26.0	25.87	26.0	1400.0
2005-10-27	CN	ETF	29.55	29.71	29.5	29.67	61700.0
2005-10-27	CNXT	ETF	1.79	1.81	1.76	1.78	7179392.0
2005-10-27	COMB	ETF	8.25	8.25	8.25	8.25	2000.0
2005-10-27	CPST	ETF	2.45	2.55	2.3	2.32	2770697.0
2005-10-27	CSA	ETF	17.0	17.1	16.75	17.0	1854400.0
2005-10-27	CSB	ETF	28.73	28.73	28.38	28.4	8000.0
2005-10-27	CSQ	ETF	13.38	13.47	13.25	13.46	298100.0
2005-10-27	CTEC	ETF	48.550000000000004	48.65	47.05	47.15	2935.0
2005-10-27	CURE	ETF	0.0912	0.1025	0.09	0.0975	4699320.0
2005-10-27	CYB	ETF	3.38	3.38	3.33	3.33	1600.0
2005-10-27	DGT	ETF	63.08	63.09	62.69	62.73	2200.0
2005-10-27	DIG	ETF	13.95	13.95	13.65	13.65	12000.0
2005-10-27	DIV	ETF	11.91	12.0	11.91	12.0	8900.0
2005-10-27	DRIV	ETF	29.96	29.989	26.15	27.71	14060027.0
2005-10-27	DSI	ETF	5.735	5.735	5.715	5.715	2800.0
2005-10-27	DUSA	ETF	9.1	9.25	8.71	8.75	101867.0

> showing 50 of 282 rows — these rows as CSV

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