PREVIEW / etf_daily / 2005-09-27

all etf daily files

  file:    by_date/etf_daily/2005/2005-09-27.parquet
  size:    15 KB
  rows:    281

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-09-27	SPY	ETF	121.52	121.99	121.02	121.55	66150800.0
2005-09-27	QQQ	ETF	38.8	38.9	38.51	38.67	64094331.0
2005-09-27	IWM	ETF	65.52	65.85	64.96	65.4	27076800.0
2005-09-27	DIA	ETF	104.37	104.9	104.07	104.53	8162900.0
2005-09-27	GLD	ETF	46.14	46.33	45.66	46.25	2341300.0
2005-09-27	TLT	ETF	92.27	92.56	91.94	92.32	827800.0
2005-09-27	AAA	ETF	55.37	55.79	55.37	55.65	1700.0
2005-09-27	ADRE	ETF	107.5	107.5	105.9601	106.44	16864.0
2005-09-27	AFK	ETF	25.45	25.53	25.45	25.53	8200.0
2005-09-27	AGG	ETF	101.68	101.79	101.3	101.55	297900.0
2005-09-27	AIQ	ETF	42.6	43.35	42.05	43.1	18900.0
2005-09-27	AIS	ETF	0.97	0.98	0.91	0.93	112700.0
2005-09-27	ARB	ETF	39.77	40.16	39.44	39.85	68500.0
2005-09-27	BAB	ETF	50.25	50.56	50.13	50.54	23800.0
2005-09-27	BBC	ETF	7.53	7.58	7.42	7.5	16400.0
2005-09-27	BBH	ETF	63.1167	63.3767	61.6667	61.6667	2804100.0
2005-09-27	BCM	ETF	61.98	62.67	61.97	62.57	53100.0
2005-09-27	BIS	ETF	635.2	635.2	635.2	635.2	1.25
2005-09-27	BITS	ETF	11.0	11.544	10.64	11.0	4232.0
2005-09-27	BKF	ETF	31.85	32.41	31.85	32.05	13400.0
2005-09-27	BNE	ETF	14.03	14.21	14.0	14.07	129000.0
2005-09-27	BRF	ETF	15.26	15.36	15.26	15.28	3100.0
2005-09-27	BTF	ETF	85.8	85.8	85.39999999999999	85.6	1440.0
2005-09-27	CBON	ETF	32.5	32.9	32.25	32.5	48634.0
2005-09-27	CDC	ETF	4.0	4.2	4.0	4.08	2300.0
2005-09-27	CDL	ETF	13.58	13.74	13.33	13.6	217200.0
2005-09-27	CEF	ETF	5.59	5.62	5.53	5.58	433100.0
2005-09-27	CEW	ETF	26.09	26.09	26.0	26.0	1500.0
2005-09-27	CHB	ETF	14.35	14.35	13.6	14.16	713000.0
2005-09-27	CHI	ETF	20.1	20.1	19.82	19.86	123800.0
2005-09-27	CHIC	ETF	14.15	14.17	13.87	14.05	136871.0
2005-09-27	CHIR	ETF	43.4499	43.5801	43.2999	43.3401	1327600.0
2005-09-27	CHY	ETF	16.3	16.33	16.1	16.21	153800.0
2005-09-27	CIL	ETF	25.96	25.96	25.96	25.96	1400.0
2005-09-27	CN	ETF	33.8	34.09	33.25	33.5	39900.0
2005-09-27	CNXT	ETF	1.85	1.8802	1.8	1.88	8575862.0
2005-09-27	CPI	ETF	24.0	24.0	23.8	23.85	2200.0
2005-09-27	CPST	ETF	4.06	4.11	3.7	3.74	8618367.0
2005-09-27	CSB	ETF	28.91	29.0	28.72	28.86	17600.0
2005-09-27	CSQ	ETF	13.74	13.75	13.41	13.47	645600.0
2005-09-27	CTEC	ETF	49.599999999999994	50.3	49.55	50.0	6559.400000000001
2005-09-27	CURE	ETF	0.1938	0.2025	0.1887	0.1913	618048.0
2005-09-27	CYA	ETF	80.0	82.0	78.0	81.6	1515.0
2005-09-27	CYB	ETF	3.95	3.95	3.9	3.91	6300.0
2005-09-27	DGT	ETF	64.37	64.48	64.36	64.46	1500.0
2005-09-27	DIG	ETF	14.5625	14.5875	14.5625	14.5875	5840.0
2005-09-27	DIV	ETF	13.33	13.37	12.99	13.1	30700.0
2005-09-27	DRIV	ETF	33.89	34.2	33.35	33.97	930974.0
2005-09-27	DSI	ETF	5.64	5.645	5.61	5.645	5400.0
2005-09-27	DUSA	ETF	9.75	10.7	9.75	10.42	256984.0

> showing 50 of 281 rows — these rows as CSV

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