Query 1 ×
▶ 1. Daily / Movement Analysis
Biggest position changes today
Tracks that moved up or down on Spotify Daily India
New entries (not on yesterday's chart)
Fresh tracks that just entered the chart today
Tracks leaving the chart
Songs that dropped off today
▶ 2. Trend Analysis (Cross-Snapshot)
Top 20 climbers vs yesterday
Tracks that gained the most positions in India
Top 20 fallers vs yesterday
Tracks that lost the most positions
0 ORDER BY CAST(Streams+ AS BIGINT) DESC LIMIT 15">
Viral candidates (big stream jumps, top 50)
Tracks with highest stream increase potential
▶ 3. Top Lists / Rankings
All-time most streamed in India (Spotify Daily)
Tracks with highest total cumulative streams
YouTube all-time most viewed music videos
Top 20 by total lifetime views
Spotify top artists by total streams
Lead vs feature breakdown
▶ 4. Country Analysis
#1 track in every country
What song is #1 across all 76 countries
India: Spotify vs YouTube top 10 overlap
Tracks charting on both platforms in India
▶ 5. Artist Analysis
Cross-platform artist ranking (top 20)
Artists ranked by combined points from all platforms
Top artists by monthly listeners
Spotify listener count with daily changes
YouTube top artists by total views
Artists with most music video views + 100M video count
▶ 6. YouTube Analysis
YouTube Daily Top 20
Today's most viewed global music videos
YouTube Top 100 Most Viewed All Time
Legendary videos by total views
▶ 7. Streaming Metrics
Peak vs Total streams ratio (India)
How close tracks are to their peak performance
0 ORDER BY Velocity DESC LIMIT 15">
Stream velocity (today / 7-day avg)
Tracks overperforming vs their own average
▶ 8. Cross-Platform Insights
Radio vs Spotify (US): songs charting on both
Radio airplay driving streaming in the US
Shazam-to-Spotify pipeline (India)
High Shazam identifying future Spotify hits
▶ 9. Predictive / Signal Analysis
100 AND CAST(Pos AS INT) <= 500 AND CAST(Streams+ AS BIGINT) > CAST(\"7Day\" AS BIGINT) * 0.5 AND CAST(Days AS INT) <= 14 ORDER BY CAST(Streams+ AS BIGINT) DESC LIMIT 15">
Viral breakout candidates
Low-ranked but surging tracks with new releases
Fade signals (long-runners losing ground)
Tracks on chart 30+ days that are dropping
▶ 10. Time-Based Analysis
Longest charting tracks still in top 100 (India)
Songs with staying power
Fresh hits (published <30 days, already top 50)
Fast-rising new releases
Fading from peak (were top 10, now dropped 20+)
Former hits losing momentum

Country-Based Sources (9)

spotify_daily
~1200 rows/country, 76 countries
Pos P_plus Artist_and_Title Days Pk Streams Streams+ 7Day Total video_id yt_views yt_channel
spotify_weekly
~1000 rows/country, 77 countries
Pos Artist_and_Title Wks Streams Streams_plus Total video_id
spotify_daily_totals
~22000 rows/country, lifetime totals
Artist_and_Title Days T10 PkStreams Total video_id
spotify_weekly_totals
~16000 rows/country, lifetime totals
Artist_and_Title Wks T10 PkStreams Total
apple_music
~200 rows/country, 158 countries
Pos P+ Artist_and_Title
apple_music_worldwide
800 rows, 4 charts (songs/albums/eu)
Pos Artist_and_Title Days Pts video_id
itunes
~130 rows/country, 120 countries
Pos P+ Artist_and_Title video_id
itunes_worldwide
800 rows, 4 charts (songs/albums/eu)
Pos Artist_and_Title Days Pts video_id
shazam
~200 rows/country, 72 countries
Pos P+ Artist_-_Title video_id yt_views
deezer
~100 rows/country, 69 countries
Pos P+ Artist_-_Title video_id
youtube_countries
~50 rows/country, 134 countries
Pos P+ Track Wks Streams Streams+ video_id

Global Sources (8)

youtube_daily
500 rows, global most viewed music
Rank Change Video Views Likes video_id yt_channel
youtube_trending
~380 rows, trending music
Video # Highlights chart_type video_id
youtube_toplists
~30000 rows, all-time most viewed
Video Views Yesterday Days Likes Comments Artist page_name
youtube_artists
~1700 rows, artists by views
Artist Total 100M
spotify_artists
~3000 rows, artists by streams
Artist Streams Daily As_lead Solo As_feature
spotify_listeners
~5000 rows, artists by listeners
# Artist Listeners Daily_+/- Peak PkListeners
artists_ranking
300 rows, cross-platform
Pos P+ Artist Points Apple_M Spotify iTunes YouTube Shazam Deezer
radio
~120 rows, airplay chart
Pos P+ Artist_and_Title Days Aud Aud+ Formats PkAud iTunes Spotify

CAST Everything

All columns are VARCHAR. Always cast before math:
CAST(Streams AS BIGINT)
CAST(Pos AS INT)
CAST(Days AS INT)
CAST(Total AS BIGINT)

Country Filter

WHERE country_code = 'in'   -- India
WHERE country_code = 'us'   -- United States
WHERE country_code = 'gb'   -- United Kingdom

Cross-Snapshot Trend (today vs yesterday)

SELECT a.Artist_and_Title,
       CAST(a.Pos AS INT) as today_pos,
       CAST(b.Pos AS INT) as yesterday_pos
FROM snapshots_files_daily__2026_08_27_spotify_daily a
JOIN snapshots_files_daily__2026_08_26_spotify_daily b
  ON a.Artist_and_Title = b.Artist_and_Title
  AND a.country_code = b.country_code
WHERE a.country_code = 'in'
ORDER BY (CAST(a.Pos AS INT) - CAST(b.Pos AS INT)) ASC
LIMIT 20;

GREATEST Days (actual age)

GREATEST(CAST(Days AS INT), CAST(days_since_published AS INT))

Find Latest Snapshot

SELECT table_name FROM information_schema.tables
WHERE table_name LIKE '%spotify_daily%'
ORDER BY table_name DESC LIMIT 1;

List All Tables

SHOW TABLES;

New Entries (not on yesterday)

SELECT a.Artist_and_Title
FROM today_table a
WHERE NOT EXISTS (
  SELECT 1 FROM yesterday_table b
  WHERE b.Artist_and_Title = a.Artist_and_Title
    AND b.country_code = a.country_code
)

Chart Exit (was there, now gone)

SELECT b.Artist_and_Title
FROM yesterday_table b
WHERE NOT EXISTS (
  SELECT 1 FROM today_table a
  WHERE a.Artist_and_Title = b.Artist_and_Title
    AND a.country_code = b.country_code
)

Position Change Indicators

P_plus / P+: "=" same, "5+" moved up 5, "3-" moved down 3