with

arb_price as (

select hour,price from ethereum.core.fact_hourly_token_prices

where symbol ilike 'arb'

),

delegate_actions as (

select tx_hash

from arbitrum.core.fact_transactions

where to_address ='0x912ce59144191c1204e64559fe8253a0e49e6548'

),

delegators as (

SELECT

event_inputs:delegator as delegator,

max(block_timestamp) as max_date

FROM arbitrum.core.fact_event_logs

WHERE tx_hash in (SELECT tx_hash from delegate_actions)

AND event_name = 'DelegateChanged'

GROUP BY 1

),

toDelegates as (

select

delegator,

event_inputs:toDelegate as toDelegate

from arbitrum.core.fact_event_logs

left outer join delegators on max_date = block_timestamp

and delegator = event_inputs:delegator

where tx_hash in (select tx_hash from delegate_actions)

and event_name = 'DelegateChanged'

and delegator is not null

),

transfer_date_arb as (

select

block_timestamp,

from_address as wallet,