SELECT

block_timestamp

, decoded_log:operator AS address

, decoded_log:"metadataURI" AS url

, row_number() OVER (PARTITION BY decoded_log:operator ORDER BY block_timestamp DESC) AS rn

FROM ethereum.core.ez_decoded_event_logs

WHERE event_name = 'OperatorMetadataURIUpdated'

QUALIFY rn = 1

),

live_query AS (

SELECT

*,

live.udf_api(url) AS resp

FROM latest_entries

SELECT

resp:data:name AS Operator

, resp:data:twitter AS Twitter

, resp:data:website AS Website

FROM live_query

Where resp:data:name is not NULL

and resp:data:twitter is not NULL

and resp:data:website is not null