WALLET | NUMBER_OF_TRANSACTIONS | TOKEN_BALANCE | PERCENT_OF_TOTAL_SUPPLY | |
|---|---|---|---|---|
1 | 0x98433581b5420bc67fc5fd2b5f9dd3e7ca43140b | 368158 | 81570201.0255436 | 8.157% |
Analyst Lab Normie Wallet Tracker
Updated 2025-04-05
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
33
34
35
36
›
⌄
--Active wallets (parameter, balance, holdings, percent of balance and holdings)
--for Normie Token on Base
--NORMIE suffered a smart contract exploit.
--Normie (NORMIE) has recently migrated from their old contract (0x7F12d13B34F5F4f0a9449c16Bcd42f0da47AF200)
--to a new contract address: 0x47b464eDB8Dc9BC67b5CD4C9310BB87b773845bD
WITH net_balance AS (
-- Outgoing transfers (negative)
SELECT
from_address as wallet,
tx_hash,
-amount as amount_change
FROM base.core.ez_token_transfers
WHERE contract_address = lower('0x47b464eDB8Dc9BC67b5CD4C9310BB87b773845bD')
UNION ALL
-- Incoming transfers (positive)
SELECT
to_address as wallet,
tx_hash,
amount as amount_change
FROM base.core.ez_token_transfers
WHERE contract_address = lower('0x47b464eDB8Dc9BC67b5CD4C9310BB87b773845bD')
)
select
wallet,
COUNT(DISTINCT tx_hash) as Number_of_Transactions,
SUM(amount_change) as token_balance,
ROUND((token_balance / 1000000000) * 100, 4) || '%' as percent_of_total_supply -- total maximum supply of Normie is 1,000,000,000
FROM net_balance
WHERE wallet = lower('{{wallet_address}}')
GROUP BY 1
Last run: 18 days ago
1
81B
64s