What's in the dataset

SELECT
  f.period_end,
  fa.value / 1e9 AS revenue_billions
FROM fact fa
JOIN filing f  ON fa.filing_id = f.filing_id
JOIN entity e  ON f.entity_id = e.entity_id
WHERE e.ticker = 'AAPL'
  AND fa.concept = 'us-gaap:Revenues'
  AND f.form_type = '10-K'
ORDER BY f.period_end DESC
LIMIT 10;

SELECT
  e.ticker,
  e.company_name,
  debt.value / equity.value AS debt_to_equity
FROM entity e
JOIN index_membership im ON e.entity_id = im.entity_id
  AND im.in_sp500 = true
JOIN filing f ON e.entity_id = f.entity_id
  AND f.form_type = '10-K'
JOIN fact debt ON f.filing_id = debt.filing_id
  AND debt.concept = 'us-gaap:LongTermDebt'
JOIN fact equity ON f.filing_id = equity.filing_id
  AND equity.concept = 'us-gaap:StockholdersEquity'
WHERE e.sic_description LIKE '%technology%'
ORDER BY debt_to_equity DESC;

SELECT
  e.ticker,
  (ocf.value - capex.value) / 1e6 AS fcf_millions
FROM entity e
JOIN filing f ON e.entity_id = f.entity_id
  AND f.form_type = '10-Q'
  AND f.period_of_report = (
    SELECT MAX(period_of_report)
    FROM filing
    WHERE entity_id = e.entity_id
      AND form_type = '10-Q'
  )
JOIN fact ocf ON f.filing_id = ocf.filing_id
  AND ocf.concept = 'us-gaap:NetCashProvidedByUsedInOperatingActivities'
JOIN fact capex ON f.filing_id = capex.filing_id
  AND capex.concept = 'us-gaap:PaymentsToAcquirePropertyPlantAndEquipment'
ORDER BY fcf_millions DESC
LIMIT 20;