Get a full understanding of a wallet and its transactions
within 30 seconds
Brought to you by
✨
Use predefined queries to find whales, top NFT holders or lending protocol users with high risk appetite.
🔎
Find wallets by balance, cashflow, lending and liquidity providing activity.
﹫
Explore holdings and the activity of the wallet, analyze and get useful insights.
🗄️
Import from and export to CSV, manage address lists, get real-time alerts and notifications.
🗞️
Be first to learn about the recent move from your favourite wallet or a questionable interaction from one of your customers.
🕵️♀️
Follow the path of money, compress several low-level transactions in one line summary.
-- TOP ACTIVE CONTRACTS:
-- Find all contracts which active in a last 20 minutes and has 1000 transactions or more
SELECT t.address, COUNT(*) as transaction_count
FROM (
SELECT from_address AS address
FROM transactions
WHERE block_timestamp > NOW() - INTERVAL '1200 minutes'
UNION ALL
SELECT to_address AS address
FROM transactions
WHERE block_timestamp > NOW() - INTERVAL '1200 minutes'
) as t
WHERE t.address NOT IN (
SELECT address
FROM interest_contracts
)
GROUP BY t.address
HAVING COUNT(*) > 1000
order by count(*) desc
How credit and trustworthy is this address?
Is this wallet monetarily valuable?
Is this wallet a human or bot?
Is this wallet connected to others, i.e. do we have 500 members compared to 2000?
How long does this wallet hold our token?
Will this wallet consistently engage with our protocol?
Will this wallet be profitable to our protocol?
Define your needs and we will engineer it for you
