PREVIEW / etf_daily / 2005-09-21

all etf daily files

  file:    by_date/etf_daily/2005/2005-09-21.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-09-21	SPY	ETF	121.79	121.87	120.78	120.91	94469100.0
2005-09-21	QQQ	ETF	38.82	38.87	38.47	38.5	116424060.0
2005-09-21	IWM	ETF	65.53	65.61	64.6	64.6	28527200.0
2005-09-21	DIA	ETF	104.51	104.51	103.62	103.72	10702800.0
2005-09-21	GLD	ETF	46.58	47.13	46.55	47.06	3681900.0
2005-09-21	TLT	ETF	93.28	93.41	93.13	93.4	993000.0
2005-09-21	AAA	ETF	55.75	56.02	55.64	55.68	2900.0
2005-09-21	ADRE	ETF	106.19	109.6	105.24	106.44	16028.0
2005-09-21	AFK	ETF	25.44	25.53	25.44	25.44	6100.0
2005-09-21	AGG	ETF	102.09	102.13	101.77	101.96	233300.0
2005-09-21	AIQ	ETF	42.9	43.2	39.9	40.35	39140.0
2005-09-21	AIS	ETF	0.86	0.88	0.83	0.83	58100.0
2005-09-21	ARB	ETF	40.73	40.73	39.78	39.91	92300.0
2005-09-21	BAB	ETF	52.46	52.67	52.06	52.07	24600.0
2005-09-21	BBC	ETF	7.75	7.87	7.6	7.67	32400.0
2005-09-21	BBH	ETF	66.15	66.15	65.0033	65.0233	1294200.0
2005-09-21	BCM	ETF	63.05	63.22	62.79	62.86	22900.0
2005-09-21	BIS	ETF	651.2	651.2	649.6	651.2	36.25
2005-09-21	BITS	ETF	12.004	12.252	11.72	11.92	3062.0
2005-09-21	BKF	ETF	30.75	31.95	30.71	31.36	64600.0
2005-09-21	BNE	ETF	14.0	14.07	13.94	13.94	147900.0
2005-09-21	BOSS	ETF	27.3	27.66	27.3	27.66	100.0
2005-09-21	BRF	ETF	15.35	15.44	15.32	15.44	10100.0
2005-09-21	BTF	ETF	86.05	86.19999999999999	85.5	85.74999999999999	3080.0
2005-09-21	CBON	ETF	32.5	32.65	32.28	32.54	16609.0
2005-09-21	CDC	ETF	3.36	3.5	3.35	3.49	5300.0
2005-09-21	CDL	ETF	13.25	13.36	12.95	13.15	290700.0
2005-09-21	CEF	ETF	5.5	5.64	5.49	5.63	755800.0
2005-09-21	CHB	ETF	13.37	14.27	13.2	14.26	1714800.0
2005-09-21	CHI	ETF	20.16	20.35	20.09	20.3	112000.0
2005-09-21	CHIC	ETF	14.2	14.2	13.48	13.55	488421.0
2005-09-21	CHIR	ETF	43.5201	43.7799	43.38	43.5	1894825.0
2005-09-21	CHY	ETF	16.39	16.39	16.23	16.32	112800.0
2005-09-21	CN	ETF	35.26	35.26	35.01	35.02	57800.0
2005-09-21	CNXT	ETF	1.88	1.89	1.8	1.86	16530910.0
2005-09-21	COMB	ETF	8.1	8.25	7.75	8.05	2200.0
2005-09-21	CPST	ETF	4.55	4.55	4.35	4.39	6016092.0
2005-09-21	CSB	ETF	29.95	29.95	29.62	29.78	4800.0
2005-09-21	CSM	ETF	2.425	2.425	2.425	2.425	2800.0
2005-09-21	CSQ	ETF	13.87	13.88	13.74	13.79	504800.0
2005-09-21	CTEC	ETF	54.74999999999999	54.800000000000004	53.49999999999999	53.550000000000004	3681.8
2005-09-21	CURE	ETF	0.2325	0.24	0.2238	0.2239	950064.0
2005-09-21	CYA	ETF	58.2	63.0	57.0	58.2	605.0
2005-09-21	CYB	ETF	4.05	4.09	3.95	4.04	17000.0
2005-09-21	DGT	ETF	64.75	64.99	64.62	64.7	4300.0
2005-09-21	DIG	ETF	14.1625	14.3875	14.1625	14.3875	1600.0
2005-09-21	DIV	ETF	13.42	13.52	13.3	13.37	26200.0
2005-09-21	DRIV	ETF	36.66	36.66	34.86	34.99	1065965.0
2005-09-21	DSI	ETF	5.64	5.64	5.61	5.61	5000.0
2005-09-21	DUSA	ETF	9.61	9.89	9.4	9.52	83520.0

> showing 50 of 278 rows — these rows as CSV

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