Query editor
WITHcontract_activity AS (SELECTDATE_TRUNC('day', b.time) AS day,t.to AS contract_address,COUNT(*) AS interaction_count,COUNT(DISTINCT t."from") AS unique_users,SUM(t.gas_used) AS total_gas_usedFROMink.transactions AS tJOIN ink.blocks AS b ON t.block_number = b.numberWHEREt.to IN (SELECTaddressFROMink.contracts)GROUP BY1,2)SELECT*,ROW_NUMBER() OVER (PARTITION BYdayORDER BYinteraction_count DESC) AS daily_rankFROM(SELECTday,contract_address,interaction_count,unique_users,total_gas_used,ROW_NUMBER() OVER (PARTITION BYdayORDER BYinteraction_count DESC) AS daily_rankFROMcontract_activity) AS ranked_activityWHEREdaily_rank <= 10