Query helper in collections db queries queries::collections::trends(...)
Dataloader to lookup associated collection based on the mint address of collection NFT for MCC and hashmd5 ID for non-mcc collections. The dataloader can either use a union (preferred) or take all the identifiers group them by mcc and non-mcc and then do 2 queries to find the all the collection objects.
Goal
Provide a query interface to the new collection trends table that tracks 1,7, and 30 day volume, floor, and sales.
Query
Requirements