select

pool_address,

pool_name,

token0_name,

token1_name,

token0_decimals,

token1_decimals

from ethereum.uniswapv3.ez_pools

where pool_address = '{{pool_address}}'

),

liquidity_events as (

select *

from ethereum.core.ez_decoded_event_logs

where contract_address = (select pool_address from pools)

and block_timestamp::date >= current_date - 90

and event_name in ('Mint', 'Collect')

),

add_liquidity_transfers as (

select

tx_hash,

block_timestamp,

origin_from_address,

to_address,

amount,

amount_usd

from ethereum.core.ez_token_transfers

where block_timestamp >= current_date - 90

and tx_hash in (

select tx_hash

from liquidity_events

where event_name = 'Mint'

)

and to_address in (select pool_address from pools)

and from_address not in (select pool_address from pools)

),