Currency Amount (Cryptocurrency)

finance.currency.amount_crypto

Cryptocurrency amount with ticker symbol suffix. Supports high-precision decimals (up to 8+ decimal places). Common in exchange exports and portfolio tracking data.

Domain

finance

Try it

CLI

$ finetype infer -i "0.00123456 BTC"
→ finance.currency.amount_crypto

DuckDB

Detect

SELECT finetype('0.00123456 BTC');
-- → 'finance.currency.amount_crypto'

Cast expression

CAST(REGEXP_REPLACE({col}, '\s*[A-Z]{2,5}$', '') AS DECIMAL(18,8))

Safe cast pipeline

-- Normalise and cast in one step
SELECT TRY_CAST(finetype_cast(my_column) AS VARCHAR) AS clean_value
FROM my_table
WHERE finetype(my_column) = 'finance.currency.amount_crypto';

Struct Expansion

Expression

numeric_value: CAST(REGEXP_REPLACE({col}, '\s*[A-Z]{2,5}$', '') AS DECIMAL(18,8))
ticker: REGEXP_EXTRACT({col}, '([A-Z]{2,5})$')

JSON Schema

finetype schema finance.currency.amount_crypto

{
  "$id": "https://meridian.online/schemas/finance.currency.amount_crypto",
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "description": "Cryptocurrency amount with ticker symbol suffix. Supports high-precision decimals (up to 8+ decimal places). Common in exchange exports and portfolio tracking data.",
  "examples": [
    "0.00123456 BTC",
    "1.50000000 ETH",
    "100.00 USDT",
    "0.025 BTC"
  ],
  "pattern": "^-?[0-9]+\\.?[0-9]*\\s?[A-Z]{2,5}$",
  "title": "Currency Amount (Cryptocurrency)",
  "type": "string",
  "x-finetype-broad-type": "VARCHAR",
  "x-finetype-transform": "CAST(REGEXP_REPLACE({col}, '\\s*[A-Z]{2,5}$', '') AS DECIMAL(18,8))"
}

Examples

0.00123456 BTC1.50000000 ETH100.00 USDT0.025 BTC

Aliases

crypto_amount