zakkisyedECO Inc. Balance
Updated 2023-07-03
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
›
⌄
WITH og AS (
SELECT SUM(raw_amount / 1e18) AS outgoing, DATE_TRUNC('day', block_timestamp) AS date
FROM ethereum.core.ez_token_transfers
WHERE from_address = '0xa201d3c815ac9d4d8830fb3de2b490b5b0069aca' -- ECO Inc
AND contract_address = '0x8dbf9a4c99580fc7fd4024ee08f3994420035727'
GROUP BY DATE_TRUNC('day', block_timestamp)
),
ig AS (
SELECT SUM(raw_amount / 1e18) AS incoming, DATE_TRUNC('day', block_timestamp) AS date
FROM ethereum.core.ez_token_transfers
WHERE to_address = '0xa201d3c815ac9d4d8830fb3de2b490b5b0069aca' -- ECO Inc
AND contract_address = '0x8dbf9a4c99580fc7fd4024ee08f3994420035727'
GROUP BY DATE_TRUNC('day', block_timestamp)
),
combined AS (
SELECT COALESCE(og.date, ig.date) AS date,
COALESCE(og.outgoing, 0) AS outgoing,
COALESCE(ig.incoming, 0) AS incoming
FROM og
FULL OUTER JOIN ig ON og.date = ig.date
),
cumulative AS (
SELECT date,
SUM(incoming - outgoing) OVER (ORDER BY date) AS cumulative_balance
FROM combined
)
SELECT date, cumulative_balance
FROM cumulative;
Run a query to Download Data