User:JustHydrogen

SELECT DISTINCT ?company ?companyLabel ?cik ?stockExchange ?stockExchangeLabel ?tickerSymbol WHERE {  
  ?company p:P361 ?partOfStatement. # part of
  ?partOfStatement ps:P361 wd:Q242345. # S&P 500
  
  # Get stock exchange and ticker symbol
  ?company p:P414 ?exchangeStatement. # stock exchange
  ?exchangeStatement ps:P414 ?stockExchange.
  OPTIONAL {
    ?exchangeStatement pq:P249 ?tickerSymbol.
  }
  OPTIONAL {
    ?company wdt:P5531 ?cik.
  }
  
  # Exclude entities with an end date
  FILTER ( NOT EXISTS { ?partOfStatement pq:P582 ?endPartOf. } )
  FILTER ( NOT EXISTS { ?exchangeStatement pq:P582 ?endExchange. } )
  
  # Filter for specific stock exchanges (Nasdaq or New York Stock Exchange)
  FILTER (?stockExchange IN (wd:Q82059, wd:Q13677))
  
  # Get labels
  SERVICE wikibase:label { 
    bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". 
    ?company rdfs:label ?companyLabel.
    ?stockExchange rdfs:label ?stockExchangeLabel.
  }
}