Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

generate candlestick data from oracle_snapshots #19

Open
moodysalem opened this issue Oct 17, 2024 · 6 comments · May be fixed by #21
Open

generate candlestick data from oracle_snapshots #19

moodysalem opened this issue Oct 17, 2024 · 6 comments · May be fixed by #21
Assignees
@FriendlyLifeguard
Labels
good first issue Good for newcomers

Comments

@moodysalem
Copy link
Member

moodysalem commented Oct 17, 2024 •
edited
Loading

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
@moodysalem moodysalem changed the title price chart view from oracle_snapshots table generate price chart from oracle_snapshots Oct 17, 2024
@moodysalem moodysalem changed the title generate price chart from oracle_snapshots generate candlestick data from oracle_snapshots Oct 17, 2024
@moodysalem moodysalem added the good first issue Good for newcomers label Oct 17, 2024
@Benjtalkshow
Copy link

Benjtalkshow commented Oct 17, 2024 •
edited
Loading

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
Copy link
Member Author

@moodysalem Is this issue open for contribution?

Yes you can apply on OnlyDust

@Jemiiah
Copy link

Jemiiah commented Oct 18, 2024

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

@Benjtalkshow
Copy link

@moodysalem Is this issue open for contribution?

Yes you can apply on OnlyDust

I have applied through onlydust sir

@Jemiiah
Copy link

Jemiiah commented Oct 18, 2024

Thank you ♥️ @moodysalem

@FriendlyLifeguard
Copy link

I'd like to take this issue.

@FriendlyLifeguard FriendlyLifeguard linked a pull request Jan 9, 2025 that will close this issue
Open
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@FriendlyLifeguard FriendlyLifeguard

Labels
good first issue Good for newcomers
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

Feat: OHLC function FriendlyLifeguard/indexer
4 participants
@moodysalem @FriendlyLifeguard @Benjtalkshow @Jemiiah