select
date_trunc('day', block_timestamp) as date,
sum(raw_amount/pow(10, 18)) as daily_revenues_stETH
from ethereum.core.fact_token_transfers
where from_address = lower('0x0000000000000000000000000000000000000000')
and to_address = lower('0x3e40D73EB977Dc6a537aF587D48316feE66E9C8c')
and contract_address = lower('0xae7ab96520DE3A18E5e111B5EaAb095312D7fE84')
and date >= '{{Analysis_Start_Date}}'
and date <= '{{Analysis_End_Date}}'
group by date