Query Library
Search a comprehensive library of pre-built queries designed to help you quickly maximize the value of our data offerings. For each query, the library provides a brief description along with the data packages necessary to execute the query.
S&P Capital IQ Estimates
Returns the Current Year Revenue Estimate For a Company
Bond to Equity Factors
Returns Bond Equity Ratios Analysis
Bond to Equity Factors
Returns Bond To Equity Ratios Records For Specific Date And UniverseID
Bond to Equity Factors
Returns Bond To Equity Factors For Specific Trading ItemID
S&P Capital IQ Estimates
Returns a Series of Current EPS Values For the 2024 Fiscal Year
S&P Capital IQ Estimates
Returns all NTM mean EPS data as it existed at a particular point in time
S&P Capital IQ Estimates
Identifying Consensus Estimates Excluding Stock-Based Compensation and or Amortization of Intangibles Using Footnote
Retail Flow
Returns Net Buy Sentiment Analysis For Retail Equity Trades
Retail Flow
Returns Retail Equity Trade Summary For TradingitemID
Retail Flow
Returns Net Buy Sentiment Analysis For Retail Equity Trades
Retail Flow
Returns Retail Equity Trade Summary For TradingitemID
SNL Insurance Regulatory Data
Returns Solvency II Datapoints For Input European Countries
Visible Alpha Estimates
Returns CRM Visible Alpha Estimates Industry Metrics Module
Visible Alpha Estimates
Returns CRM Visible Alpha Estimates Industry Metrics Pivot Module
S&P Capital IQ Financials
Returns Financial Reporting Data By Company and Financial Statement Type
S&P Capital IQ Estimates
Returns 10 Year Average TEV/EBITDA Estimates For Reported Forward One Period For A Company
S&P Capital IQ Financials
Returns Financial Data for a Specific dataItem Across Multiple Companies in an Industry
SNL Insurance Regulatory Data
Returns Direct Written Premiums By Line Of Business For A Particular Company Across The US In 2024
SNL Insurance Regulatory Data
Returns Comprehensive Overview Of Direct Written Premiums By Line Of Business Across The US In 2024
Ownership
Returns Ownership Detailed For Selected Ticker With Categorized Owner Types
Ownership
Returns Ownership Summary For Selected Tickers Over Last Five Periods With Categorized Owner Types
Physical Risk
Returns Physical Risk Company Headquarters And Asset Exposure Score Data Compared To County, State, And Subnational Exposures For A Given Forecast Year And Scenario
Physical Risk
Returns Company Level Physical Risk Data For A Given Forecast Year And Scenario
S&P Capital IQ Financials
As Reported Transparency
SNL RateWatch Depository Rates & Fees
Rates During A Specific Timeframe
SNL RateWatch Depository Rates & Fees
NY Branches
SNL RateWatch Depository Rates & Fees
Average Bank Product Rate
SNL RateWatch Depository Rates & Fees
Branches And Location
SNL RateWatch Depository Rates & Fees
Parent Operating Bank
SNL RateWatch Depository Rates & Fees
Competitive Interest Rates
SNL RateWatch Depository Rates & Fees
Standard Interest Rates
SNL RateWatch Depository Rates & Fees
Bank Product Rates
Panjiva Supply Chain Intelligence
Leverages Snowflake Dynamic Scripting To Provide Import Statistics For Specified Companies
S&P Capital IQ Estimates
Returns Estimate EPS Consensus Mean And P/E Ratio
OTC Derivatives Data
Returns Equity VolSwap Volatility And Discount Factor Data
OTC Derivatives Data
Returns Equity VarSwap Volatility And Discount Factor Data
OTC Derivatives Data
Returns Equity Index Bid Ask Volatility And Forward Curve Data
OTC Derivatives Data
Returns Equity Stock ETF Bid Ask Volatility And Forward Curve Data
Headcount Analytics
Top And Bottom 10 Companies In A Metro Area Based On 12 Months Growth Rate
Headcount Analytics
Headcount By Top 10 Next Employers
Headcount Analytics
Returns Monthly Headcount Changes For A Company
Headcount Analytics
Role And Department Tenure For A Company
Headcount Analytics
Monthly Headcount Data With Transactions Rounds Of Funding Information For A Company
Headcount Analytics
Headcount By Top 10 Previous Employers
Headcount Analytics
Returns Top And Bottom Metro Growth Areas For An Industry
Base Data
Returns 365 Days Average Fxrate Historical Data
Business Relationships Analytics
Returns Business Relationship Analytics Report For Customer Supplier Dynamics
S&P Capital IQ Financials
Returns Point In Time EVIC Data Available As Per The Observation Date For MI Keys
CDS Pricing
Returns Credit Default Swaps Data For Credit Indices
CDS Pricing
Returns Credit Default Swap Pricing Data For Credit Tranches
CDS Pricing
Return Credit Default Swaps Pricing Data For Single Names
S&P Capital IQ Financials
Returns Unconsolidated Financial EVIC Data Available As Per The LTM Holding Dates
Index Data
Returns Levels Of Index Hierarchy Using Index Key For A BMI Index
Private Company Financials
Returns Private Company Financials EVIC Data As Per The Observation Date
RatingsXpress®: S&P Credit Ratings
Returns Financials Metrics And Issuer Ratings With Filtered Out Muni Ratings
Market Data
Returns Carryforward Market Pricing Data For The Specified Date Range
RatingsXpress®: S&P Credit Ratings
Returns Financials Metrics And Bond Ratings With Filtered Out Muni Ratings
OTC Derivatives Data
Returns Equity Index Volatility Forward Curve And Dividend Yield Data
OTC Derivatives Data
Returns Equity Stock ETF Volatility Forward Curve And Dividend Yield Data
S&P Capital IQ Financials
Returns Latest EVIC Data Available As Per The Observation Date
S&P Capital IQ Financials
Returns Point In Time EVIC Data Available As Per The Observation Date
Trucost ESG Financial and Market Data
Returns Point In Time EVIC Data Available As Per The Observation Date
Key Developments
Query Maps Keydevs Events With CIQEstimates And CIQFinancials
Trucost Environmental
Returns Air Pollutants Direct Cost For Chinese Private Companies Involved In Bituminous Coal And Lignite Surface Mining
Trucost Environmental
Returns Top 10 Private Companies In United Kingdom With Highest Scope 3 Downstream Emissions In 2019
Trucost Environmental
Returns Intensity Metrics For Jaguar Land Rover Automotive Plc
Trucost Environmental
Returns Private Companies With Over 75 Percent Revenue In Crude Petroleum And Natural Gas Extraction Sector
Trucost Environmental
Returns The Latest Data On Absolute Carbon Emissions For Greenhouse Gas(GHG) Scope 1 By InstitutionIDs
Trucost Environmental, Trucost Environmental: Private Companies
Returns Latest Available Data For Greenhouse Gas(GHG) Scope Of An InstitutionId
CreditPro®
Returns The Instrument Level Details
Machine Readable Transcripts
Returns Fiscal Years And Fiscal Quarters For All Latest Transcripts
Base Data
Returns Year On Year Average Exchange Rate For All Countries
Market Data, S&P Capital IQ Estimates, S&P Capital IQ Financials
Returns Financial Multiples And Forward Estimates Data
S&P Capital IQ Estimates
Returns TEV/NTM EBITDA Values For Time Series
Compustat® Financials
Returns Consolidated Financial Data For Company As Of Observation Date
Market Data, S&P Capital IQ Financials
Returns TEV And EBITDA Ratios For Selected Companies As Of An Observation Date
S&P Capital IQ Financials
Returns Premium Financials, Market Capitalization, And Market Prices For The Trading Items Pivot
S&P Capital IQ Estimates
Returns Time Series Forward Estimate EBITDA For A Ticker
Business Entity Cross Reference Service (BECRS)
Returns Risk Score Analysis Data For DUNS And GICS Identifiers
Physical Risk: Country, Subnational & Municipal
Returns Physical Risk GDP Exposed Metric For All US Geographies
Index Data
Returns S&P500, R2000 And FALLWORLD Index Constituents And Market Data By Sector As Of A Specified Date
Market Data
Returns Analysis Of Unadjusted Outstanding Shares For Stock Splits
Visible Alpha Estimates
Identify Companies With Financial Data
Visible Alpha Estimates
Retrieve Latest Reported Revenue
Visible Alpha Estimates
Identify Business Group And Industry For Tickers
Visible Alpha Estimates
Find Latest Estimated Revenue
Visible Alpha Estimates
Explore Standard Financial Templates
Visible Alpha Estimates
Discover KPIs For A Business Group
Visible Alpha Estimates
Identify Business Groups For A Company
Key Developments
Returns Key Developments In Venture Vapital (VC) And Private Equity (PE) Firms
Visible Alpha Estimates
Find Companies In A Business Group
Visible Alpha Estimates
Access Latest Ticker Data
Visible Alpha Estimates
Access Latest Consensus For Various Periods
Visible Alpha Estimates
Access Core Financial Templates
Visible Alpha Estimates
Rank Key Performance Indicators
Visible Alpha Estimates
Calculate EPS Surprise
Visible Alpha Estimates
Track Revenue Estimate Changes
Visible Alpha Estimates
Recreate Insights Application Views
Visible Alpha Estimates
Discover Company Specific Parameters
Visible Alpha Estimates
Retrieve Quarterly Actuals For A Company
S&P Capital IQ Financials
Returns Latest LTM Total Revenue Value Along With Annual Values
Visible Alpha Estimates
Explore Industry And Business Groups For Companies
Visible Alpha Estimates
Track IPhone Sales Over Time
Visible Alpha Estimates
Identify All Companies In A Business Group
Visible Alpha Estimates
Calculate Revenue Weight By Segment
Visible Alpha Estimates
Locate Business Model Templates
Visible Alpha Estimates
Analyze Consensus Time Series
Visible Alpha Estimates
Identify Companies With Consensus Data
S&P Capital IQ Estimates
Returns Forward Estimates With Currency Conversion
Company Connections: Detailed Estimates
Returns Company Connections For Compustat Gvkey And Iid
Base Data, Market Data, S&P Capital IQ Financials
Returns Currency Adjusted Financial Metrics For Trading Item ID
S&P Capital IQ Estimates
Returns Estimates For Reported Forward Five Periods
SNL Insurance Regulatory Data
Returns Paid Loss Ratios By Accident Year Loss Triangle
SNL Insurance Regulatory Data
Returns Type SubType And Location For Product Filings Using Legacy Insurance Packages
S&P Capital IQ Estimates
Returns Estimate Consensus Coverage Between 2014-2021 For Companies Listed On The Stock Exchange Of Hong Kong Ltd.
Visible Alpha Estimates
Revision History Of Estimates For A KPI
Visible Alpha Estimates
Earnings Surprise For Every KPI For Every Company Within A Business Group
Visible Alpha Estimates
Returns SD Balance Sheet Template
Visible Alpha Estimates
Measuring Financial Health Via Debt To Equity Ratio
Visible Alpha Estimates
Use ParameterID To Find Company Specific Line Items
Visible Alpha Estimates
Latest Revenue Growth Rate Calculation
Visible Alpha Estimates
Quarterly Earnings Trend For A Specific Company
Visible Alpha Estimates
Use SDPARAMETERID To Find All Standardized Financial Metrics
S&P Capital IQ Estimates, Visible Alpha Estimates
Blending Visible Alpha Estimates With CIQ Estimates For Industry Leaders In Pharmaceuticals
Base Data, Visible Alpha Estimates
Converting Visible Alpha Estimates Using SP Foreign Exchange Rates On A Specific Date
Base Data, Visible Alpha Estimates
Linking The Visible Alpha Esimates Vacompanyid To The SP Capital IQ CompanyID
Market Data, Visible Alpha Estimates
Connecting Visible Alpha Estimates To CIQ Market Data To Get Daily Pricing And Market Capitalization
Ownership
Returns Recursive Fund Ownership Hierarchy With Company Information, Shareholding, And Ownership Metrics Across Multiple Levels
Base Data
Returns Comprehensive Company Details
Panjiva Supply Chain Intelligence
Returns First Instance Of The Fully Matching HS Code For A Given PanjivaRecordId
Physical Risk: Country, Subnational & Municipal
Return Comparison Of Portugal And Spain Population Percentage Exposure To Extreme Heat
Securitized Products Pricing
Returns The Recent Instrument Prices
Physical Risk: Country, Subnational & Municipal
Returns Subnational Level Physical Risk Absolute Hazard Frequencies For All Countries
Physical Risk: Country, Subnational & Municipal
Returns Country Level Physical Risk Exposure Scores For All Countries Within Subregion
Government, Supranational, Agency and Corporate (GSAC) Bond Pricing
Returns The GSAC Pricing Data For ISINs
Government, Supranational, Agency and Corporate (GSAC) Bond Pricing
Returns Comprehensive Trade Statistics
Government, Supranational, Agency and Corporate (GSAC) Bond Pricing
Return Liquidity Average Per ISIN Or ISINs
Government, Supranational, Agency and Corporate (GSAC) Bond Pricing
Returns The Comparative Liquidity For ISINs
Physical Risk
Returns Physical Risk Asset Level Data
Business Entity Cross Reference Service (BECRS), Company Intelligence
Returns Ultimateparent Details With Levels Recursively For A Given Company
Panjiva Supply Chain Intelligence
Returns Import And Export Shipment Statistics For A Specified Company And Its Subsidiaries Based On CompanyID, Country, Start Date, And EndDate, Including Imports And Exports Of All 19 Countries
Compustat® Financials
Returns MarketCap For All Compustat GVKeys On A Particular Day
Securities Finance: Short Interest Data
Returns Buyside Instrument Data Over The Last Seven Years
Securities Finance: Short Interest Data
Returns All US Equity Instruments Ranked By Active Utilization
Securities Finance: Short Interest Data
Returns Top Ten US Equity Instruments Ranked By The Percentage Of Outstanding Shares On Loan
Securities Finance: Short Interest Data
Returns All US Equities With A Value On Loan Greater Than One Million
Securities Finance: Short Interest Data
Returns The Top Ten UK Equities Ranked By Percentage Of Shares Outstanding On Loan
Index Data
Returns Constituents And Weights Using MSCI Daily Index Data Using S&P Capital IQ Index Data Xpressfeed
Securities Finance: Short Interest Data
Returns Value On Loan For The Last Three Years
Index Data
Returns Constituents And Weights Using MSCI Month-End Index Data Using S&P Capital IQ Index Data Xpressfeed
S&P Capital IQ Financials
Returns P/E Ratio For SP 500 As Per An Observation Date Using CIQ
Physical Risk: Country, Subnational & Municipal
Returns State Level Municipal Physical Risk Data
S&P Global EU Taxonomy Data
Returns EUT As Reported Data For Iberdrola S.A. For Year 2022
S&P Global EU Taxonomy Data
Returns Revenue Level Alignment Metrics For Iberdrola S.A.
S&P Global EU Taxonomy Data
Returns Companies In France With Eligible Revenue Exposure Percentage Revenue For Manufacturing Sector
S&P Global EU Taxonomy Data
Returns The Total Eligible And Total Aligned Data Split By Revenue For Iberdrola, S.A.
S&P Global EU Taxonomy Data
Returns Sector Level EUT Independent Assessment Data For Iberdrola, S.A. For Latest Year
S&P Global EU Taxonomy Data
Returns The Company Level EUT Independent Assessment Data For Iberdrola, S.A. For Latest Year
Physical Risk
Returns Physical Risk Asset Financial Impact Data For Companies For A Forecast Year And Scenario Level Using Dynamic Pivot
Market Data, S&P Capital IQ Estimates
Returns Average TEV/NTM Total Revenue Value For A Company For An Observation Year
Global Events
Returns All Participants In Conferences Announced By A Company
Global Events
Returns Earnings Calls For A Company With Additional Details
Global Events
Returns Earning Calls For A Company
Global Events
Display List Of Earnings Calls For Southwest Airlines
Global Events
Returns Linkage Of Transcripts To Events
Global Events
Display All Participants In HSBCs Conferences Announced In The Last Three Years
Global Events
Display List Of Speakers CFOs For A Company
Global Events
Earnings Call Analysis
Global Events
Display All Charles Schwab Corporation Board Meetings
Global Events
Display After Market Earnings Releases For A Specific Date
Global Events
Returns Speakers Who Were CFOs At That Time For A Companys Conference
EU Sustainable Finance Disclosure Regulation (SFDR)
Returns SFDR Data And EVIC In USD And EUR
Medium & Heavy Commercial Vehicle Forecast
Sales Volume By Vehicle And Cab Type
Medium & Heavy Commercial Vehicle Forecast
Forecasted Versus Actual Production Volumes By Period And Region
Medium & Heavy Commercial Vehicle Forecast
Alternative Propulsion System Distribution
Key Developments
Count Of Dividend Related Key Developments
Medium & Heavy Commercial Vehicle Forecast
Top Manufacturers By Region And Vehicle Type
Medium & Heavy Commercial Vehicle Forecast
Production Volume Trend Over Time
Medium & Heavy Commercial Vehicle Forecast
Engine Performance Comparison By Configuration And Aspiration
Medium & Heavy Commercial Vehicle Forecast
Total Sales Volume By Vehicle Type
Medium & Heavy Commercial Vehicle Forecast
Top 5 Countries By Sales Volume
Medium & Heavy Commercial Vehicle Forecast
Vehicle Count By Emission Level
Key Developments
Most Active Companies In Key Developments
Key Developments
Duration Of Key Developments In Database
Medium & Heavy Commercial Vehicle Forecast
Average Sales Volume By Region
Key Developments
Key Developments By Event Type In The Last Week
Medium & Heavy Commercial Vehicle Forecast
Sales Volume Trend By Period
Medium & Heavy Commercial Vehicle Forecast
Year Over Year Sales Growth By Region
Key Developments
Time Series Analysis Of Key Developments
Key Developments
Key Developments By Source Type
Key Developments
Key Developments With Advisor Role Type
Medium & Heavy Commercial Vehicle Forecast
Sales Volume By Company
Medium & Heavy Commercial Vehicle Forecast
Detailed Emission Levels By Vehicle Type And Manufacturer
Key Developments
Impact Analysis Of Executive Changes
Medium & Heavy Commercial Vehicle Forecast
Vehicle Sales Volume By BodyType
Key Developments
Key Developments With Most Frequent Modifications
Key Developments
Top 5 Event Types By Number Of Changes Within 15 Minutes
Medium & Heavy Commercial Vehicle Forecast
Total Production Powertrain Volume By Country
Medium & Heavy Commercial Vehicle Forecast
Total Sales Volume By GVW Rating
Medium & Heavy Commercial Vehicle Forecast
Average Battery Capacity By Alternative Propulsion System
Key Developments
Key Developments Announced In The Last Month
Medium & Heavy Commercial Vehicle Forecast
Average Engine Displacement By Manufacturer
Credit Analytics
Returns Median PD Fundamentals Country Industry Benchmark Data As Per A Company
Light Vehicle Forecast
BEV Sales Growth Comparison By Brands In China From 2023 To 2024
Light Vehicle Forecast
Total BEV Sales Volume Trend Globally
Light Vehicle Forecast
Production Volume Of Top 10 Assembly Plants For A Specific Year
Light Vehicle Forecast
Production Volume For Sub Segments Globally For A Specific Year
Light Vehicle Forecast
Sales By Propulsion System Design For A Specific Country And Year
Light Vehicle Forecast
Global Propulsion System Design Trend Volume
Light Vehicle Forecast
Unique Vehicle Models Sold By A Specific Company In A Specific Year
Light Vehicle Forecast
Market Share Percentage By Company For A Specific Year And Country
Light Vehicle Forecast
Sales Volume Trend Globally
Light Vehicle Forecast
Total BEV Sales Volume By Country In A Specific Year
Light Vehicle Forecast
Production Volume Trend Globally
Light Vehicle Forecast
Production Volume By Production Type For A Country And Specific Year
Light Vehicle Forecast
BEV Market Share By Company For A Specific Year
Light Vehicle Forecast
Production Volume By Country In A Specific Year
Light Vehicle Forecast
Domestic Versus Import Sales Volume Trend For China
Light Vehicle Forecast
Production Volume Trend For A Specific Country
Light Vehicle Forecast
Models With Production Volume By Region For A Specific Quarter And Year
Light Vehicle Forecast
Auto Brand Growth Comparison By Country From 2023 To 2024
Light Vehicle Forecast
Sales Volume By Global Sales Segment In A Specific Year
Light Vehicle Forecast
Sales Volume Trend For Company And Cybertruck By Year
Light Vehicle Forecast
Sales Volume By Country In A Specific Year
Money Market Directories (MMD)
Returns All Firms Using A Specific Manager By Name And/Or Managed Allocation
Money Market Directories (MMD)
Returns All The Exchangecodes For The MmdentityIds Using Dynamic Pivot
Market Data, S&P Capital IQ Financials
Returns Low, High, Close And Average TEV/LTM EBITDA Values For A Company As Per An Observation Date
Money Market Directories (MMD)
Returns All The Exchangecodes For The MmdentityIds Pivot
GICS®
Returns The Industry Hierarchy For The Company
RatingsXpress®: S&P Credit Ratings
Returns Company Tree And Associated Ratings
Physical Risk: Country, Subnational & Municipal
Returns GDP Weighted US Exposure Score
Physical Risk: Country, Subnational & Municipal
Returns Issue Level Municipal Physical Risk Data For Fixed Income Securities
Platts Market Data - Oil
Retrieve All Reference Data For A Specific Symbol
LNG Tenders
Retrieve All Unique Country List
LNG Tenders
Retrieve All Tenders For Company
LNG Tenders
Retrieve All Tender Information Modified With Date Range
LNG Tenders
Retrieve All Tenders For Country
Platts eWindow Market Data
Retrieve The Total Consummated Trades Per Platts Jet Fuel Product
Platts eWindow Market Data
Retrieve Trade Data Between 2020-12-31, Limit The Fields Returned, Sort The Response By Market Maker
Platts eWindow Market Data
Retrieve The Buyers And Sellers Who Participated In The MOC On 2021-01-20
Platts eWindow Market Data
Retrieve All Consummated Platts Dubai Trades For November 1 2022
Platts eWindow Market Data
Retrieve The Price Each Product Was Traded At By Each Seller Between Specific Time Range
Platts World Refinery Database
Return All Unplanned Outages Happening In The US On A Specific Date
Energy Price Forecast
Retrieve The Short-Term Price Forecast For LNG Deliver In Asia
World Oil Supply
Get The Total Crude Supply For December 2022 In Iran With Breakdown
Platts World Refinery Database
Return All Outages For Refineries Operated By BP In 2020
Global Oil Demand
Retrieve Aggregated Values
Energy Price Forecast
Retrieve Long-Term Historical And Forecast Prices For Commodity Dated Brent
Energy Price Forecast
Retrieve Short-Term Refined Product Price Forecast For 2024
Platts World Refinery Database
Returns Runs For Albpetrol Albanian State Co. Refinery In Albania 2017
Platts Forward Curves
Retrieve Historical Contract Values For A List Of Curves And Assessment Date Range
World Oil Supply
Get Annual Crude Production For Iran In 2022