In regards of the bottle opening rate I think it´s a strong KPI to analyse the bottles and why people are purchasing it.
Taking into account not everyone updates their collection I truly believe you can still take some insights.
Let´s take RX 14100 (Spirit of Rum Hampden Rumclub Private Selection Ed. 32 C<>H, 1990, 32 years, 54,51% | RX14100 | RumX)
274 bottles have been bottled.
26 are entered in the RumX Database.
25 are closed
0 are open
1 is emptied (it was the split of @RumTaTa I assume).
That comes down to an open rate of 3,8% which leads to the conclusion people purchased the bottle to invest / collect / or open for a special moment given the very high price.
Now let´s look at some other bottlings.
RX 10636 (Maison Ferrand Hampden Plantation Jamaica HJF, 2002, 19 years, 70,3% | RX10636 | RumX)
354 bottles have been bottled.
54 are entered in the RumX Database.
42 are closed
11 are open
1 is emptied
That comes down to an open rate of 22,2% which leads to the conclusion people purchased the bottle to invest / collect / but also open it right away given the fair price.
and another bottle which can be considered as something you usually open right away.
RX 11 (Hampden Pure Single Jamaican Rum, 8 years, 46% | RX11 | RumX)
?! bottles have been bottled.
943 are entered in the RumX Database.
581 are closed
243 are open
119 is emptied
That comes down to an open rate of 38,4% which leads to the conclusion people purchased the bottle to mainly open it right away.
I personally love analysing numbers and excel sheets so I´m obviously biased, but I think there is a huge potential in the open rate to make conclusions.