DELETE
FROM leaderboard_guilds lg
USING (
    SELECT
        id,
        guild_id,
        snapshot_timestamp,
        ROW_NUMBER() OVER (PARTITION BY guild_id, snapshot_timestamp::date ORDER BY id) AS row_num
    FROM leaderboard_guilds
) rg 
WHERE rg.row_num > 1 
  and rg.guild_id = lg.guild_id 
  and rg.snapshot_timestamp = lg.snapshot_timestamp
  and rg.id = lg.id;

DELETE
FROM leaderboard_guilds lg
USING (
    SELECT
        id,
        guild_id,
        snapshot_timestamp,
        ROW_NUMBER() OVER (PARTITION BY guild_id, snapshot_timestamp::date ORDER BY id) AS row_num
    FROM leaderboard_guilds
) rg 
WHERE rg.row_num > 1 
  and rg.guild_id = lg.guild_id 
  and rg.snapshot_timestamp = lg.snapshot_timestamp
  and rg.id = lg.id;