PREVIEW / etf_daily / 2005-11-07

all etf daily files

  file:    by_date/etf_daily/2005/2005-11-07.parquet
  size:    15 KB
  rows:    286

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-11-07	SPY	ETF	122.37	122.62	121.85	122.23	46765400.0
2005-11-07	QQQ	ETF	40.2	40.29	39.95	40.13	65366511.0
2005-11-07	IWM	ETF	65.73	66.05	65.26	65.72	20776800.0
2005-11-07	DIA	ETF	105.49	105.87	105.17	105.61	3314800.0
2005-11-07	GLD	ETF	45.67	45.82	45.46	45.77	816600.0
2005-11-07	TLT	ETF	88.5	88.57	88.35	88.42	1121600.0
2005-11-07	AAA	ETF	55.4	55.58	55.35	55.58	2200.0
2005-11-07	ADRE	ETF	106.8	106.8	105.0	105.57	33384.0
2005-11-07	AFK	ETF	25.38	25.46	25.38	25.39	7300.0
2005-11-07	AGG	ETF	99.69	99.74	99.35	99.56	128300.0
2005-11-07	AIQ	ETF	31.05	31.55	30.0	30.9	34580.0
2005-11-07	AIS	ETF	1.19	1.2	1.16	1.19	143700.0
2005-11-07	AOM	ETF	3.46	3.46	3.45	3.45	1600.0
2005-11-07	ARB	ETF	37.69	37.8	37.11	37.26	153100.0
2005-11-07	BAB	ETF	53.74	54.54	53.71	54.44	16500.0
2005-11-07	BBC	ETF	7.0	7.05	6.9	6.9	78600.0
2005-11-07	BBH	ETF	67.0667	67.1933	66.36	66.7	1259400.0
2005-11-07	BCM	ETF	62.1	62.51	61.99	62.43	16500.0
2005-11-07	BITS	ETF	12.0	12.0	11.0	11.56	12994.0
2005-11-07	BKF	ETF	20.15	21.08	20.1	20.2	142300.0
2005-11-07	BNE	ETF	14.98	15.2	14.87	15.1	204300.0
2005-11-07	BRF	ETF	15.23	15.35	15.21	15.34	14100.0
2005-11-07	BTF	ETF	85.99999999999999	87.35	85.89999999999999	86.54999999999998	15020.0
2005-11-07	CBON	ETF	32.84	33.15	32.37	33.14	2450.0
2005-11-07	CDL	ETF	13.91	14.03	13.85	13.99	335100.0
2005-11-07	CEF	ETF	5.62	5.68	5.62	5.68	193600.0
2005-11-07	CEW	ETF	25.85	26.0	25.85	26.0	1100.0
2005-11-07	CGO	ETF	15.0	15.01	15.0	15.0	37100.0
2005-11-07	CHB	ETF	14.49	14.69	14.26	14.69	345500.0
2005-11-07	CHI	ETF	20.31	20.39	20.18	20.32	103400.0
2005-11-07	CHIC	ETF	17.05	17.5	16.87	17.32	601942.0
2005-11-07	CHIR	ETF	44.2101	44.22	44.16	44.19	1717283.0
2005-11-07	CHY	ETF	15.8	15.99	15.74	15.96	113100.0
2005-11-07	CIZ	ETF	21.3	21.3	21.3	21.3	200.0
2005-11-07	CN	ETF	33.52	33.63	33.5	33.62	150800.0
2005-11-07	CNXT	ETF	2.34	2.37	2.22	2.22	18751159.0
2005-11-07	COMB	ETF	8.5	8.573	8.5	8.573	1885.0
2005-11-07	CPI	ETF	24.34	24.34	24.2	24.2	400.0
2005-11-07	CPST	ETF	2.8	2.84	2.65	2.68	2181710.0
2005-11-07	CSA	ETF	17.25	17.3	17.11	17.17	32000.0
2005-11-07	CSB	ETF	28.6	28.89	28.51	28.71	11500.0
2005-11-07	CSM	ETF	2.4325	2.4325	2.4325	2.4325	18800.0
2005-11-07	CSQ	ETF	13.36	13.44	13.32	13.37	285500.0
2005-11-07	CTEC	ETF	42.99999999999999	42.99999999999999	41.449999999999996	41.95	18205.0
2005-11-07	CURE	ETF	0.0675	0.0838	0.0675	0.0788	1973928.0
2005-11-07	CYB	ETF	3.24	3.26	3.24	3.25	6700.0
2005-11-07	DGT	ETF	64.27	64.42	64.12	64.36	3300.0
2005-11-07	DIV	ETF	12.06	12.19	12.06	12.17	18600.0
2005-11-07	DRIV	ETF	27.6	27.86	27.5	27.63	630650.0
2005-11-07	DUSA	ETF	9.63	9.96	9.629	9.91	161721.0

> showing 50 of 286 rows — these rows as CSV

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