with level_data as (

select *,

-- data, topics,

block_timestamp,

tx_hash,

origin_from_address as address_that_levelled,

-- data, topics, contract_address

-- -- origin_to_address,

-- contract_address,

-- concat ('0x', substr(topics[1], 27, 40)) :: string as from_address,

-- concat ('0x', substr(topics[2], 27, 40)) :: string as to_address,

livequery.utils.udf_hex_to_int(SUBSTR(data, 120, 11)) + 1 as curr_level,

livequery.utils.udf_hex_to_int(SUBSTR(data, 59, 8)) as token_id

from blast.core.fact_event_logs

where true

and contract_address = '0x159a319e73f2e8455d5fdb1467fa0b29ec99af56'

and origin_function_signature = '0x0ce90ec2'

),

latest_lvl as (

select

token_id, max(curr_level) as curr_level

from level_data

group by 1

order by token_id

),

health_data as (

select

data,

block_timestamp,

livequery.utils.udf_hex_to_int(SUBSTR(data, 59, 8)) as token_id,