Query editor
WITHprepared_bets_v3 AS (SELECT *FROM query_4746689INNER JOIN dune.azuro.dataset_frontends USING(affiliate)WHERE chain != 'arbitrum'),sorted AS (SELECTdate_trunc('{{Period}}', bet_time) as bet_date,count (distinct bet_id) as bets_count,sum (amount) as betting_volume,count (distinct bettor) as usersFROM prepared_bets_v3WHERE date_trunc('{{Period}}', bet_time) in (SELECT distinct(date_trunc('{{Period}}', bet_time)) FROM query_3243302 ORDER BY 1 DESC LIMIT 5)GROUP BY 1ORDER BY 1)SELECTdate_format(bet_date,'%e %b %Y') as bet_date,*FROM sorted