Query editor
WITH token_registry AS (SELECT 'XIDR' AS token, 'ethereum' AS blockchain, 0xebF2096E01455108bAdCbAF86cE30b6e5A72aa52 AS token_address UNION ALLSELECT 'XIDR', 'polygon', 0x2c826035c1C36986117A0e949bD6ad4baB54afE2 UNION ALLSELECT 'IDRX', 'base', 0x18Bc5bcC660cf2B9cE3cd51a404aFe1a0cBD3C22 UNION ALLSELECT 'IDRX', 'polygon', 0x649a2DA7B28E0D54c13D5eFf95d3A660652742cC UNION ALLSELECT 'IDRX', 'BSC', 0x649a2DA7B28E0D54c13D5eFf95d3A660652742cC UNION ALLSELECT 'IDRX','kaia',0x18bc5bcc660cf2b9ce3cd51a404afe1a0cbd3c22 UNION ALLSELECT 'IDRP','kaia',0xc16d986585407a74ab87d17c3d0dc19822e3eb35 UNION ALLSELECT 'IDRP','ethereum',0x07429a7f8F80Db4Bf05D0753Aa6b0FD156fffA56 UNION ALLSELECT 'IDRP','BSC',0x817d0C3D4e63231d88B2d73217B7fB75b87e0606 UNION ALLSELECT 'IDRP','polygon', 0xadb603c1d0a1b3943c9df35a50099f22feacaa58 UNION ALLSELECT 'IDDR', 'polygon', 0x9a8284c2cec196478f01ef4446a0222dd4def00e UNION ALLSELECT 'IDRT', 'ethereum', 0x998FFE1E43fAcffb941dc337dD0468d52bA5b48A UNION ALLSELECT 'IDRT', 'BSC', 0x66207e39bb77e6b99aab56795c7c340c08520d83 UNION ALLSELECT 'IDRT', 'polygon', 0x554cd6bdD03214b10AafA3e0D4D42De0C5D2937b UNION ALLSELECT 'XSGD', 'ethereum', 0x70e8de73ce538da2beed35d14187f6959a8eca96 UNION ALLSELECT 'XSGD', 'polygon', 0xDC3326e71D45186F113a2F448984CA0e8D201995 UNION ALLSELECT 'XSGD', 'avalanche', 0xb2F85b7AB3c2b6f62DF06dE6aE7D09c010a5096E UNION ALLSELECT 'XSGD', 'base',0x0A4C9cb2778aB3302996A34BeFCF9a8Bc288C33b UNION ALLSELECT 'MYRC', 'arbitrum', 0x3ed03e95dd894235090b3d4a49e0c3239edce59e UNION ALLSELECT 'MYRC','base', 0x3eD03E95DD894235090B3d4A49E0C3239EDcE59e UNION ALLSELECT 'PHPC', 'polygon', 0x006e1d324fa995f1c1b8318b058ae9c117a72c20 UNION ALLSELECT 'PHPC', 'ronin', 0x63c6e9f027947be84d390cfa7b2332d13b529353 UNION ALLSELECT 'PUSO', 'celo', 0x105d4A9306D2E55a71d2Eb95B81553AE1dC20d7B UNION ALLSELECT 'PHT', 'polygon', 0xe75220cb014dfb2d354bb59be26d7458bb8d0706 UNION ALLSELECT 'VNST', 'BSC', 0x3b26fb89eab263cc6cb1e91f611bae8793f927ef UNION ALLSELECT 'JPYC', 'ethereum', 0xe7c3d8c9a439fede00d2600032d5db0be71c3c29 UNION ALLSELECT 'JPYC', 'polygon', 0xe7c3d8c9a439fede00d2600032d5db0be71c3c29 UNION ALLSELECT 'JPYC', 'avalanche', 0xe7c3d8c9a439fede00d2600032d5db0be71c3c29 UNION ALLSELECT 'JPYC', 'polygon', 0x431d5dff03120afa4bdf332c61a6e1766ef37bdb UNION ALLSELECT 'AUDF', 'ethereum', 0xd2a530170D71a9Cfe1651Fb468E2B98F7Ed7456b UNION ALLSELECT 'AUDF', 'polygon', 0xd2a530170D71a9Cfe1651Fb468E2B98F7Ed7456b UNION ALLSELECT 'AUDF', 'avalanche',0xd2a530170D71a9Cfe1651Fb468E2B98F7Ed7456b UNION ALLSELECT 'AUDD', 'base', 0x449b3317a6d1efb1bc3ba0700c9eaa4ffff4ae65 UNION ALLSELECT 'NZDS', 'polygon', 0xfbbe4b730e1e77d02dc40fedf9438e2802eab3b5 UNION ALLSELECT 'KRWQ','ethereum', 0xc00db6b41473d065027F5Ed6fAdA20fde75f142e UNION ALLSELECT 'KRWQ', 'base', 0x370923D39f139C64813f173a1bf0b4f9Ba36a24f),ethereum AS (SELECTr.blockchain,