Import/maintain list of US stock tickers + prices

[Shpigford]

High level summary

We need to import all US stock tickers and then keep prices updated on an ongoing basis. This is foundational for future feature work.

There's code already written that uses Polygon.io for US stock data and that should be fine to get us started as they have a free plan for individual use.

A good bit of this is already done in the codebase, but it was based around only pulling in necessary tickers based on Plaid + Finicity imports.

We're about to allow people to manually enter any stock and have it track it, so we need to rework things a bit.

Functional notes/scope

• Relevant database tables/models: Security, SecurityPricing
• A listing of all symbols: https://polygon.io/docs/stocks/get_v3_reference_tickers
• Stock data import will need to happen either on app setup or some sort of check each time the app is booted
• A daily job needs to be run to check for new tickers
• Should pull as much historical pricing data as Polygon allows for a given API key (they have different pricing plans if folks want to pay for more data). This is then stored in SecurityPricing.
• We should think about allowing for "real time" pricing. The Polygon free plan only has "daily" pricing data, but if you're on a paid plan you can get more updated data. Need some sort of background job for this.
• We need to track what stock exchange a given symbol is associated with (I don't believe this is currently tracked in Security)
• As far as database modeling goes, this should err towards flexibility to add additional stock exchanges and tickers in the near future.
• There's no frontend component to this. It's purely about establishing available data for use in other features.
• This will be used by other parts of the app, such as #131

Bounty

There's a $250 bounty for this.

[Shpigford]

/bounty $250

[algora-pbc[bot]]

💎 $250 bounty created by maybe-finance 🙋 If you start working on this, comment /attempt #166 to notify everyone 👉 To claim this bounty, submit a pull request that includes the text /claim #166 somewhere in its body 📝 Before proceeding, please make sure you can receive payouts in your country 💵 Payment arrives in your account 2-5 days after the bounty is rewarded 💯 You keep 100% of the bounty award 🙏 Thank you for contributing to maybe-finance/maybe!

👉 Add a bounty • Share on socials

Attempt	Started (GMT+0)	Solution
🔴 @mrkirthi-24	Jan 19, 2024, 8:13:10 PM	WIP
🟢 @karan0handa	Jan 20, 2024, 2:33:48 PM	WIP
🟢 @tmyracle		#213

[mrkirthi-24]

/attempt #166

Algora profile	Completed bounties	Tech	Active attempts	Options
@mrkirthi-24	2 bounties from 1 project	JavaScript, Python		Cancel attempt

[crnsh]

/attempt #166

Options

• Cancel my attempt

[mrkirthi-24]

Given my lack of expertise with TSDB, I'd like to delegate this issue to @karan0handa. I appreciate the opportunity, @Shpigford. I'm eager to contribute to the frontend and will proudly do so until I gain proficiency in the backend in the upcoming days. Thank you!

[algora-pbc[bot]]

🎉🎈 @tmyracle has been awarded $250! 🎈🎊

• Share on socials
• Give feedback

[tmyracle]

Closed by #213