Store Historic Values

So I'm currently working on a project where I want to display the changes of floor prices of NFT collections in the past 24h, 7days, 1 month. I'm tracking the current floor price in realtime and updates the floor field for that collection. Now I was wondering what the best way would be to store the historic values, since having a field that updates everyday at 0:00 doesn't seem quite like a good solution. Every help is appreciated : )
6 Replies
Unknown User
Unknown User3y ago
Message Not Public
Sign In & Join Server To View
NotLuksus
NotLuksusOP3y ago
Like making the floor price its own table with a connection to the collection? And in that table have a field for dateTime & the price at that point? I thought about that and thought that aswell, but wasn't sure if that is the effective / correct way todo it
Unknown User
Unknown User3y ago
Message Not Public
Sign In & Join Server To View
NotLuksus
NotLuksusOP3y ago
Prisma with prostgres But thank you!
Unknown User
Unknown User3y ago
Message Not Public
Sign In & Join Server To View
Gaurang
Gaurang3y ago
dayjs or date-fns are both valid moment substitutes. Dayjs def. has a smaller footprint.
Want results from more Discord servers?
Add your server