MLDZMNxdai1
    Updated 2023-03-05
    SELECT
    SUM(amount/1e18) AS total
    FROM (
    SELECT RAW_AMOUNT as amount
    FROM ethereum.core.fact_token_transfers
    WHERE (
    contract_address = lower('0x6B175474E89094C44Da98b954EedeAC495271d0F') AND
    TO_ADDRESS = lower('0x4aa42145Aa6Ebf72e164C9bBC74fbD3788045016') AND
    FROM_ADDRESS != lower('0x5d3a536e4d6dbd6114cc1ead35777bab948e3643')
    )
    UNION ALL
    SELECT -RAW_AMOUNT AS amount
    FROM ethereum.core.fact_token_transfers
    WHERE (
    contract_address = lower('0x6B175474E89094C44Da98b954EedeAC495271d0F') AND
    FROM_ADDRESS = lower('0x4aa42145Aa6Ebf72e164C9bBC74fbD3788045016') AND
    TO_ADDRESS != lower('0x5d3a536e4d6dbd6114cc1ead35777bab948e3643')
    )
    )
    Run a query to Download Data