query 10 tech company network

PHOTO EMBED

Tue Jun 15 2021 02:34:39 GMT+0000 (UTC)

Saved by @suibhne #bash

/*
Accenture - 573.0, ACN 
Microsoft -  20601.0, MSFT 
SalesForce - 69444.0, CRM 
Apple - 2355.0, AAPL 
Alphabet - 116351.0, GOOGL 
Amazon - 1703.0, AMZN 
Tesla - 1650150.0, TSLA 
Facebook- 1820060.0, FB 
Adobe - 808.0, ADBE 
Oracle - 23295.0, ORCL 
*/

parm = {'boardids': (573.0, 20601.0, 69444.0, 2355.0, 116351.0, 1703.0, 1650150.0, 1820060.0, 808.0, 23295.0)}

//query
comp_net = conn.raw_sql('SELECT * FROM boardex.na_wrds_company_networks WHERE boardid in %(boardids)s limit 100000', params=parm)
content_copyCOPY