date_trunc('week', block_timestamp) as block_week,

sum(event_inputs:value/1e18) as amount_yveCRV,

count(distinct tx_id) as tx_count

from ethereum.events_emitted

where

contract_name = 'yveCRV'

and event_inputs:to::string = lower('0x9d409a0a012cfba9b15f6d4b36ac57a46966ab9a')

and tx_succeeded = 'TRUE'

group by 1