yasminTop Sources by transactions
Updated 2024-11-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
›
⌄
SELECT
"sourceChain",
"TXs Count"
FROM (
SELECT
CAST(DATA:confirm:sourceChain AS VARCHAR) AS "sourceChain",
COUNT(DISTINCT call:transactionHash) AS "TXs Count"
FROM
axelar.axelscan.fact_gmp
GROUP BY
DATA:confirm:sourceChain
UNION ALL
SELECT
CAST(source_chain AS VARCHAR) AS "sourceChain",
COUNT(DISTINCT SEND:txhash) AS "TXs Count"
FROM
axelar.axelscan.fact_transfers
GROUP BY
source_chain
) AS combined
ORDER BY
"TXs Count" DESC
LIMIT
5;
QueryRunArchived: QueryRun has been archived