Penelope Lai
     
  1. Chat Buddy (2024)  
  2. AVAXGods NFT Card Game (2024) 
  3. AlphaHub (2024)
  4. Crossed-Out (2023)
  5. Cyberfeminism in Web3 (2022)
  6. The Democracy Trap of DAO (2022)
  7. Onchain Data Visualization (2021-2024)

About
Substack
Instagram

©2024_Penelope_Lai

Onchain Data Visualization





Decentralized Creation and Trading: A Quantitative Case Study on NFT Marketplace OpenSea (2021)

Tools: Python (Data Scraping) + OpenRefine (Data Cleaning) + Tableau (Data Visualization)

Through data scraping, data cleaning and data visualization, this project investigates the underlying trading information of the mainstream NFT trading platform OpenSea by exploring questions like “ How does OpenSea’s trading data change overtime? Why?”, “What is the difference between OpenSea’s three blockchains (Ethereum, Polygon, and Klaytn)?”, and “What is the search information about OpenSea? (Changing index,  Geographic distribution, and  Top ranked related topics and queries), etc.

Click here to access my Tableau Public page for the interactive visualization and click here for the project documentation.

**This was my final project for the VMS 366L course at Duke University.





Persona NFT Data Analysis on Dune Analytics (2024)

Tools: SQL (for querying the data)

Persona is the core series of NFTs in the game ecosystem of Unagi, an onchain game development Company. Persona holders will receive direct rights to the ecosystem token UNA. This is the first comprehensive data dashboard of Persona at Dune✨ 

Created with an appreciation of its design aesthetics

Click here to access the Dune Dashboard to view its real-time data updates




Uniswap V3's Liquidity Pools Analysis (2024)

Tools: SQL (for querying the data)

This  dune analytics dashboard leverages Uniswap V3's liquidity pools on the Ethereum Mainnet as a case study, encompassing the following key elements:
  • Total Number of Liquidity Pools: A comprehensive count of all existing liquidity pools.
  • Liquidity Pools by Fee Level: Distribution of liquidity pools across different fee tiers.
  • Weekly New Pool Creation: Summary of the total number of new liquidity pools created each week.
  • Daily New Pool Creation (Last 30 Days): Total number of new liquidity pools created daily over the past 30 days.
  • Weekly New Pools by Fee Level: Aggregated count of new liquidity pools by week, categorized by fee level
  • Top Token by Pool Count: Identification of the token associated with the highest number of pools.
  • Latest 100 Liquidity Pools: Detailed records of the most recently created 100 liquidity pools.

Click here to access the Dune Dashboard to view its real-time data updates