last_block

FROM (

livequery.live.udf_api(

'POST',

'https://subnets.avax.network/meld/mainnet/rpc',

{'Content-Type': 'application/json'},

{

'jsonrpc':'2.0',

'id': 1,

'method':'eth_blockNumber',

'params': []

}

):data:result::string as results,

utils.udf_hex_to_int(results) as last_block

),

t2 as (SELECT

TO_TIMESTAMP(d.value:timestamp) as date,

d.value:value as tx_count,

sum(tx_count) over (order by date) as total_tx

from (select livequery.live.udf_api(

'https://metrics.avax.network/v1/tx_count/333000333?from=1682541000&interval=day'

) :"data" as data

join lateral flatten (input => data:results) d

order by date desc

limit 1

select

last_block,