ASSET | TOTAL_INTENTS | UNIQUE_USERS | ACTIVE_DAYS | FIRST_INTERACTION | LAST_INTERACTION | AVG_DAILY_USERS | AVG_INTENTS_PER_USER | ACTIVITY_CONSISTENCY_PCT | RANK_BY_INTENTS | RANK_BY_USERS | |
|---|---|---|---|---|---|---|---|---|---|---|---|
1 | USDC | 67877 | 3613 | 193 | 2024-11-05 10:44:20.816 | 2025-05-16 05:36:09.615 | 18.72 | 18.79 | 100 | 1 | 3 |
2 | USDT | 57487 | 4006 | 192 | 2024-11-05 14:16:34.551 | 2025-05-16 05:40:33.584 | 20.86 | 14.35 | 99.48 | 2 | 2 |
3 | NEAR | 56877 | 5295 | 193 | 2024-11-05 11:57:10.233 | 2025-05-16 05:38:32.526 | 27.44 | 10.74 | 100 | 3 | 1 |
4 | ZEC | 38464 | 460 | 107 | 2025-01-27 13:42:25.018 | 2025-05-16 05:10:18.406 | 4.3 | 83.62 | 97.27 | 4 | 21 |
5 | nep141:sbr.tkn.near | 11989 | 1225 | 28 | 2025-04-19 09:22:16.139 | 2025-05-16 04:16:16.489 | 43.75 | 9.79 | 100 | 5 | 7 |
6 | BTC | 10399 | 397 | 189 | 2024-11-06 16:45:42.937 | 2025-05-16 04:15:36.006 | 2.1 | 26.19 | 98.44 | 6 | 24 |
7 | nep141:mark.aidols.near | 10094 | 990 | 28 | 2025-04-19 12:58:57.653 | 2025-05-16 05:29:03.580 | 35.36 | 10.2 | 100 | 7 | 13 |
8 | nep141:darai.tkn.near | 9477 | 1111 | 29 | 2025-04-18 21:10:29.735 | 2025-05-16 04:44:47.605 | 38.31 | 8.53 | 100 | 8 | 9 |
9 | ETH | 7952 | 1107 | 192 | 2024-11-06 13:08:16.679 | 2025-05-16 05:05:33.113 | 5.77 | 7.18 | 100 | 9 | 10 |
10 | SOL | 7808 | 1196 | 180 | 2024-11-16 15:37:39.527 | 2025-05-16 04:38:57.906 | 6.64 | 6.53 | 98.9 | 10 | 8 |
adriaparcerisasneari top contracts
Updated 2025-05-16
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 contract_metrics AS (
SELECT
CASE
WHEN token_id = 'nep141:wrap.near' THEN 'NEAR'
WHEN token_id = 'nep141:base-0x532f27101965dd16442e59d40670faf5ebb142e4.omft.near' THEN 'BRETT'
WHEN token_id = 'nep141:base-0x833589fcd6edb6e08f4c7c32d4f71b54bda02913.omft.near' THEN 'USDC'
WHEN token_id = 'nep141:base.omft.near' THEN 'ETH'
WHEN token_id = 'nep141:17208628f84f5d6ad33f0da3bbbeb27ffcb398eac501a31bd6ad2011e36133a1' THEN 'USDC'
WHEN token_id = 'nep141:aaaaaa20d9e0e2461697782ef11675f668207961.factory.bridge.near' THEN 'AURORA'
WHEN token_id = 'nep141:arb-0xaf88d065e77c8cc2239327c5edb3a432268e5831.omft.near' THEN 'USDC'
WHEN token_id = 'nep141:arb-0xfc5a1a6eb076a2c7ad06ed22c90d7e710e35ad0a.omft.near' THEN 'GMX'
WHEN token_id = 'nep141:arb-0xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb9.omft.near' THEN 'USDT'
WHEN token_id = 'nep141:arb-0x912ce59144191c1204e64559fe8253a0e49e6548.omft.near' THEN 'ARB'
WHEN token_id = 'nep141:arb.omft.near' THEN 'ETH'
WHEN token_id = 'nep141:aurora' THEN 'AURORA'
WHEN token_id = 'nep141:btc.omft.near' THEN 'BTC'
WHEN token_id = 'nep141:doge.omft.near' THEN 'DOGE'
WHEN token_id = 'nep141:eth-0x1f9840a85d5af5bf1d1762f925bdaddc4201f984.omft.near' THEN 'UNI'
WHEN token_id = 'nep141:eth-0x7fc66500c84a76ad7e9c93437bfc5ac33e2ddae9.omft.near' THEN 'AAVE'
WHEN token_id = 'nep141:eth-0x95ad61b0a150d79219dcf64e1e6cc01f0b64c4ce.omft.near' THEN 'SHIB'
WHEN token_id = 'nep141:eth-0x514910771af9ca656af840dff83e8264ecf986ca.omft.near' THEN 'LINK'
WHEN token_id = 'nep141:eth-0x6982508145454ce325ddbe47a25d4ec3d2311933.omft.near' THEN 'PEPE'
WHEN token_id = 'nep141:eth-0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48.omft.near' THEN 'USDC'
WHEN token_id = 'nep141:eth-0xaaee1a9723aadb7afa2810263653a34ba2c21c7a.omft.near' THEN 'MOG'
WHEN token_id = 'nep141:eth-0xdac17f958d2ee523a2206206994597c13d831ec7.omft.near' THEN 'USDT'
WHEN token_id = 'nep141:eth.omft.near' THEN 'ETH'
WHEN token_id = 'nep141:sol.omft.near' THEN 'SOL'
WHEN token_id = 'nep141:xrp.omft.near' THEN 'XRP'
WHEN token_id = 'nep141:zec.omft.near' THEN 'ZEC'
WHEN token_id = 'nep141:token.sweat' THEN 'SWEAT'
WHEN token_id = 'nep141:usdt.tether-token.near' THEN 'USDT'
WHEN token_id = 'nep141:sol-c58e6539c2f2e097c251f8edf11f9c03e581f8d4.omft.near' THEN 'TRUMP'
WHEN token_id = 'nep141:eth-0xa35923162c49cf95e6bf26623385eb431ad920d3.omft.near' THEN 'TURBO'
ELSE token_id
END AS asset,
COUNT(DISTINCT tx_hash) as total_intents,
Last run: 17 days ago
10
1000B
8s