I am doing a simple Stock Data Presenter Project in Python. I pick SQLITE for DBMS

I need help in those problem

$-$Make a table of historical stock information from API in a database, and a table for stock information

$-$Write them in sqlite and connect to python.

We well fetching data from financialmodelingprep.com with apikey$=$wHHYVjp$7$Pox$9$LFc$01$LyQRcr$7$IFd$8$MU$0$K

Thanks