PREVIEW / etf_daily / 2005-09-09

all etf daily files

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

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-09	SPY	ETF	123.83	124.74	123.8	124.6	43093900.0
2005-09-09	QQQ	ETF	39.41	39.69	39.31	39.619	75389962.0
2005-09-09	IWM	ETF	67.22	67.58	67.05	67.39	23016100.0
2005-09-09	DIA	ETF	106.14	106.93	106.06	106.76	7449900.0
2005-09-09	GLD	ETF	44.67	44.87	44.66	44.84	1393900.0
2005-09-09	TLT	ETF	93.96	94.32	93.88	94.0	426300.0
2005-09-09	AAA	ETF	58.09	58.22	57.93	58.0	365600.0
2005-09-09	ADRE	ETF	103.0	104.137	103.0	104.09	12956.0
2005-09-09	AFK	ETF	25.9	25.95	25.85	25.88	17900.0
2005-09-09	AGG	ETF	102.13	102.39	102.01	102.19	234600.0
2005-09-09	AIQ	ETF	43.8	44.5	43.75	44.4	16060.0
2005-09-09	AIS	ETF	0.89	0.91	0.83	0.88	64100.0
2005-09-09	ARB	ETF	42.0	42.09	41.56	42.08	125500.0
2005-09-09	BAB	ETF	52.96	53.3	52.86	53.02	11100.0
2005-09-09	BBC	ETF	7.0	7.01	6.76	6.9	23600.0
2005-09-09	BBH	ETF	65.96	66.8333	65.91	66.6667	1671300.0
2005-09-09	BCM	ETF	60.45	61.19	60.45	60.91	271100.0
2005-09-09	BIS	ETF	689.6	694.4	688.0	688.0	58.0
2005-09-09	BITS	ETF	12.4	12.4	12.12	12.16	5994.0
2005-09-09	BKF	ETF	32.95	33.2	32.82	32.92	18300.0
2005-09-09	BNE	ETF	14.61	14.67	14.4	14.44	84100.0
2005-09-09	BRF	ETF	15.5	15.57	15.5	15.54	2200.0
2005-09-09	BTF	ETF	85.74999999999999	86.25	85.74999999999999	86.25	2740.0
2005-09-09	CBON	ETF	32.47	32.75	32.47	32.5	10590.0
2005-09-09	CDC	ETF	3.5	3.65	3.5	3.61	4800.0
2005-09-09	CDL	ETF	13.06	13.14	12.99	13.14	99500.0
2005-09-09	CEF	ETF	5.39	5.44	5.25	5.25	496700.0
2005-09-09	CEW	ETF	25.76	26.0	25.76	26.0	1100.0
2005-09-09	CHB	ETF	13.05	13.28	13.03	13.28	637000.0
2005-09-09	CHI	ETF	20.61	20.72	20.57	20.62	61800.0
2005-09-09	CHIC	ETF	14.66	15.17	14.62	14.81	578793.0
2005-09-09	CHIR	ETF	44.0001	44.1201	43.7901	43.9101	1808955.0
2005-09-09	CHY	ETF	16.69	16.78	16.65	16.74	86100.0
2005-09-09	CIL	ETF	25.91	26.0	25.91	26.0	1000.0
2005-09-09	CN	ETF	33.5	33.65	33.43	33.48	32100.0
2005-09-09	CNXT	ETF	1.69	1.71	1.66	1.69	3640260.0
2005-09-09	CPST	ETF	4.97	5.89	4.9	5.58	26611686.0
2005-09-09	CSB	ETF	31.6	31.67	31.48	31.51	9600.0
2005-09-09	CSQ	ETF	14.4	14.5	14.36	14.49	322200.0
2005-09-09	CTEC	ETF	49.05	52.37	49.05	52.05	9577.6
2005-09-09	CURE	ETF	0.2812	0.285	0.2662	0.2675	375776.0
2005-09-09	CYA	ETF	63.8	70.0	63.8	68.0	1085.0
2005-09-09	CYB	ETF	3.61	3.82	3.61	3.82	6700.0
2005-09-09	DGT	ETF	65.7	66.0	65.7	65.91	3600.0
2005-09-09	DIG	ETF	13.625	13.7375	13.5875	13.5875	4160.0
2005-09-09	DIV	ETF	13.75	13.8	13.65	13.67	9400.0
2005-09-09	DRIV	ETF	39.82	39.82	37.63	38.37	958459.0
2005-09-09	DSI	ETF	5.78	5.785	5.75	5.775	11000.0
2005-09-09	DUSA	ETF	10.3	10.44	9.85	9.87	134629.0
2005-09-09	DVY	ETF	63.68	64.0	63.52	63.98	304900.0

> showing 50 of 276 rows — these rows as CSV

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