date_trunc('week', block_timestamp) as block_week,

event_inputs:to::string as users,

event_inputs:value/1e18 as amount_3crv,

tx_id

from ethereum.events_emitted

where

lower(event_inputs:from::string) = ('0xc5bddf9843308380375a611c18b50fb9341f502a')

and lower (contract_address) = ('0x6c3f90f043a72fa612cbac8115ee7e52bde6e490')

and tx_succeeded = 'TRUE')

block_week, count(distinct tx_id) as claim_count,

count(distinct users) as users_count,

sum(amount_3crv) as total_amount_claimed,

avg(amount_3crv) as average_amount_claimed

from crv

group by 1

order by 1 desc