Skip to main content
By Fruit Stand Team · November 18, 2026 · Guides To run sentiment analysis on earnings calls in Snowflake, score each paragraph with SNOWFLAKE.CORTEX.SENTIMENT, which returns −1 to 1, then average by speaker and section. On 1,174 calls from October 1 to November 13, 2026, management averaged 0.59 in prepared remarks and 0.37 in Q&A, and analysts 0.32. Scoring 130,457 paragraphs cost about $2.24. Don’t score a whole call in one go: SENTIMENT reads only the start of long text, and AI_SENTIMENT rejects it. Below are the queries, what the scores show, how they lined up with the stock’s move, and what each Cortex function costs.
The transcripts come from Fruit Stand’s Earnings Call Transcripts listing and the prices from our Historical Stock Prices listing, both of which we publish. Every query was run on November 18, 2026, in AWS US West 2. Rates are from Snowflake’s Service Consumption Table effective November 17, 2026, at the on-demand price of $2.00 per AI credit.

Which Cortex function to use

Snowflake has three ways to get sentiment from text in SQL: An earnings call runs about 12,000 tokens, so it’s too long for the first two in one piece. In the transcripts listing each row is one paragraph, which fits: since April 2026 only 0.06% of paragraphs are longer than 2,000 characters.

Why you can’t score a whole call at once

This test takes Coca-Cola’s October 27, 2026 call and adds a block of bad news at the end, then at the start:
The call ends with 2,200 characters of bad news and its score doesn’t change. Put the same text first and the score flips. In a second test, the bad news stopped making any difference once it came after about 3,000 characters of the call, roughly 550 tokens. A whole-call score is a score of the operator’s welcome and the first minute of prepared remarks. SENTIMENT gives no warning, so the mistake is easy to miss.

Score every paragraph

This scores each paragraph of the calls held from October 1 to November 13, 2026, by companies that traded at least $50 million a day on average in September. The filter keeps the sample to the stocks most people follow; drop it to score all 3,867 calls in that window.
It scored 130,457 paragraphs from 1,211 calls in under a minute on an X-Small warehouse. Snowflake billed 12,467,377 tokens: 1.12 AI credits, or $2.24. This is the only query in the post that costs much; everything after it reads the table.

Label management, analysts and the operator

The listing gives each speaker’s name, not their role. The operator opens the Q&A, so anyone who speaks before that is management, and anyone new after it is an analyst. (The same idea is in How to Query Earnings Call Transcripts in Snowflake SQL.)
The having drops calls with no operator, such as Netflix’s and Tesla’s, which take questions another way; that leaves 1,174 of the 1,211 calls. An executive who speaks only during the Q&A is counted as an analyst, so for close work map names to titles yourself.

What the scores look like

Three things stand out:
  • Almost nothing is negative. Snowflake’s docs call −0.5 or lower negative, and under 1% of paragraphs reach it. None of Intel’s did, on a call after which the stock fell 31%. Executives and analysts don’t talk in negative words. Compare scores between calls, or against a company’s own history; don’t rely on the docs’ cutoffs.
  • Management sounds different in the Q&A. The same people average 0.59 reading prepared remarks and 0.37 answering questions.
  • Leave the operator out. “Our next question comes from…” scores near zero and pulls a call’s average toward neutral.

Did tone line up with the stock’s move?

To compare tone with the market’s reaction, join each call to the Historical Stock Prices listing. The return runs from the close before the call date to the close after it, so it covers calls held before the open and after the close alike, minus SPY’s return over the same days:
Then split the calls into fifths by how positive the analysts sounded:
The most positive fifth beat the least positive by 3.8 points on average. Analyst tone tracked the move more closely than management’s did: its correlation with the return was 0.14, against 0.07 for prepared remarks and 0.04 for management’s answers. Management reads prepared remarks from a script; analysts react to the numbers. Intel’s October 29 call shows it. Third-quarter revenue rose 21% to $16.5 billion, but Intel's [release](https://www.intc.com/news-events/press-releases/detail/1786/intel-reports-third-quarter-2026-financial-results) guided fourth-quarter revenue to $15.0 to $16.0 billion. Management's prepared remarks scored 0.58, about average. The analysts scored 0.12, in the least positive fifth. The stock fell from $95.53 on October 28 to $65.76 on October 30, 29.0 points worse than SPY. Read this as a description, not a trading signal:
  • It’s one earnings season. 1,174 calls over six weeks.
  • It isn’t a forecast. The return window includes the call, so the analysts were reacting to the same results the market was.
  • Compare the rows, not the zero line. Most rows beat SPY because SPY fell over many of the busiest windows, including 4.1% from November 4 to 6.
