where CONTRACT_ADDRESS=lower('0xC02aaA39b223FE8D0A0e5C4F27eAD9083C756Cc2') and

TX_HASH in ('0x5b6620686f88885227d363373f52fc9fc56b4f2f048477d5760450a41f7e030e','0xa4ac14ba6ab9158450d02a3bbe2f9ae16b8ac58e60c540d2376d91398618ee5d','0x54013681aa7cbb273c230cfc9c48938be47d4fb2410a1554463db89e13d54a11','0x9e9fae2c569d1e15dd84490b1240aa7c59b550db9ccf9b621f9d711ebe46af96','0x9ef6aeccbb118cec371462be63f4b1be40b82909b7b017252d952eeb2d410437','0xfd67252a56f78dc5f9977ed6a977910472587d5e2e34beae0eda3e6b07e2c1e8','0x8d89ed1aad47bc6f0a1e02159fc18b5cb30288a591588814628421042e583d60','0x88c1323d4b981e4835abad4457432cc43b46425f656d54b6b6c205ac6aa0bed0','0xe42b51db2a3314a511e48d08735d7ab4fae8703f4866f140734ef4ba00cff913','0x3b89d2cf8d70b6698a0dfafa2f0b4c68d598ef2e398eca77290623341571d6fe','0xb1d90094b6795e34d335e31aeeeb95af6b4df654d51363c3f0aade873d6a17aa','0xabe7e827f0b91ffdbb22b0a6a61b51402e3d92f32161eb054a44f48b0d36f63f','0x361a4774a9e24755dbe1c276e853c3b53b86d595e1da3abbbc054b13fc43eacd','0xe4af40be8c002f1d6014e21b351c2d9e9d3f20d6153d476f655cdc5d779d8722','0xddd4a8e87dcb61ea3919d15d40332775e1413a29e97e7f6eec2c5fbfee1f8115','0xecc3171114ce24308638215abb8bbd225724d0d4f1d53e2e6ffbbe8b51a2f473','0xd0013ce5a3f6cc6596865b8ca6754efce8b55d3d66c2dfc6f4ab1a2756c9c316','0x82977db2739d35093cb6487e3c610f3f82461c5aee367d7bf53c87f91c93482a','0xa0acbbb4421658427ccbdf2aca4c42bb411cce1d98124bbd6a5db24db37c4e35','0xb20bd57e7302c180477dc5b6d0d030b9212071c7c373f75ca3222189f641f406','0x7a8970f3ef869e998c8770da176c99b8a9d55cc3284c64d3cd71183b96d069cb','0x8706f072983940c30373b4fccfede1ad2b5659456cab480f6a54fc809a51b338','0x3a9d8f179ab2c89016d7a765b99360fdaf44caebc9ce1c8280b4beea582d55f7','0xbc4dd31e468338220a29fa9f0b28c9a59041ffc1d73fa25afad2154b40aa7cac','0xff8b5f4c1c5f478037e15837a12421ac5d5d91d766c97ad961eb555aa8fda2bc','0x2876e73a653a0bd075d50e84573d9329d1a40060b313826e28e28744ee644986','0xffc8670a8025be84e29cc0e2e66c1de649b47a9edda6b952ea30370c96f635e1','0x32d51ff238abddae4966852d901a5ceb5c975d04492e9bfcdcce1691bf649c6b','0xed548823ddadbf7f6ff20dac79bfd05d1f35e1f2fa43ea7d5608b3aa908fa1c1','0xc10af10713a9f388e291a4f0a6532746cd28d969a8addecadede99fbaa9834a7','0xf3fd76ac4513a5e8b629fb388268175f1865ebb732c567983cf1a2ab6afd044d','0x305d8e6cb5a60cce3e96e18410d3

select

date_trunc('day',BLOCK_TIMESTAMP) AS Day,

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('0xC02aaA39b223FE8D0A0e5C4F27eAD9083C756Cc2'))

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

sum(Amount) AS Volume

from tb group by 1,2