2844Sushi Activity on Ethereum-LENDING
    Updated 2022-06-27
    WITH DEPOSIT AS (
    select DATE_trunc('day',BLOCK_TIMESTAMP) as "DTE" , COUNT (DISTINCT ORIGIN_FROM_ADDRESS) AS "UNIQUE USERS-DEPOSIT", COUNT (TX_HASH) AS "DAILY TRANSACTIONS-DEPOSIT"
    from ethereum.sushi.ez_lending
    WHERE BLOCK_TIMESTAMP::DATE >= '2022-01-01'
    AND ACTION= 'Deposit'
    GROUP BY "DTE"

    ),
    Withdraw AS (
    select DATE_trunc('day',BLOCK_TIMESTAMP) as "DTE" , COUNT (DISTINCT ORIGIN_FROM_ADDRESS) AS "UNIQUE USERS-Withdraw", COUNT (TX_HASH) AS "DAILY TRANSACTIONS-Withdraw"
    from ethereum.sushi.ez_lending
    WHERE BLOCK_TIMESTAMP::DATE >= '2022-01-01'
    AND ACTION= 'Withdraw'
    GROUP BY "DTE"
    )
    SELECT DEPOSIT."DTE","UNIQUE USERS-DEPOSIT", "DAILY TRANSACTIONS-DEPOSIT",
    "UNIQUE USERS-Withdraw","DAILY TRANSACTIONS-Withdraw"
    FROM DEPOSIT,Withdraw
    WHERE DEPOSIT."DTE"=Withdraw."DTE"

    Run a query to Download Data