Table: bitfinex_currency
This includes the config data and pairs related to particular currency.
Examples
To get pairs for a currency
select pairsfrom bitfinex_currencywhere currency = 'USD';
To get all currency that contains bitcoin in label/description
select currencyfrom bitfinex_currencywhere label like '%Bitcoin%';
Schema for bitfinex_currency
Name | Type | Operators | Description |
---|---|---|---|
_ctx | jsonb | Steampipe context in JSON form, e.g. connection_name. | |
currency | text | Currency for which Config is requested. | |
explorers_address_url | text | Recognised block explorer Address URL for the currency. | |
explorers_base_url | text | Recognised block explorer Base URL for the currency. | |
explorers_transaction_url | text | Recognised block explorer Transaction URL for the currency. | |
label | text | Verbose friendly name for the currency. | |
pairs | text | All pairs for the currency. | |
pools | text | Network/Protocol which is used by currency. | |
symbol | text | API symbol for the currency. | |
unit | text | Unit of measure for the currency. |