Paul Apivat

Data ⛓️

Ethereum

Current

Data Engineering and Analytics for Crypto Markets

I’m interested in building data products for crypto markets. Currently delivering datasets at Uniswap Foundation. Speeding running Data Engineering Community Bootcamp.

Spending time with my wife and kids; family, finances and health.

Communities: Dune, Math Academy

2024

Uniswap V4 Growth by Hooks
Ethereum’s Onchain GDP
Ethereum Credit Guild: Lending Markets (WETH) | 🧵 Thread
Optimism Airdrop 4: Claimer Impact on Governance | 🧵 Thread
Optimism Airdrop 4: Creators Edition
Optimism Airdrop 4: Claimer segmentation
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

2023

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 - 2022

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.