Tracking 1d, 7d, and 30d Collection Trends - Githubissues

holaplex / indexer

Index Solana data using a Geyser plugin (downstream service cluster)

https://holaplex.com

GNU Affero General Public License v3.0

162 stars 38 forks source link

Tracking 1d, 7d, and 30d Collection Trends #751

Closed kespinola closed 2 years ago

kespinola commented 2 years ago

Goal

Along with volume tracking over time periods collection trends should also include volume and sales over the same time intervals.

Requirments

Track in a table the 1d, 7d, and 30d collection trends for both mcc and non-mcc collections.
Collections trends should be volume, sales, and floor
Only base on magic eden for now. Queries will be extended to include additional marketplaces.

When there is no data for a column coalesce to 0 for sorting purposes

collection_trends
-----------------
collection
1d_volume
prev_1d_volume
1d_floor_price
prev_1d_floor_price
1d_sales_count
prev_1d_sales_count
7d_volume
prev_7d_volume
7d_floor_price
prev_7d_floor_price
7d_sales_count
prev_7d_sales_count
30d_volume
prev_30d_volume
30d_floor_price
prev_30d_floor_price
30d_sales_count
prev_30d_sales_count