elsina___NOT_FOR_USE_ Number of unique user
Updated 2022-12-19
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
›
⌄
select
'Flow' as "Blockchain",
count(distinct PROPOSER) as "number of unique user"
from
Flow.core.fact_transactions
UNION
select
'Optimism' as "Blockchain",
count(distinct FROM_ADDRESS) as "number of unique user"
from
Optimism.core.fact_transactions
UNION
select
'Algorand' as "Blockchain",
count(
distinct algorand.core.fact_transaction.ASSET_SENDER
) as "number of unique user"
from
algorand.core.fact_transaction
UNION
select
'Ethereum' as "Blockchain",
count(distinct FROM_ADDRESS) as "number of unique user"
from
Ethereum.core.fact_transactions
UNION
select
'Polygon' as "Blockchain",
count(distinct FROM_ADDRESS) as "number of unique user"
from
Polygon.core.fact_transactions
UNION
select
'Avalanche' as "Blockchain",
count(distinct FROM_ADDRESS) as "number of unique user"
from
Run a query to Download Data