where CONTRACT_ADDRESS=lower('0x2260FAC5E5542a773Aa44fBCfeDf7C193bc2C599') and

TX_HASH in ('0x432f6dd6eced97eba6d7caefa27b35f038c81b5e06c8ca65240d9086011598d3','0x281230fba2c586651c256617a20f0310018e04a0b18ae2bf7ea5046da73e9e99',

'0x55f6b681a761bf52c9ce621f97eb58ec36c88971cdc3b36b9666fdf917a755d5','0x2edbab0e9766f544061392fc1b9d2ddf1a9baee464e01bd93e5a9ed8d380e7b3','0xfce8aca7fa2cf7be1295db31019f600d2ba6b6f838f1057770765a6793e6fc57','0x55f3ed3132e19ecacdd7e1034d5cb27ce5619ef400814999bfee46b559446570','0x2fd136256b9ba4d1c8b05fe4e17dea06587723efca9c93aa4050f75d5d292039','0x88f78fbe30dbfe5bcfeca266c5fb63cda4ad7244ca0aa72e8bbd67f622a96fd5','0x57a84afc8c4d616a5a7b90647e71383a351a9fbcb5c6124f4d5eaecb1507e59f','0xb2572cb60a883200a35e153de585aa2f7e87873901d8d41dd4d0c1a8a7b16626','0x1c8f1d703bdbcc409bcd21eccb980cc9ce40d66e4db5caf434a9a846cb6fe470','0xcf6af291419f55938d890474ea6e3ce473c22938c2fd4532ce50370a4940ebec','0x9ff882b68003dae95edd8a7398a97471f6d23ee81dd63d6acd250683ab03db13','0xef96581d1b99157e06981dfdb4d836906399ce240a574e66e0e7ddb609979e3e','0x508514d880523c7c43a493898ca9e946c630298b70d2021889be8d7622598198','0x3f02c226aba6f735561c996b001b0dd926f4583288b244f0171697167945f406','0xde38494e448c8e814471005551fb38496fb1fbd422bf7bd0d32b8f6d1b4b3096','0xf41510d7de87cf469483b3b6c8c55d479a2149a582c95b0c0c516766fb830c8c','0xb74e778b509842c53cfc3042fa54c5eb3eb9f33c9cd4a151d1b05f3727ea2065','0xd12966294de3be2e880add7b92a3318bc8253ac6e5a2a3f686517e9971abc067','0x135b010353f19b233d626f43dcf5b5f271c0fd6f8964aa212f4eb62dd75dc564','0x9bcc044b391008f0de24fd929a9c20acb3b39c3fa1f259d0775f748ac3ec5361','0x2e0c528a62d018d4888b2ba79689dfd7aad88dec6ce3a7d3a95de343ecea05a6','0xfda3f7710f7d1b79fb1791014729db6aa534bf17a3d49c76ff53c1f76199abb2','0x1769d0cf7d374bc474f0215e927c7a631b40ecabfbf491e1ac0ff0242f302632','0x4d26266bf84bf004ec27b9b27ba4d20bfad587ab0736d2e332c6df3cac65914a','0x4c5e2125ca83aa9e0cff2ec81950b7d07135435ea9a6a84f2529030192e4f8a8','0x6cb4dc6dd40be492cf2e5fd8367d449c4570b2c04c9992cbf0d69969baa1888d','0x1551b664e1b9dbec88f648a0b89ab0d1d7a67a4a7c79bb4d4e59d365b86c5290','0x862b2b4ecde0ed8ff56d3dfea293d29621eb1c0fafebce1c5cceb9918bfa7420','0x0ea7f1c7f5b4313ccad3ec4a7a88c7a948f9fabe1fc09e094cbd78d490ee38d7','0xa4a7709224d86ff018e3c22d30baffaeb9d0b2f6c3dc2a91f7e3d5345247ed8f','0x46cbddc500c4c7b0852685d214e6f22bc5cd35f9c796850dd7a745968b5fd762','0x6c401b589c349661ab94dd87722809e7b237ac

'0xb41e71929436c022046c7f45b334990cd019176511cb99b2c4988846d437bd80','0x08589df503cff983c83a5a180715fbe67ee417f87295e1c8119d04e86974355f','0xedd663d68a90b346b5647358a831a0f6cb02729a221eba1d21414f8a3543c2b6','0x8453dd2e2bbd7bfdcd308675a4bb4dce7fc16e178144e8afdab9392a94c68271','0x21958e4228baa1f0ef6028216bf903bcc084a6fea4eb1ea98d278b0fcb0a912e','0xe13c86d2b8e3d3d7f3bb654960ab61cf420389a6b844ee8639fd4adeba4d8ba7','0x0e63d2d768bb1e31052fef1801971ec6c199e8167056397b7e658b5346d9e53c','0xfafe04f9ebf8fb93dc30ffcbca1a07eba21aa1aa36b41808107b8b6054a2c5fd','0x39a9c7a2916012f21e61a5c6611ac0990fd1e2ffe1c5529e636f808e3d5cc976','0x5b210fbbfd63669ab9cf8572e3a56786d79fdf8247bc8af155c607355b4ab749','0x716c9e5e490f29083b79cd7e8642c3bdcc65d680ec7a7d0e9f86c4cc1459bf4c','0x07ca54ae904665b098a1e0f8ef8e9a39b20c4201e956444f1c92309000f54bd0','0x32215fe0b7d2c80a7f0fd737007bcfdd686254756cc378785aa8e43852e063b5','0x60000a9b86008dc190bf6e0760fab5a18b6ecd2b9b2dbffebf43641920145e83','0xa5a25e93e4fa9b3feea0a65c31923a1d4c3edce179041af73b222a47921b0bc4','0x78462e6a0bd8ba6ca42b42cd6b712baef2a26f79fae30857a27fd34a5371e2e8','0x3950debf25581b6527e9ed260ee3966d32dcc0a31772a9756d5667c905cf4f40','0xf395ad99d83e618d50d648459f21a5a70aed2442b2b249a7f7e3cd48056ed0cb','0x9c6de7b080c8cf82548dd6b47ffa3c3681e18fe278a98e2d3b72c0d1f2fa94c6','0xdc36afc9c24b60aa7c2ca342c17293ba0bef8119a41d8739865a9035639a5a64','0x882bbe4c8a6ad7e5c82d22ba331fa4e3cc30ee6fa715f09774adaa1a63a1a3c8','0xa21984a94ff4f0af2ea52f081879ebd63e4bab8ca5d08b373afb95a00e183885','0x83a93e02f747a2bd37adf2e10e55e447f1822fe2f6b2aa046c91d432281c40bc','0xb6b7604a0a431487c053f75bebb871d34979f602a16ec307a2d111d2cbf91b79','0x50abb8ebcc79bdf9b052206dfd1c27d0aa3b94cfcbafbe347149386617d08434','0xcbcb8ce6667a493618ae1541d0f8d28c08b6a261879dfff16c008753b7024571','0xcb58997c642ea2e47682d302764eed32a58a96ed2659a9a6aa93bf935ede1d55','0x7c95099be5099cb45db0c018409187d10f21b52cca885db02cb2b436b277d3f8','0x1502a5d166d3180d17614b31ff8279236af791dbd1f56e246597388fac00bba4','0x935d3437c1dd24e405019273c406e137551c409caf04edaa8e1da5eca9b20fa2','0x8e94f9ff51a3e6513bad48fbe502f15d736c49c407ba1a29ec4f1f3fab72e1d3','0xa842098ac9ad551e092ee7c5ab7b55d5fa5189

'0xf7bf143e33b964ff9442322330e338b5616084b833c2a8160a94bc2d1a8c6b9c','0xee1b81f06f3b6ad764d5a5ec09ae1b8c3e19e706698e445fe7c67d9630585db2','0x6d085cc54d7d98e4b5afa41d5edb800556a4c1912adbb7b1fcbfae34ebbec32d','0xc2e5ea78430e2aa6ea9fcfca56d4a349d003c6306494abf7a0170520d8c49306','0x5e65435511bee782919fab1288a98af73f846ef0d26698c2263dcf82a47b563c','0x581932a7e5ba154845cffb1778fc8f9b9b9053268c74b168895c8b51965ecfe4','0x29da128730be04ee87f8a8a9c30455f66ca6dad1e09c73982d2f25506f5dab8f','0x80c481dce6cd65a79a646f182481e7c11764088c9f2efb640ef2b277464ad13f','0xa70442078dc369eab1a5d6adf52cdb44ac30cf3dc36c88501287965316fd14a9','0x052ce2c1da69157abf26eb67aa00904fbee358c3fa577a2e9fbff809cd58f8f2','0x6140aa90b4fa3f8533d055803901d534911e7165e22aeccc14308b48bafe6a94','0x43655ee36389007ca4ad953b2c4766531969d8a8851e1b3b2ea0cd40bd1950a7','0x8ab17578b0d7bfb261554e6af081ce58094a823b3aba941eeac6584a8322d458','0x2077fe57d7351d3e6947c3d8eca1e0fb008e07be72e26cd790ba0f6a87364f4a','0x568df88de328692633596754470ab4afc431f3c0d71eb6766cdea5ceb7172a9a','0x34d8831508d113b8126db89b89bbddff40d3af414722c76dd103aeeda8d9253c','0x1ffac32339f55cbbc584c23d2fa5d838c534bb61c80ca5ae756e0afaed708302','0xd8bb92932c6102e165e5d9b1ca32514e0d07ab5c6c2eb4180983da22d86d3d79','0x8d82ce95babd4e1377860ad38ede234f5c9add87d11f1de6de98cab653dac3c4','0x0d633b4f0b322d18211aea63f08b54aa628fbf8651ec9aee03ae3d009adb37ff','0x22307276351951bbd1050de18be7f5f7cc6541e5a54afb187079271628097767','0xdc5793ac2c26154690358e5528abcffd3a456d3d58c3976a21edbeca9a478e3a','0x681b0d20b31d748f5c901f36e95f57ed66c9990499877a2517a62f46d4898ca4','0x64dd4157a20c2b1c7bb13f2cc2813b203ad6504d2fd5355da6d6efd8377f244b','0x59bd93186e0f3b95809b23fb391bd3da41c65e8177a8a6b39995a077f1629c39','0x116b0bf0d6a6030901f83be8eeee6b1df40b769b023419f9e3ccde262b2459e5','0x0084cb58c4f58c5a8672dd7693ed54b486ef205c37527febfe50a997e0e4209e','0x602126818cc0f005196a5274ae9ba08b3b6bab293f201dfa8110f9b238397f18','0x0063d81a1d7276f88257ff2b4104c5ea9d15dd85a83605fcef2617cc584345c6','0x2a7bbb5e3e6a1e52720748517ed698ac7ad3b164e8281b84c26514bc5ac31dad','0x18bc990311b304dfa4ab264d71fe3e1065f68e8068539a26cc674baae18ae128','0x11c11a07c0031f20f87511442a172613fa343a

),

tb3 AS (select

Senders,

case when Senders in (select DISTINCT From_Address AS Address from ethereum.core.fact_token_transfers where TO_address in (select DISTINCT POOL_ADDRESS AS Pool from ethereum.uniswapv3.ez_pool_stats)

and CONTRACT_ADDRESS=lower('0x2260FAC5E5542a773Aa44fBCfeDf7C193bc2C599'))

then 'LPs on Uniswap' else 'not Lps on Uniswap' end AS Type

from tb)

select

Type,

count(DISTINCT Senders) AS "Addresses Number"

from tb3 group by 1