Data-driven insights into blockchain trading and market dynamics
The NegRiskAdapter contract lets traders swap a basket of NO tokens for YES tokens and free up collateral - all in one event. We unpack the mechanism, the (k-1)·amount formula, and what 3.17M on-chain events reveal about who actually uses it.
We rendered millisecond-accurate timelines of two pumpfun token launches scoped to a single validator's leader window. Bar color shows success vs failure, bar height shows fee paid, and the horizontal distance between bars is the actual wall-clock time between transactions arriving at the leader.
Two new tables landed in our indexers: pumpfun_v2_swaps on Solana adds the quote-asset dimension and a failed-transaction flag, and polymarket.raw_event_meta on Polygon exposes the tag taxonomy that powers Polymarket's UI. Each table unlocks questions the old schema could not answer.
We launched an API to query our Hyperliquid ClickHouse data. Testing it on the new BTC price prediction market — how outcomes are encoded, and what the first 72 hours of data looks like.
Do Pumpfun token creators show consistent patterns in how high their tokens reach? We analyzed 323,770 tokens from 10,061 creators in March 2026 to find out.
We discovered Falcon transactions are positioned 8% earlier in Harmonic validator blocks. Here's the data proving preferential treatment in Solana's MEV landscape.
We analyzed 138,481 Pumpfun token launches from the past 7 days and found a strong correlation (Spearman r=0.45) between priority fees in the first 10 slots and maximum price achieved. Here's what the data reveals about early trading competition.
We analyzed 27,000 recent Solana blocks containing 34+ million transactions to investigate whether validators are ordering transactions fairly or engaging in preferential ordering. Our topological maps reveal where Jito tips, nonce advances, and different transaction types appear within blocks.
On February 26, 2026, Pumpfun deployed a backwards-incompatible contract update. We analyzed 153,707 swaps across a 3-hour window to measure the impact on bot activity and how long it took them to adapt.
Indexing Polygon blockchain isn't trivial. We don't guarantee 100% data quality, but here's how we validate our Polymarket data.
A deep dive into Polymarket's CTF Exchange, showing how conditional token splits enable a single trade to aggregate liquidity from 14 different sellers. Learn to read complex DeFi transactions.
A step-by-step guide to building a pure SQL query that identifies Polymarket traders with the highest ROI. We'll calculate realized and unrealized PnL using nothing but ClickHouse SQL.
Analysis of 198 new whale traders on Polymarket reveals an 89.4% success rate with +2.4% average returns. Here's how we backtested the strategy.
Which fee recipients do the fastest snipers use on Pumpfun? We analyzed 23,635 tokens launched in the last 24 hours to find the top 25 tip accounts.