hessTotal New Users
Updated 2023-02-17
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
with osmosis as ( select min(block_timestamp) as date, tx_from
from osmosis.core.fact_transactions
group by 2)
,
terra as ( select min(block_timestamp) as date, TX_SENDER as tx_from
from terra.core.fact_transactions
group by 2)
select 'Osmosis' as chain, count(DISTINCT(tx_from)) as total_user
from osmosis
where date >= '2023-01-01'
group by 1
UNION
select 'Terra' as chain, count(DISTINCT(tx_from)) as total_user
from terra
where date >= '2023-01-01'
group by 1
Run a query to Download Data