Paul Apivat
onchain ⛓️ data
public blockchains
Data @ Exponent
Feeding large language models with onchain and offchain data. Connecting pipelines to databases. In the arena making pull requests. Other hangouts: Dune, Bytexplorers
Recent Works
- DEX Comparisons: Fraxswap vs Curve vs Uniswap | 🧵 Thread
- Frax Arbitrum Short-Term Incentive Program (STIP): Return on Incentives | 🧵 Thread
- veFXS lockers | 🧵 Thread
- Arbitrum Short Term Incentives Program (STIP), with Frax Finance | 🃏 CryptoDataBytes Submission
- Frax Finance Incentivzer AMOs |🃏 CryptoDataBytes Submission
- 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
- Bankless DAO Membership Categories Dashboard
- Bankless DAO Membership Over Time
- Bankless DAO Treasury
- Bankless DAO Treasury Start & End Period
- $BANK Trading Volume
- Staking $AAVE
- Bankless DAO Community Calls POAPs Claimed Data
- Bankless DAO Tipping Economy
- ForeFront Tipping Economy
- Learn Foundational Ethereum Topics with SQL
- Grants Committee Dashboard
Off-Chain Data
- Bankless DAO Growth in Bytes: Season 3 Launch - Jan 21, 2022, | 🧵 Thread
- Bankless DAO Community Growth, Season 2 Launch | 🧵 Thread
- DAOs: The New Coordination Frontier (Gitcoin & BanklessDAO)
- Bankless DAO Twitter Analytics
- Exploring Discord Data: Bankless DAO Engagement
- Bankless DAO Onboard Survey Pt 1
- Bankless DAO Onboard Survey Pt 2
Data Pipelines
See my past data visualizations and writings on Medium, Quora, dev.to and Hashnode.
Social Media
Interests
- Onchain Data, DS/ML
- Python, SQL
- Ethereum, DeFi