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)

),

TokenTransfers AS (

SELECT

tet.TX_HASH,

tet.ORIGIN_FROM_ADDRESS,

tet.AMOUNT_USD,

tet.FROM_ADDRESS,

tet.ORIGIN_TO_ADDRESS,

tet.BLOCK_TIMESTAMP

FROM polygon.core.ez_token_transfers tet

JOIN Events e ON e.TX_HASH = tet.TX_HASH

WHERE tet.ORIGIN_TO_ADDRESS = '0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae'

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

AND tet.BLOCK_TIMESTAMP <= CURRENT_DATE

AND tet.ORIGIN_FROM_ADDRESS = tet.FROM_ADDRESS

),

Results AS (

SELECT

COUNT(DISTINCT tt.ORIGIN_FROM_ADDRESS) AS Users,

SUM(tt.AMOUNT_USD) AS Volume,

COUNT(DISTINCT tt.TX_HASH) AS Bridges

FROM TokenTransfers tt

SELECT * FROM Results;