Query editor
with ap as (select spender, owner, contract_address, count(*) n from erc20_celo.evt_Approvalwhere evt_block_time > now() - interval '90' day and contract_address in (from_hex('48065fbbe25f71c9282ddf5e1cd6d6a887483d5e'),from_hex('ceba9300f2b948710d2653dd7b07f33a8b32118c'),from_hex('d07294e6e917e07dfdcee882dd1e2565085c2ae0'),from_hex('d7493e84a060292cdca6b67619402f7702336bf4'),from_hex('d2ab3c9a02dbbab236bfec45d1d755df4267f771'),from_hex('af37e8b6c9ed7f6318979f56fc287d76c30847ff'),from_hex('fecb3f7c54e2caae9dc6ac9060a822d47e053760'),from_hex('e9185ee218cae427af7b9764a011bb89fea761b4'),from_hex('d15ec721c2a896512ad29c671997dd68f9593226'),from_hex('471ece3750da237f93b8e339c536989b8978a438')) and spender in (from_hex('000000000022d473030f116ddee9f6b43ac78ba3'),from_hex('0000000ce42d4981513060ab7e50b9e5e2d19af1'),from_hex('002f72962fa2d1fecce5118a9adb42779c7d637b'),from_hex('00eb761732a8e218354bc316e9ddaf9da134d9f5'),from_hex('01b006d5c687bde182aa36f542f1f014144742e2'),from_hex('01d40099fcd87c018969b0e8d4ab1633fb34763c'),from_hex('023fa838682c115c2cfba96ef3791cb5bd931fc7'),from_hex('02687791c96e3beccf97e42ccc047100e23fb1f4'),from_hex('0287854bc8ed933e932b326077c12cb57cb53880'),from_hex('02b567ff79645b666ad9434b1dd91e723a3193d7'),from_hex('02db1be7d7dae7229350caf9a386d732b0cd5125'),from_hex('02e5be68d46dac0b524905bff209cf47ee6db2a9'),from_hex('041120a39b107a745ce4f895331723dfb53cee15'),from_hex('0511b6a854a5d10d673715036bc91fda97af9bbb'),from_hex('05558b130c85fda2f02dbbc4321d0f6567e9772a'),from_hex('077ac6faae04b64b1cf8586f95d890491bed04e7'),from_hex('07d806c08ad7a3fe6fcd633b5c0704ba971ec28e'),from_hex('08ad8a320327d7faa857fb73036927f9f1be94d8'),from_hex('093a7a9dc23a7a4c1088824d1a39f6a72f48c252'),from_hex('093d55468acee5a9b11644d1e55097c4e99c2739'),from_hex('095226a21fa618991672339fd94381611f429c62'),from_hex('0a16835afbff15a41e4872133e59910cd094f15f'),from_hex('0a36b247692c1aaa2c3e6aab806a3e9546d74e44'),from_hex('0b44ef26e22c8cfb32f0f2476e4c4103f18563b9'),from_hex('0c4842d9ee1f9b7e224fc53da406fd7251b50185'),from_hex('0ecfe5bc58315785834b38b55a033c5c1eb990f3'),from_hex('0ee22f830a99e7a67079018670711c0f94abeeb0'),from_hex('0ff15eb2a5833efdd096fa7c1ac8e7023f8f72ab'),from_hex('1103e5b875a921d925862be28760a6644f7dea34'),from_hex('1120022cf25da7b5e6779f80f630818725f185bb'),from_hex('117fd472b97654fce5006c11afc7d867b4176201'),from_hex('1231deb6f5749ef6ce6943a275a1d3e7486f4eae'),from_hex('12c3f65cee533fe34943cfe1bdb84004fef610bb'),from_hex('12e2512ca4802aa5c49bb1d2e35cbadaf63cbc80'),from_hex('12ed8bccfe379b3e83bd11626f69a633f3d2f7cc'),from_hex('1421bde4b10e8dd459b3bcb598810b1337d56842'),from_hex('1459e4a73c6abd19aca2bc50b30d3f1ed229a329'),from_hex('16da2feb45de9d1e678c8a4efd2ead0eada1c23a'),from_hex('175d0f9d6efdcade07ed0342f576bfe2a17a2c6a'),from_hex('1787324d35abe3c4a593148a7d866a05a84df539'),from_hex('178bd4bf09e257a63772bdf52463a2a6c34cb418'),from_hex('179ef3aa8d259f9bad57a6f0777238a3a6a0391a'),from_hex('182b18554faf5d40d0a7b3c24d20ad2b294bdfcc'),from_hex('188ef8697602688c7bd7b167254769cd3735f5b1'),from_hex('18958f8b0f3acf16f6668ce256103b5bf8be8d61'),from_hex('18c23892cc1243d019e1f61b3bbed836145c96b7'),from_hex('198d5c1ecb66b09116c98b51816c02e39fab2765'),from_hex('19b6b95bcfc3442ebab4dc10e1ad54f6e7600f19'),from_hex('19c7a2f1e861b5f9bb90f257dc74fa56970ef7c5'),from_hex('19ce0b7c48608286a7872147f89f70896d0e67c6'),from_hex('1a9fed872f9562af9bf30eadd86d9fa1bc865a76'),from_hex('1b71d3a00b29b6169af1f57ba803dd7feccb25f7'),from_hex('1b7a410ecc527a4ab97693efd7850fcf088db989'),from_hex('1c8e0f6e5619c50aafc9214cbbcfc5d2fb3bf6c1'),from_hex('1d2b1de847bc76febf6671dfdbc341569eb4d41b'),from_hex('1e3f971fee8e885b42bcdba9cd64b47b15e26515'),from_hex('1ec24c70a08eb698ecd1dc6b70d46432df3dba30'),from_hex('1edac166ac0c6c7e4145d1ede01338e6eb9cf53c'),from_hex('1faf7640110fb09bad288dbef5b4f676b0ec1932'),from_hex('210aecfbd69894daf5006bf245f7235354e775c6'),from_hex('212daa217d91a15cd20eba7f6a81ee917422eaab'),from_hex('218414ad37206fd4cfd6c47947574708db0e95d2'),from_hex('21caef8a43163eea865baee23b9c2e327696a3bf'),from_hex('2307ba97c80008d63dec68c89a6bb0e98f303f06'),from_hex('235104fdd843bb805b8c4c9b5b28c83be9d326bd'),from_hex('23594710c77db93f35f9e59dc53a0580074f1ea0'),from_hex('237b9e5ea9f657e4502a8fd1cc9ee9d18c769a55'),from_hex('238394541de407fd494e455ef17c9d991f4fbed8'),from_hex('23ea5566530028d71651219abb5a421ed383c7f1'),from_hex('24434b1d5bdfa9e724dd1eac5d7eff02a79c101e'),from_hex('248b46beb66b3078d771a9e7e5a0a0216d0d07ba'),from_hex('258190e9f2807104858c18f60684fc6f0d75a60a'),from_hex('26a572ced0206554035051449121bc7c0c0f7c49'),from_hex('2733020145e8f574477b620944d9cfa45429bb60'),from_hex('2758fbaa228d7d3c41dd139f47dab1a27bf9bc25'),from_hex('2774085ec7b0b4e30739eac4b4693e587c639e03'),from_hex('27fd41bea85c39254f2b12789eb37a1543152cc1'),from_hex('280840644b33b5acd58a08399b76f71f53dfbdc8'),from_hex('288b7cdd10e069ea64d4984c3e5fa0d9c5816009'),from_hex('2893a88ae0dd18ac9406c294e5da3a91f17afe6f'),from_hex('28bbf0263919693f09ae114739d0734058002fb9'),from_hex('28f209844029755fc563c1bd4fd21f42dc7ce0e4'),from_hex('2a12076bde47004d6ef34fff57e7d3df7d9b980f'),from_hex('2a194d9469f424ec33992c77779c6a4a51751d09'),from_hex('2a9f38b41035a900d5038d1972955011fb3278e7'),from_hex('2af88995303b5e02b705a904e478729cd9abc319'),from_hex('2c1e1acaeeff8cc7c263918ba60d3fe8fbded586'),from_hex('2d492141664d309b728ad080a2963f5fd78ee5bc'),from_hex('2d94ccdc60dbd0c27a76dce05685c0a9474ed1c2'),from_hex('2dd9c7dbb7153cd1bb6ce74913eb9199d3e113df'),from_hex('2e05433e0fdd5ee920d916901682f05824a9d69d'),from_hex('2f366e160361f286904b9fbfa977be6630017113'),from_hex('2f686751b19a9d91cc3d57d90150bc767f050066'),from_hex('303382eb6d06de0a2f1386fa4b120e40b7f6a1b1'),from_hex('31b4cbc6c3508156ecafd937b36c5bf68848bcba'),from_hex('31bf6609dc9aefcafb5d6e5fa4773e0b1bf61a01'),from_hex('35b45d997b1ef6f01e806c8b3de309fd372b04f2'),from_hex('35baab4af46c2e04c2f5e2b703c221cb63b6a2a8'),from_hex('35c4dcecd0ef551d170e3e5146dede955a031959'),from_hex('3667a1e0786ea7dbdfb807833e7b8ac65894accb'),from_hex('3675ef491dadb71a646bb0254f081a1cffcc1975'),from_hex('37679bdcc253373568d9e87c812706e530e454cc'),from_hex('378ee482d446a6d8d8715a44932affb89aa4bb5b'),from_hex('37d6af9eb38a25ac8a4b8cc6ba2d7b825ed9434a'),from_hex('394753ef9904804847c73eba69c87aed524cecb0'),from_hex('39a25fd56668b2ce90caacecc2b587c7f03a9a9d'),from_hex('39c3e0fb6d6571d5efc02bc60ed2627c8d606070'),from_hex('39e66ee6b2ddaf4defded3038e0162180dbef340'),from_hex('3a053b962de5569970840b303b0d6d92ea5d7939'),from_hex('3c357af3300f383ea49b6d6ed8e084199a92bed8'),from_hex('3d79edaabc0eab6f08ed885c05fc0b014290d95a'),from_hex('3da5f9d36d1ae8769a9460a7788a21c8041c7bb3'),from_hex('3e59a31363e2ad014dcbc521c4a0d5757d9f3402'),from_hex('3e7544a07157d03a49359ee89f2fcac9a6467230'),from_hex('3e95a025efc7f93bf4efcbea40297f97d421a274'),from_hex('3ef8f9a0da701ce46b022b14e87315701d4bfef7'),from_hex('3f2ab6fcbb4303e294f7c82a31929b1bd2f48ce3'),from_hex('3f2bd3ba3809e439199c76d768b3c1d0acbc8dee'),from_hex('3ffaf39ddcc4851f96613416000923e4e21af01e'),from_hex('411e44db70476f74c3560f5ccfdbc8c63f231d33'),from_hex('4127b3e3cbf3f1bc01b9ee50f5a77efcd795322e'),from_hex('413ffcc28e6cdde7e93625ef4742810fe9738578'),from_hex('41ed3de4bcd764bb848026276353b884cd8bbe27'),from_hex('422615e302eb064a440f5be03400e03b6655abb6'),from_hex('42fd02fbcd9fc77fff37bb30766eb1c68d7afeb2'),from_hex('432322bb26e286795ed20d49cf34f62e4d98c252'),from_hex('440933053fb430cabf8152f59f5967ce0feb5f15'),from_hex('44b74ee2695d6937df20877d99a1a9609c48697d'),from_hex('454c27070a04376616eef649d48789daf24a3c59'),from_hex('45d4a04162187a8353411d940696dad1938d7855'),from_hex('48065fbbe25f71c9282ddf5e1cd6d6a887483d5e'),from_hex('48089fbd48576390bfd68d106d21715200e0207f'),from_hex('4861840c2efb2b98312b0ae34d86fd73e8f9b6f6'),from_hex('48836171cf115f94a68ff9017b39fb3df48dad67'),from_hex('49ecda7187c48a97e5a17a8f26d77ea90234144f'),from_hex('4b2118ea66a18e433aa53e48e718dbfb81dc55f0'),from_hex('4c363649d45d93a39aa2e72cb1beae5e25c63e88'),from_hex('4cd00e387622c35bddb9b4c962c136462338bc31'),from_hex('4f450a9f80b44100ac335d6185b7486870abd42c'),from_hex('504c108093781b82d8060a9e1d14e7a11da2ce6a'),from_hex('507f0387d2b73e3c9981fb15954bdeb828753c93'),from_hex('5264b1f45616db619bb3c8dcebd86fb33fa0e53f'),from_hex('54517eb73891f3ae12417b6c65babf55d668e06f'),from_hex('5567954cd026cebfe486062cb75848e0f1c12e58'),from_hex('557e17a790c85d867813fd9446a5263307a44ca7'),from_hex('5615cdab10dc425a742d643d949a7f474c01abc4'),from_hex('5615cdab10dc425a7b2b68c54518692a0ad4b143'),from_hex('5693af68ac72ed4d1ab7470f268d1c2cfcc76170'),from_hex('56ae711e89389f324237a307132b2f397f5868fd'),from_hex('56b41bca18898e2fece63843396215db71ed5f08'),from_hex('56d0ae52f33f7c2e38e92f6d20b8ccfd7dc318ce'),from_hex('56f3b7c723ed59ed030194b40685bb801274535c'),from_hex('573a678ea7a51b51344fe6a1781bbccbf0e453c7'),from_hex('58166d5422717f3db0c4c76139de6fb11d4a09cf'),from_hex('58a3724148f9714c448dad80a3ef206178d48597'),from_hex('597f53d5b4691abbf9e54d03c56425a963684ee9'),from_hex('59dc13c4317cffeebd77cdd295c3d7981eac1264'),from_hex('5a1f66d1e8e905efb176a5f647d0b51d8a979422'),from_hex('5bdc332f36017dedb48fc402598dc568c1ca60ac'),from_hex('5cde4d414f27e331b6738f783bc84c5507d8ee7a'),from_hex('5d26601065fea02a6a728388c983c976da713b01'),from_hex('5d9469f1b13dd69bc93a934d9b4c469331dcd2ca'),from_hex('5d9e7e68c77bdc4ce3edce50008b768b05a5656d'),from_hex('5ddc3c3e4799426baa56f7feebd6f3b8f97068ec'),from_hex('5dde4375a10df22279266eda9e2e05b86a9d0eb1'),from_hex('5df8ae2b963165b735b18ca86b1ea448d2aa032c'),from_hex('5e023c31e1d3dcd08a1b3e8c96f6ef8aa8fcacd1'),from_hex('5e5f4d6b03db16e7f00de7c9afaa53b92c8d1d42'),from_hex('5f614a44cdebd95b31ee88a82d5333d52687bc10'),from_hex('5f84b91c7a5186715815a5ed71f5f0bc10ce57bd'),from_hex('6131b5fae19ea4f9d964eac0408e4408b66337b5'),from_hex('61680738d3cc991dcf705464c6e06e935b876533'),from_hex('618b6ba24725acb1081cd4bc93e67e2f375d8e45'),from_hex('61da152d6842d343632648aa58244ffad59f3041'),from_hex('62af7d48462ff97cb69a09100590731eb3280daa'),from_hex('6352a56caadc4f1e25cd6c75970fa768a3304e64'),from_hex('63951637d667f23d5251dedc0f9123d22d8595be'),from_hex('643160db1995010970d64c14f429732cdcca62c6'),from_hex('6619871118d144c1c28ec3b23036fc1f0829ed3a'),from_hex('666792b9ef14d6ca9aaeee598784efcfd2840591'),from_hex('669cc493bcbf15278f07a22f1af09b553826ff8c'),from_hex('66ae3bfa3082b7ddd828386a20fe4d44376e8967'),from_hex('66fe4f50dffc4c1c6a3040e8daf1ecba02a411db'),from_hex('67316300f17f063085ca8bca4bd3f7a5a3c66275'),from_hex('67501f8d479eafdeb481d8f9cdd73461fec9a3b9'),from_hex('67c3f5b5d403f074c41936e4ae5076ac458ea537'),from_hex('68b3465833fb72a70ecdf485e0e4c7bd8665fc45'),from_hex('68d88625208f9f8d14bbda54e768aca99a8c2a71'),from_hex('69101e1884ee42ea654e0ea469193bf8d268936c'),from_hex('69460570c93f9de5e2edbc3052bf10125f0ca22d'),from_hex('69c9faf5c9b3a9227c2e1e5312a261103b99933f'),from_hex('69e9f6907376daa94db50d5b6494cab39b53e743'),from_hex('6aa46a2169c5e9f5c4e4e90b362bb87f5c0f3262'),from_hex('6bdbb3bfbfa188a3f72c5b260eabdfeefb8d1091'),from_hex('6c6d532c781d08f9b1c33eb0a8273a2474535a32'),from_hex('6caeaafbb6f82e5796a649521e0246231c572fbc'),from_hex('6cde5f5a192fbf3fd84df983aa6dc30dbd9f8fac'),from_hex('6f42b9d2085a0deb711c00a460a98b9863ae4897'),from_hex('6f49ee3bd1cae6a7fb938732227d7b45ef812db4'),from_hex('6f874c978f406b4752ceac1f4b9936845e4902af'),from_hex('6f9074a0bc5b92e839da4fd52f84be9d50e065a9'),from_hex('709ae3bca318142899f4997cc98c999a663894e5'),from_hex('7196d2c7beeef5e2d23aa8d5a82feb1950d45573'),from_hex('730a0389ebe4204c4e5b8dd24a7e17275b7ecc3b'),from_hex('734b7c12bd386c69839646ef988b3b4068bc6397'),from_hex('7441156594d4637fa1aa1f53f188139a10a5eacb'),from_hex('74a7eeb33d3862a0fa347a4c61eb4b02f56c958d'),from_hex('766a12333aa5249cdef2259cc9d3ad0c746c8132'),from_hex('777a8255ca72412f0d706dc03c9d1987306b4cad'),from_hex('78498709c45d6b4feca7dad5b7a1b10877c90a75'),from_hex('796dff6d74f3e27060b71255fe517bfb23c93eed'),from_hex('7a6d627b0464dd33c988ae3a99aa6372191e7eb2'),from_hex('7bbefbb6c5f15328946dabd412ed3be195705781'),from_hex('7c09a9c30736f17043fe6d0c0a3d03a7cf6e78fd'),from_hex('7d28570135a2b1930f331c507f65039d4937f66c'),from_hex('7d63868321c1c12b6da8eadc3f3dc91cb48bfd84'),from_hex('7d6be41a31dea59e280530c4accd4561444f2ba5'),from_hex('7e8898658c8c2879e9824198b375a68587b4b276'),from_hex('7eba0f116e731fa793a592f2cf6d80dfcd365b30'),from_hex('7ebe42906a5f1dd96e47e7152102a6aa0a0d2459'),from_hex('7ec9672678509a574f6305f112a7e3703845a98b'),from_hex('7ee96ddeabb9a7a93cd4a66a32ac45622028555f'),from_hex('7f0718aace05c6dee5796021aa0ddce2aafcbc4a'),from_hex('7f4045dc51ea17f33a8695c7c98e83da58c6418f'),from_hex('80858f5f8efd2ab6485aba1a0b9557ed46c6ba0e'),from_hex('827ccea3d460d458393eeafe831698d83fe47ba7'),from_hex('83013dce53676f523db8175832f2f3ad5b1fbb1f'),from_hex('836b336fca26913176efc45a5a6e5e72cd7bd13b'),from_hex('8388ddfd12da76ada04bcf38de85f861fa3fee54'),from_hex('84011b39fd7d12a308e3ac5f8d2bd39028a812d9'),from_hex('8536fa9a165204fedc4a0dc94c27606419b1b8aa'),from_hex('8615c66aab75996d72ddc17df9d63a0546c4fbe0'),from_hex('8620db524bcf013645b745c64d192e6f457da993'),from_hex('881cad4f885c6701d8481c0ed347f6d35444ea7e'),from_hex('88a59c58ca70df6971f9499f6117a2ba41653e3e'),from_hex('893f26ce6457475b63767c648e51c230f25e9f72'),from_hex('8956b6d81785b3c9dc4991fb27da897e3f8fe5ad'),from_hex('897387c7b996485c3aaa85c94272cd6c506f8c8f'),from_hex('89c6340b1a1f4b25d36cd8b063d49045caf3f818'),from_hex('8a691690db7c2353f950be465fdd1073778d1aa0'),from_hex('8a9869c4ba45041a1b853b81fb3006739c98c5eb'),from_hex('8ae6670187b47b780622c0cfa5a23d548194f4fa'),from_hex('8b1f6cb5d062aa2ce8d581942bbb960420d875ba'),from_hex('8b844f885672f333bc0042cb669255f93a4c1e6b'),from_hex('8bb391f98a011e1f36b8e3abdffe2f3b166db1ec'),from_hex('8bb4c975ff3c250e0ceea271728547f3802b36fd'),from_hex('8bef804e03e70ebc10d8da4cc70374e33a4f2acd'),from_hex('8c0b8d3d5af6c1f1ee21392459506134e0c40538'),from_hex('8c81f8c4906784b6bf676613b4b1bfda17059bcf'),from_hex('8d290c97100f0e87e04efd1a790f27004fa3f08b'),from_hex('8d9975296cd06ccec0f695fba8468d00185309d5'),from_hex('8de29a04dee5894d7bd536a7b4c924560f2dff57'),from_hex('8e3dc1365359a77de7f25e49d05645fdcf2b076a'),from_hex('8e70ada33714c3f8f35182b781c63449c5e079b7'),from_hex('8ee3165c50b8185dc0f1984c24a1a5b1d72543a8'),from_hex('8eed5e28216c0bc6f817df40ae6ca11c2294cc1c'),from_hex('8f4e627d4c4af5dfe11908bd8b929588d9ee58c9'),from_hex('8f7d848d1330e6f0641977340bc545b2db536fdc'),from_hex('8fdfcfeec83a45f61467378a8135f59248da088f'),from_hex('9039b97ab035a1546387756c89dc810ad14ce147'),from_hex('9115d36f15943c1826907983553f884ef8e65f2c'),from_hex('911a744ab8eccb504173fbcabbd7c34648f2a773'),from_hex('916ee1ca253749ce04f00b0b11577563bbcf71f2'),from_hex('91cfa8c11711628bfa7d1786cfbe2616bd6e6b78'),from_hex('93049bd10a7e059c965630c5ebe71c8fbe449d26'),from_hex('93316de31b4f891c56cf3b65a3f96aa6b04192ae'),from_hex('94a0b780e4b521fbdba6c8005edd9c913151b37c'),from_hex('95157729cf6fa77ec7c10f25047c6dac74fc527b'),from_hex('962d0f30245ce5d2b2abbfbdd018427f55bb7f9d'),from_hex('970b12522ca9b4054807a2c5b736149a5be6f670'),from_hex('9882d3a7a26ea1e8d70eeabb2711273395e93943'),from_hex('98fe76f41b3c4077c4014fec0bf17db5ce71f93a'),from_hex('991d5546c4b442b4c5fdc4c8b8b8d131deb24702'),from_hex('9945a5b8407cc68d45a5835e9040881966b8435a'),from_hex('998ade33acabaa1a8e252101dd8e3316c264bfb0'),from_hex('9a0474af76709af0faf225da06e37139d19446e5'),from_hex('9a74f670f3c59ae4b8450fdd477b0461b89d2dfd'),from_hex('9b572f721d7b11142bf4dbefa9b9d31ecc8f54e3'),from_hex('9d0193f7b607a15079bfe29ae28d69044f62c391'),from_hex('9d65864ac3341f90b916c30022ccf42176e47768'),from_hex('9eb22700efa1558eb2e0e522eb1decc8025c3127'),from_hex('9f989b4a93d67e63ad7c7cc9a25f34c1fc174da5'),from_hex('9fa5570f3a37fd47206b149e81c19f96e520776e'),from_hex('9fd5498a7137f5fc3313906012fa6c0db981b78d'),from_hex('a01de3d9ddc1997ed6453fe483c1c630ad37a3c8'),from_hex('a06053b2bf258f3ffbd2d1f29af856a4bd2ce574'),from_hex('a294b0575d797fedc79fed9a0f2ce22a6f326d8a'),from_hex('a35995bb2ffc5f2b33379c2e95d00c20fbf71e70'),from_hex('a3709ed2c5826cc3e5e7d2a6c17b74d629703708'),from_hex('a3b339624d21a055c6da036f8e6d219ff2c3c444'),from_hex('a4303482605aaeb0bac78f184f2f132d5e8a132f'),from_hex('a5e1a81738259256181f9a0e478188553062d340'),from_hex('a6351faeeb097698289586c4d6188530300db209'),from_hex('a65c55ce94ce54714a8bd448c9ff11d6a287303e'),from_hex('a6f999336dde2df3b69b1140063a8009b67409c1'),from_hex('a72d1177d32266b339235ebf692858e6481e9c4f'),from_hex('a730b463395f5ca07ece5cefeccf7f45e1e2c9bf'),from_hex('a885935dceabdf958c6fa52ad3559fe03f09f3e7'),from_hex('a8cfc1b4365518f56954382b6fab25a5382f5c49'),from_hex('a8f1aaf9bbd30e5c0fcd59c3269a31718824cf75'),from_hex('a8f40ed7437bcb6bf264832369e8364b80b06c83'),from_hex('a9083d72fdeb469e58f2803f2aefc226c49effbb'),from_hex('a97fc9666a41cdae3efb74a4cac87b9d33a16f0e'),from_hex('a9aa0a64769cbed4d3b1ceb4df01cde915c235b3'),from_hex('a9da96170fce6d5a1f4685964d19daba9a9c37bb'),from_hex('aaa559bcfd9cb4fd434fbbc92f014d3e0bc9cb25'),from_hex('aaaaaf3ba19413a906fddd49d489b6908f730600'),from_hex('abe0180a635cccf05cf447b66b2a5150576e45bf'),from_hex('ac4c6e212a361c968f1725b4d055b47e63f80b75'),from_hex('ac9e78fac2fc459f531721354ffc620ce76e6d89'),from_hex('ace3c09d5d01839f70c8ab03477869fe377436f7'),from_hex('ad314e606616702223d351184041c2a3ddb6d217'),from_hex('adca9a707f394509c8aa906b89b93cb222f2bebe'),from_hex('ae11e439164c7ad2ed202479c2747cacf35c532d'),from_hex('ae18d9e48367fc3d9d6977c221b1377ce6b7c1a2'),from_hex('af3cb90f8002b4f08ba7f7c4fb5d9bde698236a7'),from_hex('af84bae0a1036b7cca75a53942f43a202cc6473d'),from_hex('af8eb5ed5ef74918fe4ea1c42522cf57b7cb9a61'),from_hex('afec167e1402309891afd69db1e804c3b68aa925'),from_hex('affb98decfc3e1e7867fa412bf9580e377be265a'),from_hex('b0ecc1e95455598d5bace76e3d4e0c0aa565835a'),from_hex('b180f98037a63a3dca66b6b4ddbf250265b65110'),from_hex('b1f3a7b816b0681188f54dfa400991b93adf00ed'),from_hex('b2102cb86e0958713da09837f98af6fa5bf3ea08'),from_hex('b23d314781223b281144037fb4cc8c4580e73c88'),from_hex('b279c4380557b319c42ef3b023ac8c8b2d64b6a0'),from_hex('b2cdf6403da1ef1bb911d87d0dd155a699869bc2'),from_hex('b2d93bfa955746655ffb345037ac5e86bb22d207'),from_hex('b34548ad3a45c2a571f99341e5fb32abb4facd05'),from_hex('b45e53277a7e0f1d35f2a77160e91e25507f1763'),from_hex('b55c054d8ee75224e1033e6ec775b4f62d942b43'),from_hex('b64c8b0a3f8008d5028d8f9323b858f17b18c3c4'),from_hex('b65b5349edd1864641e5b6008a994f3fb41d536b'),from_hex('b767284b11129887bf09ee5f2db0034f3931dd98'),from_hex('b837edcf60c1cb6df49111df7fd28611b3321345'),from_hex('b8a235f56fc9b399b027647532efb606e5e66ac8'),from_hex('b957c550333222013ade8baef10e4608b3a850f6'),from_hex('b96f9a3dc173cfbeec77e867ad10c47b525917b3'),from_hex('b9703a3bbde001becd76ea86a71256fe5ea996d9'),from_hex('b9db6804e84d960e139a2bdc33bfc30f8fb689fe'),from_hex('ba0c6269dcddbb34a1c097a7473f1301558bf853'),from_hex('bad4711d689329e315be3e7c1c64cf652868c56c'),from_hex('bae8d41d1c0a997080420c4bae89475fbc6a5d33'),from_hex('bba1938ff861c77ea1687225b9c33554379ef327'),from_hex('bbbfd134e9b44bfb5123898ba36b01de7ab93d98'),from_hex('bc3c73529944b5ee0f39d3098a4467f1a0763f64'),from_hex('bc5af9807881b4f367d10f311c91155e88e2c1a8'),from_hex('bc7c8e7fc7a8ce54c50d17523fb031ffdc203fec'),from_hex('bc853ccf2481e8a566f856d1d029922dc6dbfb6e'),from_hex('bd2411183facd4edfd3efe096687e8dd66f5cf07'),from_hex('bdf8193644e63b948c959e553ba70487573451c8'),from_hex('be50daf0b6f3511a3fc07bb50bda7a371e9a5238'),from_hex('be729350f8cdfc19db6866e8579841188ee57f67'),from_hex('be92103bbd23c8e690d764b017b883eb706e3f5e'),from_hex('bedaccbd65230ea441e7955c0f5344acfc2a45e5'),from_hex('bee802f09a4d92cad7d696bf7dca6861d4d3f49b'),from_hex('bf2ef3c3a97f3eda187bef290e39189e7c5827be'),from_hex('c08c00491fb02c61299ee2951379ae5e5c3a8774'),from_hex('c1a9e274a0eb5ae4b39ba5534320709311154734'),from_hex('c217ef66838ccf40e4a19c141d0143e069afc097'),from_hex('c45617fbb1b1a5cca9062b638c44f8e378a45275'),from_hex('c477032db5ccbea767fa74ab76556ba15a06de5b'),from_hex('c6190f0f9759bcc9d4cc8761a3c69571e7dd0547'),from_hex('c66e03e3b6fa3175bd11655af5890aa97e220a42'),from_hex('c6b98147395900d4ed9876f13b1574ee86af1016'),from_hex('c6c88cc5d6877b1416bc39cac07afb0bac8c4378'),from_hex('c7899f166a2e400ecf29d6a12d6eb69e401511fa'),from_hex('c7ef75fc6283ab3b810fa4de270f074c47761189'),from_hex('c88fd3c032406f64c70a6c1aac9831602362ee04'),from_hex('c8f467e1ba04ffdeca1cd1878ca3416d84045d0e'),from_hex('ca652148317b8bb1e02f8a02223f3dec845f6bdd'),from_hex('ca7d56e1cb477d3ce39800a48ccf7e26dde35888'),from_hex('ca944fb73fa5191969014ded9bb075381d59c7de'),from_hex('caf22ce31298cf2bf1d152862f80216478ad7c67'),from_hex('cafd2f0a35a4459fa40c0517e17e6fa2939441ca'),from_hex('cb9cccf0451a284471f5ec835c03bb5d931ecc7e'),from_hex('cc5970551908673311ee04f2eedb617229627f02'),from_hex('cc5dd1ceb9ca6f7b3f7edc9522d4251581cb0afd'),from_hex('cc68be72cfe2d614eb41f4008e3d42f7d5bd3949'),from_hex('ccc88a9d1b4ed6b0eaba998850414b24f1c315be'),from_hex('cd02f10342505682869d1db2ef6d54755a0886ae'),from_hex('cdbbc0db75bce387bdc9ea2248c5f92b1f8d88c1'),from_hex('ce089d80e40bc5b20eec02acd128afd96dfceb01'),from_hex('ce16f69375520ab01377ce7b88f5ba8c48f8d666'),from_hex('ce1bdfe3eb58a610530928a36a6cedf4255facd9'),from_hex('ce40449b773a3e6e5e769adb4e567179d4828cbd'),from_hex('ceba9300f2b948710d2653dd7b07f33a8b32118c'),from_hex('cfeafcdd06d3a0e3bf1596f8afa1cac1dc19ed60'),from_hex('d03ffebbcaaa8aa21053eeb0eeade39efc504189'),from_hex('d083ab9b25b0dadc27238f1f2167c128ae88be0b'),from_hex('d1088d3376c2384d469d1c0d55d503695e1be3e6'),from_hex('d152f549545093347a162dce210e7293f1452150'),from_hex('d24ecdd8c1e0e57a4e26b1a7bbeaa3e95466a569'),from_hex('d25e02047e76b688445ab154785f2642c6fe3f73'),from_hex('d2e68acd875fb1b3a98dc0d72659910b05e7e08f'),from_hex('d2e7f202163bbe26a19f0ca13e3539840a218031'),from_hex('d3d037f4b2c8d6a83ca9d20da61a28b3a495fd81'),from_hex('d403c465e190e2f8e4df233ec69efa7886bbbdbf'),from_hex('d4845c6fe467845dcba2997191127d68ece4f1c4'),from_hex('d6591b948c526daecc4a469aaa0bdbe92ae2f097'),from_hex('d66b948d986083dacc9b4e37d66ad4cabf05e36a'),from_hex('d7137d85607be18628ce00b1020895cebceead6c'),from_hex('d7d7d76964457356d5f05e244dd4fec51bacb257'),from_hex('d7e3f17ca3fe08dcc24b89884a889afeeb15c8df'),from_hex('d7ea6f0212b5b54a9fa4fc2d805ce63426a48b18'),from_hex('d7f882e5a178983fcbeb0e9e5508d2a37a8d85d1'),from_hex('d8287809e0d68e7e50d0d962f11eb72150f48d39'),from_hex('d8749b82275a00401d1e3ac2625b70e3cfa42491'),from_hex('d9806923a40c9436ba53c5c1bb35da8c7d3d2d4c'),from_hex('da355126230365434962e50fc898728ca171c7d1'),from_hex('db1eeed09df45de38f021a39de96cd33e402c6e7'),from_hex('db299682f6568ad0193a7d37621a2eb474ca7499'),from_hex('db86389b78a0a7a2c176ca18be457e1c263e5451'),from_hex('db8b57efc26a7bdc4fac03737e7725b2c1cd566e'),from_hex('dc0b134cdc56c29b3798980bb90735a749afabdc'),from_hex('dc14d41bfcd386e035bd1ba3072d2f8c5e21eb9a'),from_hex('dc3df64448fa5d6f005cd3f0f3fce7afe7682b0e'),from_hex('dcea4f26ecea938080baec5fb29c2c4c933f3e27'),from_hex('dda2f62a2b82f70d63eeeedef2e63eb8fac22296'),from_hex('de098ce38dc3800fc170cdf2580212ab4521118d'),from_hex('de2b920506ee931a6a2abdf566526220214fbbae'),from_hex('de544cdc24c8ef7a3b893761130e8e896b5979cb'),from_hex('def1c0ded9bec7f1a1670819833240f027b25eff'),from_hex('df023f57955778aa7cfab09cfbfb7d7c98133af8'),from_hex('dfb7ff6ad5f7c653dd245bc7191435b066420e17'),from_hex('e0713cffc8fd5ecbe9c5cd0ca71b662d948c35bd'),from_hex('e0c7af3f0fccf9ec76c36034dbbfed70cf6708da'),from_hex('e12b1e2a10effbd00e3daaeb614df42ffeecb158'),from_hex('e2023f3fa515cf070e07fd9d51c1d236e07843f4'),from_hex('e226e4825cb215abafad98fdd400583eab6a594f'),from_hex('e28cbfabbab1e1242204bcce1a1a2831d33ad0f4'),from_hex('e2a5b12061a8317736b19e3ff117d1303972ac4c'),from_hex('e2b49eb5d71e142a57d7989ca482ad6e129c9f5b'),from_hex('e389f92b47d913f773254962ed638e12c28aa82d'),from_hex('e3d8bd6aed4f159bc8000a9cd47cffdb95f96121'),from_hex('e412af802099fd38a511c411fe3a9deea8073b8a'),from_hex('e42cf4620de454be0de5004255d25683e4f882c4'),from_hex('e452b5d16e7f91f698b7705b3ea18fbab2ccd7d0'),from_hex('e5453b10accd04dcc0d7c1de4af56bd4c2a7a091'),from_hex('e56017175ca1dfa2e5f3db77945a3362ba1ed6de'),from_hex('e56e80bd58cbe1235f1887011a72592f7dc8d068'),from_hex('e592427a0aece92de3edee1f18e0157c05861564'),from_hex('e66aa98b55c5a55c9af9da12fe39b8868af9a346'),from_hex('e66e57bb6a0608c413ee6aa5b1820922e23cf601'),from_hex('e698a64c698e52a64030a51fd6db87439a237cb2'),from_hex('e757683a51cfd002de479385c2f4c9db10a5e8d2'),from_hex('e774df6b8d71c37579f0e0625981035baab61d15'),from_hex('e84d263aff03fdb326db0421abb4d38c048eab8f'),from_hex('e99e90471bc1b728d6a766164678859d4b920a4e'),from_hex('ea280b39437a64473a0c77949759e6629ed1dc73'),from_hex('ea4b0689cc08df40d8384605a84a3688a3a9263a'),from_hex('eac35f40a57965a7ddb955a5f51f2523fa596362'),from_hex('eb504b0dac78e9adad920a8cfc9496d4e3f4f9dd'),from_hex('eb9b9e886433735b2e32367f35e543d50be0d87f'),from_hex('ebe5fb4657a6fc622590bc6941fc918f7ab125e2'),from_hex('ecb5a0a6b1f24f9a0c299dc6235a47c760901df2'),from_hex('ecd14495bff7e1fce8895ae268085d02df6f0e20'),from_hex('ee7d9d51e5c525fc320f00efd6aa2cc6bbad4039'),from_hex('eed17f2ab39a99fdea41e89324705d513990aa8e'),from_hex('ef56b8e2fb4c692c143f5d4fc60ab579ccb68fcd'),from_hex('f094b813eff486f2d6278ad0fb67c2a8b4784cde'),from_hex('f10e161027410128e63e75d0200fb6d34b2db243'),from_hex('f219d481a733d3beeef30c365bc8db328c7a6b9b'),from_hex('f23600977369306ee4f65b849c4e021d6c1d9a1c'),from_hex('f3d1df4218d1559a3a489c3911a13c4eaf873c79'),from_hex('f40bebe26126767417e01822177e6f120c36eb8c'),from_hex('f418217e3f81092ef44b81c5c8336e6a6fdb0e4b'),from_hex('f4b172e9c876ebe975d2bffdaf7a99463755c6dc'),from_hex('f55791afbb35ad42984f18d6fe3e1ff73d81900c'),from_hex('f5713b4c696415c74e82ef66ff6d5a481fb5ab78'),from_hex('f58ed203e348a12c49a06e97895d33b3cabc3520'),from_hex('f5980901a52c07fe10c80126db10287ff905f6d9'),from_hex('f613e798ae1cef938e9fecad006f8c13e5e0fe67'),from_hex('f695e3a6af8d7d6a7de4c630d6a67f60b42c4189'),from_hex('f708e11a7c94abde8f6217b13e6fe39c8b9cc0a6'),from_hex('f70b330320b189928ae2b2b4d783697f80b0f52b'),from_hex('f753e8fde882cf6cdc06361a6abcc49df3a2bcf5'),from_hex('f833e2d639fb573c67d798bf1bd3088817076692'),from_hex('f8ab2dbe6c43bf1a856471182290f91d621ba76d'),from_hex('f95d006c913caf2c8d4e712d4ab03aff7aa3130a'),from_hex('f96652b9c4f05e5cf71a42b57120f65beb622f4b'),from_hex('f96e7c22c47e4491d2ee2254dfe1e665fe5b8dae'),from_hex('f9b22b915c881f0565ccc7b0874f7f7032edeb76'),from_hex('f9d6ac744f7489153ea95ebb3bc3c31de9fb652e'),from_hex('fa8d963525d5f28427b897a0c761c744a43e59af'),from_hex('fad7d615511d6193b9b2c1e7d8949e6cae14e72a'),from_hex('fadb718d862cd69cd8dffdb8634e70cd84d5324f'),from_hex('fafe4c4cec5ed070a4afdc0f92826c5ba276cb80'),from_hex('fbabc6bcb11f550a23ad7d08409a24c94e08869e'),from_hex('fbcd70f6402b8a67e546d8d3d73fe1af29cebb2e'),from_hex('fbed4271a83d5e75b240526c05b6d62afde5d431'),from_hex('fc0602ffb93b795ab0b1a420c2ce19419e3adecf'),from_hex('fc573eca0e1f8d0790814155c97018f80c368ee0'),from_hex('fc9e2c63370d8deb3521922a7b2b60f4cff7e75a'),from_hex('fca14e46d74d7673168e95b5f625bf2847b009b6'),from_hex('fcaa26f661c0c13b453835fa46f01189424b16f7'),from_hex('fde8ea1081df12702e802071e4223a1f5726fbca'),from_hex('fe33e20da3270323e66c031ab26967ccee25b3a2'),from_hex('ffa0847aa63559a35ab5e6297bb6840b911e0697'),from_hex('ffcd50e01c2cfd2af2b340d055376b48edb0ecec'))group by 1,2,3),ranked as (select cast(spender as varchar) spender, cast(owner as varchar) owner,cast(contract_address as varchar) token,row_number() over (partition by spender order by n desc) rn from ap)select spender, owner, token from ranked where rn <= 5