Rodolfo-LimaToken Metrics Dune
Updated 2024-02-28
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
›
⌄
WITH query_dune AS (
SELECT
livequery.live.udf_api(
'https://api.dune.com/api/v1/query/3476228/results?api_key=mNG4qMrlhUd4MvBXAkCUGMsqLYYfnPFv'
) AS response
),
token_kpi AS (
SELECT
response:data:result:rows As data
FROM
query_dune,
LATERAL FLATTEN(input => TO_VARIANT(response:data)) AS x
OFFSET 5 ROWS
FETCH NEXT 1 ROW ONLY
)
SELECT
*
FROM
token_kpi,
LATERAL FLATTEN(input => CAST(data AS VARIANT)) AS data
QueryRunArchived: QueryRun has been archived