Query editor
with ap as (select spender, owner, contract_address, count(*) n from erc20_zksync.evt_Approvalwhere evt_block_time > now() - interval '90' day and contract_address in (from_hex('493257fd37edb34451f62edf8d2a0c418852ba4c'),from_hex('1d17cbcf0d6d143135ae902365d2e5e2a16538d4'),from_hex('703b52f2b28febcb60e1372858af5b18849fe867'),from_hex('bbeb516fb02a01611cbbe0453fe3c580d7281011'),from_hex('5aea5775959fbc2557cc8789bc1bf90a239d9a91'),from_hex('4b9eb6c0b6ea15176bbf62841c6b2a8a398cb656'),from_hex('39fe7a0dacce31bd90418e3e659fb0b5f0b3db0d'),from_hex('6a5279e99ca7786fb13f827fc1fb4f61684933d6'),from_hex('ad17da2f6ac76746ef261e835c50b2651ce36da8'),from_hex('7400793aad94c8ca801aa036357d10f5fd0ce08f')) and spender in (from_hex('0000000000000000000000000000000000010003'),from_hex('0000000000225e31d15943971f47ad3022f714fa'),from_hex('000000000022d473030f116ddee9f6b43ac78ba3'),from_hex('00000000f6bd402bfdf663dbc01c28e8889c87a1'),from_hex('006a5501fc45219ffdc353106d2946bd1dc08161'),from_hex('00a27c6c79d738d6b33c28ce9f62764fe26eaafe'),from_hex('00a533504f9f90334ced406765aa251b4c1d372d'),from_hex('02e3b9d5462e84518e309116d547c8c772a1c852'),from_hex('02e5be68d46dac0b524905bff209cf47ee6db2a9'),from_hex('03cad66259f7f34ee075f8b62d133563d249eda4'),from_hex('0616e5762c1e7dc3723c50663df10a162d690a86'),from_hex('069246dfecb95a6409180b52c071003537b23c27'),from_hex('0729e2a4716d9f7dd17858d5d504426d228697f7'),from_hex('081af547d2fa60b6d2d17383d46b908a08e93e0f'),from_hex('09873bfeca34f1acd0a7e55cda591f05d8a75369'),from_hex('09ad9411a42b4d70048e518f2fab090e24d7fede'),from_hex('09eec809966d025de3b52279d0578ce8570c3e13'),from_hex('0a976e1e7d3052beb46085acbe1e0daccf4a19cf'),from_hex('0ba9e39c007380f1df7718013d2953851178e06d'),from_hex('0c08f298a75a090dc4c0bb4caa4204b8b9d156c1'),from_hex('0d05a7d3448512b78fa8a9e46c4872c88c4a0d05'),from_hex('0d72156d26d9cbdacf552a06beb0ae9776a0dda9'),from_hex('0d72be73619e29a67fbd28348ac952288cc9ee46'),from_hex('0eb3c930944951876e2e7be8b8fe4759ffd6fb44'),from_hex('0ed4a1c66fcdf17341177422e73ca919284e040c'),from_hex('10b65e60ae95b2bd68bfcae31e1100369bd01818'),from_hex('111111125421ca6dc452d289314280a0f8842a65'),from_hex('1111113ccf1426a8e30e2bff5e005d929bf6a90a'),from_hex('111f1607d169c0a5824b5ef1a3901b0283f5c834'),from_hex('11b2669a07a0d17555a7ab54c0c37f5c8655a739'),from_hex('1231deb6f5749ef6ce6943a275a1d3e7486f4eae'),from_hex('13598fd0986d0e33c402f6907f05acf720224527'),from_hex('14a1bace0ce65d3e1701c4c505b7a294d51dfb18'),from_hex('15309aaf4fedf346e5204331027b4ef7b75b1dd7'),from_hex('160dca2d534e6940ba7775969fe1a34d54811b53'),from_hex('17132ce52d40248f5077f4f51c6e3bdf7682749f'),from_hex('18381c0f738146fb694de18d1106bde2be040fa4'),from_hex('187d5c41c2423a40f68df1a5c561a5f2e1baaa98'),from_hex('18f79872b0255f7b57a131890739539b0ad6ad4e'),from_hex('196a35f7d5fcc9838a4b72a82602e737943d6c07'),from_hex('1b249bd2b130e50bf55adafcb9a75fe10f24ef4e'),from_hex('1b887a14216bdeb7f8204ee6a269bd9ff73a084c'),from_hex('1bdb8250eaf3c596441e6c3417c9d5195d6c85b9'),from_hex('1cd43082fbb13163835e7a5b658ea82db32689a8'),from_hex('1d17cbcf0d6d143135ae902365d2e5e2a16538d4'),from_hex('1da58916f20f86d661f6b08985445a3ef36ffd92'),from_hex('1fa66e2b38d0cc496ec51f81c3e05e6a6708986f'),from_hex('1fa916c27c7c2c4602124a14c77dbb40a5ff1be8'),from_hex('1ffaff7aafc576fade4ac103d3cc2e396afef389'),from_hex('1ffbd159bfc3c9707a457bb1a9d52434ca40fc74'),from_hex('2042ecdc71f9ffb2eb9cda7f801eccc5c6c8b7eb'),from_hex('20f18c5c5260c07830e3be17a3a010f52f755a7f'),from_hex('211ac72f3ee4a35523b41aa8d67644e1ef860059'),from_hex('213551f927f64a23a9e8470b09c9bab6ad225209'),from_hex('22bfb19ed098ec206fe2e5d0f719672a7dc7103e'),from_hex('2350d92f6bf51c202395b10d6b8a6ae0b37bb577'),from_hex('23fdd6487a17abb8360e8da8b1b370c94ee94cc2'),from_hex('240b0d28b2ff9ff793700e71865fbbe23ac5f612'),from_hex('240d5645bffaf6f8bc3586e459a4155f270bcb3b'),from_hex('24a72dd17de0f92da5460c46cc2948e3a5cb755d'),from_hex('2593dd3a3e458161411dd641fed07c8a33c82633'),from_hex('25ccd633dd66d9b2e655c6afc2c7d6c2edd5a70f'),from_hex('28731bcc616b5f51dd52cf2e4df0e78dd1136c06'),from_hex('291d9f9764c72c9ba6ff47b451a9f7885ebf9977'),from_hex('2c81df4f11a1c7e43acb972e73767b1f5d0d9edc'),from_hex('2c947bcd58720f4477a053da5a9de4f72286b923'),from_hex('2da10a1e27bf85cedd8ffb1abbe97e53391c0295'),from_hex('2dcc88fa6b6950ee28245c3238b8993be5feea42'),from_hex('2e71597b779f50d6e070662f0f0b53c63504b60c'),from_hex('2e89cae8f6532687b015f4ba320f57c77920b451'),from_hex('2ec2c4c3dc212c990d1bc2b48b0392a3951d926e'),from_hex('2f23f6f25d4e2a34ebeca892ee7ce84e388260b5'),from_hex('3000b6dde9bd070128b344f018da7a611afaddd5'),from_hex('30e63157bd0ba74c814b786f6ea2ed9549507b46'),from_hex('341e94069f53234fe6dabef707ad424830525715'),from_hex('357b5935482ad8a4a2e181e0132abd1882e16520'),from_hex('35e98c2b3894d71d3d4d7edb8b30e4f36e2f9179'),from_hex('36a1acbbcafca2468b85011ddd16e7cb4d673230'),from_hex('37a47bed105defc9d4242c8f7232f1ff61e24976'),from_hex('38307cb291af47af9847c134a34e9477c939ca28'),from_hex('38ae1164ca61ee7aa395bb139b3990e347988ce1'),from_hex('396ea0670e3112bc344791ee7931a5a55e0bdbd1'),from_hex('39e098a153ad69834a9dac32f0fca92066ad03f4'),from_hex('3aef05a8e7d7a83f5527eded214e0b24a87d0991'),from_hex('3b88b6fd5bc6450dbc86c356156ff821714c6c87'),from_hex('3c5b3d99bc747d39cc5e5934009cce2488a0d35a'),from_hex('3d7264539e6e3f596bb485e3091f3ae02ad01ef8'),from_hex('3ea15e09fa5e39c810d3eeb84248bb59126aae9a'),from_hex('3f95ef3f2eaca871858dbe20a93c01daf6c2e923'),from_hex('407b78fd08c29a2b2ea842423de9b1457598fd60'),from_hex('4081e092f948cffd946a75e1f556c13c372304bc'),from_hex('40ad8e452b87381adb6c088fb80173b80752ed65'),from_hex('41ddd7b64cadee12916a5c38e7d4defb3263a018'),from_hex('42115ddd6a53497475f4a46c167616b130af6c7a'),from_hex('4325cccac772ba1dea9d7f13782a8d5baac1af1b'),from_hex('432e6791d35dc6c638f44e949a5c0228e4048244'),from_hex('443f985fd3484b9fdc7b5df58c9a0fadbe449b92'),from_hex('446d8e69bd642ea000d9a631c147fbd4013e5f36'),from_hex('45a0b6ac062a6f137ddc12c01e580cfed1a6f4ec'),from_hex('46b9821e57a68274342e679b2a44c1acb5af55c8'),from_hex('46dbd39e26a56778d88507d7aec6967108c0bd36'),from_hex('4725b7b990c1dacbda850fd25a9d0a30bdb9de8d'),from_hex('483fde31bce3dcc168e23a870831b50ce2ccd1f1'),from_hex('4842547944832fe833af677bfdb157def391e685'),from_hex('484a72b4879ac8b04652b51bf1d1c110077990a4'),from_hex('48d8b671c891d558905284d292f630a3b3db9aed'),from_hex('493257fd37edb34451f62edf8d2a0c418852ba4c'),from_hex('497e86456eea398fa2ea7ac1bb5e3f61f80c241e'),from_hex('498f7bb59c61307de7dea005877220e4406470e9'),from_hex('49fa3f535ec8f72045a7ff4272114ce1e40fbe8a'),from_hex('4a825b53416682be1bdefc6418a55da1911362f0'),from_hex('4ae2ba9a5c653038c6d2f5d9f80b28011a454597'),from_hex('4bba932e9792a2b917d47830c93a9bc79320e4f7'),from_hex('4c0d29dd100aa9a94449b88abb958272791f011a'),from_hex('4c615e78c5fca1ad31e4d66eb0d8688d84307463'),from_hex('4d88434edc8b7ffe215ec598c2290cdc6f58d12d'),from_hex('4d9429246ea989c9cee203b43f6d1c7d83e3b8f8'),from_hex('4f5456d4d0764473dfca1ffbb8524c151c4f19b9'),from_hex('4f91f1321b3e686a93763a9b42e7d6ce6e999a78'),from_hex('508381b4ced348bf97a565693e5d6102316a8faf'),from_hex('5095677a34133e790fd49c3e0732134b66e81b8b'),from_hex('50e2c7cce1c5bc04ec05d2636bccfb125877e555'),from_hex('54069e96c4247b37c2fbd9559ca99f08cd1cd66c'),from_hex('5567954cd026cebfe486062cb75848e0f1c12e58'),from_hex('55e6e2e3a2222b6a29f31497eae2431793f8d682'),from_hex('57050267698b9153e6c491eea6478ec73662631e'),from_hex('57e3c2ddc4d62010ef93522f7812dfb0cdb3898c'),from_hex('58078e429a99478304a25b2ab03abe79199be618'),from_hex('5908e0cb938571ee4fa1b5e09e73980efbd29b5f'),from_hex('593786ce9f2962740d57f8eb1d5b53456b6c7c86'),from_hex('5a148a9260c1f670429361c34d40b477280f01a9'),from_hex('5aea5775959fbc2557cc8789bc1bf90a239d9a91'),from_hex('5aeaf2883fbf30f3d62471154eda3c0c1b05942d'),from_hex('5fe556bcf5fc7db6e075ca6f4cd4f8bbee2a3e54'),from_hex('6134ceffe5db53741997389cbc987af4cb1d8ea5'),from_hex('621425a1ef6abe91058e9712575dcc4258f8d091'),from_hex('62a3e2282c906447a2d7c5657b4650e10a890fa5'),from_hex('6352a56caadc4f1e25cd6c75970fa768a3304e64'),from_hex('64848eefbc2921102a153b08fa64536ae1f8e937'),from_hex('64b3664cba13bcbb94cb45168d67af7c2f602900'),from_hex('64b53e9516069f2d13cfffc4b300c96a9fbee59b'),from_hex('65de59507caa235c8ca49bfd008cada4d846caa7'),from_hex('686fd50007eaa636f01154d660b96110b6bfe351'),from_hex('69cda960e3b20dfd480866fffd377ebe40bd0a46'),from_hex('6ac81d4c43c86c8dbd4842c1eb0fd1a1c2c16b97'),from_hex('6c31035d62541ceba2ac587ea09891d1645d6d07'),from_hex('6d90d891a03c32d4082126d0cee145f3be62444a'),from_hex('6e2b76966cbd9cf4cc2fa0d76d24d5241e0abc2f'),from_hex('6f6b9063097492cbb782ea8269ce11f411f03ee2'),from_hex('6fd4383cb451173d5f9304f041c7bcbf27d561ff'),from_hex('70796621893f3f667601cdf014592ac2d44a5c38'),from_hex('70b86390133d4875933be54ae2083aaebe18f2da'),from_hex('72ae6cbc34aecf6573655739739bf746346b7c84'),from_hex('73d7641e8a4cf78ab9202a47942740f8e3bc9185'),from_hex('7642e38867860d4512fcce1116e2fb539c5cdd21'),from_hex('7667915530fbf47ff822770d2a4458766abcccbc'),from_hex('7688c2ee21e63819581a671e437ef03888674271'),from_hex('769c6cec23814bad240f8be6f116820a1bb1d926'),from_hex('772eda6c5aacc61771f9b5f9423d381d311a7018'),from_hex('7868a55b638ed298370c16f83fa32b26664726ab'),from_hex('78e30497a3c7527d953c6b1e3541b021a98ac43c'),from_hex('7c0e7d6066af191977a4483b445b5c06fc41ecd6'),from_hex('7c99ced6d8011af8a52488884f7ba2c61b0fa57d'),from_hex('7d208d26c75711ec9c7c3368fead3254a40a8a28'),from_hex('7e7d4185d9c3c44d5266ed974493b24811398049'),from_hex('7ec9672678509a574f6305f112a7e3703845a98b'),from_hex('7f2fe641b923ad58dbdad8f76577fc33603cdc7f'),from_hex('7f4cb0666b700df62e7fd0ab30e7c354aa0a1890'),from_hex('7f5e085981c93c579c865554b9b723b058aae4d3'),from_hex('7fe3975fb0f9a7f78b015806fb8a1e569b014c10'),from_hex('8109038fb9e7562bbb17f46596384e0418861bbe'),from_hex('838964640c45fc0c8175e6435e9244b46f0d4372'),from_hex('84064c058f2efea4ab648bb6bd7e40f83ffde39a'),from_hex('849a1a594b9dd9732ccbf4309b4ce921c37bd97e'),from_hex('84dd021b2fca11ef1bccadf4231c75989516308b'),from_hex('850fe8be964cc5feb3dd00cfe1364590b45e3926'),from_hex('8627ba97bcf838757831da8fe98feec6678666dd'),from_hex('87c0878b54c174199f438470fd74b3f7e1def295'),from_hex('87d4007a8a7e4897ab00a5390daaf0b8be199c84'),from_hex('8809511a70dea0f4abfb7825708e39bcc805f66f'),from_hex('894cccb9908a0319381c305f947ad0ef44838591'),from_hex('8a2af0811ad79db1e944fa7eb567e7db730e69d0'),from_hex('8b4e76e42f9052b00ffce095bad9cbf482af8c09'),from_hex('8b6f1c18c866f37e6ea98aa539e0c117e70178a2'),from_hex('8b791913eb07c32779a16750e3868aa8495f5964'),from_hex('8ca239448add34b057d1cb5934f12ac899db66e1'),from_hex('8d7285c97d0d0c451be72f737875a98751870b97'),from_hex('8e70e517057e7380587ea6990dae81cb1ba405ce'),from_hex('8ea703234b9f73dd6155daae3d55525cb613ae39'),from_hex('8f2915411c27bbb1d86bf19a36f41a30c39a512f'),from_hex('8fa0041997fc969af8ba5b2cca94b93064019d6a'),from_hex('915d3aee4861853903bb7276623e5fd89af427ca'),from_hex('929255875391d89da68741762c4d12f68ed636d7'),from_hex('930da5e58f7f0d6dc417ab07e07558c78cff1445'),from_hex('936c9a1b8f88bfdbd5066ad08e5d773bc82eb15f'),from_hex('937f4f2ff1889b79daa08debfca5c237a07a5208'),from_hex('943ac2310d9bc703d6ab5e5e76876e212100f894'),from_hex('9500de91902d878aa1bc4837c8dd18b5b0079461'),from_hex('9522ab080dd3fa8fbc7e0b0fafa269fe9dbb7439'),from_hex('958ccb87c088534e8e1a90ceebc7d33d62ebef7e'),from_hex('95cdd9632c924d2cb5586168cf0ba7640df30598'),from_hex('9606ec131eec0f84c95d82c9a63959f2331cf2ac'),from_hex('981c8021c0652f62b772d017e42e31af70ae4abd'),from_hex('998d7c178a1f9607b47ea3a8e22426451b3ce707'),from_hex('99c56385dabce3e81d8499d0b8d0257abc07e8a3'),from_hex('99fbe80b912011e1574bb30aaab9295e7d8a960d'),from_hex('9b0549ed9e65b80c5d1d67d3fbfc8e98f8e0cc49'),from_hex('9b5def958d0f3b6955cbea4d5b7809b2fb26b059'),from_hex('9c9d8c408b5657793795aea65e80dc1f2453e446'),from_hex('9d8095d3a929400dc2312e37bd8211218108849d'),from_hex('9eda1ee29475f3726fef3681f5f19b5d741a9f42'),from_hex('9f915b7b070cbfcd71b0384911fa2da88d26214a'),from_hex('a269031037b4d5fa3f771c401d19e57def6cb491'),from_hex('a2aac7bc9725c36ad9b12d2407df8de6b2b68359'),from_hex('a459ebf3e6a6d5875345f725ba3f107340b67732'),from_hex('a478bf3f621d47e6753f463711630c282d2803ab'),from_hex('a577ddda8e06be1a0705fe9c6e6ce2d2011100c9'),from_hex('a731a771a5d41afcd5ec235b5bc4318d60b1bcda'),from_hex('a7f73dc216945794ec040dfb14e474fe180e3768'),from_hex('a815e2ed7f7d5b0c49fda367f249232a1b9d2883'),from_hex('a93472c1b88243793e145b237b7172f1ee547836'),from_hex('a9bfa49f26733271f4fd34a4b57bb7c563ae056a'),from_hex('ab3ddb86072a35d74bed49aa0f9210098ebf2d08'),from_hex('abca8cfdfa2a4285a4704bf960fb45e49821762f'),from_hex('ad8262e847676e7eddafee664c4fd492789260ba'),from_hex('adde7028e7ec226777e5dea5d53f6457c21ec7d6'),from_hex('af8fd83cfcbe963211faaf1847f0f217f80b4719'),from_hex('b08772aa562ed5d06b34fb211c51ec92debf7b26'),from_hex('b11ceafbe57a85a67d693bfa841bcf5816b29af3'),from_hex('b2bd4db07731ba1517f3f43c4e8fe801f870b374'),from_hex('b44958ff91b4b67d8d4db010e38ccffe52551ecb'),from_hex('b6822a8494174735341dd9e1ccdfbe25c49593a5'),from_hex('b693b8b743351a94f80723ee30ba09b3edd51ef8'),from_hex('b760b45ebcce662882108eae2f6c94f73d16cbfb'),from_hex('b92fe925dc43a0ecde6c8b1a2709c170ec4fff4f'),from_hex('bbbfd134e9b44bfb5123898ba36b01de7ab93d98'),from_hex('bbeb516fb02a01611cbbe0453fe3c580d7281011'),from_hex('be3c7859ba3f68ed4d26309a934b8a0fa3e07f00'),from_hex('be7d1fd1f6748bbdefc4fbacafbb11c6fc506d1d'),from_hex('bf3922a0cebbcd718e715e83d9187cc4bba23f11'),from_hex('c218e15a8aaf6ac596efa58f1b4f728ea39bd1c6'),from_hex('c46c966dd05447dec36152254306feffd0116338'),from_hex('c5589f0f4679f0a4b44e987d618f6c7c77289080'),from_hex('c593dcfd1e4605a6cd466f5c6807d444414dbc97'),from_hex('c5b20203b6807e742853c96ce7dcfb1e7b201c0a'),from_hex('c67879f4065d3b9fe1c09ee990b891aa8e3a4c2f'),from_hex('c6b6c26254339f39b298137a0beb5b7b5a31e0b9'),from_hex('c7a4a594ef6e834ae75392a62a79638e0b6178c1'),from_hex('c8a3d1d834617796cdd8c68709e9719f41cb472e'),from_hex('c9110f53c042a61d1b0f95342e61d62714f8a2e6'),from_hex('c96934dd87d99d938ea78e45dc5d296116b8cc1c'),from_hex('c9d8eaf3d32cace17aafa7d290533e280f2ff137'),from_hex('c9e2c117163ac4f85ac244bd4042a56d86756900'),from_hex('ca11bde05977b3631167028862be2a173976ca11'),from_hex('ccc88a9d1b4ed6b0eaba998850414b24f1c315be'),from_hex('cdebf599ed32cb6dbcb708525d93afd7a04f76bc'),from_hex('cfb1f00fb3851973a4eddcf3d726d7b67a589448'),from_hex('d05eef3792276e92bb051029dadfc2bf81121692'),from_hex('d06a1fa35c92281c5f8f00450d29180fca7e98c1'),from_hex('d085fd2338cefb9cbd212f74d479072c1e7a25bf'),from_hex('d1f1ba4bf2ade4f47472d0b73ba0f5dc30e225df'),from_hex('d277a4303f9e6fc3da96d7bcd45df30d8e21526d'),from_hex('d468772a171330c124d711c94226bf9fff48ca79'),from_hex('d70c70ad87aa8d45b8d59600342fb3aee76e3c68'),from_hex('d71bdf7ffca335e0b67bba03174937bded4111f1'),from_hex('d756e8070b33a35e42f00140ac92c4b4e0bbfb82'),from_hex('d81d322eae44926f2d6cbc895413358a264d67c2'),from_hex('d9085ac07da21bd6eb003a530a524ab054ca8652'),from_hex('d999e16e68476bc749a28fc14a0c3b6d7073f50c'),from_hex('dc14d41bfcd386e035bd1ba3072d2f8c5e21eb9a'),from_hex('dca324bdd4ebb6b8a1802959324ce125b5d57921'),from_hex('dd5d340a2bbbcd99964bef6549314a4b81adedfa'),from_hex('dd6f2bc0f4f15329a9a712e46b2d988529df80e4'),from_hex('dde4d098d9995b659724ae6d5e3fb9681ac941b1'),from_hex('de6a186c5104120803f7595b0158ce9850ede34c'),from_hex('df3e4da3ee75f1018d277222967ce3d69f3271d9'),from_hex('e0b015e54d54fc84a6cb9b666099c46ade9335ff'),from_hex('e0d2833d9ed879d16bfc1cec3573293770b8abbb'),from_hex('e1ccec2dbd0d0b2b365d5a71668ca0f8e99b13a8'),from_hex('e226e4825cb215abafad98fdd400583eab6a594f'),from_hex('e4c82643a4f9fd288322cc6fbd7c48ab068b38d3'),from_hex('e4e156167cc9c7ac4abd8d39d203a5495f775547'),from_hex('e66aa98b55c5a55c9af9da12fe39b8868af9a346'),from_hex('e7d7b5cd36deed96c2ade3da228d9792d2be756a'),from_hex('e832e655e4c3c36b2be5256915ecf8536a642f59'),from_hex('e87321ec851b5f31ca6238830dffd5360c105171'),from_hex('e8bf402bf943e5a6d6420f1753158b6b1ba474ee'),from_hex('e955c98e8411ee4c7332ebe48df7f0ca12711dc2'),from_hex('e999bb14881e48934a489cc9b35a4f9449ee87fb'),from_hex('e9a934311f77689bcb76c51104e49d8f691c1fb8'),from_hex('ebbdfef411ff813d1c1e7f100ffa09c2e07c03ff'),from_hex('eecb86c38c4667b46487255f41c6904df3d76f8f'),from_hex('f29eb540eeba673f8fb6131a7c7403c8e4c3f143'),from_hex('f2a173643ca958213714712ce195f6f6e9c686e7'),from_hex('f504c1fe13d14df615e66dcd0abf39e60c697f34'),from_hex('f560df1cafb0da08ecb1f9e244c68640b701e53e'),from_hex('f5c2d1f19fdbd766d21179b49d7b4e04a31a9867'),from_hex('f5e67261cb357edb6c7719fefafaab280cb5e2a6'),from_hex('f6852d043652bffb5c9ce3da09e7091708b22610'),from_hex('f8b59f3c3ab33200ec80a8a58b2aa5f5d2a8944c'),from_hex('f8c42655373a280e8800beee44fcc12ffc99e797'),from_hex('fc76c0f5fdad139a7110607eed8c2709284d0c4c'),from_hex('fcf64165772037f9b750f7c9a7391e7e926a8a53'),from_hex('fd505702b37ae9b626952eb2dd736d9045876417'),from_hex('fe6b0136fb9b5993dc840371cc8bee83a46a41b5'),from_hex('ff05102762ffce576af90d614a780ce10ea6dc64'))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