WITH all_del as (

select

block_number,

date_trunc('day', block_timestamp) as date,

delegation_type,

delegator,

from_delegate as old_delegate,

to_delegate as delegate,

raw_previous_balance / pow(10, 18) as old_bal,

raw_new_balance / pow(10, 18) as new_bal,

new_bal - old_bal as amount,

tx_hash

from optimism.core.fact_delegations

order by date desc

select

date,

delegation_type,

sum(amount) as daily_amt,

count(*) as daily_del_evts

from all_del

where date >= '2023-01-01 00:000'

group by 1,2

order by date desc