KARTODMonthle Sushi Activity on Ethereum
    Updated 2022-06-26
    SELECT
    DATE_TRUNC('month', BLOCK_TIMESTAMP) AS "Date",
    'Borrow' AS "Action",
    COUNT(DISTINCT TX_HASH) AS "Txs",
    SUM(AMOUNT_USD) AS "USD Volume",
    COUNT(DISTINCT ORIGIN_FROM_ADDRESS) AS "Users"
    FROM ethereum.sushi.ez_borrowing
    WHERE ACTION = 'Borrow'
    GROUP BY 1
    UNION ALL

    SELECT
    DATE_TRUNC('month', BLOCK_TIMESTAMP) AS "Date",
    'Repay' AS "Action",
    COUNT(DISTINCT TX_HASH) AS "Txs",
    SUM(AMOUNT_USD) AS "USD Volume",
    COUNT(DISTINCT ORIGIN_FROM_ADDRESS) AS "Users"
    FROM ethereum.sushi.ez_borrowing
    WHERE ACTION = 'Repay'
    GROUP BY 1
    UNION ALL

    SELECT
    DATE_TRUNC('month', BLOCK_TIMESTAMP) AS "Date",
    'Deposit' AS "Action",
    COUNT(DISTINCT TX_HASH) AS "Txs",
    SUM(AMOUNT_USD) AS "USD Volume",
    COUNT(DISTINCT ORIGIN_FROM_ADDRESS) AS "Users"
    FROM ethereum.sushi.ez_lending
    WHERE ACTION = 'Deposit'
    GROUP BY 1
    UNION ALL

    Run a query to Download Data