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 >= CURRENT_DATE - INTERVAL '1 month'

),

TokenTransfers AS (

SELECT

tet.TX_HASH,

tet.ORIGIN_FROM_ADDRESS,

tet.AMOUNT_USD

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.ORIGIN_FROM_ADDRESS = tet.FROM_ADDRESS

AND tet.BLOCK_TIMESTAMP >= CURRENT_DATE - INTERVAL '1 month'

),

UserVolumes AS (

SELECT

ORIGIN_FROM_ADDRESS AS user,

SUM(AMOUNT_USD) AS total_volume

FROM

TokenTransfers

GROUP BY

ORIGIN_FROM_ADDRESS

),

UserGroups AS (

SELECT

user,