dan-smith2023-04-18 06:38 PM
    Updated 2023-04-18
    SELECT
    SUM(amount) AS total_lp
    FROM (
    SELECT
    -amount AS amount
    FROM ethereum.core.ez_token_transfers
    WHERE
    contract_address = lower('0x853d955acef822db058eb8505911ed77f175b99e')
    AND from_address = lower('0xdcef968d416a41cdac0ed8702fac8128a64241a2')
    UNION ALL
    SELECT
    amount
    FROM ethereum.core.ez_token_transfers
    WHERE
    contract_address = lower('0x853d955acef822db058eb8505911ed77f175b99e')
    AND to_address = lower('0xdcef968d416a41cdac0ed8702fac8128a64241a2')
    )
    Run a query to Download Data