hessJumper (Dune) Api copy
    Updated 2025-01-12
    -- forked from Jumper (Dune) Api @ https://flipsidecrypto.xyz/studio/queries/a58ddbc8-5acb-4c18-b5e8-9f316b920a93

    with jumper as ( select * from (
    SELECT
    livequery.live.udf_api (
    'https://api.dune.com/api/v1/query/4272715/results?api_key=2dWxTthnCicdV214q7Wwns5s3Lb6s6eV') as resp)
    ,
    table(FLATTEN(parse_json(resp:data:"result":"rows"))))

    select TO_TIMESTAMP(REPLACE(value:"date", ' UTC', '')) AS date,
    value:"tx_hash" as tx_hash,
    value:"receiver" as origin_from_address,
    value:"chain_origin" as chain,
    null as bridge,
    value:"value" as amount_usd,
    value:"symbol" as symbol
    from jumper


    QueryRunArchived: QueryRun has been archived