SELECT

TX_HASH

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)

),

BridgedTransfers AS (

SELECT

SYMBOL,

AMOUNT_USD,

TX_HASH,

ORIGIN_FROM_ADDRESS

FROM polygon.core.ez_token_transfers

WHERE

ORIGIN_TO_ADDRESS = '0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae'

AND ORIGIN_FROM_ADDRESS = FROM_ADDRESS

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

AND AMOUNT_USD IS NOT NULL

SELECT

BT.SYMBOL,

SUM(BT.AMOUNT_USD) AS volume,

COUNT(DISTINCT BT.TX_HASH) AS bridges,

COUNT(DISTINCT BT.ORIGIN_FROM_ADDRESS) AS users

FROM LiFiTransfers LT

JOIN BridgedTransfers BT ON LT.TX_HASH = BT.TX_HASH

GROUP BY BT.SYMBOL

ORDER BY volume DESC

LIMIT 10;