Welcome to my page where I document and explore web3 and our decentralized future through words, data and code.

Paul Apivat

Paul Apivat

data in web3

the internet

Enabling capital, coordination and culture on Web3 through on- and off-chain data.


Contributor at Bankless DAO ( POAPs). I work primarily in the Analytics and Developer’s Guild to support other guilds including Education, Treasury, Marketing, Writing and Operations (see our Notion).

On-Chain Data

Off-Chain Data

I also enjoy visualizing data.

Past writings can be found on Medium, Quora, dev.to, Hashnode and Notion.

Check out my NFTs

Find me on Twitter.


  • Data Analytics and Visualization
  • SQL, Python, R
  • Ethereum, Web3, Bitcoin


  • Data and Web technologies, 2018 - present


  • Organizational Psychology (phd), 2014

    Teachers College, Columbia University

Recent Posts

Online Writing: Medium | Quora | Hashnode | dev.to | Notion

Learn Foundational Ethereum Topics with SQL

A tutorial to help readers learn how Ethereum works by running SQL queries and getting a feel for on-chain data

Pad Thai is a Terrible Choice

Using R and Python to scrape, pre-process, wrangle and visualize data.