date_trunc('minute', block_timestamp) as mins,

date(block_timestamp) as date,

count(distinct tx_id) as tx_count,

ROW_NUMBER() OVER(PARTITION BY date ORDER BY tx_count desc) as rank

from thorchain.swaps

group by 1,2),

final as (select tx_count, date, mins

from raw

where rank = 1)

select *

from final

order by 1 desc

limit 20