dan-smith2023-04-18 06:38 PM
Updated 2023-04-18
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
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