Query editor
WITH mine AS (SELECT address FROM dune.zdcacaca5306.dataset_bscgap_00 UNION ALL SELECT address FROM dune.zdcacaca5306.dataset_bscgap_01 UNION ALL SELECT address FROM dune.zdcacaca5306.dataset_bscgap_02 UNION ALL SELECT address FROM dune.zdcacaca5306.dataset_bscgap_03 UNION ALL SELECT address FROM dune.zdcacaca5306.dataset_bscgap_04 UNION ALL SELECT address FROM dune.zdcacaca5306.dataset_bscgap_05 UNION ALL SELECT address FROM dune.zdcacaca5306.dataset_bscgap_06 UNION ALL SELECT address FROM dune.zdcacaca5306.dataset_bscgap_07 UNION ALL SELECT address FROM dune.zdcacaca5306.dataset_bscgap_08)SELECT '0x'||to_hex(a) address FROM (SELECT "from" a FROM avalanche_c.transactions WHERE "from" IN (SELECT address FROM mine)UNION ALLSELECT "to" a FROM avalanche_c.transactions WHERE "to" IN (SELECT address FROM mine)) xGROUP BY 1