Flipside Axelar AnalystsChainlink CCIP
Updated 2025-01-21
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
28
29
30
31
32
33
34
35
36
›
⌄
with tab_volume as (
with dune_data AS (
SELECT livequery.live.udf_api(
'https://api.dune.com/api/v1/query/4596146/results?api_key=kmCBMTxWKBxn6CVgCXhwDvcFL1fBp6rO'
) AS response),
flatten_dune_data AS (SELECT
value:"result":"rows" as data
FROM dune_data, table(flatten(response, ''))
)
SELECT
value:"Source Chain" as "Source Chain",
value:"Volume of Transfers" as "Volume of Transfers",
value:"Cross-Chain Service" as "Cross-Chain Service"
FROM flatten_dune_data, lateral FLATTEN(input => data)
),
---------------------------------------------------
---------------------------------------------------
tab_user as (
with dune_data AS (
SELECT livequery.live.udf_api(
'https://api.dune.com/api/v1/query/4596014/results?api_key=kmCBMTxWKBxn6CVgCXhwDvcFL1fBp6rO'
) AS response),
flatten_dune_data AS (SELECT
value:"result":"rows" as data
FROM dune_data, table(flatten(response, ''))
)
SELECT
value:"Source Chain" as "Source Chain",
value:"Number of Users" as "Number of Users",
value:"Cross-Chain Service" as "Cross-Chain Service"
FROM flatten_dune_data, lateral FLATTEN(input => data)
),
---------------------------------------------------
---------------------------------------------------
tab_transfer as (
with dune_data AS (
QueryRunArchived: QueryRun has been archived