jorshimayorCross-Chain Liquidity Transfers by Source Chain and LP Token
    Updated 2024-09-03
    SELECT
    source_chain,
    lp_token_name,
    COUNT(*) AS transfer_count,
    SUM(lp_token_amount) AS total_lp_token_amount
    FROM
    crosschain.olas.fact_pol_transfers
    GROUP BY
    source_chain,
    lp_token_name
    HAVING
    SUM(lp_token_amount) > 1000
    ORDER BY
    total_lp_token_amount DESC;
    QueryRunArchived: QueryRun has been archived