SELECT

CASE

-- section of code from https://flipsidecrypto.xyz/0-MID/dashboards

WHEN DECODED_LOG:bridgeData:destinationChainId = 137 THEN 'Polygon'

WHEN DECODED_LOG:bridgeData:destinationChainId = 324 THEN 'zkSync'

WHEN DECODED_LOG:bridgeData:destinationChainId = 8453 THEN 'Base'

WHEN DECODED_LOG:bridgeData:destinationChainId = 534352 THEN 'Scroll'

WHEN DECODED_LOG:bridgeData:destinationChainId = 56 THEN 'BNB'

WHEN DECODED_LOG:bridgeData:destinationChainId = 59144 THEN 'Linea'

WHEN DECODED_LOG:bridgeData:destinationChainId = 1 THEN 'Ethereum'

WHEN DECODED_LOG:bridgeData:destinationChainId = 43114 THEN 'Avalanche'

WHEN DECODED_LOG:bridgeData:destinationChainId = 250 THEN 'Fantom'

WHEN DECODED_LOG:bridgeData:destinationChainId = 1101 THEN 'Polygon zkEVM'

WHEN DECODED_LOG:bridgeData:destinationChainId = 1151111081099710 THEN 'Solana'

WHEN DECODED_LOG:bridgeData:destinationChainId = 1088 THEN 'Metis'

WHEN DECODED_LOG:bridgeData:destinationChainId = 42161 THEN 'Arbitrum'

ELSE 'Others'

-- section of code inspired and edited from https://flipsidecrypto.xyz/0-MID/dashboards

END AS ChainName,

TX_HASH AS TxHash

FROM polygon.core.ez_decoded_event_logs

WHERE

EVENT_NAME = 'LiFiTransferStarted'

AND DECODED_LOG:bridgeData:integrator = 'jumper.exchange'

AND ORIGIN_TO_ADDRESS = '0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae'

AND BLOCK_TIMESTAMP >= DATE_TRUNC('month', CURRENT_DATE)

),

TokenDetails AS (

SELECT

TX_HASH AS TxHash,

ORIGIN_FROM_ADDRESS AS SenderAddress,

AMOUNT_USD AS VolumeUSD

FROM polygon.core.ez_token_transfers

WHERE

ORIGIN_TO_ADDRESS = '0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae'