NuveveCryptoArchivedactive users by bridge
Updated 2023-04-22
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
›
⌄
with squid as (
select
concat('Squid') as bridge,
count(distinct total.from_address) as total_users
from (
select
from_address
from arbitrum.core.fact_transactions as arbitrum
where arbitrum.to_address = '0xce16f69375520ab01377ce7b88f5ba8c48f8d666'
and arbitrum.block_timestamp >= current_date - 30
union
select
from_address
from avalanche.core.fact_transactions as avax
where avax.to_address = '0xce16f69375520ab01377ce7b88f5ba8c48f8d666'
and avax.block_timestamp >= current_date - 30
union
select
from_address
from bsc.core.fact_transactions as bsc
where bsc.to_address = '0xce16f69375520ab01377ce7b88f5ba8c48f8d666'
and bsc.block_timestamp >= current_date - 30
union
select
from_address
from ethereum.core.fact_transactions as ethereum
where ethereum.to_address = '0xce16f69375520ab01377ce7b88f5ba8c48f8d666'
and ethereum.block_timestamp >= current_date - 30
union
select
from_address
from polygon.core.fact_transactions as polygon
where polygon.to_address = '0xce16f69375520ab01377ce7b88f5ba8c48f8d666'
and polygon.block_timestamp >= current_date - 30
) as total
),
Run a query to Download Data