PREVIEW / etf_daily / 2005-06-29

all etf daily files

  file:    by_date/etf_daily/2005/2005-06-29.parquet
  size:    15 KB
  rows:    278

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-29	SPY	ETF	120.37	120.4	119.76	119.83	42316500.0
2005-06-29	QQQ	ETF	37.25	37.26	36.97	37.068	71580396.0
2005-06-29	IWM	ETF	63.86	64.06	63.63	63.84	17068800.0
2005-06-29	DIA	ETF	104.23	104.25	103.55	103.6	5145900.0
2005-06-29	GLD	ETF	43.49	43.7	43.46	43.63	1199800.0
2005-06-29	TLT	ETF	96.47	96.48	95.6	95.84	1682400.0
2005-06-29	AAA	ETF	56.8	57.31	56.8	57.28	36000.0
2005-06-29	ADRE	ETF	91.7	91.7	91.28	91.64	3996.0
2005-06-29	AFK	ETF	26.25	26.34	25.98	26.33	7400.0
2005-06-29	AGG	ETF	103.34	103.34	102.89	103.05	166800.0
2005-06-29	AIQ	ETF	53.6	53.75	52.0	52.25	39840.0
2005-06-29	AIS	ETF	1.03	1.09	0.98	1.03	145400.0
2005-06-29	ARB	ETF	42.73	43.23	42.66	42.95	164300.0
2005-06-29	BAB	ETF	48.29	48.56	48.21	48.32	32900.0
2005-06-29	BBH	ETF	56.5833	56.5833	55.9833	56.0	1044000.0
2005-06-29	BCM	ETF	62.5	62.83	62.18	62.45	17500.0
2005-06-29	BIS	ETF	614.4	625.6	614.4	625.6	8.75
2005-06-29	BITS	ETF	13.0	14.8	13.0	14.36	47200.0
2005-06-29	BKF	ETF	37.6	37.9	37.3	37.89	7600.0
2005-06-29	BNE	ETF	15.04	15.05	14.59	14.67	749000.0
2005-06-29	BRF	ETF	15.45	15.46	15.42	15.43	6600.0
2005-06-29	BTF	ETF	85.8	85.8	85.19999999999999	85.64999999999999	1660.0
2005-06-29	CBON	ETF	31.7	31.72	30.28	31.37	46040.0
2005-06-29	CDC	ETF	6.75	7.0	6.75	7.0	6900.0
2005-06-29	CDL	ETF	12.08	12.24	12.06	12.17	171000.0
2005-06-29	CEF	ETF	5.31	5.35	5.29	5.35	168800.0
2005-06-29	CEW	ETF	26.65	26.65	26.65	26.65	100.0
2005-06-29	CHB	ETF	10.0	10.0	9.88	9.98	93000.0
2005-06-29	CHI	ETF	19.43	19.43	19.35	19.42	63700.0
2005-06-29	CHIC	ETF	12.39	12.87	12.31	12.72	143634.0
2005-06-29	CHIR	ETF	35.5899	35.5899	34.9899	35.1099	715239.0
2005-06-29	CHY	ETF	16.34	16.38	16.29	16.35	110300.0
2005-06-29	CIL	ETF	25.72	25.74	25.72	25.74	200.0
2005-06-29	CIZ	ETF	22.25	22.25	22.25	22.25	200.0
2005-06-29	CN	ETF	28.72	28.72	28.32	28.57	16700.0
2005-06-29	CNXT	ETF	1.51	1.5501	1.5	1.53	3281549.0
2005-06-29	CPI	ETF	23.55	23.55	23.55	23.55	1200.0
2005-06-29	CPST	ETF	1.33	1.33	1.26	1.33	510220.0
2005-06-29	CSB	ETF	29.38	29.64	29.15	29.58	13100.0
2005-06-29	CSM	ETF	2.4025	2.4025	2.4025	2.4025	20000.0
2005-06-29	CSQ	ETF	13.91	13.97	13.86	13.97	363500.0
2005-06-29	CTEC	ETF	55.35	56.6	54.65	55.99999999999999	7486.6
2005-06-29	CURE	ETF	0.3	0.3063	0.2687	0.2975	1019928.0
2005-06-29	CYA	ETF	137.0	145.0	136.2	142.0	870.0
2005-06-29	CYB	ETF	3.29	3.31	3.158	3.22	8800.0
2005-06-29	DGT	ETF	63.8	63.8	63.49	63.5	18000.0
2005-06-29	DIG	ETF	12.4125	12.5875	12.4125	12.5875	4880.0
2005-06-29	DIV	ETF	13.65	13.76	13.64	13.76	24200.0
2005-06-29	DRIV	ETF	32.89	33.73	32.5	33.0	1483521.0
2005-06-29	DSI	ETF	5.815	5.815	5.815	5.815	1000.0

> showing 50 of 278 rows — these rows as CSV

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