hyoeisemandap 3
Updated 2022-10-19
99
1
2
3
4
5
6
7
8
9
10
›
⌄
select date_trunc ('month', weekly1) as monthly, count (distinct daily_active_users) as count_active_wallets
from (select date_trunc( 'week',block_timestamp) as weekly1, tx_from as daily_active_users,
count (distinct (date_trunc('day',block_timestamp))) as count_active_day
from osmosis.core.fact_transactions
where tx_status ilike 'SUCCEEDED' and block_timestamp <= current_date - 1
group by 1,2
having count_active_day >=4) group by 1
Run a query to Download Data