Chain | Cumulative Tx 2 Weeks | Cumulative Wallets 2 Weeks | Cumulative Tx 4 Weeks | Cumulative Wallets 4 Weeks | Cumulative Tx 6 Weeks | Cumulative Wallets 6 Weeks | Cumulative Tx 8 Weeks | Cumulative Wallets 8 Weeks | Cumulative Tx 12 Weeks | Cumulative Wallets 12 Weeks | |
|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Arbitrum | 293 | 31 | 376 | 58 | 689 | 124 | 1072 | 219 | 1882 | 343 |
2 | Aurora | 6 | 4 | 21 | 9 | 49 | 14 | 74 | 26 | 148 | 51 |
3 | BNB Smart Chain | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
4 | Base | 531 | 42 | 654 | 72 | 994 | 163 | 1446 | 259 | 2459 | 402 |
5 | Berachain | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
6 | Bitcoin | 214 | 17 | 274 | 29 | 426 | 59 | 518 | 85 | 937 | 123 |
7 | Dogecoin | 0 | 0 | 46 | 7 | 141 | 23 | 185 | 36 | 219 | 41 |
8 | Ethereum | 1000 | 34 | 4805 | 69 | 6572 | 125 | 7637 | 253 | 10577 | 423 |
9 | Gnosis | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
10 | NEAR | 641 | 60 | 1458 | 142 | 2627 | 303 | 3717 | 512 | 6650 | 776 |
11 | Solana | 9 | 3 | 229 | 66 | 402 | 110 | 876 | 224 | 3508 | 497 |
12 | XRP Ledger | 0 | 0 | 0 | 0 | 66 | 4 | 118 | 12 | 157 | 16 |
13 | Zcash | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 25 | 2 |
datavortextime range
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,
block_timestamp
FROM near.defi.fact_intents
WHERE receipt_succeeded = TRUE
)
SELECT
blockchain_name AS "Chain",
COUNT(DISTINCT CASE WHEN block_timestamp <= (SELECT MIN(block_timestamp) FROM near.defi.fact_intents) + INTERVAL '2 weeks' THEN tx_hash END) AS "Cumulative Tx 2 Weeks",
COUNT(DISTINCT CASE WHEN block_timestamp <= (SELECT MIN(block_timestamp) FROM near.defi.fact_intents) + INTERVAL '2 weeks' THEN owner_id END) AS "Cumulative Wallets 2 Weeks",
COUNT(DISTINCT CASE WHEN block_timestamp <= (SELECT MIN(block_timestamp) FROM near.defi.fact_intents) + INTERVAL '4 weeks' THEN tx_hash END) AS "Cumulative Tx 4 Weeks",
COUNT(DISTINCT CASE WHEN block_timestamp <= (SELECT MIN(block_timestamp) FROM near.defi.fact_intents) + INTERVAL '4 weeks' THEN owner_id END) AS "Cumulative Wallets 4 Weeks",
COUNT(DISTINCT CASE WHEN block_timestamp <= (SELECT MIN(block_timestamp) FROM near.defi.fact_intents) + INTERVAL '6 weeks' THEN tx_hash END) AS "Cumulative Tx 6 Weeks",
COUNT(DISTINCT CASE WHEN block_timestamp <= (SELECT MIN(block_timestamp) FROM near.defi.fact_intents) + INTERVAL '6 weeks' THEN owner_id END) AS "Cumulative Wallets 6 Weeks",
COUNT(DISTINCT CASE WHEN block_timestamp <= (SELECT MIN(block_timestamp) FROM near.defi.fact_intents) + INTERVAL '8 weeks' THEN tx_hash END) AS "Cumulative Tx 8 Weeks",
COUNT(DISTINCT CASE WHEN block_timestamp <= (SELECT MIN(block_timestamp) FROM near.defi.fact_intents) + INTERVAL '8 weeks' THEN owner_id END) AS "Cumulative Wallets 8 Weeks",
COUNT(DISTINCT CASE WHEN block_timestamp <= (SELECT MIN(block_timestamp) FROM near.defi.fact_intents) + INTERVAL '12 weeks' THEN tx_hash END) AS "Cumulative Tx 12 Weeks",
COUNT(DISTINCT CASE WHEN block_timestamp <= (SELECT MIN(block_timestamp) FROM near.defi.fact_intents) + INTERVAL '12 weeks' THEN owner_id END) AS "Cumulative Wallets 12 Weeks"
Last run: 20 days ago
13
567B
4s