SELECT

'0xf1815bd50389c46847f0bda824ec8da914045d14' as token_address, 'USDC' as token_name, 6 as decimals

UNION ALL

SELECT '0x2f6f07cdcf3588944bf4c42ac74ff24bf56e7590', 'WETH', 18

UNION ALL

SELECT '0x2aabea2058b5ac2d339b163c6ab6f2b6d53aabed', 'USDF', 6

UNION ALL

SELECT '0x674843c06ff83502ddb4d37c2e09c01cda38cbc8', 'USDT', 6

UNION ALL

SELECT '0xfa0e06b54986ad96de87a8c56fea76fbd8d493f8', 'USDF', 6

UNION ALL

SELECT '0xea3910f1c6e687b59835885904a2fd1944b51ec6', 'TRUMP', 18

),

bridge_transfers AS (

SELECT

block_timestamp::Date as date,

tx_hash,

contract_address as token_address,

'0x' || substr(TOPIC_1,27) as from_address,

'0x' || substr(TOPIC_2,27) as user_address,

TRY_TO_NUMBER(livequery.utils.udf_hex_to_int(DATA)) as amount_raw,

t.token_name,

t.decimals,

CASE

WHEN amount_raw IS NOT NULL THEN amount_raw/pow(10,decimals)

ELSE TRY_TO_NUMBER(data, 16)/pow(10,decimals)

END as amount

FROM flow.core_evm.fact_event_logs e

JOIN token_info t ON e.contract_address = t.token_address

WHERE origin_to_address = '0xa20db4ffe74a31d17fc24bd32a7dd7555441058e'

AND topic_0 = '0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef'

AND tx_succeeded = 'TRUE'

AND '0x' || substr(TOPIC_1,27) = '0x0000000000000000000000000000000000000000'

),