Moechainlink dune
Updated 2025-01-19
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
with dune_data AS (
SELECT livequery.live.udf_api(
'https://api.dune.com/api/v1/query/4590138/results?api_key=oxl31HACH1AngKoJJiwhoSEsFLayGYF6'
) AS response
),
flatten_dune_data AS (
SELECT
value:"result":"rows" as data
FROM dune_data, table(flatten(response, ''))
)
SELECT
value:"month" as month,
value:"txns" as txns,
value:"users" as users,
value:"usd_value" as volume_usd
FROM flatten_dune_data, lateral FLATTEN(input => data)
QueryRunArchived: QueryRun has been archived