TYPE | BLOCKCHAIN | ACTIVE_ADDRESSES | |
|---|---|---|---|
1 | Other Chains | solana | 80510564 |
2 | Other Chains | near | 44029216 |
3 | Kaia | kaia | 21751765 |
4 | Other Chains | base | 20317954 |
5 | Other Chains | aptos | 10108853 |
6 | Other Chains | ethereum | 6636803 |
7 | Other Chains | polygon | 5198649 |
8 | Other Chains | Core | 5084078 |
9 | Other Chains | arbitrum | 3545968 |
10 | Other Chains | sei | 3350992 |
11 | Other Chains | optimism | 2243016 |
12 | Other Chains | avalanche | 1913460 |
13 | Other Chains | Aleo | 61455 |
14 | Other Chains | thorchain | 60189 |
SajjadiiiTotal Addresses copy
Updated 2025-05-14
999
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
›
⌄
-- forked from Masi / Total Addresses @ https://flipsidecrypto.xyz/Masi/q/bvuH7-Nl3sKV/total-addresses
with tb0_0 AS (
SELECT
block_timestamp,
BLOCK_ID,
tx_hash,
ifnull(tx:actions[0]:Delegate:delegate_action:receiver_id::string, TX_RECEIVER)::string as receiver,
ifnull(tx:actions[0]:Delegate:delegate_action:sender_id::string, TX_SIGNER)::string AS user
FROM near.core.fact_transactions
where block_timestamp::date >= current_date - 30
)
,
tb0 as ( select block_timestamp,
from_address
from thorchain.core.fact_transfers
where block_timestamp::date >= current_date - 30
UNION
select block_timestamp,
from_address
from thorchain.defi.fact_swaps
where block_timestamp::date >= current_date - 30
UNION
select block_timestamp,
native_to_address as from_address
from thorchain.defi.fact_swaps
where block_timestamp::date >= current_date - 30)
,
tb1 as (select
'ethereum' as blockchain,
count(DISTINCT from_address) as active_addresses
from ethereum.core.fact_transactions
where block_timestamp::date >= current_date - 30
group by 1
UNION all
select
Last run: 19 days ago
14
469B
357s