select date_trunc('day', block_timestamp) AS date,sum(amount) as "Total Claimed CRV", sum(amount_usd) as "Total CRV Claimed in USD"

from ethereum.udm_events where contract_address = '0xd533a949740bb3306d119cc777fa900ba034cd52' and tx_id in (

select tx_id from ethereum.udm_events where contract_address ='0xc5bddf9843308380375a611c18b50fb9341f502a' and to_label = 'yearn'

and ORIGIN_FUNCTION_NAME = 'harvest' and symbol = 'yveCRV')

group by 1 order by date desc)

select * from yvecrv_claims order by date desc