I would be particularly grateful for some sample code.
Thank you!
Hi @Agsoler,
I believe this article may be what you're after: https://developers.lseg.com/en/article-catalog/article/run-google-bigquery-sql-with-vscode When it comes to the SQL query nessesary to collect the data you are after, please note that this LSEG Developer Q&A Forum is for LSEG API technical questions only. For content questions such as yours, please use myaccount.lseg.com.
If the "Run Google BiqQuery SQL inside VS Code" article does not answer your question as expected, please do let me know as a comment to this answer.