PREVIEW / etf_daily / 2005-09-06

all etf daily files

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

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-06	SPY	ETF	122.66	123.8	122.65	123.7	57251300.0
2005-09-06	QQQ	ETF	38.93	39.41	38.9	39.34	78129723.0
2005-09-06	IWM	ETF	66.37	67.19	66.27	67.16	26684300.0
2005-09-06	DIA	ETF	104.98	105.93	104.92	105.83	10767100.0
2005-09-06	GLD	ETF	44.42	44.42	44.19	44.27	819700.0
2005-09-06	TLT	ETF	95.01	95.17	94.48	94.49	965300.0
2005-09-06	AAA	ETF	58.81	59.05	58.66	58.85	3400.0
2005-09-06	ADRE	ETF	103.27	103.27	102.11	102.98	12164.0
2005-09-06	AFK	ETF	25.9	25.94	25.76	25.8	2400.0
2005-09-06	AGG	ETF	102.55	102.62	102.18	102.4	121300.0
2005-09-06	AIQ	ETF	45.35	45.5	44.55	44.55	38460.0
2005-09-06	AIS	ETF	0.92	0.94	0.9	0.93	182900.0
2005-09-06	ARB	ETF	41.62	42.76	41.62	42.7	156000.0
2005-09-06	BAB	ETF	51.68	51.78	51.48	51.78	14100.0
2005-09-06	BBC	ETF	6.85	7.05	6.85	7.05	231400.0
2005-09-06	BBH	ETF	65.53	66.7867	65.53	66.6667	1381500.0
2005-09-06	BCM	ETF	59.64	60.12	59.36	59.81	194400.0
2005-09-06	BIS	ETF	686.4	696.0	686.4	691.2	96.0
2005-09-06	BITS	ETF	11.28	12.0	11.28	11.88	3102.0
2005-09-06	BKF	ETF	32.4	32.9	32.2	32.49	46300.0
2005-09-06	BNE	ETF	14.53	14.96	14.53	14.86	96300.0
2005-09-06	BRF	ETF	15.5	15.51	15.48	15.51	8200.0
2005-09-06	BTF	ETF	84.64999999999999	85.85000000000001	84.64999999999999	85.85000000000001	3740.0
2005-09-06	CBON	ETF	34.52	34.75	33.77	34.27	9132.0
2005-09-06	CDC	ETF	3.2	3.2	3.1	3.2	3900.0
2005-09-06	CDL	ETF	13.25	13.25	13.04	13.17	377500.0
2005-09-06	CEF	ETF	5.47	5.47	5.4	5.4	295000.0
2005-09-06	CEW	ETF	25.85	25.85	25.85	25.85	100.0
2005-09-06	CHB	ETF	13.32	13.4	12.89	13.08	1438900.0
2005-09-06	CHI	ETF	20.55	20.64	20.44	20.56	63500.0
2005-09-06	CHIC	ETF	13.74	14.23	13.74	14.0	300984.0
2005-09-06	CHIR	ETF	43.2501	43.611	43.1499	43.5099	2619243.0
2005-09-06	CHY	ETF	16.55	16.68	16.55	16.62	74900.0
2005-09-06	CIL	ETF	25.89	25.89	25.89	25.89	100.0
2005-09-06	CIZ	ETF	22.75	22.75	22.75	22.75	200.0
2005-09-06	CN	ETF	33.7	33.91	33.6	33.9	7700.0
2005-09-06	CNXT	ETF	1.65	1.72	1.64	1.72	6839162.0
2005-09-06	CPI	ETF	23.5	23.8	23.5	23.65	1100.0
2005-09-06	CPST	ETF	4.94	5.21	4.85	5.02	10602267.0
2005-09-06	CSB	ETF	31.62	31.9	31.51	31.69	13400.0
2005-09-06	CSM	ETF	2.42	2.4425	2.42	2.435	50400.0
2005-09-06	CSQ	ETF	14.19	14.4	14.15	14.38	271900.0
2005-09-06	CTEC	ETF	50.55	50.55	47.599999999999994	49.1	9946.6
2005-09-06	CURE	ETF	0.2775	0.2775	0.2687	0.27	273040.0
2005-09-06	CYA	ETF	61.6	62.8	56.0	61.84	905.0
2005-09-06	CYB	ETF	3.66	3.66	3.6	3.6	2600.0
2005-09-06	DGT	ETF	65.0	65.43	65.0	65.37	3300.0
2005-09-06	DIV	ETF	13.6	13.84	13.6	13.84	24300.0
2005-09-06	DRIV	ETF	38.61	39.4	38.22	39.3	397086.0
2005-09-06	DSI	ETF	5.74	5.775	5.74	5.775	1800.0

> showing 50 of 279 rows — these rows as CSV

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