To test tone as a signal, measure returns that start after the call and compare each company’s tone with its own past calls. How to Calculate Stock Returns From Daily Prices in SQL has the return queries.

Tone by topic with AI_SENTIMENT

AI_SENTIMENT labels the paragraph overall and for topics you name. This runs it on the management and analyst paragraphs of Intel’s call, with five topics:
Snowflake’s docs say a topic the text doesn’t mention comes back as unknown. On these 141 paragraphs it rarely did. This counts each topic’s labels, split by whether the paragraph mentions it:
Pricing comes up in 6 paragraphs, but AI_SENTIMENT labeled it in 132 others too. Count only the paragraphs that mention a topic, as the mentioned flag does. On those, Intel’s call reads as you’d expect from the release: demand mostly positive, while supply drew 10 negative paragraphs and pricing 5 of 6.

Score a whole call with AI_COMPLETE

To score a whole call at once, or ask for a reason as well as a score, send the full transcript to a model with AI_COMPLETE. response_format makes it return JSON, and a temperature of 0 makes reruns repeatable:
The model rated Intel’s analysts negative, which SENTIMENT never did. It’s more expensive per call and its scale is the model’s own judgment, so keep the prompt and model fixed if you compare calls over time. Snowflake’s quant research guide uses the same approach with a 1 to 10 scale on the Dow 30.

Older calls: split long paragraphs first

Before April 2026, the listing’s transcripts used longer paragraphs: 7.7% of 2025’s are over 2,000 characters, and the longest runs to 71,684. Split those into chunks with SPLIT_TEXT_RECURSIVE_CHARACTER and average the chunks’ scores:
Coca-Cola’s July 2025 call has five paragraphs over 2,000 characters; the longest, from the CEO’s prepared remarks, splits into 8 chunks. Chunks of 1,500 characters stay under SENTIMENT’s limit and well under AI_SENTIMENT’s.

What it costs

AI_SENTIMENT billed three times the 11,832 tokens in those paragraphs, because it adds a prompt and the topic list to every paragraph. At that rate, the 1,211 calls would cost about $120 with `AI_SENTIMENT`, about $16 with claude-haiku-4-5, and $2.24 with SENTIMENT. The warehouse is billed on top; Snowflake recommends nothing larger than Medium, since a bigger one doesn’t make these functions faster. Each call shows up in snowflake.account_usage.cortex_ai_functions_usage_history, within a few hours:

Things to know

  • English. SENTIMENT is documented for English text. AI_SENTIMENT also handles French, German, Hindi, Italian, Portuguese and Spanish.
  • Region. AI_SENTIMENT runs in a list of regions, plus cross-region inference; check Snowflake’s docs for yours. All three need the SNOWFLAKE.CORTEX_USER database role.
  • Scores are relative. Different functions, models and prompts give different scales. Pick one and keep it.
  • Speaker roles are inferred. The listing has names, not titles, so the management and analyst labels come from the operator pattern above.

F.A.Q.

For scoring many calls, SNOWFLAKE.CORTEX.SENTIMENT on each paragraph: it’s about 18 times cheaper per token than AI_SENTIMENT and gives a number you can average. Use AI_SENTIMENT for tone on specific topics, and AI_COMPLETE when you want a reason with the score.
It runs, but it reads only roughly the first 550 tokens and ignores the rest without a warning. Score paragraphs or chunks and average them.
Earnings calls use careful, mostly upbeat language. Under 1% of paragraphs scored −0.5 or lower, even on calls followed by a 30% drop. Compare scores between calls instead of using fixed cutoffs.
Scoring every paragraph of 1,211 calls with SENTIMENT billed 12.5 million tokens, 1.12 AI credits or about $2.24, plus warehouse time. The same calls would cost about $120 with AI_SENTIMENT.
In this sample it lined up with the two-day move: calls where analysts sounded most positive beat SPY by 3.8 points more than the least positive ones. That window includes the call itself, so it’s not a forecast. Test returns that start after the call before trading on it.
To run these queries on calls from 4,500+ companies since 2005, start a free 30-day trial of the Earnings Call Transcripts listing on the Snowflake Marketplace. The schema is in the dataset docs. For the price data in the reaction queries, see the Historical Stock Prices listing. Questions? Reach out at contact@fruitstand.dev.