select count(distinct tx_hash) as total_stake, sum(event_inputs:value/pow(10,18)) as volume, date_trunc('day', block_timestamp) as date_time
from ethereum.core.fact_event_logs
where origin_to_address = '0xae78736cd615f374d3085123a210448e74fc6393'
and tx_status ilike 'success'
and event_name ilike '%transfer%'
and date_trunc('day', block_timestamp) >= '2021-11-01'
group by date_time
order by date_time