select

date_trunc('week', block_timestamp) as TIME,

count(tx_id) as transaction_count,

pool_id,

label,

row_number() over (partition by TIME order by transaction_count desc) as rank

from terra.core.ez_swaps s inner join terra.core.dim_address_labels l on l.address = s.pool_id

where TX_SUCCEEDED = 'TRUE'

and block_timestamp >= CURRENT_DATE - {{Past_X_Days}}

and label not in ('astroport router', 'terraswap router')

group by TIME, pool_id, label

)

select TIME, transaction_count, pool_id, rank, label

from source

having rank <=3