Home / Companies / Tiger Data / Blog / Post Details
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
Company Posts That Month
12
Language
English
Hacker News Points
-
Post removed?
Yes
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.

Trends Found in this Post

No tracked trend matches for this post yet.

Use This Data

Use this post, company, and trend context to find content marketing opportunities, perform competitive analysis, or address product feature gaps via the Plushcap MCP server or the Plushcap API.