select
--*,
origin_function_signature,
text_signature,
--contract_address,
sum(raw_amount/1e18) as amount
--row_number() over (partition by origin_function_signature order by tx_hash) row_num
from polygon.core.fact_token_transfers left join ethereum.core.dim_function_signatures on origin_function_signature = bytes_signature
where to_address = lower('0xfd225C9e6601C9d38d8F98d8731BF59eFcF8C0E3')
and contract_address = lower('0xfa68FB4628DFF1028CFEc22b4162FCcd0d45efb6')
group by 1,2
--qualify row_num = 1
--limit 100
--group by 1,2
/*
0xea99c2a6 submit
0x46e04a2f claimtokens
0x6f4a2cd0 distributerewards
*/