elsinaMonthly number of unique users
Updated 2022-12-20
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
select date_trunc('month', block_timestamp) as "Day", count(distinct from_address) as "number of unique user", 'Eethereum' as chain
from Ethereum.core.fact_transactions
group by 1
union all
select date_trunc('month', block_timestamp) as "Day", count(distinct from_address) as "number of unique user", 'Avalanche' as chain
from Avalanche.core.fact_transactions
group by 1
union all
select date_trunc('month', block_timestamp) as "Day", count(distinct PROPOSER) as "number of unique user", 'Flow' as chain
from flow.core.fact_transactions
group by 1
union all
select date_trunc('month', block_timestamp) as "Day", count(distinct from_address) as "number of unique user", 'Polygon' as chain
from Polygon.core.fact_transactions
group by 1
union all
select date_trunc('month', block_timestamp) as "Day", count(distinct from_address) as "number of unique user", 'Optimism' as chain
from Optimism.core.fact_transactions
group by 1
Run a query to Download Data