u/buddies2705

Hello,

How do you investigate any crypto address?

Where money come from, and where does the money go?

I want to trace crypto addresses

I want to trace Solana addresses where money came from and where it went.

What tools do you use?

So I am a non-tech person, I sometimes trade on Pumpfun, use various tools for research, check GMGN and other similar tools to find traders,

What tools do you guys use?

I want to fully reindex the Ethereum chain; however, archive nodes are very slow and costly. What are the alternatives?

So custodians usually manage thousands and some cases millions of wallets, how they monitor them across multiple chains for deposits?

How this infra looks like?

I am working on a ML project that involves preparing a dataset for transfers and Dex trades for Optimism chain. Based on some early research I came across Dune which provides APIs and lets you pull data via SQL queries. I tried to pull last 3 years of transfers data for Optimism, and it costed me around 100 USD worth of credits. Are there any more viable alternatives?

How can I stream real-time liquidity data from Uniswap v4 pools? I'm looking to track liquidity across all pools continuously. Any recommendations?

I want to watch pending txs for a few specific contracts in real time, but running and maintaining nodes across chains just to get mempool visibility is a huge time sink, and the data gaps when a node hiccups are brutal. Tried a couple of public WebSocket feeds and they drop connections constantly. Is there a hosted way to subscribe to mempool activity that doesn't fall over? Curious what the frontrun-defense folks are running.

Our trading dashboard covers Ethereum, Solana, BSC, Base and a couple others.

Each chain has its own RPC quirks, its own DEX schemas, its own way of representing a trade. Every time one of them changes something, a parser breaks.

I'm spending more time on glue code than on the actual product. Has anyone found a single data source that normalizes DEX trades across chains so I'm not maintaining six separate pipelines?

I'm building an agent that should answer things like "how much volume did this token do today" or "which wallets bought in the last hour." I tried wiring it to raw RPC and it falls apart — the model can't reason about logs, and I end up writing a custom endpoint for every single question. Tried a couple of indexers but the agent still needs me to pre-write the GraphQL. I want the model to just ask in plain English and get structured data back. What's everyone using for the data layer behind their agents?

Been using Coingecko for Solana DEX trading data for a while and hitting two walls: price and candle data isn't live enough (noticeably behind what I see on GMGN and Axiom), and I keep running into downtime. For anything time-sensitive it's just not cutting it.

What's everyone using for real-time Solana DEX price and OHLC data? Looking for something with low latency and reliable uptime. Open to paid options if they actually hold up.

Willing to pay more for it

I am looking for a Kafka stream which stream all instructions, balance updates, trades, transfers, and transactions from the Solana blockchain.

I need it in subsecond latency.

Uptime should be 99.9999%

Building a stablecoin analytics dashboard that shows daily USDT volume on Tron — total USD moved, transfer count, and unique active addresses per day.

The naive approach is pulling every raw transfer event and aggregating client-side, but Tron processes an enormous number of USDT transfers daily and paginating through all of them to compute a daily sum is both slow and burns through API quota fast.

I've tried pulling from TronGrid with date filters but it doesn't return pre-aggregated metrics — you get the raw rows.

CoinMetrics covers some of this but it's expensive for just one chain and doesn't give you the address-level breakdowns.

Is there an API that lets you group by date and return sum(transfer_amount), count(transfers), and uniq(senders) server-side in a single call?

Doing a lot of memecoin and wallet research lately and the workflow is broken — I write SQL against my own database copy of Solana trades, export to CSV, paste into Claude, get analysis, repeat. Every iteration loses context.

Tried building a quick MCP server over a Dune query but rate limits killed it within a day. The CoinGecko MCP works fine for price/market data but doesn't have wallet-level trade data, which is what I actually need (per-trader PnL, copy-trade candidates, detecting wallets that are basically pump orchestrators).

What's the cleanest setup for getting wallet-level and pool-level DEX trades into Claude as a queryable tool? Ideally something with Solana + EVM coverage and not too much auth ceremony.