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'

),

DailyStats AS (

SELECT

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

COUNT(DISTINCT tt.ORIGIN_FROM_ADDRESS) AS daily_users,

SUM(tt.AMOUNT_USD) AS daily_volume

FROM

TokenTransfers tt

GROUP BY

DATE_TRUNC('day', tt.BLOCK_TIMESTAMP)