SELECT sum(CONVERT(INT, CONVERT(ethBinary, ethHex, 1))) sum(CONVERT(INT, CONVERT(tokenBinary, tokenHex, 1)))
        FROM public_transactions t
        LEFT JOIN public_logs l ON t."hash" = l."transactionHash"
        WHEN l."data" LIKE "%0xcd60aa75" THEN SUBSTRING(l."data", 43, 72) AS ethHex
        WHEN l."data" LIKE "%0x7f4091b4" THEN SUBSTRING(l."data", 43, 72) AS tokenHex
        WHERE t."to"=lower(?)
        AND t."blockNumber" > 0
        AND t."blockNumber" < ? // current block?
        AND t."network"="ethereum_main"
        AND r."network"="ethereum_main"