commanderjoseph-761gwXdune api 4 use
Updated 2025-01-25
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
›
⌄
-- forked from dune api 4 @ https://flipsidecrypto.xyz/studio/queries/5da160ff-fc92-4465-9ec5-a57056b42678
with dune_api
AS
(
select
livequery.live.udf_api (
'https://api.dune.com/api/v1/query/4616809/results?api_key=RHbPbkgZ50RyFP0QazXfUlalXFyd7nql'
):data:result:rows as data
),
detass
AS
(
SELECT
value:holder AS holder
FROM
dune_api, LATERAL FLATTEN (input => data)
)
SELECT
holder
FROM
detass
QueryRunArchived: QueryRun has been archived