event_name, decoded_log:_user AS user,

CASE

WHEN decoded_log:_token = '0x9702230a8ea53601f5cd2dc00fdbc13d4df4a8c7' THEN 'USDT'

ELSE 'USDC'

END AS Token,

decoded_log:_amount / 1e6 AS amount

FROM avalanche.core.fact_decoded_event_logs

WHERE CONTRACT_ADDRESS = '0xc3e9006559cb209a987e99257986aa5ce324f829'

AND event_name IN ('Stake', 'FlashWithdraw', 'RequestClaim', 'ClaimAssets')

AND block_timestamp >= '2025-02-01'

ORDER BY block_timestamp ASC

LIMIT 50;