select * from (

VALUES

('Bitcoin', 20000000000001), ('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),('Solana',1151111081099710), ('Velas', 106), ('Fuse', 122),

('Boba', 288),('Moonbeam', 1284),('Moonriver', 1285),('Cronos',25),('Evmos', 9001),

('OKExChain', 66),('Harmony', 1666600000), ('Metis', 1088),('Mode', 34443),('opBNB', 204),

('Rootstock',30),('Fraxtal', 252),('Taiko', 167000),('Gravity', 1625),

('Sei', 1329), ('Immutable zkEVM', 13371)

) as a (chain, chain_id)

,

ethereum_chain_data as (

select

'ethereum' as src_chain ,

'LiFi' as aggregator,

block_timestamp,

tx_hash,

origin_from_address,

decoded_log:bridgeData:destinationChainId as dest_chain_id,

decoded_log:bridgeData:minAmount as amount_raw,

decoded_log:bridgeData:sendingAssetId as asset_id

from ethereum.core.ez_decoded_event_logs

where event_name = 'LiFiTransferStarted'

and tx_status = 'SUCCESS'

and block_timestamp::date >= '2024-01-01'

,

arbitrum_chain_data as (

select

'arbitrum' as src_chain,

'LiFi' as aggregator,

block_timestamp,