Client spend in the last 30 days

An MTS product analyst pulls a weekly leaderboard of top wallets by spend in the last month — feeds trigger campaigns and upsell offers. Clients are identified by UUIDs from billing; transaction amounts arrive in rubles with kopecks. Compute total spend per client over the last 30 days relative to CURRENT_DATE (today inclusive). The biggest wallets come on top. Skip clients with no transactions in that window. Treat the current moment as 2026-05-05 12:00:00 UTC — every relative-time expression in the seed and the reference solution is anchored to that point. Sort the result by spend_30d (descending).