Query editor
WITH mine AS (SELECT address FROM dune.zdcacaca5306.dataset_fx_00 UNION ALL SELECT address FROM dune.zdcacaca5306.dataset_fx_01 UNION ALL SELECT address FROM dune.zdcacaca5306.dataset_fx_02 UNION ALL SELECT address FROM dune.zdcacaca5306.dataset_fx_03 UNION ALL SELECT address FROM dune.zdcacaca5306.dataset_fx_04 UNION ALL SELECT address FROM dune.zdcacaca5306.dataset_fx_05 UNION ALL SELECT address FROM dune.zdcacaca5306.dataset_fx_06 UNION ALL SELECT address FROM dune.zdcacaca5306.dataset_fx_07 UNION ALL SELECT address FROM dune.zdcacaca5306.dataset_fx_08)SELECT '0x'||to_hex("to") safe,'0x'||to_hex("from") our_owner,count(*) tx_countFROM avalanche_c.transactionsWHERE "from" IN (SELECT address FROM mine)AND bytearray_substring(data, 1, 4) = 0x6a761202GROUP BY 1,2