Company
Date Published
June 3, 2024
Author
Attila Toth
Word count
5134
Language
English
Hacker News points
None

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.