Query editor
WITH depositor_transactions AS (SELECT DISTINCT node_address AS depositor_address FROM dune.serotonin_data.result_depin_node_addresses -- Node Addresses), contract_addresses AS (SELECTaddress,category,namespace,nameFROM query_3540685), relevant_transactions AS (SELECTt."from" AS depositor_address,t."to" AS contract_address,t.block_time AS timestampFROM ethereum.transactions AS tWHEREt.block_time >= CURRENT_DATE - INTERVAL '1' yearAND t."to" IN (SELECTaddressFROM contract_addresses)), interactions AS (SELECTrt.depositor_address,rt.contract_address,ca.category,ca.namespace,ca.name,rt.timestampFROM relevant_transactions AS rtJOIN depositor_transactions AS dtON rt.depositor_address = dt.depositor_addressJOIN contract_addresses AS caON rt.contract_address = ca.address)SELECTnamespace,COUNT(DISTINCT depositor_address) AS unique_depositors_countFROM interactionsGROUP BYnamespaceHAVINGCOUNT(DISTINCT depositor_address) > 9ORDER BYunique_depositors_count DESC