TYPE | BLOCKCHAIN | ACTIVE_ADDRESSES | |
|---|---|---|---|
1 | Other Chains | solana | 72248168 |
2 | Other Chains | near | 48215627 |
3 | Kaia | kaia | 21464151 |
4 | Other Chains | base | 16631233 |
5 | Other Chains | aptos | 14080312 |
6 | Other Chains | ethereum | 6762184 |
7 | Other Chains | polygon | 5730420 |
8 | Other Chains | arbitrum | 5160328 |
9 | Other Chains | Core | 4496167 |
10 | Other Chains | sei | 2429079 |
11 | Other Chains | optimism | 922269 |
12 | Other Chains | avalanche | 846148 |
13 | Other Chains | Aleo | 142595 |
14 | Other Chains | blast | 117095 |
15 | Other Chains | thorchain | 55107 |
SajjadiiiTotal Addresses copy
Updated 12 hours ago
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: about 12 hours ago
15
500B
255s