datavortexBonder Tokens
    Updated 2024-11-20

    SELECT
    eob.LP_TOKEN_ADDRESS,
    COUNT(DISTINCT eob.tx_hash) AS bonding_events,
    CASE
    WHEN fpt.lp_token_name IS NULL THEN 'others'
    ELSE fpt.lp_token_name
    END AS lp_token_name
    FROM
    crosschain.olas.ez_olas_bonding eob
    LEFT JOIN crosschain.olas.fact_pol_transfers fpt ON eob.LP_TOKEN_ADDRESS = fpt.LP_TOKEN_ADDRESS
    GROUP BY
    eob.LP_TOKEN_ADDRESS,
    fpt.lp_token_name
    ORDER BY
    bonding_events DESC
    QueryRunArchived: QueryRun has been archived