Unusual whales and tradytics but for crypto degens.
All token transfers flowing into verified contracts (query on transpose)
SELECT tt.contract_address, tt.timestamp, tt.block_number, tt.transaction_hash, tt.log_index, tt.category, tt.operator_address, tt.from_address, tt.to_address, tt.quantity, tt.activity_id, tt.__confirmed, t.name, t.symbol, t.decimals, t.description, t.external_url, t.image_url, t.verified, a.type, cl.name as to_name, cl.labels
FROM ethereum.token_transfers tt
INNER JOIN ethereum.tokens t ON tt.contract_address = t.contract_address
INNER JOIN ethereum.accounts a ON tt.from_address = a.address
INNER JOIN ethereum.contract_labels cl ON tt.contract_address = cl.contract_address
WHERE tt.category = 'send'
AND a.type = 'contract'
AND cl.name IS NOT NULL
and t.verified = true
and timestamp >= date_trunc('day', NOW() - interval '1 day')::TIMESTAMP
There is no single API we can use to extract this data on chains I’m interested in. Will likely require custom data ingestion modules to query raw RPC and we’ll probably only support up to 30 days of historical data which is fine, unless we want a data lake to train AI (might be cheap if we dont need to make it easily accessible).
We can also offer api access to this data and other signals. There are currently like 250+ wallet companies in the space. To differentiate themselves and retain users they need useful features and our API could be something they plug into and integrate with their product offering.
The React library to build dashboards fast
NextUI - Beautiful, fast and modern React UI Library
Nansen offers a hot contracts feature which is what I was thinking of but its only available on their $1500 per month plan and they dont support all chains I would want. They say support is coming soon but the way they operate I know its very expensive for them to expand easily since they index a lot more data than I care about, hence the $1500 price tag.