PREVIEW / etf_daily / 2005-07-27

all etf daily files

  file:    by_date/etf_daily/2005/2005-07-27.parquet
  size:    15 KB
  rows:    277

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-07-27	SPY	ETF	123.5	123.89	123.05	123.79	43181600.0
2005-07-27	QQQ	ETF	39.43	39.76	39.226	39.72	83631468.0
2005-07-27	IWM	ETF	67.25	67.32	66.45	67.27	24091600.0
2005-07-27	DIA	ETF	106.09	106.46	105.74	106.35	7002400.0
2005-07-27	GLD	ETF	42.3	42.5	42.3	42.44	1560600.0
2005-07-27	TLT	ETF	93.07	93.27	93.01	93.21	593300.0
2005-07-27	AAA	ETF	51.6	52.65	51.6	52.0	17600.0
2005-07-27	ADRE	ETF	94.2	95.32	93.9	95.3	6444.0
2005-07-27	AFK	ETF	25.71	25.88	25.68	25.88	2700.0
2005-07-27	AGG	ETF	101.91	102.08	101.9	102.0	73000.0
2005-07-27	AIQ	ETF	50.8	51.25	50.15	50.75	16220.0
2005-07-27	AIS	ETF	1.08	1.12	1.07	1.09	50700.0
2005-07-27	ARB	ETF	42.06	42.6	41.77	42.58	317900.0
2005-07-27	BAB	ETF	48.74	49.39	48.6	49.28	30100.0
2005-07-27	BBH	ETF	63.65	64.1933	63.3333	64.0867	1726200.0
2005-07-27	BCM	ETF	64.13	65.76	64.13	65.24	189300.0
2005-07-27	BIS	ETF	678.4	678.4	678.4	678.4	6.25
2005-07-27	BITS	ETF	12.76	13.36	12.32	13.36	16713.0
2005-07-27	BKF	ETF	34.35	34.67	34.2	34.25	11200.0
2005-07-27	BNE	ETF	14.1	14.17	14.02	14.02	154200.0
2005-07-27	BRF	ETF	15.4	15.6	15.35	15.59	11300.0
2005-07-27	BTF	ETF	87.55	87.75	87.5	87.65	4060.0
2005-07-27	CBON	ETF	33.34	33.35	33.16	33.17	13602.0
2005-07-27	CDC	ETF	6.55	6.55	5.94	6.0	28300.0
2005-07-27	CDL	ETF	12.5	12.66	12.34	12.52	1189300.0
2005-07-27	CEF	ETF	5.25	5.25	5.16	5.19	237600.0
2005-07-27	CEW	ETF	26.75	26.75	26.7	26.7	1000.0
2005-07-27	CHB	ETF	12.05	12.37	12.0	12.35	346400.0
2005-07-27	CHI	ETF	20.03	20.09	20.0	20.09	83500.0
2005-07-27	CHIC	ETF	14.69	14.92	14.69	14.82	444547.0
2005-07-27	CHIR	ETF	36.39	36.39	35.4099	36.0801	1301251.0
2005-07-27	CHY	ETF	16.47	16.53	16.4	16.52	110000.0
2005-07-27	CIL	ETF	25.78	25.8	25.78	25.8	1700.0
2005-07-27	CN	ETF	30.7	30.94	30.6	30.94	27400.0
2005-07-27	CNXT	ETF	1.88	1.9	1.77	1.89	10285243.0
2005-07-27	CPST	ETF	1.88	1.88	1.81	1.84	462897.0
2005-07-27	CSB	ETF	29.25	29.6	29.2	29.41	8900.0
2005-07-27	CSM	ETF	2.42	2.42	2.42	2.42	2800.0
2005-07-27	CSQ	ETF	14.3	14.41	14.24	14.4	388600.0
2005-07-27	CTEC	ETF	54.65	58.05	54.5	56.449999999999996	85515.40000000001
2005-07-27	CURE	ETF	0.3	0.325	0.3	0.3025	1186064.0
2005-07-27	CYA	ETF	128.4	128.4	114.0	120.0	1240.0
2005-07-27	CYB	ETF	2.99	3.51	2.99	3.43	118300.0
2005-07-27	DGT	ETF	63.75	64.17	63.75	64.17	4900.0
2005-07-27	DIG	ETF	12.3125	12.4375	12.3125	12.375	1200.0
2005-07-27	DIV	ETF	13.75	13.8	13.71	13.8	20300.0
2005-07-27	DRIV	ETF	36.33	36.48	35.05	35.49	2255210.0
2005-07-27	DSI	ETF	5.8	5.8	5.8	5.8	1400.0
2005-07-27	DUSA	ETF	9.14	9.18	9.06	9.16	100821.0
2005-07-27	DVY	ETF	63.95	64.15	63.78	64.02	335400.0

> showing 50 of 277 rows — these rows as CSV

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