Welcome to our in-depth tutorial on analyzing NFT transactions using SQL! In this video, we’ll walk you through several powerful SQL queries to extract and analyze data from our NFT transaction dataset. By the end of this video, you’ll have a solid understanding of how to manipulate and gain insights from your data.
Here’s what we’ll cover:
1.) 🔗 Overview of the NFT Dataset:
2.) 📊 Total sales in the given time period.
3.) 💸 Top 5 highest transactions (USD): name, ETH price, USD price, date.
4.) 📈 Transaction table: event, USD price, 50-transaction moving average.
5.) 💰 NFT names with average USD sale price (descending order).
6.) 📅 Day of the week: number of sales and average ETH price, ordered by transaction count.
7.) 📝 Transaction summary: seller, buyer, NFT name, date, and rounded USD price.
8.) 👤 View of sales with “0x1919db36ca2fa2e15f9000fd9cdc2edcf863e685” as buyer.
9.) 📉 Histogram of ETH price ranges (rounded to nearest hundred).
10.) 🔀 Union query: highest and lowest NFT purchase prices with status.
11.) 🏆 Most sold NFT each month/year with name and USD price (chronological order).
12.) 📅 Monthly total volume of sales (rounded to nearest hundred).
🔍 Estimated average value calculator: daily representative price excluding outliers.
For the steps in creating the "estimated average value calculator":
a.) 🗂 Subquery: event date, USD price, average USD price (daily) in a temporary table.
b.) 🧮 Filter subquery: exclude USD prices below 10% of daily average, return new estimated daily average.
⏰ * Time Stamp:
00:00 📝 Overview and Objective SQL Project
01:20 📊Total sales in the given time period
01:48 💸Top 5 highest transactions (USD): name, ETH price, USD price, date
02:50 📈 Transaction table: event, USD price, 50-transaction moving average
06:25 💰 NFT names with average USD sale price (descending order)
07:50 📅 Day of the week: number of sales and average ETH price, ordered by transaction count
12:25 📝 Transaction summary: seller, buyer, NFT name, date, and rounded USD price
15:50 👤 View of sales with “0x1919db36ca2fa2e15f9000fd9cdc2edcf863e685” as buyer
17:45 📉 Histogram of ETH price ranges (rounded to nearest hundred)
19:45 🔀 Union query: highest and lowest NFT purchase prices with status
22:15 🏆 Most sold NFT each month/year with name and USD price (chronological order)
28:05 📅 Monthly total volume of sales (rounded to nearest hundred)
30:00 🔍 Estimated average value calculator: daily representative price excluding outliers
💸 *SQL Queries and Data Repository:
Find the complete Queries and Data used in this video on our GitHub repository
github.com/AbhisheakSaraswat/...
👉 Python NumPy Playlist: • Python Numpy Tutorial
👉 Python Excel Automation: • Excel Automation Using...
👉 Python Teaser: • A Beautiful Python Pro...
👉 Python Pandas Tutorial: • Python Pandas Tutorial...
👉 Python Playlist: • Python Tutorial for Be...
👉 Python Data Structure Playlist: • Python Data Structure
👉 Python OOPs Playlist: • Object Oriented Progra...
👉 Python Project for Data Analysis- Exploratory Data Analysis | Data Analyst Project : • Python Data Science: A...
👉 Telegram Link: t.me/+32-TodtiOvo2Njk9
👉 Medium Story: 📖 / programmingisfun
👉 LinkedIn: / abhisheak-saraswat
👉 ProgrammingIsFun: / 10365183
13 авг 2024
