Count Currencies by Asset Class

select asset_class, count(*) as count
from ores.currencies
where valid_to = '9999-12-31 23:59:59'::timestamptz
group by asset_class
order by count desc;

| asset_class   | count |
|---------------+-------|
| fiat          |   153 |
| commodity     |     4 |
| supranational |     1 |