SELECT

DATE_TRUNC('day', block_timestamp) AS date,

contract_address,

COUNT(*) AS daily_transactions,

COUNT(DISTINCT ORIGIN_FROM_ADDRESS) AS unique_users

FROM blast.core.fact_event_logs

WHERE block_timestamp >= CURRENT_DATE - INTERVAL '30 days'

GROUP BY 1, 2

),

ranked_contracts AS (

SELECT

date,

contract_address,

daily_transactions,

unique_users,

ROW_NUMBER() OVER (PARTITION BY date ORDER BY daily_transactions DESC) AS rank

FROM daily_contracts

SELECT

date,

contract_address,

daily_transactions,

unique_users

FROM ranked_contracts

WHERE rank <= 10

ORDER BY date DESC, daily_transactions DESC