select

date(block_timestamp) as date,

EVENT_INPUTS:fromChainID as From_Chain_ID,

case

when EVENT_INPUTS:fromChainID = '1' then 'Ethereum'

when EVENT_INPUTS:fromChainID = '56' then 'BSC'

when EVENT_INPUTS:fromChainID = '42161' then 'Arbitrum'

when EVENT_INPUTS:fromChainID = '137' then 'Polygon'

when EVENT_INPUTS:fromChainID = '43114' then 'Avalanche'

when EVENT_INPUTS:fromChainID = '250' then 'Fantom'

when EVENT_INPUTS:fromChainID = '10' then 'Optimism'

when EVENT_INPUTS:fromChainID = '25' then 'Cronos'

when EVENT_INPUTS:fromChainID = '324' then 'zkSync Era'

when EVENT_INPUTS:fromChainID = '1284' then 'Moonbeam'

when EVENT_INPUTS:fromChainID = '2222' then 'Kava EVM'

when EVENT_INPUTS:fromChainID = '2000' then 'Dogechain'

when EVENT_INPUTS:fromChainID = '1285' then 'Moonriver'

when EVENT_INPUTS:fromChainID = '66' then 'OKXChain'

when EVENT_INPUTS:fromChainID = '8217' then 'Klaytn'

when EVENT_INPUTS:fromChainID = '42170' then 'Arbitrum Nova'

when EVENT_INPUTS:fromChainID = '321' then 'Kucoin'

when EVENT_INPUTS:fromChainID = '1666600000' then 'Harmony'

when EVENT_INPUTS:fromChainID = '1559' then 'Tenet'

when EVENT_INPUTS:fromChainID = '1234' then 'Step'

when EVENT_INPUTS:fromChainID = '128' then 'Huobi ECO'

when EVENT_INPUTS:fromChainID = '40' then 'Telos'

when EVENT_INPUTS:fromChainID = '288' then 'Boba'

when EVENT_INPUTS:fromChainID = '88' then 'TomoChain'

when EVENT_INPUTS:fromChainID = '1001313161554' then 'Other'

when EVENT_INPUTS:fromChainID = '1559' then 'Tenet'

when EVENT_INPUTS:fromChainID = '1313161554' then 'Aurora'

when EVENT_INPUTS:fromChainID = '2001' then 'Milkomeda C1'

when EVENT_INPUTS:fromChainID = '336' then 'Shiden'

when EVENT_INPUTS:fromChainID = '1294' then 'Bobabeam'

when EVENT_INPUTS:fromChainID = '199' then 'BitTorrent'