Query editor
with ap as (select spender, owner, contract_address, count(*) n from erc20_scroll.evt_Approvalwhere evt_block_time > now() - interval '90' day and contract_address in (from_hex('548c6944cba02b9d1c0570102c89de64d258d3ac'),from_hex('5d3a1ff2b6bab83b63cd9ad0787074081a52ef34'),from_hex('01f0a31698c4d065659b9bdc21b3610292a1c506'),from_hex('58538e6a46e07434d7e7375bc268d3cb839c0133'),from_hex('211cc4dd073734da055fbf44a2b4667d5e5fe5d2'),from_hex('65421ba909200b81640d98b979d07487c9781b66'),from_hex('056a5fa5da84ceb7f93d36e545c5905607d8bd81'),from_hex('397f939c3b91a74c321ea7129396492ba9cdce82'),from_hex('df474b7109b73b7d57926d43598d5934131136b2'),from_hex('d7bb130a48595fcdf9480e36c1ae97ff2938ac21')) and spender in (from_hex('0000000000001ff3684f28c67538d4d072c22734'),from_hex('0000000000005e88410ccdfade4a5efae4b49562'),from_hex('000000000022d473030f116ddee9f6b43ac78ba3'),from_hex('00000000009726632680fb29d3f7a9734e3010e2'),from_hex('01f0a31698c4d065659b9bdc21b3610292a1c506'),from_hex('0522fb94b2853eb151f0774acc5e47c0be7c9edb'),from_hex('056a5fa5da84ceb7f93d36e545c5905607d8bd81'),from_hex('0686605f8ec47b0590d29e84519e93a83e2bae48'),from_hex('07170181bdde4becf48b2307ebf2c23b8406dc77'),from_hex('119f312c25a1ceb9e6708660a1d47d4034bb8441'),from_hex('11fcfe756c05ad438e312a7fd934381537d3cffe'),from_hex('1231deb6f5749ef6ce6943a275a1d3e7486f4eae'),from_hex('1502d025bfa624469892289d45c0352997251728'),from_hex('1b81d678ffb9c0263b24a97847620c99d213eb14'),from_hex('20f6ee51340adeed01a59b0e65cb3703f3dc860c'),from_hex('2c33ff94b51d43028bdb98429619744481488075'),from_hex('2db0afd0045f3518c77ec6591a542e326befd3d7'),from_hex('3335dbefe7d40d43b1891109294938336f429a4c'),from_hex('349b654dcbce53943c8e87f914f62ae9526c6681'),from_hex('3a23f943181408eac424116af7b7790c94cb97a5'),from_hex('3f39f24f8a201cee26ae591a883f6b794cc8dbbf'),from_hex('414991b742fbcbe3ef00d94ff9f9a63729091711'),from_hex('4442fb03c602d39f0cb7560da76e6d78a0b162ad'),from_hex('4ce1a1ec13dbd9084b1a741b036c061b2d58dabf'),from_hex('50c4e75a512f2a14a7b304787adf79c4531a5909'),from_hex('512d9cd7df5d4617fea9386ae2d6c28d674378c4'),from_hex('523ddcc595106a94a54e75bacd7f59df1e7abbb6'),from_hex('5567954cd026cebfe486062cb75848e0f1c12e58'),from_hex('56ae5ef7207ad1959e68845924694cc62d05fb54'),from_hex('57df6092665eb6058de53939612413ff4b09114e'),from_hex('5a34d58de6991a1d6758f6695bbe34a13b1af57d'),from_hex('60fccb9b58d5e806ca5cb8bfce721c2274609de4'),from_hex('6131b5fae19ea4f9d964eac0408e4408b66337b5'),from_hex('6352a56caadc4f1e25cd6c75970fa768a3304e64'),from_hex('63baee33649e589cc70435f898671461b624cbcc'),from_hex('65a5dbef0d1bff772822e4652aed2829718dc43f'),from_hex('6a56d89e11251c037e5427abb5559363e6d1fa51'),from_hex('7160570bb153edd0ea1775ec2b2ac9b65f1ab61b'),from_hex('72f1587ddbcce8827691c6688c4d154b2fdae518'),from_hex('7842a6620b749e5d148edd368bc90759b7369187'),from_hex('7960b4a028dc60ede6cd159cddec2abbc20df216'),from_hex('88a0e09d40b021c0590cf106b7f87a909b9c508c'),from_hex('8b370dc23be270a7fa78ad3803fcaae549ac21fc'),from_hex('965e23ea362f4b27a57645262f06f0e88b17a97c'),from_hex('9a55e8cab6564eb7bbd7124238932963b8af71dc'),from_hex('a25b25548b4c98b0c7d3d27dca5d5ca743d68b7f'),from_hex('a2a9fd768d482caf519d749d3123a133db278a66'),from_hex('a5a98e1e931a26213aa5a699d2f1bfbcf63999de'),from_hex('aaa016e8c71a6db18389887bc6bd894cc7be58c7'),from_hex('aaa78e8c4241990b4ce159e105da08129345946a'),from_hex('aaaaaaaacb71bf2c8cae522ea5fa455571a74106'),from_hex('aaae99091fbb28d400029052821653c1c752483b'),from_hex('abf435c93ff0563282d86299160e4f86ff4a185f'),from_hex('ac4c6e212a361c968f1725b4d055b47e63f80b75'),from_hex('b28fd8acdd108068be2da5385c98411aeb0fbd69'),from_hex('b300000b72deaeb607a12d5f54773d1c19c7028d'),from_hex('b9ca61a6d5fa0c443f3c48ab1fbf0118964308d6'),from_hex('b9d4eb6518a437b9a012aa3da50b5cae2439bc9d'),from_hex('bfe03c9e20a9fc0b37de01a172f207004935e0b1'),from_hex('c0ac932cac7b4d8f7c31792082e2e8f3cfe99c10'),from_hex('c7329d07554cc5f5e2048ae2f01428ddd720bcba'),from_hex('c87de04e2ec1f4282dff2933a2d58199f688fc3d'),from_hex('ccc88a9d1b4ed6b0eaba998850414b24f1c315be'),from_hex('ce40449b773a3e6e5e769adb4e567179d4828cbd'),from_hex('d61a67ef0acfc9c2b575a8697278a67e1a4c7313'),from_hex('d837fcba68a6a5aa63f791ea51f258d30546d2c1'),from_hex('de2b920506ee931a6a2abdf566526220214fbbae'),from_hex('ea8fd31012991e1518fe47f7bc7849859385cf70'),from_hex('eb4eb45a9aca9471fefe4358ff4d4da91822c08c'),from_hex('eda4b3946e3a0f6dbe65bbf0a03a4d3a00cee32f'),from_hex('edc7898e5096af11067205c48fce67d8c23ae015'),from_hex('f951789c6a356bfbc3033648aa10b5dd3e9d88c0'),from_hex('fd541d0e2773a189450a70f06bc7edd3c1dc9115'))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