-- forked from Delegations 1 @ https://flipsidecrypto.xyz/edit/queries/a3f49113-37dc-45bb-95bd-6b968c689cf6

-- forked from Validators Stats @ https://flipsidecrypto.xyz/edit/queries/59eee55d-6c26-4462-9960-28ca2e031404

with

delegate AS (

with

tb AS (

select

BLOCK_TIMESTAMP,

TX_ID,

ATTRIBUTE_VALUE AS val

from

sei.core.fact_msg_attributes

where

MSG_TYPE = 'delegate'

and ATTRIBUTE_KEY = 'validator'

)

select

tb.BLOCK_TIMESTAMP,

TX_ID,

'delegate' AS Action,

SUBSTR(ATTRIBUTE_VALUE, 1, len(ATTRIBUTE_VALUE) -4)::Int / 1e6 AS Amount,

val,

null AS src_val

from

sei.core.fact_msg_attributes

inner join tb using (TX_ID)

where

MSG_TYPE = 'delegate'

and ATTRIBUTE_KEY = 'amount'

),

undelegate AS (

with