date_trunc(day, block_timestamp)::date as date

,count(DISTINCT tx_hash) as staked_count

,sum(EVENT_INPUTS:amount/pow(10,18)) as amount_aave

,sum(amount_aave) over(order by date) as growth_amount

,sum(staked_count) over(order by date) as growth_staked_count

from ethereum.core.fact_event_logs

where block_timestamp::date>='2022-02-01'

and contract_address = lower('0x4da27a545c0c5b758a6ba100e3a049001de870f5')

and EVENT_NAME='Staked'

and TX_STATUS ='SUCCESS'

group by 1

order by 1