UNIQUE_ACTIVE_WALLETS | TOTAL_TRANSFERS | CIRCULATING_SUPPLY | MARKET_CAP | |
|---|---|---|---|---|
1 | 115401 | 1184758 | 1023571475.56179 | 951958.150216224 |
Analyst Lab Normie Wallet Key Stats
Updated 8 days ago
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
›
⌄
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')
),
token_interactions AS (
SELECT
DISTINCT wallet,
COUNT(DISTINCT tx_hash) AS tx_count,
SUM(amount_change) AS wallet_balance
FROM net_balance
WHERE wallet != '0x0000000000000000000000000000000000000000' -- Exclude null address
GROUP BY wallet
),
supply_calc AS (
SELECT
COUNT(DISTINCT wallet) AS unique_active_wallets,
SUM(tx_count) AS total_transfers,
SUM(CASE WHEN wallet_balance > 0 THEN wallet_balance ELSE 0 END) AS circulating_supply
FROM token_interactions
Last run: 8 days ago
1
52B
29s