BLOCKCHAIN_NAME | Total Intent Transactions | unique users | |
|---|---|---|---|
1 | NEAR | 131340 | 9619 |
2 | Ethereum | 61787 | 1282 |
3 | Zcash | 28490 | 393 |
4 | Solana | 17958 | 1556 |
5 | Bitcoin | 8786 | 333 |
6 | Arbitrum | 7009 | 907 |
7 | Base | 6966 | 941 |
8 | Berachain | 6436 | 184 |
9 | XRP Ledger | 5200 | 70 |
10 | Dogecoin | 3582 | 81 |
11 | Aurora | 656 | 115 |
12 | Gnosis | 275 | 42 |
13 | BNB Smart Chain | 102 | 39 |
datavortexIntent Transactions By Chains
Updated 2025-05-04
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 ChainData AS (
SELECT
token_id,
CASE
WHEN REGEXP_REPLACE(SPLIT_PART(token_id, 'nep141:', 2), '[-.].*', '') IN ('eth') THEN 'Ethereum'
WHEN REGEXP_REPLACE(SPLIT_PART(token_id, 'nep141:', 2), '[-.].*', '') IN ('sol') THEN 'Solana'
WHEN REGEXP_REPLACE(SPLIT_PART(token_id, 'nep141:', 2), '[-.].*', '') IN ('btc') THEN 'Bitcoin'
WHEN REGEXP_REPLACE(SPLIT_PART(token_id, 'nep141:', 2), '[-.].*', '') IN ('gnosis') THEN 'Gnosis'
WHEN REGEXP_REPLACE(SPLIT_PART(token_id, 'nep141:', 2), '[-.].*', '') IN ('arb') THEN 'Arbitrum'
WHEN REGEXP_REPLACE(SPLIT_PART(token_id, 'nep141:', 2), '[-.].*', '') IN ('base') THEN 'Base'
WHEN REGEXP_REPLACE(SPLIT_PART(token_id, 'nep141:', 2), '[-.].*', '') IN ('aurora') THEN 'Aurora'
WHEN REGEXP_REPLACE(SPLIT_PART(token_id, 'nep141:', 2), '[-.].*', '') IN ('xrp') THEN 'XRP Ledger'
WHEN REGEXP_REPLACE(SPLIT_PART(token_id, 'nep141:', 2), '[-.].*', '') IN ('bsc') THEN 'BNB Smart Chain'
WHEN REGEXP_REPLACE(SPLIT_PART(token_id, 'nep141:', 2), '[-.].*', '') IN ('zec') THEN 'Zcash'
WHEN REGEXP_REPLACE(SPLIT_PART(token_id, 'nep141:', 2), '[-.].*', '') IN ('doge') THEN 'Dogecoin'
WHEN REGEXP_REPLACE(SPLIT_PART(token_id, 'nep141:', 2), '[-.].*', '') IN ('bera') THEN 'Berachain'
ELSE 'NEAR'
END AS blockchain_name,
tx_hash,
owner_id
FROM near.defi.fact_intents
WHERE receipt_succeeded = TRUE
),
ChainStats AS (
SELECT
blockchain_name,
COUNT(DISTINCT tx_hash) AS "Total Intent Transactions",
COUNT(DISTINCT owner_id) AS "unique users"
FROM ChainData
GROUP BY blockchain_name
)
SELECT
blockchain_name,
"Total Intent Transactions",
"unique users"
FROM ChainStats
Last run: 22 days ago
13
280B
2s