select *

from $query('ad651c06-e8bf-46b0-8491-3db499ad0b81')

),

all_contracts_list as (

select *

from $query('22c3bdd1-3720-4594-bcd6-e14a9c76d781')

),

participants_contracts_list as (

select *

from $query('75f58bb3-b2cd-4208-85e9-e3d75d901a1c')

),

tokens_pool as (

select *

from $query('1b597bbe-cdeb-4bf9-becd-ff1d334313d9')

),

tokens_pools_balance as (

select token_address, b.symbol, replace(pair_symbol,'WMATIC','WPOL') as pair_symbol, b.pool_address,

sum(change) as balance

from

(select *, case when from_address in (select pool_address from tokens_pool) then from_address else to_address end as pool_address,

case when from_address in (select pool_address from tokens_pool) then -AMOUNT_PRECISE else AMOUNT_PRECISE end change

from polygon.core.ez_token_transfers

where (from_address in (select pool_address from tokens_pool) or to_address in (select pool_address from tokens_pool))

and contract_address in ('0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270','0xc2132d05d31c914a87c6611c10748aeb04b58e8f',

'0x7ceb23fd6bc0add59e62ac25578270cff1b9f619','0x2791bca1f2de4661ed88a30c99a7a9449aa84174','0x3c499c542cef5e3811e1192ce70d8cc03d5c3359')

and from_address!=to_address

union all

select *, case when to_address in (select pool_address from tokens_pool) then to_address else from_address end as pool_address,

case when to_address in (select pool_address from tokens_pool) then AMOUNT_PRECISE else -AMOUNT_PRECISE end change

from polygon.core.ez_token_transfers

where (from_address in (select pool_address from tokens_pool) and to_address in (select pool_address from tokens_pool))