Skip to content

Files

Latest commit

540b708 · Sep 27, 2024

History

History
22 lines (14 loc) · 822 Bytes

README.md

File metadata and controls

22 lines (14 loc) · 822 Bytes

SQL-project: NFT Data Analysis Project

Introduction

This project analyzes Cryptopunks' sales data from January 2018 to December 2021, exploring trends and insights in the NFT market.

Objectives

  • Determine total sales and top 5 expensive transactions.
  • Calculate moving average of USD prices and average sale price of NFTs.
  • Analyze sales trends by day of the week.
  • Create descriptive summaries for each sale.
  • Identify specific wallet transactions and visualize price distribution.
  • Aggregate highest and lowest purchase prices for each NFT.
  • Determine monthly/yearly top-selling NFTs.
  • Calculate total sales volume and wallet transaction count.
  • Develop an estimated average value calculator.

This project provides valuable insights into Cryptopunks' NFT market dynamics and transaction trends.