Papasotquicknode example copy
    Updated 2023-03-15
    -- forked from 3a395b94-1d44-47ce-84e1-01267491a0d9

    -- after registering your quicknode key with ephit...

    SELECT
    livequery.live.udf_api(
    'POST',
    '{eth_url}',
    {},
    { 'method' :'eth_blockNumber',
    'params' :[],
    'id' :1,
    'jsonrpc' :'2.0' },
    'quicknode'
    ) AS resp,
    resp :data :result :: STRING AS toBlock,
    ethereum.public.udf_hex_to_int(toBLock) as toBlock_N;


    Run a query to Download Data