carsonbrownCurve Balance Changes
Updated 2022-10-03
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
WITH tokens_in AS (
SELECT BLOCK_NUMBER, BLOCK_TIMESTAMP, DATE_TRUNC('DAY', BLOCK_TIMESTAMP) AS DAY, CONTRACT_ADDRESS, SYMBOL, RAW_AMOUNT, AMOUNT, TX_HASH
FROM ethereum.core.ez_token_transfers
WHERE TO_ADDRESS = '0xdcef968d416a41cdac0ed8702fac8128a64241a2'
),
tokens_out AS (
SELECT BLOCK_NUMBER, BLOCK_TIMESTAMP, DATE_TRUNC('DAY', BLOCK_TIMESTAMP) AS DAY, CONTRACT_ADDRESS, SYMBOL, RAW_AMOUNT * -1, AMOUNT * -1, TX_HASH
FROM ethereum.core.ez_token_transfers
WHERE FROM_ADDRESS = '0xdcef968d416a41cdac0ed8702fac8128a64241a2'
),
moves AS (
SELECT * FROM tokens_in
UNION ALL
SELECT * FROM tokens_out
)
SELECT DAY, SYMBOL, SUM(AMOUNT) AS CHANGE
FROM moves
GROUP BY DAY, SYMBOL
Run a query to Download Data