select *

from (values

('0x7712c34205737192402172409a8F7ccef8aA2AEc'),

('0xA6525Ae43eDCd03dC08E775774dCAbd3bb925872'),

('0xa1CDAb15bBA75a80dF4089CaFbA013e376957cF5'),

('0x2893Ef551B6dD69F661Ac00F11D93E5Dc5Dc0e99'),

) as l(address)

select

chain,

symbol,

sum(amt) as total_bal

(select date(block_timestamp) as datetime,

'Ethereum' as chain,

symbol,

amount as amt

from ethereum.core.ez_token_transfers

where contract_address in (select lower(address) from list_contract)

and

from_address = '0x0000000000000000000000000000000000000000'

union all

select date(block_timestamp) as datetime,

'Ethereum',

symbol,

-amount

from ethereum.core.ez_token_transfers

where contract_address in (select lower(address) from list_contract)

and

to_address = '0x0000000000000000000000000000000000000000'

union all

select date(block_timestamp) as datetime,