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.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.)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:
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.
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:
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 withAI_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 withSPLIT_TEXT_RECURSIVE_CHARACTER and average the
chunks’ scores:
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.
SENTIMENTis documented for English text.AI_SENTIMENTalso handles French, German, Hindi, Italian, Portuguese and Spanish. - Region.
AI_SENTIMENTruns in a list of regions, plus cross-region inference; check Snowflake’s docs for yours. All three need theSNOWFLAKE.CORTEX_USERdatabase 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.
Which Snowflake function is best for earnings call sentiment?
Which Snowflake function is best for earnings call sentiment?
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.Can I run SENTIMENT on a whole transcript?
Can I run SENTIMENT on a whole transcript?
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.
Why are almost no paragraphs negative?
Why are almost no paragraphs negative?
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.
How much does it cost to score a quarter of earnings calls?
How much does it cost to score a quarter of earnings calls?
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.Does call sentiment predict stock returns?
Does call sentiment predict stock returns?
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.