PREVIEW / etf_daily / 2005-11-22

all etf daily files

  file:    by_date/etf_daily/2005/2005-11-22.parquet
  size:    16 KB
  rows:    293

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-22	SPY	ETF	125.56	126.52	125.42	126.3	66438800.0
2005-11-22	QQQ	ETF	41.46	41.87	41.36	41.7	88819199.0
2005-11-22	IWM	ETF	67.46	68.11	67.29	67.93	21208700.0
2005-11-22	DIA	ETF	107.98	108.74	107.84	108.64	7228500.0
2005-11-22	GLD	ETF	49.02	49.34	48.85	49.32	2799500.0
2005-11-22	TLT	ETF	90.37	90.67	90.35	90.53	1026900.0
2005-11-22	AAA	ETF	52.27	53.02	52.25	53.02	2700.0
2005-11-22	ADRE	ETF	110.99	110.99	108.75	110.8499	21552.0
2005-11-22	AFK	ETF	25.36	25.43	25.35	25.35	6100.0
2005-11-22	AGG	ETF	100.49	100.74	100.3	100.69	202700.0
2005-11-22	AIQ	ETF	28.3	28.3	27.3	27.85	11360.0
2005-11-22	AIS	ETF	1.17	1.26	1.14	1.17	213400.0
2005-11-22	AOM	ETF	3.52	3.52	3.44	3.51	15700.0
2005-11-22	ARB	ETF	39.0	39.25	38.78	39.01	97400.0
2005-11-22	BAB	ETF	53.55	53.55	52.28	52.89	29000.0
2005-11-22	BBC	ETF	9.94	10.0	8.77	9.15	398200.0
2005-11-22	BBH	ETF	70.6533	70.75	70.1167	70.47	1087800.0
2005-11-22	BCM	ETF	63.76	64.29	63.67	64.2	22500.0
2005-11-22	BITS	ETF	14.0	14.28	13.6	14.08	6411.0
2005-11-22	BKF	ETF	21.39	21.39	20.98	21.09	151000.0
2005-11-22	BNE	ETF	15.28	15.62	15.28	15.51	126800.0
2005-11-22	BRF	ETF	15.15	15.21	15.15	15.2	8700.0
2005-11-22	BTF	ETF	88.0	88.0	87.6	87.89999999999999	1240.0
2005-11-22	CBON	ETF	33.1	33.1	33.0	33.07	1100.0
2005-11-22	CDL	ETF	13.53	13.89	13.465	13.8	777600.0
2005-11-22	CEF	ETF	6.08	6.12	6.03	6.12	348400.0
2005-11-22	CEW	ETF	25.9	25.9	25.9	25.9	200.0
2005-11-22	CGO	ETF	14.94	15.0	13.77	13.85	87700.0
2005-11-22	CHB	ETF	14.93	15.2	14.64	15.16	649800.0
2005-11-22	CHI	ETF	19.92	20.06	19.9	19.98	76400.0
2005-11-22	CHIC	ETF	17.23	17.69	17.02	17.68	176248.0
2005-11-22	CHIR	ETF	44.3301	44.3799	44.2599	44.3499	1176371.0
2005-11-22	CHY	ETF	15.61	15.67	15.53	15.56	105900.0
2005-11-22	CIL	ETF	25.99	26.1	25.99	26.05	2900.0
2005-11-22	CN	ETF	33.7	33.7	33.31	33.35	10600.0
2005-11-22	CNXT	ETF	2.37	2.5	2.35	2.43	16824276.0
2005-11-22	COMB	ETF	8.25	8.65	8.25	8.65	17800.0
2005-11-22	CPI	ETF	25.65	25.65	25.5	25.5	200.0
2005-11-22	CPST	ETF	3.89	3.93	3.75	3.77	4942157.0
2005-11-22	CSA	ETF	16.8	17.0	16.8	17.0	22000.0
2005-11-22	CSB	ETF	28.35	28.74	28.2	28.54	10700.0
2005-11-22	CSM	ETF	2.435	2.435	2.435	2.435	18000.0
2005-11-22	CSQ	ETF	13.2	13.2	13.03	13.12	459400.0
2005-11-22	CTEC	ETF	43.25	44.599999999999994	42.949999999999996	44.24999999999999	24561.600000000002
2005-11-22	CURE	ETF	0.0625	0.0737	0.0625	0.0712	2422088.0
2005-11-22	CYB	ETF	3.55	3.65	3.55	3.65	3600.0
2005-11-22	DGT	ETF	65.2	65.67	65.2	65.67	3800.0
2005-11-22	DIG	ETF	14.9875	15.25	14.9875	15.25	10400.0
2005-11-22	DIV	ETF	11.88	12.0	11.88	11.94	32300.0
2005-11-22	DRIV	ETF	27.09	27.68	26.8	27.28	1092759.0

> showing 50 of 293 rows — these rows as CSV

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