flipside

    Total Fee Lend On Polygon
    YakuzaTotal Fee Lend On Polygon
    Updated 2022-07-11
    WITH lend AS (
    SELECT DISTINCT(LENDING_POOL_ADDRESS) AS pool , LENDING_POOL , sum(TX_FEE) AS fees
    FROM polygon.sushi.ez_lending JOIN polygon.core.fact_transactions
    ON polygon.sushi.ez_lending.TX_HASH = polygon.core.fact_transactions.TX_HASH
    WHERE LENDING_POOL LIKE '%km%'
    GROUP BY pool , LENDING_POOL
    )
    SELECT sum(fees) FROM lend

    Run a query to Download Data