*

FROM (

SELECT

trunc(BLOCK_TIMESTAMP, 'month') AS time,

COUNT(DISTINCT TX_HASH) AS transactions,

row_number() OVER (PARTITION BY time ORDER BY transactions DESC) as contract_rank,

CONTRACT_ADDRESS

FROM

ethereum.core.fact_decoded_event_logs

GROUP BY

CONTRACT_ADDRESS,

time

ORDER BY

time DESC)

WHERE

contract_rank <= 10