SELECT

DATE(BLOCK_TIMESTAMP) as date,

EVENT_NAME,

TX_HASH,

DECODED_LOG:beneficiary::string as user_address,

DECODED_LOG:collateral_amount::float/1e6 as collateral_amount_usdc,

DECODED_LOG:avusd_amount::float/1e18 as avusd_amount

FROM avalanche.core.ez_decoded_event_logs

WHERE CONTRACT_ADDRESS IN (

'0x1499cb3197427b78dc0e2d356a1e0e4149e0ed51',

'0x24dE8771bC5DdB3362Db529Fc3358F2df3A0E346'

)

AND EVENT_NAME IN ('Mint', 'Redeem', 'Transfer')

AND TX_SUCCEEDED = TRUE

SELECT

user_address as "User Address",

COUNT(DISTINCT TX_HASH) as "Transaction Count",

SUM(CASE

WHEN EVENT_NAME = 'Mint' THEN collateral_amount_usdc

WHEN EVENT_NAME = 'Redeem' THEN collateral_amount_usdc

ELSE 0

END) as "Total Volume (USDC)",

MIN(date) as "First Transaction",

MAX(date) as "Last Transaction"

FROM mint_redeem_events

GROUP BY user_address

ORDER BY "Transaction Count" DESC

LIMIT 50;