WITH chains AS (

SELECT

*

FROM

(

VALUES

('Ethereum', '1', 'ETH'),

('Arbitrum', '42161', 'ETH'),

('BNB Smart chain', '56', 'BNB'),

('Avalanche_C', '43114', 'AVAX'),

('Optimism ', '10', 'ETH'),

('Polygon', '137', 'MATIC'),

('BASE', '8453','ETH'),

('Gnosis', '100', 'XDAI'),

('zkSync Mainnet', '324', 'ETH'),

('Solana', '1151111081099710','SOL'),

('Fantom Opera', '250','FTM'),

('Polygon zkEVM', '1101','ETH'),

('Linea', '59144', 'ETH'),

('Aurora','1313161554','AURORA')

) AS a (chain, dest_chain_id,currency)

,

polygon_chain_data as (

SELECT

'polygon' as src_chain ,

'Li.Fi' 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