zakkisyed$ECO in Locked Contracts
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
30
31
32
›
⌄
WITH balances AS (
SELECT DATE_TRUNC('day', last_activity_block_timestamp) AS date,
user_address,
CASE
WHEN user_address = '0x8c02d4cc62f79aceb652321a9f8988c0f6e71e68' THEN 'Community Treasury'
WHEN user_address = '0x98830c37aa6abdae028bea5c587852c569092d71' THEN 'Association'
WHEN user_address = '0xa201d3c815ac9d4d8830fb3de2b490b5b0069aca' THEN 'Eco Inc.'
WHEN user_address = '0x99f98ea4a883db4692fa317070f4ad2dc94b05ce' THEN 'Association'
WHEN user_address = '0xa28f219bf1e15f5217b8eb5f406bcbe8f13d16dc' THEN 'Claim Contract'
ELSE 'Other'
END AS account_label,
SUM(current_bal) AS cumulative_balance
FROM ethereum.core.ez_current_balances
WHERE contract_address = '0x8dbf9a4c99580fc7fd4024ee08f3994420035727'
AND user_address IN (
'0x8c02d4cc62f79aceb652321a9f8988c0f6e71e68', --(Community Treasury)
'0x98830c37aa6abdae028bea5c587852c569092d71', --(Association)
'0xa201d3c815ac9d4d8830fb3de2b490b5b0069aca', --(Eco Inc.)
'0x99f98ea4a883db4692fa317070f4ad2dc94b05ce', --(Association)
'0xa28f219bf1e15f5217b8eb5f406bcbe8f13d16dc' -- claim contract
)
GROUP BY DATE_TRUNC('day', last_activity_block_timestamp), user_address
),
previous_balances AS (
SELECT date, user_address, account_label, cumulative_balance,
LAG(cumulative_balance) OVER (PARTITION BY user_address ORDER BY date) AS previous_balance
FROM balances
)
SELECT date, account_label, COALESCE(cumulative_balance, previous_balance) AS cumulative_balance
FROM previous_balances
ORDER BY date;
Run a query to Download Data