Analyzing 5 Million NFT Sales on OpenSea using PostgreSQL
What's this blog post about?
- 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.
Company
Timescale
Date published
June 3, 2024
Author(s)
Attila Toth
Word count
5134
Hacker News points
None found.
Language
English