Quantopian's community platform is shutting down. Please read this post for more information and download your code.
Back to Community
get data on etf for further backtest

hello, guys

I want to receive information on ETF for dates starting from 1998
1 ETF ticker
2 trading volume
3 description etf example ( DIA - SPDR Dow Jones Industrial Average ETF)
4 closing price
5 exclude shoulder and inverse ETF
6 then I want to write all the data into a simple database like

wrote the following script (atteched):

help me please

how can i solve this problem?

thank!

3 responses

Database like sqllite

The biggest issue one will face doing this on Quantopian is getting the data into an external database. Quantopian doesn't allow for exporting data from the site. However, why not keep all your work on Quantopian and not use a database? Pandas dataframes are much easier to work with IMHO.

I have poor knowledge of python to do a backtest - so I want to translate data and do a backtest in Java. but I don't know yet
can I get ETF data even on the website