Dune published Serotonin's data operations as an official case study, covering how we run analytics across data infrastructure, client audiences, product-market fit signals, and protocol tracking with no PII and no traditional tracking. It documents the migration from ad hoc queries to incremental dbt models, which cut infrastructure costs by more than half. → https://dune.com/case-studies/serotonin

Solstice needed an incentive system that could be tuned while it was running, not audited after it ended. I designed and operated the analytics stack behind it; dbt, Snowflake, Python, and multi-source on-chain data , powering multiplier optimization, wallet eligibility filtering, and capital allocation decisions through the TGE. I also built the public dashboard for the token listing and a custom API tracking TVL retention for wallets that chose the vesting reward option, w

Tokenized RWA vaults advertise yield, but the question that actually matters to an allocator is how long it takes to get money back out. I built the vault and risk-layer analysis behind this piece with Cork, measuring time to cash across Maple vaults, with the underlying queries published as a public RWA vaults dashboard on Dune. → https://www.cork.tech/blog/measuring-time-to-cash-in-maple-vaults → https://dune.com/serotonin_data/rwa-vaults-analysis

Privacy is easy to argue for and hard to measure. For Aleo, the first private programmable Layer-1, I contributed the on-chain analysis behind a report quantifying how much stablecoin activity is publicly exposed, alongside the production dashboards that back it. The goal was a research output grounded in verifiable data rather than positioning claims. → Report: https://aleo.org/privacy-gap-report-2025/ → Dashboard: https://aleo.org/privacy-gap-report-2025/

2024 began, and I haven't stopped. Last month, I finished an airdrop project for ZKX, a perpetual exchange protocol based on Starknet...

Read the full article here: https://rodolfo-projects.notion.site/X-ray-on-Curve-DEX-Dynamics-69b148a8593b48d29e89234cff3f9918

Note: This project is a 1st place winner from the bounty challenge powered by Uniswap Foundation 🥇 The main purpose of this article is...

Note: This project is a 1st place winner of the data challenge powered by Desights AI and Ocean Protocol. 🥇 As a data consultant for...

The primary objective of this project is to propose a strategy for purchasing $5M worth of GNS through DEX while causing minimal market...

Dashboard powered by Flipside Crypto. Click here to access it! I used SQL and Flipside API to query on-chain data, Python to prepare the...

Coinbase, one of the world's largest cryptocurrency exchanges, recently announced the launch of its own layer-2 (L2) blockchain called...

Uniswap 🦄 was launched in November 2018 and has since become one of the most popular decentralized exchanges in the cryptocurrency...

Dashboard powered by Flipside Crypto. Click here to access it! I used SQL and Flipside API to query on-chain data, Python to prepare the...

Dashboard powered by Flipside Crypto. Click here to access it! I used SQL and Flipside API to query on-chain data, Python to prepare the...

Dashboard powered by Flipside Crypto. Click here to access it. Flipside rewarded me with the Grand Prize for submitting the best...

Dashboard powered by Flipside Crypto. Click here to access it! Best Dashboard from the chosen NFT collection. This dashboard won the the...

Credit and lending are two of the most important financial functionalities that exist in Decentralized Finance (DeFi), and traditional...

You can access the project here Dune Analytics is an analytical platform that allows users to analyze blockchain data, mainly of the...

Note: Full Github repository with code and files used in the project is available here 1. Introduction Information management is a...

​Figuring out how the economy can control the violence