'https://app.layer3.xyz/' || origin_from_address as "Claimer profile",

block_timestamp,

CASE WHEN origin_function_signature = '0x9a15bf92' THEN 'Claim'

ELSE 'Claim and Stake'

END AS claim_type,

SUM(raw_amount/POWER(10,18)) as amount_claimed

FROM ethereum.core.fact_token_transfers t

WHERE (origin_function_signature = '0x9a15bf92' OR origin_function_signature = '0x0768132f')

AND origin_to_address = '0x6571e50e8769d236414f3fb9e9b1d05341f6f79a'

GROUP BY 1,2,3

ORDER BY amount_claimed DESC