select * from (

VALUES

('Ethereum', 1),

('Arbitrum', 42161),

('Optimism ', 10),

('BNB Smart chain', 56),

('Avalanche_C', 43114),

('Polygon', 137),

('Base', 8453),

('Gnosis', 100),

('Polygon zkEVM',1101),

('zkSync Era', 324),

('Fantom', 250),

('Linea', 59144),

('Aurora',1313161554),

('Mantle',5000),

('Scroll', 534352),

('Blast', 81457)

) as a (chain, chain_id)

,

aurora_chain_data as (

select

'aurora' as src_chain ,

'Socket' as aggregator,

block_timestamp,

tx_hash,

origin_from_address,

livequery.utils.udf_hex_to_int(

REGEXP_SUBSTR_ALL(SUBSTR(data, 3, len(data)), '.{64}')[2] :: string) :: int as dest_chain_id ,

livequery.utils.udf_hex_to_int(

REGEXP_SUBSTR_ALL(SUBSTR(data, 3, len(data)), '.{64}')[0]::string) :: int as amount_raw ,

lower('0x' || substr(

REGEXP_SUBSTR_ALL(SUBSTR(data, 3, len(data)), '.{64}')[1]::string, 25, 40) :: string) as token

from aurora.core.fact_logs