flipside

    Top Bridges
    datavortexTop Bridges
    Updated 2024-09-17
    /*
    WITH top_bridges AS (
    SELECT
    MAX(amount_usd) AS max_amount
    FROM
    avalanche.defi.ez_bridge_activity
    WHERE
    amount IS NOT NULL
    )
    SELECT
    e.token_symbol,
    e.platform AS protocol,
    e.amount AS top_bridges
    FROM
    avalanche.defi.ez_bridge_activity e
    JOIN
    largest_transaction l
    ON
    e.amount_usd = l.max_amount
    WHERE
    e.amount_usd IS NOT NULL
    LIMIT 1;
    */
    WITH ranked_bridges AS (
    SELECT
    e.token_symbol,
    e.platform AS protocol,
    e.amount_usd AS transaction_amount,
    ROW_NUMBER() OVER (ORDER BY e.amount_usd DESC) AS rank
    FROM
    avalanche.defi.ez_bridge_activity e
    WHERE
    e.amount_usd IS NOT NULL
    )
    SELECT
    token_symbol,
    QueryRunArchived: QueryRun has been archived