aaronr3genvulnerable-magenta
Updated 2025-02-17
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
WITH wallet_addresses AS (
SELECT 'Enzyme Operations Account' as wallet_name, '0xfc60416885f38adb121c6bd090d94cf9f0448f53' as address
UNION ALL
SELECT 'Treasury Wallet', '0xfECA27229A3801b34591582B66C46c82a9bC9994'
)
SELECT
w.wallet_name,
w.address,
COUNT(cb.user_address) as number_of_tokens,
MIN(cb.last_activity_block_timestamp) as earliest_activity,
MAX(cb.last_activity_block_timestamp) as latest_activity
FROM wallet_addresses w
LEFT JOIN ethereum.core.ez_current_balances cb
ON LOWER(w.address) = LOWER(cb.user_address)
WHERE cb.current_bal > 0
GROUP BY 1,2;
QueryRunArchived: QueryRun has been archived