t.block_timestamp,

t.tx_hash,

t.from_address,

t.tx_json:chain_id as chainID,

t.tx_json:receipt:logs[0]:address::string as tokenID,

t.tx_json:receipt:logs[0]:decoded:inputs:value as raw_amount,

symbol,

decimals,

t.tx_json:receipt:logs[0]:decoded:inputs:value / pow(10, decimals) as adjusted_amount

from ethereum.core.fact_transactions t

left join ethereum.core.ez_token_transfers u ON t.tx_json:receipt:logs[0]:address::string = u.contract_address

where t.to_address = '0x3ee18b2214aff97000d974cf647e7c347e8fa585' --wormhole Ethereum token bridge address

having chainID = '0x1'

--tx_hash = '0x3cb8d98e4624cd90d4174a144cbdd88a819d9fcf8353dd7c38d03fb60191fa12' USDC from Solana to Ethereum