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,

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

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

),

UserFirstBridge AS (

SELECT

ORIGIN_FROM_ADDRESS,

MIN(BLOCK_TIMESTAMP) AS first_bridge_date

FROM polygon.core.ez_token_transfers

WHERE ORIGIN_TO_ADDRESS = '0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae'

AND ORIGIN_FROM_ADDRESS = FROM_ADDRESS

GROUP BY ORIGIN_FROM_ADDRESS

),

DailyStats AS (

SELECT

DATE_TRUNC('day', tt.BLOCK_TIMESTAMP) AS transaction_date,

COUNT(DISTINCT CASE WHEN ufb.first_bridge_date >= CURRENT_DATE - INTERVAL '1 month' THEN tt.ORIGIN_FROM_ADDRESS END) AS new_users,