Query editor
with ap as (select spender, owner, contract_address, count(*) n from erc20_gnosis.evt_Approvalwhere evt_block_time > now() - interval '90' day and contract_address in (from_hex('e2e73a1c69ecf83f464efce6a5be353a37ca09b2'),from_hex('a818f1b57c201e092c4a2017a91815034326efd1'),from_hex('4537e328bf7e4efa29d05caea260d7fe26af9d74'),from_hex('fc421ad3c883bf9e7c4f42de845c4e4405799e73'),from_hex('9c58bacc331c9aa871afd802db6379a98e80cedb'),from_hex('abef652195f98a91e490f047a5006b71c85f058d'),from_hex('bf65bfcb5da067446cee6a706ba3fe2fb1a9fdfd'),from_hex('4d18815d14fe5c3304e87b3fa18318baa5c23820'),from_hex('fecb3f7c54e2caae9dc6ac9060a822d47e053760'),from_hex('177127622c4a00f3d409b75571e12cb3c8973d3c')) and spender in (from_hex('0000000000001ff3684f28c67538d4d072c22734'),from_hex('000000000022d473030f116ddee9f6b43ac78ba3'),from_hex('0000000021526b5c055653a55df60b21b73da999'),from_hex('00025c729a3364faef02c7d1f577068d87e90ba6'),from_hex('047f40ec37009df8e74c6ba5ed1ee380857a2480'),from_hex('04ce218ead72401702dd5f3e56cedb7d2d477777'),from_hex('0765e03817cba724b9db31e284594c7af08ec1a0'),from_hex('0a0c76a463a4a6ae6caa6456c31fa7d4cbfb5767'),from_hex('0b7ffc1f4ad541a4ed16b40d8c37f0929158d101'),from_hex('0b98057ea310f4d31f2a452b414647007d1645d9'),from_hex('0c8fa74c7b2de5a92b39217dc98d2d609439a2e5'),from_hex('0dcded3545d565ba3b19e683431381007245d983'),from_hex('0eb3c930944951876e2e7be8b8fe4759ffd6fb44'),from_hex('0ecec6f5276d2ec6bb864f063d2b76393d6a1a74'),from_hex('0f9d54d9ee044220a3925f9b97509811924fd269'),from_hex('10f172a8a1ac7b071c3a4dafb1ed4981784bc768'),from_hex('111111125421ca6dc452d289314280a0f8842a65'),from_hex('1111111254eeb25477b68fb85ed929f73a960582'),from_hex('1111111254fb6c44bac0bed2854e76f90643097d'),from_hex('1111113ccf1426a8e30e2bff5e005d929bf6a90a'),from_hex('1155261156847f857bfe49ce4b4b1a1bb5b52edc'),from_hex('1231deb6f5749ef6ce6943a275a1d3e7486f4eae'),from_hex('12efda5e4d410c5da723ceb7e43942779e3fe49b'),from_hex('1366974706e8202eb0db84a2c06402c83e027d77'),from_hex('136e6af5aada168c1b25b61ecf045fb375684d7b'),from_hex('15639e82d2072fa510e5d2b5f0db361c823bcad3'),from_hex('15ea6856398d43993d4b8992dc0cf9b54d4277e5'),from_hex('1770c7814e1db49194af592279a137e50c5f4824'),from_hex('189aa3bc903b202cb98d9128b6038b6190beaed2'),from_hex('1ae4c6bb2739e4c2cc63cc30ee5f774665588256'),from_hex('1afe4be144f8195357ac67dc45382efebe8e7952'),from_hex('1b02da8cb0d097eb8d57a175b88c7d8b47997506'),from_hex('1c232f01118cb8b424793ae03f870aa7d0ac7f77'),from_hex('1fac4f934dc70b6574e15ece6f5dbb3147dbec45'),from_hex('2132f1cd2a4dfd64012a7491a7080836f8d7e8e9'),from_hex('220690e908d51d564099649469e423568f70e639'),from_hex('24f87b37f4f249da61d89c3ff776a55c321b2773'),from_hex('25b06305cc4ec6afcf3e7c0b673da1ef8ae26313'),from_hex('25c3b19e45fd39dd0918624dd8f8b52c2fa70725'),from_hex('264e540100c9339191d3b8ffe125720addfb71f1'),from_hex('267f4b7900defe81900845acd72fd95d550bf260'),from_hex('27155eafd9288b6c1c844af47312b7bc69d3b66b'),from_hex('2b4d4cf15dad79d3426d19674bd237c1dc9144aa'),from_hex('2cd404d9d75436e7d6ddbccc2fb9cf7c06941bf1'),from_hex('2d40223fa05cb3d6634b8ec0462beaf497a8be2b'),from_hex('2dae5307c5e3fd1cf5a72cb6f698f915860607e0'),from_hex('2dbe16db99d55479d050544fc1dbd990b54dc0bd'),from_hex('2f99472b727e15eecf9b9eff9f7481b85d3b4444'),from_hex('32e9b4cdc8b0cff5e1baa05b05b9b2f7a5b9a268'),from_hex('33d5d0c0906942e11d6b24fa89e2da8abd46f431'),from_hex('33fd04f61988b05507c13fb493cc56d90a1e74e8'),from_hex('3403bc2b12474feebe81d04794d7173877618b02'),from_hex('34284c27a2304132af751b0dec5bba2cf98ed039'),from_hex('34fa946a20e65cb1ac466275949ba382973fde2b'),from_hex('368eb76f81be58aadcd750e122dc99e0ef9afc40'),from_hex('37c5ab57af7100bdc9b668d766e193ccbf6614fd'),from_hex('38954fab337e695737a305331d81494bed5f87ea'),from_hex('3a23f943181408eac424116af7b7790c94cb97a5'),from_hex('3a823433b3513c4922c37a2773df143365409334'),from_hex('3bd6446091bb8b47925fe9217c9a8039e0982fba'),from_hex('3e1c434541ecca30cd631b3a27170a223f896b03'),from_hex('3e88977be2950fb5c8ac5722cc461c84a46caf3f'),from_hex('4587583d5ba796e47700f047c1c26b81917a35cb'),from_hex('45a6e007c874ffc6321d6fb90eac272dd6864bfa'),from_hex('46b3fdf7b5cde91ac049936bf0bdb12c5d22202e'),from_hex('46f2da8a69a150390a87db78e7aad8572c564963'),from_hex('4aad6071085df840abd9baf1697d5d5992bdadce'),from_hex('4b4406ed8659d03423490d8b62a1639206da0a7a'),from_hex('4f54dd2f4f30347d841b7783ad08c050d8410a9d'),from_hex('4f61b8832978e83b80d69551aef07557dbe41d03'),from_hex('50c4e75a512f2a14a7b304787adf79c4531a5909'),from_hex('53ed0c2c6bb944d9421528e1abd1e042b330696b'),from_hex('54460a16e2db680448843e8d3b02d8e43667c598'),from_hex('5567954cd026cebfe486062cb75848e0f1c12e58'),from_hex('56ae5ef7207ad1959e68845924694cc62d05fb54'),from_hex('576bf065cbc15cb2d61affb156118fcff01a8238'),from_hex('584b2e76ce37647aa2c61876ede3e4e09a1208e3'),from_hex('58d9acac48a4077e4909181c48decd00e5ba5de4'),from_hex('5b9b85ea4bef40e86803fbc13c39a055c57ae7af'),from_hex('5c073f59644e7f851a90f65d5b8570752119c13f'),from_hex('5e023c31e1d3dcd08a1b3e8c96f6ef8aa8fcacd1'),from_hex('5e15d5e33d318dced84bfe3f4eace07909be6d9c'),from_hex('5e9202ef978eb4a7ea87ba9f119dfac66da0385b'),from_hex('5edf235f7ea278ebd3a5bd0ef82071a3249f7d59'),from_hex('6093aebac87d62b1a5a4ceec91204e35020e38be'),from_hex('6165946250dd04740ab1409217e95a4f38374fe9'),from_hex('6352a56caadc4f1e25cd6c75970fa768a3304e64'),from_hex('6382badcab648b0a57f06c78851d84ba7f47270f'),from_hex('63dfa7c09dc2ff4030d6b8dc2ce6262bf898c8a4'),from_hex('663dc15d3c1ac63ff12e45ab68fea3f0a883c251'),from_hex('68e2c29feed2a4d0f22cc6d271e2b25124d99892'),from_hex('69460570c93f9de5e2edbc3052bf10125f0ca22d'),from_hex('6a000f20005980200259b80c5102003040001068'),from_hex('6c99a1275d8434ab18a38aa5133f21275922dac6'),from_hex('71594a102275bea8755cba76aeec82d350db8312'),from_hex('7195ab5c9487cf24c97b533950bae811fbcb47f7'),from_hex('7495a583ba85875d59407781b4958ed6e0e1228f'),from_hex('7775b274f0c3fa919b756b22a4d9674e55927ab8'),from_hex('777d8fdce12499ae2d66520865811eee8c7de679'),from_hex('79dbec2d18a758c62d410f9763956d52fbd4a3cc'),from_hex('7a8cbbf690084e43de778173cfacf7313c9122dd'),from_hex('7c16f0185a26db0ae7a9377f23bc18ea7ce5d644'),from_hex('7d7eedcbeb158d55c5b200ad271baf1ca7561cbd'),from_hex('7e4b5442d09913273f15f6d6b75e31ec962ad873'),from_hex('7efc5e7f2632dd72722cd9d752ccae78185def8f'),from_hex('809484b8579dc605917b8f94aa284282d5fe375d'),from_hex('825286eaf60fc4ba0b92b7581fc5a6e6030570fe'),from_hex('8271becad4c7114488461bed1b9193d4a5126797'),from_hex('856b0ddd7277b4b121f19202406183d23ae63aed'),from_hex('892406491a47ef0db3abad92064fb5551ff776e0'),from_hex('89c6340b1a1f4b25d36cd8b063d49045caf3f818'),from_hex('8a81f57a71ce5945fa14132ba58c108b85afa6b6'),from_hex('8b2563c86c60ed30febb3a1309adc026d5cb1aa3'),from_hex('8b35b2ee655cb6e851910bc848a4079feb43e82a'),from_hex('8c1cddc5c012a2c84d531855f3946d927fe38e1e'),from_hex('8eed5e28216c0bc6f817df40ae6ca11c2294cc1c'),from_hex('903bce6641ef9cf12fe91ca66ece109882184a79'),from_hex('90f00d6aec4cc1165604c64e69ca26f6e4804cfc'),from_hex('9188e9b4dabaa1ff4e75092404c223bf69cab9b7'),from_hex('928d1d64ae6b2953d43d48942c68ddcf3233213a'),from_hex('96c220076ade7e8b75033ffd1c1495c57c112751'),from_hex('96e9fbdd615b5c068210f949aa2132943463082c'),from_hex('97795da27138bd8d79204d37f3a2e80fa4d30488'),from_hex('97b0b57fa67d7a4eb86861da38e0e2abfd6f4435'),from_hex('98937578c83f0d24c0ac34f3ae447bcb3c4b4402'),from_hex('99e7b45cde4ec4d329f9d6740acb6583fbf3f901'),from_hex('9a577736552443585b7963cb68143135ca4141d4'),from_hex('9c769e81001fbd30a5d34f16cc8426bddb458c0e'),from_hex('9def5d7fec5a20232dfae3223a453286b23b13c3'),from_hex('9ea52f774e21ff2fd4dd452160d612c764d21581'),from_hex('9f5f127982b8a2566cf53c375c0523f58789fd46'),from_hex('a3752af0d28549a04b2bb90c9fb5533d380c8ffa'),from_hex('a5e1a81738259256181f9a0e478188553062d340'),from_hex('a64d8025dda09bce94da2cf2dc175d1831e2df76'),from_hex('a6a147946facac9e0b99824870b36088764f969f'),from_hex('a86bd6927444b14c9633f0f15fc8c8ad277d5d95'),from_hex('a993d8bc698de614da1b20e0cdf3d457bb726abb'),from_hex('ab235da7f52d35fb4551afba11bfb56e18774a65'),from_hex('ac4c6e212a361c968f1725b4d055b47e63f80b75'),from_hex('ac611cb3fdbc4c79c9463838e88c4d3bae744ce4'),from_hex('adb2d3b711bb8d8ea92ff70292c466140432c278'),from_hex('ae8fbe656a77519a7490054274910129c9244fa3'),from_hex('ae9f6f928b203b33711659971d011fef92050964'),from_hex('af204776c7245bf4147c2612bf6e5972ee483701'),from_hex('b1f3a7b816b0681188f54dfa400991b93adf00ed'),from_hex('b50201558b00496a145fe76f7424749556e326d8'),from_hex('b5253c895361678ff5d0ffdda81dd02f1f7a81d6'),from_hex('b5814811dc4fc2ac127a1f8fb708460bf9fad619'),from_hex('b60f6c4648e9b0854607e140b7aabc1e5ebfe49e'),from_hex('ba12222222228d8ba445958a75a0704d566bf2c8'),from_hex('ba1333333333a1ba1108e8412f11850a5c319ba9'),from_hex('bb2254047f7b332ed1d289c9b47d3f4535155c40'),from_hex('bcf474926a8cc651d39a0c99a7196146671ec83d'),from_hex('bdf4488dcf7165788d438b62b4c8a333879b7078'),from_hex('beb0a58e627fee7afc795ee9baaf9e4c934913d7'),from_hex('bedfac7488dccaafdd66d1d7d56349780fe0477e'),from_hex('c092587808890d53dff3ff37bebee3433b5f0ac6'),from_hex('c20c9c13e853fc64d054b73ff21d3636b2d97eab'),from_hex('c33375b0bb4f0a192bd3cbd5ea7d53b1f9e3509e'),from_hex('c554bdbbed28d34e3675c6c53dc0ab645cf285e0'),from_hex('c6d25285d5c5b62b7ca26d6092751a145d50e9be'),from_hex('c702faf72e4dff8c7241023321ebaa0c72f7420a'),from_hex('c7242d167563352e2bca4d71c043fbe542db8fb2'),from_hex('c76bca73e25b84555a24d344850ae8b3006ac5e4'),from_hex('c87de04e2ec1f4282dff2933a2d58199f688fc3d'),from_hex('c92e8bdf79f0507f65a392b0ab4667716bfe0110'),from_hex('cb362c3b3e6a997026428719181411bc8eeaca5b'),from_hex('cb5092b62d54f5a429b70f41bd32c72becbdda5b'),from_hex('cb6eb8df68153cebf60e1872273ef52075a5c297'),from_hex('ccc88a9d1b4ed6b0eaba998850414b24f1c315be'),from_hex('ccdd929a2da635c6651520b54aba5c020614aaa0'),from_hex('ce40449b773a3e6e5e769adb4e567179d4828cbd'),from_hex('ceafdd6bc0bef976fdcd1112955828e00543c0ce'),from_hex('cf62493a5a5f9ef3ba08534c9b33d4cc2d0ebcee'),from_hex('d0f033cc7c7481548368fdc71167119ea6487bbf'),from_hex('d21c2396a5caaf4b02f2e400cdc1a4f2a58350bd'),from_hex('d4b7769dffa274daa8ec351b67609804fafb4307'),from_hex('d6e1154fbee3ff2a94653e7724d912723df7dea8'),from_hex('d7f1dd5d49206349cae8b585fcb0ce3d96f1696f'),from_hex('d8088f0d57db91ac6404fb3a9723a890100a6bb3'),from_hex('d82ff94b53cc04f213ab05f8f72967214c551287'),from_hex('d877c87e64026a416f3486d9b151f41f618f56f9'),from_hex('d9a05489b2158dbe225ff78a99698cf7b20883c3'),from_hex('dc1ba4028b16d2cc4d27b8a2733fe1642b198ab6'),from_hex('de256291e33139abc97cafcd68ed91a4c8037777'),from_hex('de2b920506ee931a6a2abdf566526220214fbbae'),from_hex('e092d7339d2c69b37e35f9378eece29dd96ef68f'),from_hex('e0a342ed4e0f0dbe97c4810534cfcb6550ea017d'),from_hex('e2996f6bc88ba0f2ad3a6e2a71ac55884ec9f74e'),from_hex('e3d0b29bdff611e27194b7e070c6b74fc3366b30'),from_hex('e43e60736b1cb4a75ad25240e2f9a62bff65c0c0'),from_hex('e4b70ebc3632e1d53892455b921873e53352b8d0'),from_hex('e4dab2ee9c11f428d3d65b226b44235747862e2c'),from_hex('e5759714998e8b50a33c7333c04c2d02e5dce77f'),from_hex('e82e331890d6d5b16fb2262ce8397bed4eda9bc8'),from_hex('e8a249626d3f3b876b887c30a3355513cb3fa9e4'),from_hex('ec9048b59b3467415b1a38f63416407ea0c70fb8'),from_hex('ed5f8ecefb32e9a62742c60508f6002df3dc602d'),from_hex('f0d4c12a5768d806021f80a262b4d39d26c58b8d'),from_hex('f152812e0fb93e56f03c16f98da47b2e84f0b837'),from_hex('f1c5e22fb6f4b974ad12ca4bc461f9746f77bb7d'),from_hex('f304dcf7b4f4cf4cc0350742e2634d274c6e8025'),from_hex('f6a78083ca3e2a662d6dd1703c939c8ace2e268d'),from_hex('f75584ef6673ad213a685a1b58cc0330b8ea22cf'),from_hex('f85fc807d05d3ab2309364226970aac57b4e1ea4'),from_hex('fa39c1c670b48956eef9fd0bbd0e81a290326330'),from_hex('fa6a571c10a99865bef5943166b657bbb074c9aa'),from_hex('fb89098b280b3399df4bce07b16b380260c4c0b6'),from_hex('fb8b95fb2296a0ad4b6b1419fdaa5aa5f13e4009'),from_hex('fcd125f4c5030137634863a2d3e5d6d89158f19c'),from_hex('fcdff29b45035467f5d8b57febb559c0c7dc1c27'),from_hex('ffb643e73f280b97809a8b41f7232ab401a04ee1'))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