select
snapshot_date, week_number, listeners, playcount,
listener_delta, listener_pct_change, listeners_indexed
from api_artist_timeseries
where artist_id = $1
order by snapshot_date ascIndexed to 100 at each series' first observation.
select
ts.snapshot_date, ts.week_number, ts.listeners, ts.listeners_indexed,
cw.artist_count, cw.p25_indexed, cw.median_indexed, cw.p75_indexed
from api_artist_timeseries ts
left join api_cohort_weekly cw
on cw.cohort_type = $2 -- 'genre' or 'size_band'
and cw.cohort_key = $3 -- primary_genre or size_band
and cw.snapshot_date = ts.snapshot_date
where ts.artist_id = $1
order by ts.snapshot_date asc| Artist | Listeners | 13-week growth |
|---|---|---|
| Atreyu | 1.4M | +0.61% |
| As I Lay Dying | 1.1M | +0.54% |
| Killswitch Engage | 1.7M | +1.28% |
| Parkway Drive | 895k | +0.87% |
| Trivium | 1.4M | +1.11% |
| Unearth | 414k | +0.38% |
| Miss May I | 466k | +0.98% |
| Bullet for My Valentine | 2.6M | +1.22% |
| August Burns Red | 818k | +1.05% |
| Caliban | 427k | +0.32% |
| Light the Torch | 129k | +1.67% |
| Shadows Fall | 427k | +0.25% |
| Still Remains | 240k | +1.08% |
| Darkest Hour | 308k | +0.71% |
| DevilDriver | 636k | +0.70% |
| Bury Tomorrow | 284k | +1.59% |
| Times of Grace | 96k | +1.35% |
| Bleeding Through | 369k | +0.38% |
| Sonic Syndicate | 549k | +0.15% |
| Soilwork | 667k | +0.46% |
select
similar_artist_id, slug, display_name, size_band,
latest_listeners, total_pct_growth, weeks_tracked, similarity_score, rank
from api_artist_similar
where artist_id = $1
order by rank ascselect *
from api_artist_profile
where artist_id = $1