walemathsTransaction Volume
    Updated 2024-07-11
    WITH unique_transfers AS (
    SELECT
    DISTINCT
    BLOCK_TIMESTAMP,
    TX_HASH,
    SOURCE_CHAIN,
    SENDER,
    DESTINATION_CHAIN,
    RECEIVER,
    TOKEN_ADDRESS,
    TOKEN_SYMBOL,
    AMOUNT
    FROM
    axelar.defi.ez_bridge_satellite
    )

    SELECT
    COUNT(DISTINCT TX_HASH) AS total_transactions,
    COUNT(DISTINCT SENDER) AS unique_senders,
    COUNT(DISTINCT RECEIVER) AS unique_receivers,
    ROUND(SUM(CASE WHEN TOKEN_SYMBOL ILIKE '%usd%' THEN AMOUNT ELSE 0 END), 2) AS stablecoin_volume
    FROM
    unique_transfers;