with all_del as (
select
block_number,
date(block_timestamp) as date,
delegation_type,
delegator,
from_delegate 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,
delegator,
delegate,
sum(amount) as amount
from all_del
group by 1,2
order by delegated_amount desc