block_timestamp :: date,

delegator,

to_delegate,

t.tag_name AS to_delegate_name,

from_delegate,

tt.tag_name AS from_delegate_name,

(raw_new_balance - raw_previous_balance) / POW(10, 21) AS balance_change,

raw_new_balance / POW(10,21) AS OP_delegated

FROM optimism.core.fact_delegations d

LEFT OUTER JOIN crosschain.core.address_tags t

ON d.to_delegate = t.address

LEFT OUTER JOIN crosschain.core.address_tags tt

ON d.from_delegate = tt.address

WHERE

t.creator = 'jkhuhnke11'

AND tt.creator = 'jkhuhnke11'

AND t.tag_type = 'delegate_name'

AND tt.tag_type = 'delegate_name'

AND block_timestamp :: date >= CURRENT_DATE - {{days}}

AND delegation_type = 'Re-Delegation'