predecessor_id,

COUNT(DISTINCT tx_hash) as number_of_transactions,

SUM(CASE WHEN log_event = 'mt_mint' THEN TRY_CAST(amount_raw AS NUMBER)/1e24 ELSE 0 END) as total_wrapped,

SUM(CASE WHEN log_event = 'mt_burn' THEN TRY_CAST(amount_raw AS NUMBER)/1e24 ELSE 0 END) as total_unwrapped,

SUM(TRY_CAST(amount_raw AS NUMBER)/1e24) AS total_wnear_volume

FROM near.defi.fact_intents

WHERE token_id = 'nep141:wrap.near'

AND block_timestamp >= DATEADD('day', -30, CURRENT_DATE)

AND receipt_succeeded = TRUE

GROUP BY 1

HAVING total_wnear_volume > 0

ORDER BY total_wnear_volume DESC

LIMIT 10;