value:"POWER" as voting_power

from (

SELECT livequery.live.udf_api(

'https://flipsidecrypto.xyz/api/v1/queries/3bd4bfd0-5a2e-4796-8110-43004ef74bb3/data/latest') as resp

,LATERAL FLATTEN (input => resp:data))

,

transaction as (select DISTINCT tx_id

from lava.core.fact_msg_attributes

where attribute_key = 'memo'

and msg_type = 'ibc_transfer'

and TRY_PARSE_JSON(attribute_value):destination_chain::STRING in ('arbitrum','Arbitrum')

and tx_succeeded = 'TRUE'

and block_timestamp::Date >= '2024-07-01')

,

amount as (select block_timestamp,

tx_id,

TRY_PARSE_JSON(attribute_value):amount::STRING/pow(10,6) AS amount,

TRY_PARSE_JSON(attribute_value):denom::STRING AS denom,

TRY_PARSE_JSON(attribute_value):sender::STRING AS sender,

TRY_PARSE_JSON(TRY_PARSE_JSON(attribute_value):memo::STRING):destination_chain::STRING AS destination_chain

from lava.core.fact_msg_attributes

where TRY_PARSE_JSON(TRY_PARSE_JSON(attribute_value):memo::STRING):destination_chain::STRING in ('arbitrum','Arbitrum')

and ATTRIBUTE_KEY = 'packet_data'

and MSG_TYPE = 'send_packet'

and tx_id in (select tx_id from transaction))

,

validators as (select DISTINCT validator_address

from lava.gov.fact_staking_rewards)

,

vali_address as (select validator_address,

LEFT(validator_address, POSITION('@' IN validator_address) - 1),

'@',

SUBSTRING(