eth_bridge_transfers AS (

SELECT

tx_hash

, block_timestamp

, eth_from_address AS from_address

, 'ETH' AS token_symbol

, amount

, amount_usd

FROM ethereum.core.ez_eth_transfers

WHERE block_timestamp::date BETWEEN '2021-07-01' AND '2022-06-15'

AND eth_to_address IN (

'0x98f3c9e6e3face36baad05fe09d375ef1464288b'

, '0xf92cd566ea4864356c5491c177a430c222d7e678'

, '0x3ee18b2214aff97000d974cf647e7c347e8fa585'

)

),

token_bridge_transfers AS (

SELECT

tr.tx_hash

, tr.block_timestamp

, tr.from_address

, tr.contract_address AS token_contract_address

, tr.symbol AS token_symbol

, tr.amount

, tr.amount_usd

FROM ethereum.core.ez_token_transfers AS tr

WHERE tr.block_timestamp::date BETWEEN '2021-07-01' AND '2022-06-15'

AND tr.to_address IN (