dan-smith2023-04-17 07:06 PM
Updated 2023-04-17
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
SELECT
SUM(amount) AS total_lp
FROM (
SELECT
block_timestamp
,amount
,'mint' AS action
FROM ethereum.core.ez_token_transfers
WHERE
contract_address = lower('0xf43211935C781D5ca1a41d2041F397B8A7366C7A')
AND from_address = '0x0000000000000000000000000000000000000000'
UNION
SELECT block_timestamp
,-amount
,'burn' AS action
FROM ethereum.core.ez_token_transfers
WHERE
contract_address = lower('0xf43211935C781D5ca1a41d2041F397B8A7366C7A')
AND to_address = '0x0000000000000000000000000000000000000000'
)
Run a query to Download Data