MLDZMNxdai1
Updated 2023-03-05
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
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