hessJumper (Dune) Api copy
Updated 2025-01-12
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
-- 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