PREVIEW / etf_daily / 2005-12-16

all etf daily files

  file:    by_date/etf_daily/2005/2005-12-16.parquet
  size:    16 KB
  rows:    291

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-12-16	SPY	ETF	127.28	127.36	126.36	126.36	46238300.0
2005-12-16	QQQ	ETF	41.87	41.94	41.549	41.58	63742939.0
2005-12-16	IWM	ETF	68.44	68.55	67.81	67.84	21479900.0
2005-12-16	DIA	ETF	108.98	109.24	108.5	108.51	4573100.0
2005-12-16	GLD	ETF	50.32	50.59	49.93	50.09	2688000.0
2005-12-16	TLT	ETF	90.83	90.93	90.56	90.7	684500.0
2005-12-16	AAA	ETF	55.04	55.26	54.99	55.26	800.0
2005-12-16	ADRE	ETF	115.59	115.59	113.0	113.87	21496.0
2005-12-16	AFK	ETF	25.18	25.4	25.14	25.27	10000.0
2005-12-16	AGG	ETF	100.57	100.58	100.18	100.29	779300.0
2005-12-16	AIQ	ETF	29.0	31.5	28.7	29.95	58280.0
2005-12-16	AIS	ETF	1.41	1.41	1.35	1.36	177900.0
2005-12-16	AOM	ETF	4.0	4.12	4.0	4.0	26400.0
2005-12-16	ARB	ETF	39.14	39.15	38.5	38.5	329200.0
2005-12-16	BAB	ETF	60.49	61.0	60.46	60.71	32600.0
2005-12-16	BBC	ETF	14.45	14.5	13.76	14.1	289600.0
2005-12-16	BBH	ETF	67.5833	67.6667	66.7	66.75	2100000.0
2005-12-16	BCM	ETF	65.3	65.69	65.2	65.43	26200.0
2005-12-16	BITS	ETF	12.92	13.4	12.8	13.32	4538.0
2005-12-16	BKF	ETF	20.02	20.29	20.0	20.15	77900.0
2005-12-16	BNE	ETF	14.61	15.12	14.61	14.85	459400.0
2005-12-16	BRF	ETF	15.1	15.1	15.03	15.03	18000.0
2005-12-16	BTF	ETF	88.1	88.35000000000001	88.1	88.35000000000001	1100.0
2005-12-16	CBON	ETF	32.0	32.13	31.44	32.01	40558.0
2005-12-16	CDL	ETF	13.23	13.23	13.04	13.06	542200.0
2005-12-16	CEF	ETF	6.23	6.32	6.21	6.3	349600.0
2005-12-16	CEW	ETF	26.01	26.01	25.88	25.88	60100.0
2005-12-16	CGO	ETF	13.3	13.37	13.19	13.37	54900.0
2005-12-16	CHB	ETF	14.9	14.99	14.03	14.13	1172300.0
2005-12-16	CHI	ETF	20.12	20.31	20.12	20.14	70700.0
2005-12-16	CHIC	ETF	19.45	20.0	19.44	19.93	301775.0
2005-12-16	CHIR	ETF	44.6601	44.9601	44.6601	44.85	4666940.0
2005-12-16	CHY	ETF	15.84	15.84	15.66	15.66	100100.0
2005-12-16	CIL	ETF	25.23	25.23	25.23	25.23	100.0
2005-12-16	CN	ETF	32.46	32.46	31.8	31.8	69900.0
2005-12-16	CNXT	ETF	2.4	2.45	2.34	2.37	11736738.0
2005-12-16	CPI	ETF	27.5	27.5	27.0	27.4	2100.0
2005-12-16	CPST	ETF	3.28	3.34	3.11	3.15	2972240.0
2005-12-16	CSA	ETF	16.05	16.06	15.86	16.0	81700.0
2005-12-16	CSB	ETF	31.07	31.07	30.8	30.95	32300.0
2005-12-16	CSQ	ETF	12.95	13.06	12.92	12.99	563800.0
2005-12-16	CTEC	ETF	50.49999999999999	50.949999999999996	50.25	50.599999999999994	4188.6
2005-12-16	CURE	ETF	0.0187	0.0362	0.0187	0.0338	36055136.0
2005-12-16	CYB	ETF	3.45	3.5	3.45	3.5	4300.0
2005-12-16	DGT	ETF	65.96	65.96	65.72	65.72	2100.0
2005-12-16	DIG	ETF	15.5375	15.625	15.4875	15.4875	2880.0
2005-12-16	DIV	ETF	11.96	12.0	11.95	11.95	47400.0
2005-12-16	DRIV	ETF	29.46	30.45	29.31	30.15	1287595.0
2005-12-16	DSI	ETF	6.075	6.1	6.055	6.055	35800.0
2005-12-16	DUSA	ETF	9.56	10.25	9.56	9.9	469291.0

> showing 50 of 291 rows — these rows as CSV

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