date_trunc('month', block_timestamp) as date,

sum(event_inputs:amount / pow(10,18)) as aave_amount,

count(distinct tx_hash) as tx_count,

'Stake' as type

from

ethereum.core.fact_event_logs

where

contract_address = '0x4da27a545c0c5b758a6ba100e3a049001de870f5' and

event_name = 'Staked' and

block_timestamp::date < current_date

group by 1