Add helper for computing a creator's 24h trading volume from the trade history table

[Chucks1093]

Summary

The 24h trading volume for a creator is computed inline in the creator detail and trending endpoints independently, each with slightly different time window logic. A shared helper should centralise this calculation so the result is consistent across all surfaces.

Scope

• Add compute24hVolume(creatorId: string, db: Database): Promise<bigint> helper
• Sum the price field of all trade records for the creator within the last 24 hours
• Time window is rolling — based on current time minus 24 hours, not calendar day boundaries
• Add unit tests: trades all within window included, trades outside window excluded, no trades returns 0

Acceptance Criteria

• All trades within the rolling 24h window summed
• Trades outside the window excluded
• No trades returns 0
• Both creator detail and trending endpoints use the helper

ETA: 12 hours

---

Coordinate on Telegram

[vj570145-web]

@vj570145-web has applied to work on this issue as part of the Stellar Wave Program's 7th wave.

I've looked closely at the issue and am confident I can provide a clean, effective resolution.

ℹ️ Repo Maintainers: To accept this application, review their application or assign @vj570145-web to this issue.

[Bilalishaq7]

@Bilalishaq7 has applied to work on this issue as part of the Stellar Wave Program's 7th wave.

gooday maintainer, i can fix this and i'd submit a PR shortly after assignment

ℹ️ Repo Maintainers: To accept this application, review their application or assign @Bilalishaq7 to this issue.

[Marvell69]

@Marvell69 has applied to work on this issue as part of the Stellar Wave Program's 7th wave.

hello, i'd like to work on this issue please

ℹ️ Repo Maintainers: To accept this application, review their application or assign @Marvell69 to this issue.

[drips-wave]

Congratulations, @Marvell69! 🎉 Your application was accepted by the repo's maintainers, and the issue is due on July 30, 2026.

🧑‍💻 @Marvell69: Please resolve the issue such that the repo's maintainers have enough time to review your contribution before the due date. You'll earn Points for completing the issue on-time, which will make you eligible for a share of the Stellar Wave Program's reward pool.

Warning

When opening a PR, please link it to this issue to ensure it gets tracked accurately. Points are awarded when this issue is marked as completed by the maintainer.

🤠 Repo maintainers: Please keep an eye on the contributor's progress and review their work before the due date. You can manage this issue, including adjusting its complexity and points, here.

🌊 Happy Wave 🌊

[grantfox-oss]

🎉 This issue has been marked as completed on GrantFox as part of the Official Campaign | FWC26 campaign!

@Marvell69's PR #629 was approved and merged by @Chucks1093.

🏆 @Marvell69: You earned 35 FoxPoints for this contribution! Your current tier: Explorer (306 total points). Track your full progress on GrantFox.

👏 Great work, @Marvell69! Keep contributing to accesslayerorg.

[drips-wave]

This issue has been completed by @Marvell69 as part of the Stellar Wave Program's 7th Wave 🥳

😎 @Marvell69: You earned 200 Points for completing this issue! After the current Wave ends, you'll be eligible for a percentage of the Wave's reward pool based on the percentage of total points you've earned. Learn more here. You can also Leave a review to share your experience working on this issue.

🧑‍💻 Repo maintainers: How'd the contributor do? Leave a review to share your experience working with them.