Content Deep Dive
Analyzing 5 Million NFT Sales on OpenSea using PostgreSQLRemoved
Blog post from Tiger Data
Post Details
Company
Date Published
Author
Attila Toth
Word Count
5,134
Language
English
Hacker News Points
-
Summary
- The daily volume of ETH spent on assets in one collection can be compared to others using SQL queries. - Daily mean and median sale prices of assets in a specific collection can also be analyzed using SQL queries. - Analyzing the total volume of top buyers over time can help identify patterns in sales. - Complex queries can be used to calculate 30-min mean and median sale prices, OHLCV data per asset, and assets with the biggest intraday price change.