generate candlestick data from oracle_snapshots

[moodysalem]

need to be able to query the price chart for any token pair from a view based on oracle_snapshots table

optionally it could be a postgres function as well that returns the data

need to be able to query by base_token and quote_token for a specific time interval ('1 h') and get a list of points for a candlestick chart (open, high, low, close) using only snapshot data

high and low are just whatever the high/low tick was for that period

open could just be the tick from the last interval, and close can be the twap over that interval

we do something similar here https://github.com/EkuboProtocol/oracle-extension/blob/6f6924d7dd3b1bf9e111c23e24950dd4a0c80d6c/src/price_fetcher.cairo#L201-L315

[Benjtalkshow]

I am applying to this issue via OnlyDust platform.

My background and how it can be leveraged

@moodysalem I am a Full Stack Developer with extensive experience in blockchain development, specializing in Next.js, TypeScript, Node.js, and Rust. With over 31 contributions across projects in the OnlyDust ecosystem, I’ve developed a strong proficiency in delivering high-quality solutions and tackling complex issues under tight deadlines. My experience spans frontend, backend and a deep understanding of optimizing and maintaining scalable codebases.

I will be glad if this task is assigned to me thanks.

[moodysalem]

@moodysalem Is this issue open for contribution?

Yes you can apply on OnlyDust

[Jemiiah]

@moodysalem I as well would want to work on this issue

[Benjtalkshow]

@moodysalem Is this issue open for contribution?

Yes you can apply on OnlyDust

I have applied through onlydust sir

[Jemiiah]

Thank you ♥️ @moodysalem