block_timestamp::date as date,

count(distinct tx_hash) as "Number Stake",

count(ORIGIN_to_ADDRESS) as "Stakers",

sum(event_inputs:value)/pow(10,18) as "Amount ETH"

from avalanche.core.fact_event_logs

where event_name ilike 'Transfer'

and contract_address = lower('0x49D5c2BdFfac6CE2BFdB6640F4F80f226bc10bAB')

and ORIGIN_FUNCTION_SIGNATURE = '0x1cff79cd'

and tx_status = 'SUCCESS'

group by 1