The DeFi Lending Endgame: Scale is the Only Lever Left
Intro Lending is one of the oldest functions in finance. A lender lets a borrower turn $1 of collateral into more than $1 worth of financial exposure while charging interest for it. Homeowners do this with a home equity line of credit (HELOC), and options traders do this with margin. The modern economy relies on credit for various financial functions demonstrating a clear product-market fit. Crypto performs the same function through lending protocols. A user deposits an asset, borrows against it, and pays interest on the loan. Aave, the leading lending venue, accepts USDC, EUR, and gold-pegged assets as collateral and intermediates ~$10 billion in active loans. The base primitive supports cash-and-carry trades and long and short positions, and it has grown into curated vault products through protocols like Morpho which recently integrated with Coinbase. In structure these venues now resemble global FX markets. ...
Automated ETL Pipeline for Onchain Analysis
For onchain analysis, the limiting factor is often SQL and data plumbing. Researchers end up spending too much time writing queries and moving data between Dune and external APIs. At Blocmates, we solved this with an agent-driven ETL pipeline that automates dashboard production for the research team. You fill out a data spec, the agent writes, tests, and pushes queries to Dune using GitHub for version control. If the spec involves heavy API usage, the agent sets up a GitHub Action to collect data and load it into Dune. Queries are generated in minutes and are then ready for visualization in Dune’s UI. ...
Perp DEXs: The Mismarked Capital Stack
Since the early days of GMX, the market has treated the token as the equity-like asset and the LP as the yield product. The token captures the narrative and gives investors a liquid claim on protocol growth. Meanwhile, the LP is usually evaluated on its APY. That framing misses the risk structure of the exchange. Every leveraged position creates exposure that has to be priced and resolved, and in pool-based designs, the LP carries that exposure. When the system prices risk well, trading revenue accrues to LP NAV. When it does not, trader P&L from toxic flow hits the LP first. LP NAV therefore becomes a live mark on the protocol’s underwriting quality. ...
Building a Local AI System to Stay Ahead of the Crypto News Cycle
With Crypto operating 24/7 it’s challenging to keep up with current news while also going deep on a report. Writing forces you to focus on a project or sector deeply, but you still have to track headlines that could change your thesis or reframe the data. To solve this, I vibecoded an AI research assistant to keep me up to date with the latest news in crypto and finances everyday, in around 20 minutes reading time – down from 1-2 hours. It runs on locally hosted models including OpenAI’s GPT OSS 20b, and Deepseek R1 via LM studio. ...
MetaDAO Launchpad Query Notes (Dune/ TrinoSQL)
While building the MetaDAO dashboard at Blocmates, @563defi and I spent some time digging into MetaDAO’s launchpad program to understand the existing Dune queries, build on them, and create new ones. These are my notes, which I will be referring back to as I verify & build out more queries on MetaDAO’s activity. This can also be used as context to feed to an LLM for generating simple queries. Hopefully this helps you understand the program structure and verify your queries are pulling the right data. ...
Unpacking the Superapp Stack
Over the past year, trading platforms like Robinhood, Bybit, and Kraken have rolled out onchain protocols to extend their product offerings. By tapping into decentralized protocols they’re able to deliver new services at scale, ranging from tokenized equities to non-custodial trading. As this trend continues, the competition between Web2 and Web3 is converging into a race to build Superapps: platforms that combine mobile-first distribution with blockchain infrastructure. Mobile-first apps like Robinhood start from the top down: It already commands retail distribution and is now building on Arbitrum rails underneath to extend its product suite onchain. In contrast, Hyperliquid runs the opposite playbook: It specializes in perp infrastructure and lets other frontends - mobile or web - plug in through Builder Codes. ...