How do I list all symbols?

[meglio]

I tried this:

select symbol from finance_quote where symbol ilike '%btc%';

but it throws an error:

Error: rpc error: code = Internal desc = 'List' call for table 'finance_quote' is missing 1 required qual: column:'symbol' operator: =
 (SQLSTATE HV000)

So, how do I list all symbols?

[e-gineer]

The finance plugin mostly uses the Yahoo API under the hood, and they don't support (as best I can find) a way to download the list of symbols (stackoverflow discussion).

The finance_quote table requires the symbol column to be defined in the where clause for all queries to the table. It then uses that information under the hood to get quotes for that specific symbol. Docs and example queries.

We'd certainly welcome ideas (issues) or contributions (PRs) to expand and improve the finance plugin!