contract_mapping as (

select lower('0xc98D64DA73a6616c42117b582e832812e7B8D57F') as contract, 'RSS3' as symbol union

select lower('0xA0b86991c6218b36c1d19D4a2e9Eb0cE3606eB48') as contract, 'USDC' as symbol union

select lower('0xC02aaA39b223FE8D0A0e5C4F27eAD9083C756Cc2') as contract, 'WETH' as symbol union

select lower('0xdAC17F958D2ee523a2206206994597C13D831ec7') as contract, 'USDT' as symbol

),

bridge_dep as (

select

block_timestamp,

tx_hash,

symbol,

amount

from ethereum.core.ez_token_transfers

where to_address = lower('0x4cbab69108Aa72151EDa5A3c164eA86845f18438')

order by block_timestamp desc

),

bridge_with as (

select

block_timestamp,

tx_hash,

symbol,

-amount

from ethereum.core.ez_token_transfers

where from_address = lower('0x4cbab69108Aa72151EDa5A3c164eA86845f18438')

order by block_timestamp desc

),

combined as (

select * from bridge_dep union

select * from bridge_with

),

dates as (

select

date_trunc('day', combined.block_timestamp) as day,

contract_mapping.symbol as symbol