Query editor
WITH mine AS (SELECT address FROM dune.zdcacaca5306.dataset_cand_000 UNION ALL SELECT address FROM dune.zdcacaca5306.dataset_cand_001 UNION ALL SELECT address FROM dune.zdcacaca5306.dataset_cand_002 UNION ALL SELECT address FROM dune.zdcacaca5306.dataset_cand_003 UNION ALL SELECT address FROM dune.zdcacaca5306.dataset_cand_004 UNION ALL SELECT address FROM dune.zdcacaca5306.dataset_cand_005 UNION ALL SELECT address FROM dune.zdcacaca5306.dataset_cand_006 UNION ALL SELECT address FROM dune.zdcacaca5306.dataset_cand_007 UNION ALL SELECT address FROM dune.zdcacaca5306.dataset_cand_008 UNION ALL SELECT address FROM dune.zdcacaca5306.dataset_cand_009 UNION ALL SELECT address FROM dune.zdcacaca5306.dataset_cand_010 UNION ALL SELECT address FROM dune.zdcacaca5306.dataset_cand_011 UNION ALL SELECT address FROM dune.zdcacaca5306.dataset_cand_012 UNION ALL SELECT address FROM dune.zdcacaca5306.dataset_cand_013 UNION ALL SELECT address FROM dune.zdcacaca5306.dataset_cand_014 UNION ALL SELECT address FROM dune.zdcacaca5306.dataset_cand_015 UNION ALL SELECT address FROM dune.zdcacaca5306.dataset_cand_016 UNION ALL SELECT address FROM dune.zdcacaca5306.dataset_cand_017 UNION ALL SELECT address FROM dune.zdcacaca5306.dataset_cand_018 UNION ALL SELECT address FROM dune.zdcacaca5306.dataset_cand_019 UNION ALL SELECT address FROM dune.zdcacaca5306.dataset_cand_020 UNION ALL SELECT address FROM dune.zdcacaca5306.dataset_cand_021 UNION ALL SELECT address FROM dune.zdcacaca5306.dataset_cand_022 UNION ALL SELECT address FROM dune.zdcacaca5306.dataset_cand_023 UNION ALL SELECT address FROM dune.zdcacaca5306.dataset_cand_024 UNION ALL SELECT address FROM dune.zdcacaca5306.dataset_cand_025 UNION ALL SELECT address FROM dune.zdcacaca5306.dataset_cand_026 UNION ALL SELECT address FROM dune.zdcacaca5306.dataset_cand_027 UNION ALL SELECT address FROM dune.zdcacaca5306.dataset_cand_028 UNION ALL SELECT address FROM dune.zdcacaca5306.dataset_cand_029 UNION ALL SELECT address FROM dune.zdcacaca5306.dataset_cand_030 UNION ALL SELECT address FROM dune.zdcacaca5306.dataset_cand_031 UNION ALL SELECT address FROM dune.zdcacaca5306.dataset_cand_032 UNION ALL SELECT address FROM dune.zdcacaca5306.dataset_cand_033 UNION ALL SELECT address FROM dune.zdcacaca5306.dataset_cand_034 UNION ALL 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 UNION ALL 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 UNION ALL SELECT address FROM dune.zdcacaca5306.dataset_lw_00)SELECT DISTINCT '0x' || to_hex(a) AS address FROM (SELECT "from" a FROM boba.transactions WHERE "from" IN (SELECT address FROM mine)UNION ALLSELECT "to" a FROM boba.transactions WHERE "to" IN (SELECT address FROM mine)) x