Paul Apivat

onchain ⛓️ data

public blockchains

Feeding large language models with onchain and offchain data. Scaling pipelines and databases. In the arena making pull requests. Other hangouts: Dune, Llama Risk, Frax, Curve, Convex.

Recent Works

LlamaRisk - Collateral Risk Assessment - Coinbase Wrapped Staked ETH (cbETH) 🦙| 🧵 Thread
LlamaRisk - Asset Risk Assessment: Reserve Protocol (eUSD)🦙| Thread 🧵
LlamaRisk - Asset Risk Assessment: DeFi Franc🦙| Thread 🧵
Dune Spellbook - Query Labels ️🧙
MetricsDAO 101 🎓
DeFi Risk Themes from @ LlamaRisk 🧵
Risk Modeling with Monte Carlo simulation, pt.1
Additional Liquidity Risk Metrics on Aave v2
Liquidity Risk on Aave v2
Synthetic Data Vault (SDV), Enzyme demo💻
Safe Proxies TVL & Deployment
Curve StableSwap Invariant 101 💻 | Accompanying PDF | 🧵 Thread
Metrics Library @ Exponent | 🧵 Thread
Dune Analytics walk-through @ Exponent | 🧵 Thread
Stablecoin Risk Dimensions | 🧵 Thread
Gnosis Safe Holdings Analysis | version 1.0: Examines Safe Proxies from factory contract v1.3.0. 🧵 Thread
Exponent Fennec Stash | version 1.0: Examines Exponent Treasury Vault with Pool & Safe Dollar Yield strategies. 🧵 Thread

Past Projects

Velodrome Emissions Per $1 Bribed | 🧵 Thread
Frax Bribe ROI | 🧵 Thread
Curve v2 Pools | 🧵 Thread
Tokemak Liquidity Deployment | 🧵 Thread
Tokemak Overview | 🧵 Thread
GMI - Bankless DeFi Innovation Index overview
Ribbon Finance Vaults - $GMI Index
CultDAO Overview
Bank Token Buy & Sell Volume

2021

Core contributor at Bankless DAO ( POAPs), providing insights through on- and off-chain data (see below).

Founding member of our Analytics Guild, helping secure initial funding and governance structures. My colleagues and I built an in-house analytics platform called DAO Dash to provide insights on engagement, community health and governance.

I contributed growth and usage metrics to the BanklessDAO Bounty Board while sharing insights with the broader community through forum posts.

I wrote about my journey to web3 data here.

On-Chain Data