Ethereum Address

finance.crypto.ethereum_address

Ethereum wallet or contract address. 42 characters: 0x + 40 hex digits. May be EIP-55 checksummed (mixed case) or not.

Domain

finance

Try it

CLI

$ finetype infer -i "0x742d35Cc6634C0532925a3b844Bc3e7c1f2B9C2C"
→ finance.crypto.ethereum_address

DuckDB

Detect

SELECT finetype('0x742d35Cc6634C0532925a3b844Bc3e7c1f2B9C2C');
-- → 'finance.crypto.ethereum_address'

Cast expression

LOWER(CAST({col} AS VARCHAR))

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.crypto.ethereum_address';

JSON Schema

finetype schema finance.crypto.ethereum_address

{
  "$id": "https://meridian.online/schemas/finance.crypto.ethereum_address",
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "description": "Ethereum wallet or contract address. 42 characters: 0x + 40 hex digits. May be EIP-55 checksummed (mixed case) or not.",
  "examples": [
    "0x742d35Cc6634C0532925a3b844Bc3e7c1f2B9C2C",
    "0x0000000000000000000000000000000000000000",
    "0xd9965507d3b0ce0ce6932b0337db0c11b85fcf7d"
  ],
  "pattern": "^0x[a-fA-F0-9]{40}$",
  "title": "Ethereum Address",
  "type": "string",
  "x-finetype-broad-type": "VARCHAR",
  "x-finetype-transform": "LOWER(CAST({col} AS VARCHAR))"
}

Examples

0x742d35Cc6634C0532925a3b844Bc3e7c1f2B9C2C0x00000000000000000000000000000000000000000xd9965507d3b0ce0ce6932b0337db0c11b85fcf7d