Sbhn_NPQ1 Active
Updated 2023-04-21
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
with new_user as (
select trader as new_users,
min(block_timestamp::date) as min_date
from osmosis.core.fact_swaps
where tx_succeeded = 'true'
group by 1),
active_user as (
select block_timestamp,
trader as active_users
from osmosis.core.fact_swaps
where tx_succeeded = 'true'
)
select
count(DISTINCT active_users) as users
from active_user
where block_timestamp::date between '2023-01-01' and '2023-03-31'
Run a query to Download Data